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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
