Value either a delayed perpetuity or a delayed annuity


Problem: 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.

Request for Solution File

Ask an Expert for Answer!!
Finance Basics: Value either a delayed perpetuity or a delayed annuity
Reference No:- TGS03230562

Expected delivery within 24 Hours