thank you!

The information you hand to Mary shows the following: Initial investment outlay of $30 million, consisting of $25 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal year Project and equipment life: 5 years Sales: $25 million per year for five years Assume gross margin of 60% (exclusive of depreciation) Depreciation: Straight-line for tax purposes Selling, general, and administrative expenses: 10% of sales Tax rate: 35% "Then, compute NPV and IRR of the project using the Excel spreadsheet I sent earlier today," says Mary. "Use the IRR financial function for the computation of IRR." A Cost of Capital Time/yr Cash flow Input here Discounted CF 5 6 7 8 9 10 11 NPV 12 PV factor 13 14 IRR 15 16 17 B 10.00% #NUM! G 0 0=cf1/((1+n)^1) 0 0.909090909 D =cf2/((1+n)^2) 2 0 0.826446281 E =cf3/((1+n)^3) 3 0 0.751314801 F =cf4/((1+n)^4) 4 0 0.683013455 G 5 0 0.620921323 =cf5/((1+n)^5) H