Answer & Explanation: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:
Determine
the cash inflows and outflows for each year.Evaluate
the capital project by calculating the following metrics:
net present
value (NPV)internal
rate of return (IRR)modified
internal rate of return (MIRR)payback
period 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.
capital_project_case_study_part_1.doc
