Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In our readings, we studied Craig's decision to buy a car. Craig knows the following two Excel commands that he used during the Quantitative Reasoning

In our readings, we studied Craig's decision to buy a car. Craig knows the following two Excel commands that he used during the Quantitative Reasoning Process:
PMT(rate, nper, PV, FV)
FV(rate, nper, pmt, PV)
In step3 of the Quantitative Reasoning Process, quantitative tools, Craig used the following command in Excel:
=PMT(0.0412,7**12,-5000,0)
The Excel output for this command was $68.34. Which of the following best describes what this output represents?
If Craig saves $405.85 per year in an account paying 0.04% interest he will be able to buy a $5000 car in 84 years.
The monthly payment on a car loan of $5000, with an interest rate of 0.33% for 7 years, will be $68.34 times 12(or $820.08 per month).
If Craig saves $68.34 per month in an account paying 4% interest he will be able to buy a $5000 car in 7 years.
The monthly payment on a car loan of $5000, with an interest rate of 0.04% for 84 months, will be $68.34.
The monthly payment on a car loan of $5000 with an interest rate of 4% for 7 years will be $68.34.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations In Personal Finance

Authors: Dave Ramsey

3rd Edition

1936948524, 978-1936948529

More Books

Students also viewed these Finance questions

Question

Does this mean that the Tropes have to tear down their house?

Answered: 1 week ago