Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Flo 2970000 2 (10,000,000)X IC NWC (100,000) (650,000)(750,000) 15,000,000 8,000,000 500,000 2,000,000 4,500,000 1,530,000 2,970,000 2,000,000 4,970,000 450,000 1,050,000 6,500,000 4,000,000 500,000 2,000,000 2,000,000 7,500,000
Flo 2970000 2 (10,000,000)X IC NWC (100,000) (650,000)(750,000) 15,000,000 8,000,000 500,000 2,000,000 4,500,000 1,530,000 2,970,000 2,000,000 4,970,000 450,000 1,050,000 6,500,000 4,000,000 500,000 2,000,000 2,000,000 7,500,000 4,000,000 500,000 2,000,000 1,000,000 340,000 660,000 2,000,000 2,660,000 15,000,000 8,000,000 500,000 2,000,000 4,500,000 1,530,000 2,970,000 2,000,000 4,970,000 Sales VCs FCs 10,500,000 5,600,000 500,000 6 EBT -T(.34) 2,400,000 816,000 1,584,000 10 2,000,000 2,000,000 3,584,000 2,000,000 12 13 14 15 16 17 18 19 20 21 OCF Salvage NPV- $3,597,996.91 >0, Accept! IRR- 22.30% >10%, Accept! Question: If each year's price per unit decreases by the same ?96, will the project's NPV become zero? Please reference all cells and make the final link in cell "A1" (Note that VCs vary with sales accordingly.) 23 24 25 Print the revised table and results on one page; print the formula sheet on the back of the same page To show formulas, go to "Formulas", then "Show Formulas". Before you print, please go to "Page Setup", "Sheet", choose "Row and column headings
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started