Optimize future business planning with our Pro Forma Financial Statement Template - a comprehensive workflow tool for detailed financial analysis and projection.
1
Identify the financial years for the forecast
2
Gather historical performance data
3
Track down sales records
4
Obtain cost of goods sold (COGS) records
5
Collect operational expense data
6
Prepare sales projection
7
Prepare COGS projection
8
Prepare operational expenses projection
9
Calculate net income
10
Adjust net income with non-cash expenses
11
Calculate Working Capital
12
Approval: CFO for the calculated figures
13
Calculate Investing Activities
14
Calculate Financing Activities
15
Prepare Cash Flow Statement
16
Prepare Income Statement
17
Prepare Balance Sheet
18
Approval: Board of Directors for the final documents
19
Finalise the documents
20
Archive the Pro Forma Financial Statement
Identify the financial years for the forecast
This task involves identifying the specific financial years that will be included in the forecast. It is essential to determine the time period for which the financial statements will be prepared in order to accurately project future performance. By specifying the financial years, the forecast can be aligned with the company's strategic goals and objectives. Consider the historical data, market trends, and company plans while selecting the applicable years. Be aware of any potential challenges in gathering data for specific years and ensure compatibility with reporting requirements.
1
2022-2023
2
2023-2024
3
2024-2025
4
2025-2026
5
2026-2027
Gather historical performance data
In this task, you will collect historical performance data of the company. This data serves as a foundation for forecasting future financial statements. Gather relevant financial documents, such as income statements, balance sheets, and cash flow statements, for the selected financial years. Ensure the accuracy and completeness of the data by cross-referencing different sources. Take note of any inconsistencies or missing information and address them promptly to maintain the integrity of the forecast. Identify potential challenges in gathering the data and allocate sufficient time and resources to overcome them.
1
Income statements
2
Balance sheets
3
Cash flow statements
4
Tax returns
5
Audited financial statements
Track down sales records
This task involves tracking down sales records for the selected financial years. Sales data serves as a key input for the financial forecast, enabling accurate revenue projections. Identify different sources of sales records, such as sales invoices, CRM systems, or sales databases. Gather both quantitative and qualitative information, including sales volume, customer demographics, and market trends. Consider potential challenges related to data availability or accuracy and develop strategies to overcome them. By tracking down sales records, you can ensure the forecast reflects the company's sales performance accurately.
1
Sales invoices
2
CRM system data
3
Sales databases
4
Point of sale (POS) data
5
Sales reports
Obtain cost of goods sold (COGS) records
To prepare an accurate financial forecast, it is crucial to obtain cost of goods sold (COGS) records for the selected financial years. COGS represents the direct costs associated with producing or delivering a company's products or services. Gather data related to raw material costs, direct labor expenses, and manufacturing overheads. Identify sources of COGS records, such as purchase invoices, production reports, or inventory management systems. Pay attention to data accuracy and completeness, resolving any discrepancies or missing information. By obtaining COGS records, the forecast can accurately account for the cost of generating revenue.
1
Purchase invoices
2
Production reports
3
Inventory management system data
4
Cost accounting records
5
Supplier contracts
Collect operational expense data
In this task, you will collect operational expense data for the selected financial years. Operational expenses include costs not directly related to the production of goods or services, such as rent, utilities, salaries, marketing expenses, and administrative costs. Gather data from various sources, including expense reports, accounting records, and vendor invoices. Ensure the accuracy and completeness of the data by cross-referencing different sources and addressing any inconsistencies or missing information. Be aware of potential challenges in collecting the data and allocate sufficient time and resources to overcome them. By collecting operational expense data, the forecast can reflect the company's overall cost structure.
1
Expense reports
2
Accounting records
3
Vendor invoices
4
Payroll data
5
Lease agreements
Prepare sales projection
In this task, you will prepare a sales projection for the forecasted financial years. Utilize the gathered sales records, market analysis, and industry trends to estimate future sales performance. Consider factors such as market growth rates, competitive landscape, and customer behavior to make informed projections. Take into account any potential challenges or uncertainties that may impact sales performance, and document these factors for reference. By preparing a sales projection, the forecasted revenue can provide insights into the company's future financial performance.
Prepare COGS projection
To accurately forecast financial statements, it is essential to prepare a cost of goods sold (COGS) projection. Utilize the collected COGS records, market analysis, and production efficiency to estimate future COGS. Consider factors such as raw material costs, labor expenses, and pricing strategies to make informed projections. Address any potential challenges or uncertainties that may impact COGS and document these factors for reference. By preparing a COGS projection, the forecast can reflect the expected cost structure associated with generating revenue.
Prepare operational expenses projection
In this task, you will prepare an operational expenses projection for the forecasted financial years. Utilize the collected operational expense data, industry benchmarks, and cost-saving initiatives to estimate future expenses. Consider factors such as inflation, regulatory changes, and company growth plans when making projections. Address any potential challenges or uncertainties that may impact operational expenses and document these factors for reference. By preparing an operational expenses projection, the forecast can reflect the expected cost structure associated with running the business.
Calculate net income
In this task, you will calculate the net income for the forecasted financial years. Net income represents the company's earnings after subtracting all expenses, including COGS, operational expenses, and non-cash expenses. Utilize the projected revenue and expense figures to calculate the net income. Apply appropriate tax rates and deductions to ensure accuracy. Address any potential challenges or uncertainties that may impact the net income calculation and document these factors for reference. By calculating net income, the forecast can provide insights into the company's profitability.
1
10%
2
15%
3
20%
4
25%
5
30%
Adjust net income with non-cash expenses
To accurately reflect the company's financial performance, it is important to adjust the net income with non-cash expenses. Non-cash expenses include items such as depreciation and amortization. Identify the non-cash expenses applicable for the forecasted financial years and calculate the adjustment amount. Consider accounting standards and industry practices when making adjustments. Address any potential challenges or uncertainties related to non-cash expenses and document these factors for reference. By adjusting net income with non-cash expenses, the forecast can provide a more accurate representation of the company's cash flow.
1
Depreciation
2
Amortization
3
Stock-based compensation
4
Impairment charges
5
Deferred tax expenses
Calculate Working Capital
This task involves calculating the working capital for the forecasted financial years. Working capital represents the difference between current assets and current liabilities, indicating the company's liquidity and short-term financial health. Utilize the projected balance sheet data to calculate the working capital. Consider factors such as inventory levels, accounts receivable, and accounts payable when making calculations. Address any potential challenges or uncertainties related to working capital and document these factors for reference. By calculating working capital, the forecast can provide insights into the company's ability to meet short-term obligations.
Approval: CFO for the calculated figures
Will be submitted for approval:
Calculate net income
Will be submitted
Adjust net income with non-cash expenses
Will be submitted
Calculate Working Capital
Will be submitted
Calculate Investing Activities
In this task, you will calculate the investing activities for the forecasted financial years. Investing activities represent the cash flows associated with long-term asset investments, such as purchasing property, plant, and equipment, or acquiring investments. Utilize the projected cash flow statement and historical investment data to calculate the investing activities. Consider factors such as capital expenditure plans and investment strategies when making calculations. Address any potential challenges or uncertainties related to investing activities and document these factors for reference. By calculating investing activities, the forecast can provide insights into the company's capital expenditure plans.
Calculate Financing Activities
To assess the company's financing activities, you will calculate the financing activities for the forecasted financial years. Financing activities represent the cash flows associated with raising and repaying funds, such as issuing or repurchasing stocks, obtaining or repaying loans. Utilize the projected cash flow statement and historical financing data to calculate the financing activities. Consider factors such as dividend payments, stock issuances, and debt repayment plans when making calculations. Address any potential challenges or uncertainties related to financing activities and document these factors for reference. By calculating financing activities, the forecast can provide insights into the company's capital structure and funding strategies.
Prepare Cash Flow Statement
In this task, you will prepare the cash flow statement for the forecasted financial years. The cash flow statement provides insights into how cash moves in and out of the company during a specific period. Utilize the projected cash inflows and outflows from operating, investing, and financing activities to prepare the cash flow statement. Consider factors such as cash flow ratios and industry benchmarks to assess the financial health of the company. Address any potential challenges or uncertainties related to cash flow statement preparation and document these factors for reference. By preparing the cash flow statement, the forecast can provide a comprehensive view of the company's cash position.
1
Operating activities
2
Investing activities
3
Financing activities
4
Cash equivalents
5
Non-cash transactions
Prepare Income Statement
To present the company's financial performance, you will prepare the income statement for the forecasted financial years. The income statement, also known as the profit and loss statement, summarizes the revenue, expenses, and net income of the company. Utilize the projected revenue and expense figures to prepare the income statement. Consider factors such as gross profit margin, operating margin, and net profit margin to assess the profitability of the company. Address any potential challenges or uncertainties related to income statement preparation and document these factors for reference. By preparing the income statement, the forecast can provide insights into the company's revenue generation and cost structure.
1
Revenue
2
Cost of goods sold
3
Gross profit
4
Operating expenses
5
Net income
Prepare Balance Sheet
In this task, you will prepare the balance sheet for the forecasted financial years. The balance sheet provides a snapshot of the company's financial position at a specific point in time, showing its assets, liabilities, and shareholders' equity. Utilize the projected asset and liability figures to prepare the balance sheet. Consider factors such as current ratio, debt-to-equity ratio, and return on equity to assess the financial stability of the company. Address any potential challenges or uncertainties related to balance sheet preparation and document these factors for reference. By preparing the balance sheet, the forecast can provide insights into the company's financial health and solvency.
1
Assets
2
Liabilities
3
Shareholders' equity
4
Current assets
5
Long-term liabilities
Approval: Board of Directors for the final documents
Will be submitted for approval:
Prepare Cash Flow Statement
Will be submitted
Prepare Income Statement
Will be submitted
Prepare Balance Sheet
Will be submitted
Finalise the documents
In this task, you will finalize the pro forma financial statement documents for the forecasted financial years. Review and cross-reference the prepared cash flow statement, income statement, and balance sheet to ensure accuracy and consistency. Verify all calculations, formulas, and supporting data to maintain the integrity of the documents. Address any discrepancies or errors promptly and make necessary adjustments. Seek input and feedback from relevant stakeholders, such as finance managers or executives. By finalizing the documents, the forecasted financial statements can be deemed complete and ready for analysis and decision-making.
Archive the Pro Forma Financial Statement
To ensure proper record-keeping, you will archive the pro forma financial statement documents for future reference. Implement a systematic filing or storage system to store and organize the documents securely. Consider using cloud-based storage platforms or physical filing cabinets, depending on your organization's preferences and policies. Label the documents clearly with appropriate titles and version numbers to facilitate retrieval. Communicate the archiving process to relevant stakeholders to ensure consistent practices. By archiving the pro forma financial statement, you can maintain a reliable record of the forecasted financial performance.
