The question was "What is the interest-based payback". The answer is given already. I just want to know how you would get those numbers in the interest-based CB column on excel.
Given the answers below. How would you find the Interest-based cash balance column on excel? I just need some clarification on how to achieve the answers given in excel. $ Initial O&M cost Incrementate O&M costs Discount interest rate Initials of tourists Incrementate tourists Ticket price IC IOM DIR NT 80,000.00 3% 12% 60000 10% 10.00 P Costs #tourists Revenues Year O&M Construction $ 1,000,000.00 $ $ 1,500,000.00 $ $ $ $ $ $ $ $ 40,000.00 80,000.00 82.400.00 84.872.00 87.418.16 90.040.70 92,741.93 95.524.18 98.389.91 Advertising Total costs 20,000.00 $ 1,020,000.00 20,000.00 $ 1,520,000.00 $ 40,000.00 $ 120,000.00 $ $ 122,400.00 40,000.00 $ 124.8 72.00 40,000.00 $ 127.418.16 40,000.00 $ 130.040.70 40,000.00 $ 132,741.93 40,000.00 $ 135,524.18 $ 40,000.00 $ 138,389.91 60000 $ 60000 $ 66000 $ 72600 $ 79860 $ 87846 $ 96630.6 $ 106293.66 $ 600,000.00 600,000.00 660,000.00 726,000.00 798,600.00 878 460.00 966.306.00 1.062.936.60 10 Parta) Part c) Yea Outflows Infows Cash flows Discounted CF Cash Balances (CB) Interest based CB $ (1.020,000.00) $ $ (1.020,000.00) $1,020,000.00 $ (1.020,000.00) $ (1.020.000.00) 2 $ (1,520,000.00) $ $ (1.520,000.00) $1,357,142 86 $ R2,540,000.00) S (2,662,400.00) 31 $ (120,000.00) $ 600,000.00 $ 480,000.00 $ 382,653.06 $ 2.060,000.00) $ (2,501.888.00 415 (122,400.00) $ 600,000.00 $ 477.600.00 $ 339,946.25 $ (1.582,400.00) $ (2,324,514.56) 51 $ * 660.000.00 (124.8 72.00) $ 1 $ 535,128.00 340.083.52 (1.047.272.00) $ (2,068,328.31) 6$ (127.418.16) $ 726.000.00 598,58 1.84 339,65141 $ (448.690.16) $ (1.717,945.86) 75 (130,040.70) $ 798.600.00 $ 668,559.30 3 338,712.95 219,869.14 $ (1.255.540.07) 8$ (132,741.93) $ 878.460.00 745.718.07 $ 337,324.99 $ 965,58 7.21 $ 660 486.81) (135,524.18) $ 966,306.00 830,78 1.82 $ 335,538 84 $ 1.796.36 9.03 $ 91.036.59 10 (138,389.91) $ 1.062.936.60 924,546.69 $ 333,400.81 $ 2.720,915.72 $ 1,026,507.67 Total $ 2,720,915.72 $ 370, 168.96
