A maintenance company is offering a firm tow payments plans, A and B for a machi
ID: 2735463 • Letter: A
Question
Explanation / Answer
1)use pv formulae ine excel to find the present value of each payment
pv(eate,nper,pmt,fv,type)
plan A:
Here rate=6% nper=4 pmt=480
=PV(6%,4,-480,,0)=$1663.25
plan B:
hre it is monthly so rate =6%/12 nper=5*12(monthly) pmt=50
=PV(6%/12,5*12,-50,,0)=$2586.28
Plan A is better since we are paying less there
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.