Business: Pro Forma Income Statements

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:

1. Pro forma income statement #1

2. Pro forma income statement #2

3. 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:

1. Pro forma income statement #1 (revenue increase projection)

1. Pro forma balance sheet #1

2. Pro forma cash flow statement #1

2. Pro forma income statement #2 (capital funding projection)

1. Pro forma balance sheet #2

2. Pro forma cash flow statement #2

3. Pro forma income statement #3 (your choice)

1. Pro forma balance sheet #3

2. Pro forma cash flow statement #3

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.

– 3 spreadsheets (not PowerPoint) in Microsoft Excel with 3 tabs (one for each financial statement)

– 2-page narrative in APA format

I have added Week 3’s “current financials” file and a business SWOT to give you an idea of the business for the narrative.