For this assignment, you will use the financial statements you created for Assig

Question

For this assignment, you will use the financial statements you created for Assignment 1 and create pro forma statements in your spreadsheet software. Each pro forma statement should have a different projection. At least one should include a revenue increase and at least one should include the receipt of capital funding. The third is your choice. Include the following with your submission:

Pro forma income statement #1

Pro forma income statement #2

Pro forma income statement #3

Continue with your 3 pro forma income statements and create 3 pro forma balance sheets and 3 pro forma cash flow statements in your spreadsheet software, based on those pro forma income statements. Each pro forma statement should have a different projection. Include the following with your submission:

Pro forma income statement #1 (revenue increase projection)

Pro forma balance sheet #1

Pro forma cash flow statement #1

Pro forma income statement #2 (capital funding projection)

Pro forma balance sheet #2

Pro forma cash flow statement #2

Pro forma balance sheet #3

Pro forma cash flow statement #3

Pro forma income statement #3 (your choice)

What spreadsheet software can i use to do these csh flow statements , income statements and balance sheets as i am not familiar with creating pro forma statements

Explanation / Answer

Ans: )

To incorporate the scenarios mentioned in the above question it is advisable to use a spreadsheet software like Microsoft office, Open office, Google docs or Libre office which would allow you to incorporate the financial projections and forecasts of future income and cash flows that are required to prepare a pro forma financial statements (like, Balance sheet, Income statement and Cash flow statement) and enable you to efficiently analyze the company's future growth prospects.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.