For this assignment, you will use the financial statements you created for Assignment 3 and create pro forma statements in your spreadsheet software (Excel). 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
[order_button_a]
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)
Lastly, include a narrative explaining which projection is best for your business.
*NOTE: You are limited to submitting 3 spreadsheets – 1 for each projection (with 3 tabs in each spreadsheet). You will submit a spreadsheet for each of the pro forma financial statements, with 3 tabs in each spreadsheet.
[order_button_b]