Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please use excel on december 31,2024, parents dec

PLEASE USE EXCEL On December 31,2024, parents decide to accumulate $70,000 to be used...

70.2K

Verified Solution

Question

Accounting

PLEASE USE EXCEL
On December 31,2024, parents decide to accumulate $70,000 to be used for their child's college education. The parents would like to have the amount available on December 31,2029. Assume that the funds will accumulate in an account paying 8% interest compounded annually.
Answer each of the following independent questions.
Required:
If they were to deposit a single amount, how much would they have to invest on December 31,2024?
If they were to make five equal deposits on each December 31, beginning on December 31,2025, what is the required amount of each deposit?
If they were to make five equal deposits on each December 31, beginning on December 31,2024, what is the required amount of each deposit?
Note: For all requirements, use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV. of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1)
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Discovery Manufacturing, Inc. has 2,550,000 shares of common stock outstanding. The current share price is $115.67,...

Finance
Q

For 220.0 mL of a buffer solution that is 0.3028 M in CH3CH2NH2 and 0.2783 M...

Chemistry
Q

1) You are exposed to influenza viruses, and alas, you have not yet had your influenza...

Biology
Q

the dermis is made of irregular fibrous connective tissue. what is the structure and makeup of the...

Medical Sciences
Q

I was stunned at how the lake had changed in the 10 years since I had...

Biology
Q

1.You've probably heard more than one of your peers sneer at someone speaking a foreign language...

Psychology
Q

Evaluate Apple's success in executing the three core processes of business: people, strategy, and operations.

General Management
Q

Under which circumstances should you report a confidence interval Select all that apply how much...

Statistics
Q

bability And K Question 12 of The distribution of Master s degrees confe university is...

Statistics
Q

Use the following information for the month of May: Assuming that...

Accounting
Q

An advertisement placed in a paper which announces a public offering of securities is called...

Accounting
Q

What are the benefits of a corporate leadership strategy? Watch the video on Leadership...

Accounting