Introduction
Microsoft Excel is an excellent tool that can be used for solving Business Math problems. This guide has been developed as a companion to the Math71775 course at Conestoga College.
In addition to using financial formulas, the following functions will covered:
DAYS(end_date,start_date)
NOMINAL(effect_rate,npery)
EFFECT(nominal_rate,npery)
FV(rate, nper, pmt, pv, type)
PV(rate, nper, pmt, fv, type)
NPER(rate,pmt,pv,fv,type)
PMT(rate,nper,pv,fv,type)
RATE(nper,pmt,pv,fv,type)
CUMIPMT(rate,nper,pv,start_period,end_period,type)
CUMPRINC(rate,nper,pv,start_period,end_period,type)
IPMT(rate,per,nper,pv,fv,type)
PPMT(rate,per,nper,pv,fv,type)