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.
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 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!
Is there any profit after the registration of the Baijia account is approved by others?Yes, after registering for the Baijia account, if the review was passed, the author would receive a certain amount of income when the article was read by the readers. This income was calculated according to a certain proportion of the article's reading volume. Generally speaking, the distribution of income included platform income, author income, advertising income, and so on.
However, it should be noted that the income distribution of the Baijia account is random, which means that the same author's article may produce different income distribution proportions among different readers. In addition, authors also needed to ensure the quality of their articles in order to obtain a higher approval rate and better distribution of profits.
Would there be any profit after the registration of the Baijia account was successful?No, after successfully registering and becoming a Baijia account, you still need to go through a certain amount of review and certification before you can receive any benefits. During the review process, you need to submit the corresponding articles or works according to the regulations of Baijia and go through the evaluation and review of experts. If they passed the review, they could publish articles or works on the Baijia account and earn the corresponding income.
However, it was important to note that the distribution of profits was not one-time but distributed in multiple times. Under normal circumstances, Baijia would distribute the income to the author according to the number of readers, likes, reposts, and other factors. Therefore, before posting, one needed to understand the income distribution mechanism of the Baijia account and prepare the corresponding materials in order to obtain better benefits.
How much does it cost to publish a statement of loss?There is a fee to publish a loss statement. The amount of the fee may vary according to the region and the type of newspaper. Generally speaking, the cost of publishing a loss statement usually included the publication fee and the reporting fee.
A notice in the newspaper refers to the announcement of relevant information in the newspaper or other media to remind readers. Placing a statement in the Big River newspaper usually requires a certain fee. The specific amount may vary according to the region and the type of newspaper.
It should be noted that different newspapers may have different charging standards. Therefore, when choosing to publish a statement in the newspaper, you should carefully read the charging standards of the newspaper and choose according to the actual situation.