Explore BrainMass
Share

Explore BrainMass

    Cash flow scenarios NPV and IRR

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Initial investment outlay of $20 million for equipment only
    Project and equipment life: 5 years
    Sales projected to be $12 million per for 5 years
    Assume gross margin of 50% (exclusive of depreciation)
    Depreciation: straight-line for tax purposes
    Selling, general and administrative expenses: 10% of sales
    Tax rate: 35%
    Solve for NPV and IRR.

    © BrainMass Inc. brainmass.com October 10, 2019, 7:18 am ad1c9bdddf
    https://brainmass.com/business/discounted-cash-flows-model/cash-flow-scenarios-npv-and-irr-576425

    Solution Summary

    The tutorial with instructional notes is attached in excel. Click in cells to see computation. You do not specify a required rate of return or cost of capital. I assumed 8% but the model will update if you change this rate (see yellow cell).

    $2.19