Create a spreadsheet in which you analyze the costs and returns of adding a childcare option to an employer sponsored retirement and benefits plan using ROI, Payback, IRR, and NPV. The point of this assignment is to show understanding of how to analyze costs and returns and which financial measures to apply.
Duration- 5 years
Discount Rate- 5%
Initial investment- $1,000,000
Cash inflow generated: $50,000
Expected return from other projects 10%
Net Profit expected from implementing childcare- $500,000
NPV-
IRR-
ROI-
Payback Period- 2 years