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

confused on what to do
confused on what to do Study the following two google sheets formulas.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!