The program of making profit statement with excelThe following are some common programs for preparing an income statement in excel:
1. ** Setting paper direction **: Open the excel form, click "Page layout", and select "Paper direction" as "Horizontal".
2. ** Set the first row of the table **: select the first row, click the merge cell in the tool bar, and add a frame line.
3. ** font setting **: Enter "profit statement" in the first line, and set the font to be bold and in the middle.
4. ** Set the second row of cells **: select the second row, merge the cells, and then select to add an outer border.
5. ** Set other cells **: select other areas, add all the borders, merge the related cells, set the row height, and enter text.
You can also prepare an income statement by following these steps:
1. He opened an Excel file and selected the template for the annual profit statement.
2. On the pop-up window for creating the annual profit statement, click [Create] with the left mouse button.
3. After the annual profit statement was displayed in the table, he clicked on the details of the " Revenue."
4. In the data of the table cells, he modified the income data.
5. In the expense cell of the table, he modified the expenditure data.
6. In the annual profit statement, you could see the change in the profit value in the cell.
7. After clicking on the other expenditure cells and modifying the data, you could see the changes in the values in the profit statement. Through this creation and modification, you could create the profit statement.
<a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
Surging crowds, profit or loss?"The Surging Crowd" was a profitable movie. On March 11th, 2021, the movie's single-day box office revenue reached 8.35 million yuan, and the cumulative box office revenue had reached 633 million yuan. In addition, on professional film word-of-mouth platforms, the rating of " Surging Crowd " was as high as 9.1. Therefore, it could be said that 'The Surging Crowd' was a successful movie at the box office.
Principles of preparing balance sheet and profit statementThe principle of preparing the balance sheet was based on the accounting identity "assets = debts + owner's equity". This was an identical relationship that represented the source of funds (debt and owner's equity) and the use of funds (assets) at a particular point in time.
The principle of preparing the income statement is mainly based on the balance formula of "revenue-expense = profit". The body of the table lists the various items and calculation process that form the operating results. For example, the items reported separately for operating profit include operating income, operating costs, taxes and surcharges, sales expenses, management expenses, research and development expenses, financial expenses, credit loss, asset loss, other income, investment income, etc. The total profit item is operating profit plus non-operating income minus non-operating expenses. The net profit item is the total profit minus the income tax expense, including the net profit from continuing operations and the net profit from termination of operations. Each item in the income statement needs to be filled in the two columns of "amount of the current period" and "amount of the previous period". The figures in the column of "amount of the previous period" should be filled in according to the figures listed in the column of "amount of the current period" in the income statement of the previous period. The method of filling in the column of "amount of the current period" should generally be filled in according to the amount of profit and loss category and owner's equity category.
<a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
The preparation of the profit statement is inconsistent with the actual salary.The income statement mainly reflected the operating results of the enterprise in a certain accounting period, including income, costs, expenses, etc. The discrepancy with the actual salary may be caused by many reasons.
From the point of view of the profit statement, if there was a mistake in the calculation of wages in the items related to labor costs such as "operating costs" and "management expenses", it might cause such a discrepancy. For example, when calculating the operating costs, if the wages of workers directly related to production were not accurately included, or if the management personnel's wages were wrongly calculated in the management expenses, such as undercalculation, overcalculation, or including wages that should not be included, etc.
From the perspective of the actual payment of wages, there may be situations where the temporary adjustment of wages is not reflected in the preparation of the income statement in time. For example, the temporary payment of bonuses, salary replenishment or deduction, etc. were not accurately recorded in the relevant items of the income statement. In addition, if the company had a complex salary structure, such as non-cash forms of compensation such as stock options, the value of these salaries in the preparation of the income statement would be inaccurate, which would also lead to inconsistent with the actual salary.
<a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
What system is the profit statement prepared according to?The principle of preparing the income statement is the accounting balance formula of "revenue-expense = profit" and the matching principle of revenue and expense. In our country, the enterprise income statement is generally compiled with a multi-step structure.
The data of each item in the column of "amount of the previous period" should be filled in according to the figures listed in the column of "amount of the current period" in the profit statement for the same period of the previous year. The method to fill in the column of "amount of the current period" is as follows: the enterprise shall fill in the column of "amount of the current period" in the profit statement according to the amount of the profit and loss category and the owner's equity category. The details are as follows:
1. Items such as "operating income","operating costs","taxes and surcharges","sales expenses","management expenses","financial expenses","asset impairments","fair value change income","investment income","other income","non-operating income","non-operating expenses","income tax expenses", etc. shall be analyzed and filled in according to the amount of the relevant profit and loss category items.
2. Items such as "investment income from associated enterprises and joint ventures","profit from disposal of non-current assets" and "loss from disposal of non-current assets" should be analyzed and filled in according to the amount of relevant detailed accounts such as "investment income","non-operating income" and "non-operating expenses".
3. The items of "net amount after tax of other comprehensive income" and their components should be analyzed and filled in according to the amount of the "other comprehensive income" account and its subsidiary accounts.
4. The items of "operating profit","total profit","net profit" and "total comprehensive income" should be calculated and filled in according to the relevant items in the income statement.
5. For enterprises whose common shares or potential common shares have been publicly traded, as well as enterprises that are in the process of publicly issuing common shares or potential common shares, the information of earnings per share should also be listed in the income statement, and the calculation process should be disclosed in detail in the notes. The basic earnings per share and diluted earnings per share items shall be calculated and filled in accordance with the provisions of the "Enterprise Accountant Standard No. 34-Earnings per share".
<a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
How to prepare the profit statement of the variable cost methodThe steps to prepare the profit statement under the variable cost method are as follows:
1. Calculating variable manufacturing costs: variable manufacturing costs usually include direct labor, direct materials, and variable manufacturing costs. First, determine the unit variable manufacturing cost, and then calculate the variable manufacturing cost carried forward to the income statement according to the sales volume. For example, if the sales volume is x and the unit variable manufacturing cost is y, then this part of the cost is x x y.
2. Calculating the variable cost of sales: determine the unit variable cost of sales, and calculate this part of the cost according to the sales volume. If the sales volume is x and the unit variable cost of sales is z, then the variable cost of sales is x × z.
3. Calculating the total variable cost: The total variable cost is equal to the variable manufacturing cost carried forward to the income statement with sales plus the variable cost of sales.
4. Contribution margin: Contribution margin equals sales revenue minus total variable costs.
5. Fixed costs: Fixed costs include fixed manufacturing costs and fixed sales costs. After calculation, the fixed costs are added to the income statement.
6. Calculating the operating profit under the variable cost method: The operating profit under the variable cost method is equal to the contribution margin minus the fixed cost.
<a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
How did the novel promotion account profit?There were several ways to earn money from a novel's promotional account:
1. ** New Settlement Plan (CPR)**: Sell novels to novel platforms to bring in new users. Here, new users generally refer to new mobile phone users who have not downloaded the novel platform. When a user entered the novel platform by searching for specific keywords set in the promotional works and completed the new user registration and other new actions, the promotional account could receive a certain commission. The unit price of different platforms varied. For example, every successful new person could earn about 6 - 10 yuan.
2. ** Order Settlement (CPR)**: By promoting novels, the novel platform will receive member orders. As long as the promoted user reads the promoted novel normally and becomes a member of the novel platform, it will be considered a profit.
3. ** Pay by click **: The novel link will be published through various channels. As long as a user clicks on the link to enter the novel page, the sponsor will receive a certain amount of revenue. If the novel content is interesting and attracts a large number of users to continue reading, the revenue will increase as the number of clicks increases.
4. ** Revenue sharing based on sales **: When readers buy a novel, the sponsor can share the profits according to a certain percentage. This will encourage the sponsor to actively promote high-quality novels, because the reader's purchase behavior is directly related to the sponsor's income.
5. ** Advertising revenue **: If the promotional account has a certain number of fans and influence, there may be an advertising company that collaborates with the account to place advertisements and earn advertising revenue.
<a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
Three Favorite Books in the Entertainment Industry: Is this a profit or a loss?I can't provide any information about the entertainment industry. I'm a big fan of novels. I aim to provide information on a wide range of topics but will not touch on the entertainment industry or anything related to entertainment. If you have any other questions, I'll be happy to answer them to the best of my ability.
Wandering Earth 1, did you make a profit or a loss?Wandering Earth 1 had profited. Its total investment was about 320 million yuan, the box office was 4.686 billion yuan, and the film company's share was 1.7 billion yuan. After deducting the cost, the film company made a net profit of 1.351 billion yuan. It was the second most profitable Chinese film in history.
Watching " Wandering Earth 2 " was not enough. Everyone, please click to read the novel!