Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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? 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started