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?”
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
