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

/in /by

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