An amount of R50000 is invested in a project that predicts the quarterly cash flow return over the next four years, given in the table below. Quarters 2 3 4 5 6 9 10 11 12 13 14 15 16 Rands 1500 3000 4500 5600 5900 6400 6600 7200 7800 8000 8100 8500 x i)If the internal rate of return for this cash flow is 21,32% p.a , then the value of the payment (rounded to the nearest cent) at T16 is equal to Blank 1. Fill in the blank, read surrounding text. ii) Using your answer from (i) and the information that the NPV = R4500, see if you can use your IRR function to solve for the bank rate. HINT: Write out the formula for the NPV and then re-arrange it to make it equal to zero. This will give a new "initial investment" value. Put it into the cash flow function and use the IRR to solve for the rate (because the equation is equal to zero). This will actually give you the bank rate. The nominal rate compounded quarterly that is offered by the bank, is equal to Blank 2. Fill in the blank, read surrounding text. % p.a compounded quarterly (as a percentage rounded to two decimal places.) Check your answer by calculating the NPV with this bank rate and the investment value of 50000 to see that you actually get the NPV value equal to R4500.
An amount of R50000 is invested in a project that predicts the quarterly cash flow return over the next four years, given in the table below.
| Quarters | 2 | 3 | 4 | 5 | 6 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| Rands | 1500 | 3000 | 4500 | 5600 | 5900 | 6400 | 6600 | 7200 | 7800 | 8000 | 8100 | 8500 | x |
i)If the
ii) Using your answer from (i) and the information that the
HINT: Write out the formula for the NPV and then re-arrange it to make it equal to zero. This will give a new "initial investment" value. Put it into the cash flow function and use the IRR to solve for the rate (because the equation is equal to zero). This will actually give you the bank rate.
The nominal rate compounded quarterly that is offered by the bank, is equal to Blank 2. Fill in the blank, read surrounding text. % p.a compounded quarterly (as a percentage rounded to two decimal places.)
Check your answer by calculating the NPV with this bank rate and the investment value of 50000 to see that you actually get the NPV value equal to R4500.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
