applied managerial finance
With the following information: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 yearProject and equipment life: 5 yearsSales: $25 million per year for five yearsAssume gross margin of 60% (exclusive of depreciation)Depreciation: Straight-line for tax purposesSelling, general, and administrative expenses: 10% of salesTax rate: 35%Use a WACC of 1%.Compute, cash flows, NPV and IRR of the project using the Excel spreadsheet. (Use the IRR financial function for the computation of IRR.)Submit an Excel Spreadsheet
OUR PROCESS
Order
Payment
Writing
Delivery
Why Choose Us: Cost-efficiency, Plagiarism free, Money Back Guarantee, On-time Delivery, Total Сonfidentiality, 24/7 Support, 100% originality
.P4IP NPV-IRR full spreadsheet empty to instructor files-1.xlsx