Question: Problem 1.10 INPUT PV= $ 6,000.00 FV= $ 10,000.00 RATE= ? TIME= 5 PMT= 0 OUTPUT RATE= #NUM! Problem 1.13 INPUT PV= $ 30.00 FV=
| Problem 1.10 | |
| INPUT | |
| PV= | $ 6,000.00 |
| FV= | $ 10,000.00 |
| RATE= | ? |
| TIME= | 5 |
| PMT= | 0 |
| OUTPUT | |
| RATE= | #NUM! |
| Problem 1.13 | |
| INPUT | |
| PV= | $ 30.00 |
| FV= | $ 60.00 |
| RATE= | 7% |
| TIME= | ? |
| PMT= | 0 |
| OUTPUT | |
| TIME= | |
| Problem 1.17 | |
| INPUT | |
| PV= | $ - |
| FV= | $ 120,000.00 |
| RATE= | 5% |
| TIME= | 18 |
| PMT= | 0 |
| OUTPUT | |
| PMT= | |
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, Time order please.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help