I need help with my Apply Managerial Finance.

I need an Excel file showing the computation of cash flows, NPV, and IRR. I'm just not processing it and it is really driving me crazy.

Here's the information I was given in order to be able to complete this assignment.

The information you hand to Mary shows the following: This is the scenario that was give listed below.

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%