Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started