Question: Please do these maths in short cut way in excel: ( not using Chat gpt ) Find the present value of the following cash flows:

Please do these maths in short cut way in excel: (not using Chat gpt)
Find the present value of the following cash flows:
(1) A fifteen year annuity of $300 starting at T3. Interest rates are 6%.
(2) A seven year annuity of $450 starting in five year's time. Interest
rates are 11%
(3) A perpetuity of $33,000 commencing at T2. Interest rates are 22%
(4) A perpetuity of $14,000 starting in ten year's time. Interest rates are 12.5%
(5) A perpetuity of $2,000 starting in six year's time, growing at 3% per annum. Interest rates are 10%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!