Interest family

Banking category Home 

ComponentWhat the name means
Interest Calculate Interest for a timeperiod for a Balance that has Start and Finish dates.
FInterest Calculate Interest using 'From' Dates
TInterest Calculate Interest using 'To' dates
TotInterestSF The total interest accrued between two dates
InterestX Calculate Interest for a timeperiod for a Balance that has Start and Finish dates., extended version
PVFInterest PV of FInterest
PVInterestX PV of InterestX
PVInterest PV of Interest

Loan Sign Convention

+ve-ve
Loan Balances:You OweYou are Owed
Cash Balances:NAYou have Cash
InterestYou ReceiveYou Pay
PrincipalYou DrawYou Repay