Question: Can somebody please help me fill out this chart with cell references? All information needed is present, it's just very confusing to me. The MAVI

 Can somebody please help me fill out this chart with cellreferences? All information needed is present, it's just very confusing to me.

Can somebody please help me fill out this chart with cell references? All information needed is present, it's just very confusing to me.

The MAVI Company is considering investing in a new machine for one of its factories. The company can choose either MAchine A or Machine B. The life span for each machine is 5 years, and depreciation is straight-line to zero salvage value. The widgets produced by the machines are sold for $6 each. The company has a cost of capital of 12%, and its tax rate is 35%. PART A. If the company manufactures 1,000,000 units per year, which machine should it buy? MAVI WIDGET COMPANY \begin{tabular}{|l|r|r|} \hline Cost of capital & 12% \\ \hline Tax rate & 35% & \\ \hline Widget sales price/unit & 6.00 & \\ \hline & & \\ \hline Cost & Machine A & Machine B \\ \hline Annual fixed cost & 4,000,000 & 10,000,000 \\ \hline Variable cost per widget & 300,000 & 210,000 \\ \hline Life span (years) & 1.20 & 0.80 \\ \hline A & 5 & 5 \\ \hline \end{tabular} Annual depreciation Cash flow, annual Production Revenue Fixed cost Variable cost Depreciation Profit before taxes Add back depreciation Cash flow NPV for 5 years Decision The MAVI Company is considering investing in a new machine for one of its factories. The company can choose either MAchine A or Machine B. The life span for each machine is 5 years, and depreciation is straight-line to zero salvage value. The widgets produced by the machines are sold for $6 each. The company has a cost of capital of 12%, and its tax rate is 35%. PART A. If the company manufactures 1,000,000 units per year, which machine should it buy? MAVI WIDGET COMPANY \begin{tabular}{|l|r|r|} \hline Cost of capital & 12% \\ \hline Tax rate & 35% & \\ \hline Widget sales price/unit & 6.00 & \\ \hline & & \\ \hline Cost & Machine A & Machine B \\ \hline Annual fixed cost & 4,000,000 & 10,000,000 \\ \hline Variable cost per widget & 300,000 & 210,000 \\ \hline Life span (years) & 1.20 & 0.80 \\ \hline A & 5 & 5 \\ \hline \end{tabular} Annual depreciation Cash flow, annual Production Revenue Fixed cost Variable cost Depreciation Profit before taxes Add back depreciation Cash flow NPV for 5 years Decision

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!