Question: make a user defined VBA function that has the flexibility to value either a delayed perpetuity or a delayed annuity, being sure that your function

make a user defined VBA function that has the flexibility to value either a delayed perpetuity or a delayed annuity, being sure that your function accommodates the possibility that the yearly cash flows for the delayed perpetuity/annuity will grow at a constant rate once the initial payment has been received at the end of M+1 years. Your Function must be included in a Spreadsheet Module named Delay. Please remember to save your spreadsheet in macro-enabled format with a .xlsm extension.

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!