Schedule of payments

Today we are using excel to make a schedule of payments. In don want to blog too much because i have to listen it is going by pretty fast and i need to pay attention. Untill we meet again!

To add a payment function - Formulas->insert function->PMT

Whoah! havent blogged in a while! today we are learning about tvm
n=number of times in total interest is compounded.
APPS ENTER ENTER
i%=interest rate as A.P.R.
PV= Present value(value at time now)
PMT=Payment per period
FV= Future value
P/Y= Payments per year
C/Y= compoundings per year