Question: 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

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 statemen

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Mayne Manufacturing Co. has incurred substantial losses for several years and has become insolvent. On March 31, 20A, Mayne petitioned the court for protection from creditors and submitted the...

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

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

Reviewing the previous quarters financial statements will provide you with data to construct pro forma financial statements for Starbucks and make some basic projections. This week, you will be...

Introduction Create pro forma (budget) financial statements (including income statement, balance sheet, and statement of cash flows for business plan Create cash receipts and disbursement budget for...

Go back to the financial analysis spreadsheet from Homework #5 that you prepared in Excel for the Talat-Nabil Construction company. Make assumptions about historical financial ratios and historical...

CSL Limited considers selling new diagnostic products and it has the following estimates for this new project: price=$420 per unit variable costs=$145 per unit, fixed costs=56,800,000,...

Question 4. (Total 15 marks) Palantir Technologies Inc. is considering a project to produce a new machine to replace the current machine. The initial investment required for this new equipment will...

I would like to have the entries for chapter 5 of the Smithville computer case (short version) see attachment Instructions City of Smithville Short Version Computerized Cumulative Problem For use...

hello everyone. i really need your help with this assignment to make the earnings model for cocacola company. the instructions are in the screen shots i have uploaded. kindly help me with this asap....

I need help ONLY with PART TWO (the analysis) , I uploaded part one solution to help in the analysis part. if the picture is small, please save it on computer so you can ZOOM IN. thank you CVP...

How many grams of perchloric acid, HClO4, are contained in 37.6 g of 70.5 wt% aqueous perchloric acid? How many grams of water are in the same solution?

discuss about the benefits and disadvantages of the leverage, provide two examples. You can talk about a company with leverage and one without leverage. This can be done by comparing EPS and ROE of...

What was the significance of the passing of the Voting Rights Act of 1 5 6 5 in America? Multyple Onoice

A company has $250,000 to be invested in either Project A or Project B with the following cash flows: Year Project A Project B 1 $50,000 $20,000 2 $50,000 $40,000 3 $50,000 $80,000 4 $50,000 $100,000...