What would be the IRR and NPV in the scenario with an ROI of 7% and a payback period od 3 years

CoursHeroTranscribedText

File Home Insert Page Layout Formulas Data Review View Help Cut Calibri 11 A A Wrap Text Copy Paste BI U v A v Merge & Center Format Painter > Alignment General $ % 9500-00 x AutoSum 4 Fill Conditional Format as Formatting Table Cell Styles Insert Delete Format Clear Filter Sort & Find & Select Analyze Data > Styles Cells Editing Analysis Clipboard H20 Font Number fx B C D E F G H Onsite Daycare Onsite Daycare Wellness Program Wellness Program 2 Costs Value Benefits Value 4 3 Salary Healthcare 5 customization 6 Food/ENT 7 Building Space $ 100,000.00 Attendence Increase $ 20,000.00 $125,000 $125,000 Costs Gym Membership Value Benefits Value $ 250,000.00 $ 325,000.00 Food $ 50,000.00 $ 325,000.00 $ 10,000.00 $ 45,000.00 Medicinal shop Spa $ 75,000.00 $ 80,000.00 $ 65,000.00 Increase in Production 8 Total Costs of OD 9 $ 240,000.00 total benefits of OD $250,000 Total Costs of WP $ Employee Stock Option Plan Employee Stock Option Plan 10 Costs Value Benefits Value Costs Profit Match to Retirement Plan Value 230,000.00 Total Benefits of WP Profit Match to $ 650,000.00 11 Call Options $ 550,000.00 Wages Saved $ 12 13 14 Employee Retention Increase in Attendence Increase in Production $ $ 85,000.00 Senior Employees 80,000.00 Contribution Match $ 115,000.00 $ Benefits 90,000.00 Increase in Production 115,000.00 Wages Saved Retirement Plan Value $ 150,000.00 $ 60,000.00 Employee Retention $ 85,000.00 $ 150,000.00 15 16 Total Costs of ESOP $ 325,000.00 Total Benefits of ESOP $ 17 Total Costs $ 825,000.00 430,000.00 Total Costs of PMRP Analyzing Costs & Returns $ 18 Total Benefits $ 1,000,000.00 Program Costs Benefits 19 Annual Return $ 85,000.00 Onsite Daycare $ 250,000.00 $ 205,000.00 Total Benefits of PMRP $ Metric Value ROI 250,000.00 Payback 295,000.00 7% 3 20 21 22 Wellness Program Employee Stock Option Plan Profit Match to Retirement Plan $ 230,000.00 $ 250,000.00 IRR $ 325,000.00 $ 325,000.00 NPV $ 205,000.00 $ 205,000.00 23 Total $ 1,010,000.00 $ 1,030,000.00 24 25 26 Annual Return Initial Investments to get Programs Started RRR (Discount) $ 65,000.00 $ 162,000.00 15% 27 28 29 Sheet1 a X N P W Share Comments K L M N + 100% 9:59 PM 1/9/2021