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)

 

License

Icon for the Creative Commons Attribution-NonCommercial 4.0 International License

Using Excel in Business Math Copyright © by Lisa Koster is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

Share This Book