create the pro forma balance sheet

1. 1. See attached file

2.  

3. Calculate external funds needed (EFN) to create the pro forma balance sheet. Calculate the following year-end ratios for the pro forma statements:

4.  

• Profit as a percentage of sales
• Current ratio
• Asset ratio

Create pro forma statements.

1.  

2. 2. Determine the proposal’s appropriateness and economic viability. For the scenario, assume spending occurs on the first day of each year and benefits or savings occurs on the last day. Assume the discount rate or weighted average cost of capital is 10%. Ignore taxes and depreciation.

3.  

Proposal A: New Factory

A company wants to build a new factory for increased capacity. Find the net present value (NPV) and use the method of capital budgeting, determine the proposal’s appropriateness and economic viability with the following information:

• Building a new factory will increase capacity by 30%.

• The current capacity is $10 million ofsales with a 5% profit margin.

• The factory costs $10 million to build.

• The new capacity will meet the company’s needs for 10 years.

• The factory is worth $14 million over 10 years.

Explain the effect of a higher or lower cost of capital on a firm’s long-term financial decisions.

Analyze the use of capital budgeting techniques in strategic financial management.

***Utilize Excel Spreadsheet***

“