Note: In order to use the spreadsheet examples, you need to download Business Functions
|DepreciateFcstPer (Time, Base, AbsFinish, StartDep, LifeOrDecRate, DepType, InitialValue, [FinalValue], FcstVals, StartFcst, FcstBase, Periodicity, [DayCount], [Periods], [ProjMode])|
|Auto Array Function|
|...Fcst...||Changes are read of a supplied forecast.|
Use of AbsFinish: No depreciation strean can start after AbsFinish. depreciation CAN occur after AbsFinish. In other words, AbsFinish marks the end of when StartDeps can occur, even though depreciation can continue after this date.
If ØIntervalØ months is shorter than LifeOrDecRate years, successive depreciation streams will overlap - this is fine. Note though that if ØIntervalØ is zero, the function will not periodically repeat at all.