Determine the cash inflows and outflows for each year, business and finance homework help

Please see attached documents to complete assignment. Work Must be Shown.

Assignment

The Capital Project Case Study, Part 2 spreadsheet provides cash flow data (costs and benefits) for the proposal. Download and save this Excel spreadsheet, and use the information provided to complete the following:

  1. Determine the cash inflows and outflows for each year.

  2. Evaluate the capital project by calculating the following metrics:

    1. net present value (NPV)

    2. internal rate of return (IRR)

    3. modified internal rate of return (MIRR)

    4. payback period

    5. discounted payback period

Indicate whether the project is acceptable, assuming Jiranna has a corporate policy of not accepting projects that take more than 3.5 years to pay for themselves, and assuming an 11% cost of capital