Question
For this assignment, you will use the financial statements you created for Assignment 1 and create pro forma statements in your spreadsheet software. Each pro
For this assignment, you will use the financial statements you created for Assignment 1 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)
What spreadsheet software can i use to do these csh flow statements , income statements and balance sheets as i am not familiar with creating pro forma statements
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started