Note: In order to use the spreadsheet examples, you need to download Business Functions | ||||||||
PVTStepRentFcst (NPVDate, DisAER, RentStart, BrksOrExp, ReviewDates, AnnRents, FcstVals, StartFcst, FcstBase, [RevMos], [RevDisc], [DayCount], [CashBasis], [DayCountDisc], [PrdsDisc], [StartDCF], [FinishDCF], [UOTog], [Brk]) | ||||||||
Present Value of the TStepRentFcst function | ||||||||
This function simply does a Present Value of the TStepRentFcst function, doing all the discounting housekeeping internally and just outputting the NPV. | ||||||||
Features | ||||||||
Market Zero-Aware | Market Zero-Aware | |||||||
PV... | Present Value | |||||||
T... | Rates pertain to the time up until each corresponding to date | |||||||
...Fcst... | Changes are read of a supplied forecast. | |||||||
Step... | Has a stepped rate profile | |||||||
ExamplePVTStepRentFcst.xls |