Period $ Go-No Go Decision Cost to Buy Tax Credit Annual Savings Cost of Maintenance Net...

Transcribed Image Text:

Period $ Go-No Go Decision Cost to Buy Tax Credit Annual Savings Cost of Maintenance Net Cash Flow 0 $(30,000.00) Payback PV Discounted Pay Back Initial Cost Values $ 1,064.00 $ 1 $9,000.00 $ 1,064.00 $ (168.00) $ (29,104.00) $ (29,104.00) $ (168.00) $ 9,896.00 $ (19,208.00) $ (29,104.00) $ (29,104.00) Tax Credit 30,000.00 $ 9,000.00 9,424.76 $ (19,679.24) Annual Savings $ 1,064.00 2 $ 1,064.00 $ (168.00) $ 896.00 $ (18,312.00) $ 812.70 $ (18,866.54) Cost of Maintenance $ 168.00 3 $ 1,064.00 $ (168.00) $ 896.00 $ (17,416.00) $ 774.00 $ (18,092.54) Discount Rate 5.00% 4 $ 1,064.00 $ (168.00) $ 896.00 $ (16,520.00) $ 737.14 $ (17,355.40) Calculations 5 $ 1,064.00 $ (168.00) $ 896.00 $ (15,624.00) $ 702.04 $ (16,653.36) Payback Period ??? 6 $ 1,064.00 $ (168.00) $ 896.00 $ (14,728.00) $ 668.61 $ (15,984.75) Discounted Payback Period ??? 7 $ 1,064.00 $ (168.00) $ 896.00 $ (13,832.00) $ 636.77 $ (15,347.98) 8 $ 1,064.00 $ (168.00) $ 896.00 $ (12,936.00) $ 606.45 $ (14,741.53) NPV IRR $ (6,758.86) 2% 9 $ 1,064.00 $ (168.00) $ 896.00 $ (12,040.00) $ 577.57 $ (14,163.96) MIRR 4% 10 $ 1,064.00 $ (168.00) $ 896.00 $ (11,144.00) $ 550.07 $ (13,613.90) 11 $ 1,064.00 $ (168.00) $ 896.00 $ (10,248.00) $ 523.87 $ (13,090.02) 12 $ 1,064.00 $ (168.00) $ 896.00 $ (9,352.00) $ 498.93 $ (12,591.10) 13 $ 1,064.00 $ (168.00) $ 896.00 $ (8,456.00) $ 475.17 $ (12,115.93) 14 $ 1,064.00 $ (168.00) $ 896.00 $ (7,560.00) $ 452.54 $ (11,663.39) 15 $ 1,064.00 $ (168.00) $ 896.00 $ (6,664.00) $ 430.99 $ (11,232.40) 2 R c g~ 16 $ 1,064.00 $ (168.00) $ 896.00 $ (5,768.00) $ 410.47 $ (10,821.93) 17 $ 1,064.00 $ (168.00) $ 896.00 $ (4,872.00) $ 390.92 $ (10,431.01) 18 $ 1,064.00 $ (168.00) $ 896.00 $ (3,976.00) $ 372.31 $ (10,058.70) 19 $ 1,064.00 $ (168.00) $ 896.00 $ (3,080.00) $ 354.58 $ (9,704.12) 20 $ 1,064.00 $ (168.00) $ 896.00 $ (2,184.00) $ 337.69 $ (9,366.43) 21 $ 1,064.00 $ (168.00) $ 896.00 $ (1,288.00) $ 321.61 $ (9,044.82) $ 1,064.00 $ (168.00) $ 896.00 $ (392.00) $ 306.30 $ (8,738.52) 23 $ 1,064.00 $ (168.00) $ 896.00 $ 504.00 $ 291.71 $ (8,446.81) 24 $ 1,064.00 $ (168.00) $ 896.00 $ 1,400.00 $ 277.82 $ (8,168.99) 25 $ 1,064.00 $ (168.00) $ 896.00 $ 2,296.00 $ 264.59 $ (7,904.40) 26 $ 1,064.00 $ (168.00) $ 896.00 $ 3,192.00 $ 251.99 $ (7,652.41) 27 $ 1,064.00 $ (168.00) $ 896.00 $ 4,088.00 $ 239.99 $ (7,412.41) 28 $ 30 SSS $ 1,064.00 $ (168.00) $ 896.00 $ 4,984.00 $ 228.56 $ (7,183.85) 1,064.00 $ (168.00) $ 896.00 $ 5,880.00 $ 217.68 $ (6,966.17) $ 1,064.00 $ (168.00) $ 896.00 $ 6,776.00 $ 207.31 $ (6,758.86) Period $ Go-No Go Decision Cost to Buy Tax Credit Annual Savings Cost of Maintenance Net Cash Flow 0 $(30,000.00) Payback PV Discounted Pay Back Initial Cost Values $ 1,064.00 $ 1 $9,000.00 $ 1,064.00 $ (168.00) $ (29,104.00) $ (29,104.00) $ (168.00) $ 9,896.00 $ (19,208.00) $ (29,104.00) $ (29,104.00) Tax Credit 30,000.00 $ 9,000.00 9,424.76 $ (19,679.24) Annual Savings $ 1,064.00 2 $ 1,064.00 $ (168.00) $ 896.00 $ (18,312.00) $ 812.70 $ (18,866.54) Cost of Maintenance $ 168.00 3 $ 1,064.00 $ (168.00) $ 896.00 $ (17,416.00) $ 774.00 $ (18,092.54) Discount Rate 5.00% 4 $ 1,064.00 $ (168.00) $ 896.00 $ (16,520.00) $ 737.14 $ (17,355.40) Calculations 5 $ 1,064.00 $ (168.00) $ 896.00 $ (15,624.00) $ 702.04 $ (16,653.36) Payback Period ??? 6 $ 1,064.00 $ (168.00) $ 896.00 $ (14,728.00) $ 668.61 $ (15,984.75) Discounted Payback Period ??? 7 $ 1,064.00 $ (168.00) $ 896.00 $ (13,832.00) $ 636.77 $ (15,347.98) 8 $ 1,064.00 $ (168.00) $ 896.00 $ (12,936.00) $ 606.45 $ (14,741.53) NPV IRR $ (6,758.86) 2% 9 $ 1,064.00 $ (168.00) $ 896.00 $ (12,040.00) $ 577.57 $ (14,163.96) MIRR 4% 10 $ 1,064.00 $ (168.00) $ 896.00 $ (11,144.00) $ 550.07 $ (13,613.90) 11 $ 1,064.00 $ (168.00) $ 896.00 $ (10,248.00) $ 523.87 $ (13,090.02) 12 $ 1,064.00 $ (168.00) $ 896.00 $ (9,352.00) $ 498.93 $ (12,591.10) 13 $ 1,064.00 $ (168.00) $ 896.00 $ (8,456.00) $ 475.17 $ (12,115.93) 14 $ 1,064.00 $ (168.00) $ 896.00 $ (7,560.00) $ 452.54 $ (11,663.39) 15 $ 1,064.00 $ (168.00) $ 896.00 $ (6,664.00) $ 430.99 $ (11,232.40) 2 R c g~ 16 $ 1,064.00 $ (168.00) $ 896.00 $ (5,768.00) $ 410.47 $ (10,821.93) 17 $ 1,064.00 $ (168.00) $ 896.00 $ (4,872.00) $ 390.92 $ (10,431.01) 18 $ 1,064.00 $ (168.00) $ 896.00 $ (3,976.00) $ 372.31 $ (10,058.70) 19 $ 1,064.00 $ (168.00) $ 896.00 $ (3,080.00) $ 354.58 $ (9,704.12) 20 $ 1,064.00 $ (168.00) $ 896.00 $ (2,184.00) $ 337.69 $ (9,366.43) 21 $ 1,064.00 $ (168.00) $ 896.00 $ (1,288.00) $ 321.61 $ (9,044.82) $ 1,064.00 $ (168.00) $ 896.00 $ (392.00) $ 306.30 $ (8,738.52) 23 $ 1,064.00 $ (168.00) $ 896.00 $ 504.00 $ 291.71 $ (8,446.81) 24 $ 1,064.00 $ (168.00) $ 896.00 $ 1,400.00 $ 277.82 $ (8,168.99) 25 $ 1,064.00 $ (168.00) $ 896.00 $ 2,296.00 $ 264.59 $ (7,904.40) 26 $ 1,064.00 $ (168.00) $ 896.00 $ 3,192.00 $ 251.99 $ (7,652.41) 27 $ 1,064.00 $ (168.00) $ 896.00 $ 4,088.00 $ 239.99 $ (7,412.41) 28 $ 30 SSS $ 1,064.00 $ (168.00) $ 896.00 $ 4,984.00 $ 228.56 $ (7,183.85) 1,064.00 $ (168.00) $ 896.00 $ 5,880.00 $ 217.68 $ (6,966.17) $ 1,064.00 $ (168.00) $ 896.00 $ 6,776.00 $ 207.31 $ (6,758.86)