Business: Pro Forma Income Statements Corrections

Prior Assignment: “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.

***Please use the Sample Cashflow for the correct format***

The instructor’s notes to fix are:

“This is well done. However, please note the following:

Your statement of cash flow (spreadsheets 1, 2, and 3) is not in the correct format. All cash flows must be organizes by activity: Operating Activities, Investing Activities, and Financing Activities. I am attaching a sample for your review.

In your income staements (spreadsheet 1), your operating expenses should broken down (more details). It is also missing interest expense and taxes. Please check the other spreadsheets as well.

Why is there such a difference in size between the balance sheet you submitted in Spreadssheet 1 and the balance sheets in the other spread sheets?”