- B C D E F G H 1 A11y 2 Back To Index 3 Model 4 12 31 2020 3 31 2021 6 30 2021 9 30 2021 12 31 2021 3 31 2022 6 30 2022 9 1 (60.35 KiB) Viewed 31 times
- B C D E F G H 1 A11y 2 Back To Index 3 Model 4 12 31 2020 3 31 2021 6 30 2021 9 30 2021 12 31 2021 3 31 2022 6 30 2022 9 2 (26.29 KiB) Viewed 31 times
B C D E F G H 1 A11Y 2 Back to Index 3 Model 4 12/31/2020 3/31/2021 6/30/2021 9/30/2021 12/31/2021 3/31/2022 6/30/2022 9/30/2022 12/31/2022 5 | -$975,000 6 Exp. Revenues $0 $300,000 $325,000 $330,000 $370,000 $400,000 $445,000 $435,000 $450,000 7 Exp. Expenses $0 $160,000 $185,000 $315,000 $245,000 $220,000 $200,000 $190,000 $185,000 8 Taxable $0 $140,000 $140,000 $15,000 $125,000 $180,000 $245,000 $245,000 $265,000 9 Taxes (35%) $0 $49,000 $49,000 $5,250 $43,750 $63,000 $85,750 $85,750 $92,750 10 TV $300,000 11 Net CFS $975,000 $91,000 $91,000 $9,750 $81,250 $117,000 $159,250 $159,250 $472,250 12 Benchmark rate 13%
In order to calculate an annual internal rate of return for this investment project, how should the IRR function be set up? Note 1: The benchmark rate is an annual rate Note 2: You may assume that 12/31/2020 is time 0 O=IRR(B11:J11,J10)*4 O=IRR(B11:J11)*4 O=IRR(B11:J11,J10) 0 =(1+IRR(B11:J11)^4)-1 O=IRR(C11:J11)+B11