Week 5 Assig. For this assignment, you will use the financial statements you created for Assignment 3 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)
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)
Minimum 3 spreadsheets with 3 tabs (one for each financial statement)
Minimum 2 page narrative
