how to get NPV and ROI, please show calculate Created by: Amber Cary Discount rate Financial Analysis

how to get NPV and ROI, please show calculate

Transcribed Image Text:

Created by: Amber Cary Discount rate Financial Analysis for Project1 Date: January 18, 2017 Costs Discount factor Discounted costs Benefits Discount factor Discounted benefits ROI $200,000 0 1.00 $200,000 9% $30,000 1 0.92 $27,523 Discounted benefits - discounted costs, or NPV 0.92 $91,743 Year 2 $0 $100,000 $100,000 $100,000 1.00 $0 3 $30,000 $30,000 0.77 0.84 $25,250 $23,166 0.84 0.77 $84,168 $77,218 TOTAL $275,939 $300,000 $253,129 ($22,809) -8% Created by: Amber Cary Discount rate Financial Analysis for Project1 Date: January 18, 2017 Costs Discount factor Discounted costs Benefits Discount factor Discounted benefits ROI $200,000 0 1.00 $200,000 9% $30,000 1 0.92 $27,523 Discounted benefits - discounted costs, or NPV 0.92 $91,743 Year 2 $0 $100,000 $100,000 $100,000 1.00 $0 3 $30,000 $30,000 0.77 0.84 $25,250 $23,166 0.84 0.77 $84,168 $77,218 TOTAL $275,939 $300,000 $253,129 ($22,809) -8%