Question
I need help to get equation what to put in excel to get the same answer below the question. Also, can I know what the
I need help to get equation what to put in excel to get the same answer below the question.
Also, can I know what the variables are stand for?
Q : I know I'm going to need a new car in five years. I'm anticipading $20,000. How much do i have to save in order to be able to pay cash for car? I currently get a 10% return on my saving:
A : = pmt(0.1/12,60, ,-20000) $258.27 =FV(0.1/12,60,-258.27)
Step by Step Solution
3.52 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
To calculate the amount you need to save in order to pay cash for a car in five years you can use the Excel functions PMT and FV Heres how you can set ...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 StartedRecommended Textbook for
Fundamentals of Case Management Practice Skills for the Human Services
Authors: Nancy Summers
5th edition
1305094765, 130509476X, 9781305544833 , 978-1305094765
Students also viewed these Finance questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App