Problem 11-12 New-Project Analysis Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax...

70.2K

Verified Solution

Question

Finance

Problem 11-12
New-Project Analysis

Madison Manufacturing is considering a new machine that costs$350,000 and would reduce pre-tax manufacturing costs by $110,000annually. Madison would use the 3-year MACRS method to depreciatethe machine, and management thinks the machine would have a valueof $33,000 at the end of its 5-year operating life. The applicabledepreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Workingcapital would increase by $35,000 initially, but it would berecovered at the end of the project's 5-year life. Madison'smarginal tax rate is 40%, and a 10% cost of capital is appropriatefor the project.

  1. Calculate the project's NPV. Round your answer to the nearestdollar.
    $  
    Calculate the project's IRR. Round your answer to two decimalplaces.
         %
    Calculate the project's MIRR. Round your answer to two decimalplaces.
         %
    Calculate the project's payback. Round your answer to two decimalplaces.
         



  2. Assume management is unsure about the $110,000 cost savings -this figure could deviate by as much as plus or minus 20%.Calculate the NPV if cost savings value deviate by plus 20%. Roundyour answer to the nearest dollar.
    $  
    Calculate the NPV if cost savings value deviate by minus 20%. Roundyour answer to the nearest dollar.
    $



  3. Suppose the CFO wants you to do a scenario analysis withdifferent values for the cost savings, the machine's salvage value,and the working capital (WC) requirement. She asks you to use thefollowing probabilities and values in the scenario analysis:

    Scenario

    Probability
    Cost
    Savings
    Salvage
    Value

    WC
    Worst case0.35$  88,000$28,000$40,000
    Base case0.35110,00033,00035,000
    Best case0.30132,00038,00030,000

    Calculate the project's expected NPV. Round your answer to thenearest dollar.
    $  
    Calculate the project's standard deviation. Round your answer tothe nearest dollar.
    $  
    Calculate the project's coefficient of variation. Round your answerto two decimal places.
         

Answer & Explanation Solved by verified expert
3.8 Ratings (522 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Problem 11-12New-Project AnalysisMadison Manufacturing is considering a new machine that costs$350,000 and would reduce pre-tax manufacturing costs by $110,000annually. Madison would use the 3-year MACRS method to depreciatethe machine, and management thinks the machine would have a valueof $33,000 at the end of its 5-year operating life. The applicabledepreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Workingcapital would increase by $35,000 initially, but it would berecovered at the end of the project's 5-year life. Madison'smarginal tax rate is 40%, and a 10% cost of capital is appropriatefor the project.Calculate the project's NPV. Round your answer to the nearestdollar.$  Calculate the project's IRR. Round your answer to two decimalplaces.     %Calculate the project's MIRR. Round your answer to two decimalplaces.     %Calculate the project's payback. Round your answer to two decimalplaces.     Assume management is unsure about the $110,000 cost savings -this figure could deviate by as much as plus or minus 20%.Calculate the NPV if cost savings value deviate by plus 20%. Roundyour answer to the nearest dollar.$  Calculate the NPV if cost savings value deviate by minus 20%. Roundyour answer to the nearest dollar.$Suppose the CFO wants you to do a scenario analysis withdifferent values for the cost savings, the machine's salvage value,and the working capital (WC) requirement. She asks you to use thefollowing probabilities and values in the scenario analysis:ScenarioProbabilityCostSavingsSalvageValueWCWorst case0.35$  88,000$28,000$40,000Base case0.35110,00033,00035,000Best case0.30132,00038,00030,000Calculate the project's expected NPV. Round your answer to thenearest dollar.$  Calculate the project's standard deviation. Round your answer tothe nearest dollar.$  Calculate the project's coefficient of variation. Round your answerto two decimal places.     

Other questions asked by students