Question: On the Excel, Is there any order to put first? for example, =Rate(-PV,FV,TIME,PMT) Like that kind of order? I put this way, but it shows

 On the Excel, Is there any order to put first? forexample, =Rate(-PV,FV,TIME,PMT) Like that kind of order? I put this way, but

On the Excel, Is there any order to put first? for example, =Rate(-PV,FV,TIME,PMT) Like that kind of order?

I put this way, but it shows up like that (#NUM!)

Also, PMT order, PV order please.

Problem 1.19 INPUT Problem 1.20 INPUT PV= FV= $ Problem 1.21 INPUT PV= PV= ? ? $ $ FV= FV= $ RATE= 4% 5% 500,000.00 ? 20 2500 RATE= TIME= RATE= TIME= TIME= 25 30 24000 PMT= PMT= PMT= 80000 OUTPUT OUTPUT RATE= OUTPUT PV= #NUM! PV= Problem 1.22 INPUT $ 750,000.00 PV= FV= $ RATE= TIME= 30 PMT= 65000 OUTPUT RATE=

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!