Instructions
Assignment 5 – Pro Forma Income Statements (PO8, CO4, ILO.SK4,
Instructions
<
Assignment 5 – Pro Forma Income Statements (PO8, CO4, ILO.SK4, BIS2, IS1, IS3, IS4, AL1)
<
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). You will submit a spreadsheet for each of the pro forma financial statements, with 3 tabs in each spreadsheet.
<
<
<
<
Minimum 3 spreadsheets with 3 tabs (one for each financial statement)
<
<
Minimum 2-page narrative
<
<
APA format for narrative
<
<
Please feel free to contact me with questions about the assignment.
<
Email Address: doll2008face@gmail.com
<
<
