Question: confused on what to do Study the following two google sheets formulas. a. =pmt(0.08/12,126,-50000,0) which yields $876.66 b. =pmt(0.08/12, 12*6,0,50000) which yields -$543.33 i. For
Study the following two google sheets formulas. a. =pmt(0.08/12,126,-50000,0) which yields $876.66 b. =pmt(0.08/12, 12*6,0,50000) which yields -$543.33 i. For both a and b, describe the situation in detail. The interest rate is __%, compounded _ for years. Explain the present value and the future value. ii. How much total money is earned or paid in interest in each situation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
