1 L23 fx A B C D E F Benson Regional Medical Center: Capital Budgeting 2 Discount Rate = 10% 3 4 WACC = 10% 5 6 Program A 7 Years Cash Flows 8 0 -$228,500.00 9 1 10 2 $16,715.00 $83,070.24 11 3 $172,620.29 12345 4 $137,957.29 5 $92,975.49 Discounted Payback Period 23 24 25 26 27 SE22222222 16 17 18 Project A 19 2 20 3 21 4 5 Years Cash Flows Cash Flows discounted to today's $$ (PV) Cumulative Discounted CFs 0 1 -$228,500.00 $16,715.00 $83,070.24 -$228,500.00 ($228,500.00) $15,195.45 ($213,304.55) $68,653.09 ($144,651.45) $172,620.29 $129,692.18 ($14,959.28) $137,957.29 $94,226.69 $79,267.41 $92,975.49 $57,730.46 $136,997.87 Net Present Value = $136,997.87 Internal Rate of Return = 16% Discounted Payback (YY/MM) = 4/2 0.16 Sheet1 Type here to search Project B G H K L M N Years Program B Cash Flows -$419,500.00 0 1 2 3 4 5 Years 0 $45,430.00 $153,351.75 $294,861.83 $282,824.17 $220,932.28 Discounted Payback Period Cash Flows Cash Flows discounted to today's $$ (PV) -$419,500.00 Cumulative Discounted CFs -$419,500.00 $41,300.00 -$378,200.00 -$419,500.00 1 $45,430.00 2 $153,351.75 $126,736.98 -$251,463.02 3 $294,861.83 $221,534.06 -$29,928.96 4 $282,824.17 $193,172.71 $163,243.75 5 $220,932.28 $137,181.56 $300,425.32 Net Present Value = Internal Rate of Return= Discounted Payback (YY/MM) = $300,425.32 18% amazon 4/2 -0.15493368 53F 8:23 AM 12/7/2021