How To Draw Up A Forecast Profit And Loss Statement

Table of contents:

How To Draw Up A Forecast Profit And Loss Statement
How To Draw Up A Forecast Profit And Loss Statement

Video: How To Draw Up A Forecast Profit And Loss Statement

Video: How To Draw Up A Forecast Profit And Loss Statement
Video: Income Statement Forecasting - How to do a 5 year forecast in excel 2024, April
Anonim

The forecast profit and loss statement is a form of financial statements, which is drawn up before the beginning of the planning period and shows the results of the planned production activity. It is drawn up to determine and account for the payment of income tax when calculating the change in the amount of funds in the company's budget fund.

How to make a forecast profit and loss statement
How to make a forecast profit and loss statement

Instructions

Step 1

Type the title of the document at the top of the right corner of the document: Forward-looking Profit and Loss Statement. Beside the date of the report and the name of the company.

Step 2

Make a table. The forecast report should be compiled on the basis of the data contained in the sales budgets on the cost price, goods sold, as well as on current expenses. In this case, it is necessary to add information about other profits, other expenses and the amount of income tax.

Step 3

Break the columns by month if you are making a forecast report for the year. If it was foreseen in advance for several years, then you can split the columns by year. In this case, leave the first line of the first column empty, because just under it, in the following lines you will need to enter the name of the following indicators: start-up capital, sales income, cost of goods sold, one-time costs, fixed costs, total profit, total costs.

Step 4

Conduct a cost estimate. To do this, build a cost model that will automatically recalculate this indicator depending on changes in various factors of consumption of certain resources or prices.

Step 5

Dedicate a few lines in your cost price table. Specify data on the initial inventory, transportation costs for purchases, the number of goods for sale. Then output the sum of ending inventories.

Step 6

Divide the one-time costs into several sections: registration, tools. Then divide the fixed costs of the business into the following groups: taxes, advertising, salaries, pension contributions, supplies.

Step 7

Enter the planned data into the resulting table. After that, make all the necessary calculations of the totals.

Recommended: