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

Finance
1.2K views

For your job as the business reporter for a local? newspaper, you are given the task...

Biology
1.2K views

1)Describe the progression of a DIFFERENT bacterial, fungal OR protozoan microbial pathogen (causes disease) from acuteinfection to...

General Management
1.2K views

What are the sales objectives for the new Sales Representative? 8-2. What role will the compensation...

Physics
1.2K views

Two prisms of same glass u 2 are stuck together without gap as shown Find...

Physics
1.2K views

of mass m is released from the state of rest over a large smooth solid...

Calculus
1.2K views

Select all of the following statements which are true If A and B are invertible...

Accounting
1.2K views

Q17: IAS 18 (Revenue) will be superseded by IFRS 15 as of 1 January 2018.This...

Accounting
1.2K views

Nickleby's Ski Store is completing the accounting process for its first year ended December 31,...

Accounting
1.2K views

Exercise 13-4 (Algo) Special Order Decision (LO13-4) Imperial Jewelers manufactures and sells a gold bracelet...

Accounting
1.2K views

Q3 (10 Points) The following budget and transactions relate to the General Fund...

Accounting
1.2K views

On July 1, 2022, Aaron places in service a new SUV ( 5Yr ) that...

Finance
1.2K views

One year ago, your company purchased a machine used in manufacturing for $100,000. You have...