• 100% Satisfaction Guarantee
JKCPA, CPA
Category: Finance
Satisfied Customers: 5882
Experience:  Bachelors degree and CPA with Accounting experience.
23848519
JKCPA is online now

# Gary Whitmore is a high school sophomore. He currently has

### Resolved Question:

Gary Whitmore is a high school sophomore. He currently has \$7,500 in a money market account paying 5.65 percent annually. He plans to use this and his savings over the next four years to buy a car at the end of his sophomore year in college. He estimates that the car will cost him \$12,000 in four years. How much should he invest in the money market account every year for the next four years if he wants to achieve his target?
Submitted: 4 years ago.
Category: Finance
Expert:  JKCPA replied 4 years ago.
Hi,

Hope this helps!
JKCPA, CPA
Category: Finance
Satisfied Customers: 5882
Experience: Bachelors degree and CPA with Accounting experience.
Customer: replied 4 years ago.
What was the formula you used?
Expert:  JKCPA replied 4 years ago.
Hi,

Thanks for the accept.

The Excel formula is:
=PMT(RATE,NPER,PV,-FV)

where nper = number of periods (4)
rate = interest rate = 5.65%
PV = present value = \$7500
FV = future value = \$12000
PMT = what we're solving for (amount to be deposited each year)

Let me know if you meant that you need the mathematical formula to figure this out by hand (without Excel).

Customer: replied 4 years ago.
I'd like the marhmarical formula. Thanks
Expert:  JKCPA replied 4 years ago.

The math formula is:

 Attachments are only available to registered users.Register Here Attachments are only available to registered users.Register Here Attachments are only available to registered users.Register Here View Full Image Attachments are only available to registered users.Register Here

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
< Previous | Next >
• I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
• I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight. Bonnie Chesnee, SC
• Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation. John Minneapolis, MN
• Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with. Orville Hesperia, California
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA

### Meet The Experts:

#### Satisfied Customers:

2489
Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
< Last | Next >

#### Satisfied Customers:

2489
Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years

### Megan C

#### Satisfied Customers:

2210
Licensed CPA, CFE, CMA, CGMA who teaches accounting courses at Master's Level

### Manal Elkhoshkhany

#### Satisfied Customers:

1905
More than 5000 online tutoring sessions.

### JKCPA

#### Satisfied Customers:

843
Bachelors degree and CPA with Accounting experience.

### Eric

#### Satisfied Customers:

559
Loan servicing, counseling and real estate expert. Foreclosure Expert and Financial Planner.

### R. Klein, EA

#### Satisfied Customers:

480
TurboTax Expert. QuickBooks Certified Pro Advisor