Question: With the information above fill out the excel sheet below with work: MACRS Schedule 3-year 5- year begin{tabular}{rrcccccc} Year 1 & Year 2 & Year

With the information above fill out the excel sheet below with

With the information above fill out the excel sheet below with work:

$work: MACRS Schedule 3-year 5- year \begin{tabular}{rrcccccc} Year 1 & Year 2$

MACRS Schedule 3-year 5- year \begin{tabular}{rrcccccc} Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 & Year 8 \\ \hline 33.33% & 44.45% & 14.81% & 7.41% & & & \\ 20.00% & 32.00% & 19.20% & 11.52% & 11.52% & 5.76% & \\ 14.29% & 24.49% & 17.49% & 12.49% & 8.93% & 8.92% & 8.93% & 4.46% \end{tabular} Pro Forma Income Statements Year \begin{tabular}{lllll} 1 & 2 & 4 & 5 \\ \hline \end{tabular} Revenues Variable costs Fixed costs Depreciation EBIT Taxes(21%) Net income OCF Net Working Capital Year 0 01 2 3 Initial NWC Ending NWC NWC cash flow Salvage Value Market value of salvage Book value of salvage Taxes on sale: Aftertax salvage value: Project Cash Flows Year OCF Change in NWC Capital spending Total cash flow Cumulative cash flow Payback calculation Discounted cash flows Cumulative discounted cash flow Discounted payback calculation MACRS Schedule 3-year 5- year \begin{tabular}{rrcccccc} Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Year 7 & Year 8 \\ \hline 33.33% & 44.45% & 14.81% & 7.41% & & & \\ 20.00% & 32.00% & 19.20% & 11.52% & 11.52% & 5.76% & \\ 14.29% & 24.49% & 17.49% & 12.49% & 8.93% & 8.92% & 8.93% & 4.46% \end{tabular} Pro Forma Income Statements Year \begin{tabular}{lllll} 1 & 2 & 4 & 5 \\ \hline \end{tabular} Revenues Variable costs Fixed costs Depreciation EBIT Taxes(21%) Net income OCF Net Working Capital Year 0 01 2 3 Initial NWC Ending NWC NWC cash flow Salvage Value Market value of salvage Book value of salvage Taxes on sale: Aftertax salvage value: Project Cash Flows Year OCF Change in NWC Capital spending Total cash flow Cumulative cash flow Payback calculation Discounted cash flows Cumulative discounted cash flow Discounted payback calculation

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!

Pro Corporation purchased 11,000 shares of Schroeder Corporation on January 1, 20X3, at book value. At that date, the fair value of the noncontrolling interest was equal to 26.6 percent of Schroeders...

You are creating a business plan to add an outpatient MRI located on Local Hospital campus. This plan is being submitted to senior leadership of Local Hospital for consideration. Business Plan Format...

Introduction: You have recently been hired as a Financial Analyst in the Finance Department of Zeta Auto Corporation which is seeking to expand production. The CFO asks you to help decide whether the...

I need help writing therecommendation to the CFO (not the executive summary). I have already completed the attached excel workbook. Introduction: You have recently been hired as a Financial Analyst...

Hi! I need help on finishing what I could not figure out. I got the basic analysis part and tornado diagram finished. I need help on the breakeven and the CP part. If you could look over the WACC tab...

let me know I will increase the price if you really solve the problem. Introduction: You have recently been hired as a Financial Analyst in the Finance Department of Zeta Auto Corporation which is...

You have recently been hired as a Financial Analyst in the Finance Department of Zeta Auto Corporation which is seeking to expand production. The CFO asks you to help decide whether the firm should...

As a Financial Analyst in the Finance Department of Zeta Auto Corporation they are seeking to expand production. The CFO asks you to help decide whether the firm should set up a new plant to...

To assess the suitability of the project you begin by listing the various cash flows. A consultant has been paid $50,000 to do a market survey. She reports back that Zeta can sell 7,000 Spenzas for...

Air flows into an insulated nozzle at 1MPa, 1200 K with 15 m/s and mass flow rate of 2 kg/s. It expands to 650 kPa and exit temperature is 1100 K. Find the exit velocity, and the nozzle efficiency.

Little Toddlers (Pty) Ltd (hereafter Little Toddlers) is a company that has been operating in Windhoek and manufactures clothes for children. Little Toddlers has various assets that it uses in its...

Insert a drawing of a logical gate representing the following Boolean expression. which gate is AND, OR or NOT x ( y + z )

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...