Discover an insightful workflow for creating a Pro Forma Balance Sheet, complete with financial projections, adjustments, and comprehensive analysis.
1
Collect the previous year's financial statements
2
Calculate current assets
3
Compile information on current liabilities
4
Calculate long-term assets
5
Compile information on long-term liabilities
6
Determine shareholder's equity
7
Identify any non-operating adjustments
8
Include forward-looking information
9
Calculate net income projections
10
Calculate retained earnings projections
11
Identify any anticipated changes in capital structure
12
Create the pro forma balance sheet
13
Review financial ratios and indicators
14
Clarify assumptions and methodology used
15
Approval: Financial Analyst
16
Finalize and format pro forma balance sheet
17
Distribute the pro forma balance sheet to relevant parties
18
Address any queries or clarifications needed
Collect the previous year's financial statements
Gather the financial statements from the previous year to use as a reference for the pro forma balance sheet. These statements will provide important information about the company's financial performance and position.
Calculate current assets
Determine the value of current assets, which are resources that are expected to be used up or converted into cash within one year. This includes cash, accounts receivable, inventory, and other short-term investments.
Compile information on current liabilities
Gather information on current liabilities, which are obligations that are expected to be settled within one year. This includes accounts payable, accrued expenses, and short-term debt.
Calculate long-term assets
Determine the value of long-term assets, which are resources that are expected to provide benefits for more than one year. This includes property, plant, and equipment, intangible assets, and long-term investments.
Compile information on long-term liabilities
Gather information on long-term liabilities, which are obligations that are not expected to be settled within one year. This includes long-term debt and other long-term liabilities.
Determine shareholder's equity
Calculate the shareholder's equity, which represents the residual interest in the assets of the company after deducting liabilities. This includes share capital, retained earnings, and other equity components.
Identify any non-operating adjustments
Check for any non-operating adjustments that need to be made to the balance sheet. These adjustments could include gains or losses from the sale of assets, interest income or expense, and other non-operating items.
Include forward-looking information
Include any forward-looking information that is relevant to the balance sheet. This could include projections for future sales, expenses, and other financial metrics.
Calculate net income projections
Calculate the projected net income for the upcoming year based on the company's assumptions and forecasts. Net income is the company's total revenue minus its total expenses.
Calculate retained earnings projections
Calculate the projected retained earnings for the upcoming year based on the company's net income projections and any dividends or other adjustments. Retained earnings are the accumulated profits of the company that have not been distributed to shareholders.
Identify any anticipated changes in capital structure
Identify any anticipated changes in the company's capital structure, such as new investments, additional debt or equity financing, or changes in ownership.
Create the pro forma balance sheet
Use the collected information and calculations to create the pro forma balance sheet. This will include the projected values for assets, liabilities, and equity based on the company's assumptions and forecasts.
Review financial ratios and indicators
Review the financial ratios and indicators derived from the pro forma balance sheet. These ratios and indicators provide insight into the company's financial health and performance.
1
Liquidity ratio
2
SolVency ratio
3
Profitability ratio
4
Efficiency ratio
5
Market value ratio
Clarify assumptions and methodology used
Clarify and document the assumptions and methodology used to create the pro forma balance sheet. This will provide transparency and allow for better understanding and analysis of the balance sheet.
Approval: Financial Analyst
Will be submitted for approval:
Create the pro forma balance sheet
Will be submitted
Finalize and format pro forma balance sheet
Finalize the pro forma balance sheet by reviewing and formatting the document. Ensure that all values and calculations are accurate and that the layout and presentation are clear and professional.
Distribute the pro forma balance sheet to relevant parties
Distribute the finalized pro forma balance sheet to relevant parties such as shareholders, investors, and financial analysts. Ensure that the document is delivered in a timely manner and through appropriate channels.
Address any queries or clarifications needed
Address any queries or clarifications that may arise regarding the pro forma balance sheet. Provide the necessary information and explanations to resolve any issues or concerns raised by stakeholders.
