Mr. Blochirt is creating a college investment fund for his daughter. He will put in $7,000 per year for the next 17 years and expects to earn a 12% annual rate of return. How much money will his daughter have when she starts college?

Mr. Blochirt is creating a college investment fund for his daughter. He will put in $7,000 per year for the next 17 years and expects to earn a 12% annual rate of return. How much money will his daughter have when she starts college?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Related questions

Q: Your parents invest $10,000 in a college fund when you are born. They find a fund that will return…

A: Initial investment (P) = $10000 Interest rate (r) = 8% Fund duration (n) = 18 years Let the tuition…

Q: Your younger sister, Brittany, will start college in five years. She has just informed your parents…

A: given, A = $30,000 r=10% n = 4 years

Q: A man wants to set up a 529 college savings account for his granddaughter. How much would he need to…

A: The equivalent annual cost is the periodic payment made towards the acquisition of an asset or…

Q: A father is now planning a savings program to put his daughter through college. She is 13, plans to…

A: The present value of the amount represents the current value of the future cash flows. The…

Q: Soon-to-be proud parents of a new born baby are planning to establish a scholarship fund for their…

A: To calculate the lump sum amount we need to calculate the present value of all the future cash flows…

Q: A father is now planning a savings program to put his daughter through college. She is 13, plans to…

Q: Mr. and Mrs. Revilla decided to sell their house and to deposit the fund in a bank. After computing…

A: Determine the present value of the annual withdrawals after 5 year of deposit using the Excel PV…

Q: Laura is saving for the college education of hertwochildren. They are two years apart in age; one…

A: As a first step let’s plot the cash flows on a time diagram.Please see the white board. In the table…

Q: Palma wants to establish a fund for her granddaughter's college education. What lump sum must she…

A: Computation:

Q: Tatsumi invested Php 10,000 now for the college education of his three-year old son. If the fund…

A: Amount invested today (A) = Php 10000 Age of son today = 3 years He needs to withdraw for 4 years (m…

Q: A father is now planning a savings program to put his daughter through college. She is 13, plans to…

A: Solution: Current annual cost is $13,000 and these costs expected to increase by 6% annually.…

Q: Millet wants to provide a ₱200,000 graduation gift for her daughter Mae who is now 16 years old. She…

A: Present value is the sum of money that must be invested in order to achieve a specific future goal.…

Q: A father is now planning a savings program to put his daughter through college. She is 13, plans to…

A: Current annual cost= $18000 College savings= $7000 Interest= 9%

Q: I am setting up a fund for my son to go to college. I figure that he will need $50,000 by the time…

A: An annuity is the sum of equal payments made for a certain period, at a particular rate of return.…

Q: Jessica is 25 year old now and he wants to start saving up for her retirement fund.She will retire…

A: Retirement planning is the calculation of requirement of a lum sum corpus for the time period when a…

Q: Keith Stone has a 10-year-old daughter, Kate, who will be entering college in 8 years. Keith…

A: Time value of money is a concept that helps in determining the value of cash (or money) at a future…

Q: A father wants to help provide a college education for his young son. He can afford to invest…

Q: A father is now planning a savings program to put his daughter through college. She is 13, plans to…

A: Required: Compute the value of annual deposits to be made by the father so that college expenses can…

Q: What is the expected cost of college in each of the 4 years?

A: Future value or the expected value of a college can be found out by multiplying the interest rate…

Q: Nana and Abena Sarfo are saving for the university education of their newborn daughter, Akosua. The…

A: Annual university expenses (E) = GH₵ 30000 Expense period (p) = 4 years Interest rate (r) = 0.14…

Q: A young couple is planning for the education of their two children. They plan to invest the same…

A: Annuities are insurance contracts that promise to pay you regular income either immediately or in…

Q: Today Dante and Sharon had their first child. All of the grandparents gave them money to help out,…

A: Given:

Q: The parents of Hala saved an amount of AED 20,000 to cover her university costs and expected to…

A: Amount saved = AED 20,000 Growth = 5% per year Period = 18 Future value is to be calculated of the…

Q: Ann and Tom want to establish a fund for their grandson's college education. What lump sum must…

A: The amount required to deposit today can be calculated with the help of present value function.

Q: Theresa figures she needs $200,000 in ten years to pull off an early retirement to an undisclosed…

A: The future value of the annuity is the total value of all the payments which is occurred regularly…

Q: A father is now planning a savings program to put his daughter through college. She is 13, plans to…

A: Inflation rate is the rate at which prices of goods and services increases over a period of time…

Q: is thinking of establishing a fund for his daughter’s college education. He wants his daughter to be…

A: There is need of planning for savings for the education of the children so that they can study…

Q: Mr. J. J. Parker is creating a college fund for his daughter. He plans to make 15 yearly payments of…

A: GIVEN, YEARLY PAYMENT = $1500 N = 15 YEARS R = 12% LET FOUR YEARLY WITHDRAWAL = A withdrawal from…

Q: A man who won 730,000 pesos in a lottery decided to place 50% of his winnings in a trust fund for…

A: A man won a lottery of worth = 730,000 pesos He invested 50% in trust funds for his son education =…

Q: I am setting up a fund for my son to go to college. I figure that he will need Php50,000 by the time…

A: Future value (FV) = Php. 50,000 Annual interest rate = 5.75% Monthly interest rate (r) = 5.75%/12 =…

Q: Revere College predicts that in 18 years it will take $200,000 to attend the college for four years.…

A: Present Value = Future value / (1+rate)^n Where, Future Value = $200000 n = 18*12 = 216 r= 9%…

Q: Tom and Sandy have set up a sinking fund in order to have $18,000.00 in 4 years for their child's…

A: Using excel PMT function

Q: Matt plans to start his own business once he graduates from college. He plans to save $3,000 every…

A: Compute the semi-annual interest rate as follows: Compute the no. of half-years as follows:

Q: Mr. and Mrs. Revilla decided to sell their house and to deposit the fund in a bank. After computing…

A: Annuity Due: It is an annuity where payment is due immediately at the start of each period.

Q: Your daughter needs to be able to draw $50,000 a year from her college savings fund (you started…

Q: Ginny is planning for her son's college education to begin five years from today. She estimates the…

A: Frist we need to calculate present value of annuity due by using this formula PV of annuity due…

Q: A man wants to help provide a college education for his young daughter. He can afford to invest…

A: The annual investment is the amount to be paid at the end of the period. It is paid on annual basis.…

Q: Richard wants to ensure that at least some of his descendants are well educated in perpetuity. He is…

A: The present value of a lump sum: The present value of a lump sum (single) investment made at a…

Q: Jamie wants to have $800,000 for her retirement in 25 years. How much should she save annually if…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: Tala McLouf, a 21-year-old BBA graduate, likes to plan for her future ahead, and would like to save…

A: Since the question has more than 3 sub-parts, the first 3 subparts are answered. If you want the…

Q: Holly wants to have $200,000 to send a recently born child to college. She sets up a 529 plan and…

A: Using excel PMT function

Q: Mr. Blochirt is creating a college investment fund for his daughter. He will put in $850 per year…

A: The future value of the annuity is the future worth of a cash flow series at a certain rate of…

Q: Aini wishes to have 93,000USD to purchase a car in 6 years as part of her financial goals. How much…

A: Future Value = 93,000 USD Time Period = 6 Years Interest Rate = 8%

Q: . What is the expected cost of college in each of the 4 years? 2. How much will need to be in the…

A: Hi, since there are multiple questions posted, we will answer first three questions. If you want any…

Q: Tatsumi invested Php10,000 now for the college education of his three-year old son. If the fund…

A: First, we compute the Future value of the initial investment. On the basis of this future value, the…

Question

Mr. Blochirt is creating a college investment
fund for his daughter. He will put in $7,000 per
year for the next 17 years and expects to earn
a 12% annual rate of return. How much money
will his daughter have when she starts college?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction :

VIEW

Step 2: Answer :

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Ethan is creating a college investment fund for his daughter. He will put in $21,000 per year for the next 17 years and expects to earn a 12% annual rate of return. How much money will his daughter have when she starts college? Use Appendix C to calculate the answer. Multiple Choice $1,014, 538 $1,015,551 $1,027,291 $1,026,564
Mrs. Lorez wants all of her grandchildren to go to college and decides to help financially. How much must she give to each child at birth if they are to have $10,000 on entering college 18 years later, assuming 6% interest compounded annually?
Mr. Wise is creating a college investment fund for his daughter. He will put in P850 per year for the next 15 years and expects to earn an 8% annual rate of return. How much money will his daughter have when she starts college? * P12,750 P23,079 P11,250 P24,003 P12,263
Suppose you want to provide for the college education of your son. He will begin college six years from now, and you wish to have $15,000 available for him at the beginning of each year in college. How much must be invested today at a 12 percent annual rate of return in order to provide the 4-year, $15,000 annuity for your son?
Nana and Abena Sarfo are saving for the university education of their newborn daughter, Akosua. The Sarfos estimate the university expenses will run GH₵ 30000 per year when their daughter reaches university in 18years. The annual interest rate over the next few decades will be 14%. How much should they deposit in the bank each year so that their daughter will be completely supported four years of university? Assume she enters the university on her 18th birthday.
A man wants to help provide a college education for his young daughter. He can afford to invest $1500/yr for the next 5 years, beginning on the girl’s 5th birthday. He wishes to give his daughter $10,000 on her 18th, 19th, 20th, and 21st birthdays, for a total of $40,000. Assuming 6% interest, what uniform annual investment will he have to make on the girl’s 9th through 17th birthdays? PLEASE USE EXCEL SOFTWARE TO SOLVE. WOULD GIVE POSITIVE RATING.
Your mother wants to buy a car which will cost $15,000 five years from today. She would like save $2,450 at the end of each year (for the next five years) in an account, so as to have the amount she needs. What interest (to the closest percent) must she earn in this account to achieve this financial objective?
Michael and Ava want to know how much it will cost to put their daughter Lily through college. She will begin college in 13 years. Assume college costs $12,000 per year today. Lily will attend college for 4 years. College costs increase 4.0% each year. How much money do Michael and Ava need to have on hand on the day Lily BEGINS college, in order to fund her entire college degree? (Assume the money will earn 6% annual interest while it is in her college savings account). Lily will spend the entire amount available during her college years. Each year of college she will withdraw more than the prior year (the amount will increase by the college cost inflation rate). (amortize the balance in her account to zero at the end of the 4 college years...base calculations on a growing annuity withdrawal schedule). (amortize the balance in her account to zero at the end of the 4 college years). O $73,292.32 O $69,235.87 O $48,000.00 O $79,923.53
Your parents start saving for your sister's college education. She will begin college at age 18 and will need $4,000 per year at the end of each of the next 4 years. They will make a deposit one year from today in an account which pays 6% compounded annually, and an identical deposit each year including the year she starts college. If a deposit of $1,987 will allow them to reach their goal, how old is your sister now?
I am setting up a fund for my son to go to college. I figure that he will need $50,000 by the time he is old enough to go to college. I found an account that pays 5.75% compounded monthly. How much will my monthly payment be to get my son set up for college in 17 years?
Sharpy and Jane are saving for the college education of their newborn son, Kasuba. The couple estimate that college expenses will run K30,000 per year when their son reaches college in 18 years. The annual interest rate over the next few decades will be 14 percent.How much money must they deposit in the bank each year so that their son will be completely supported through four years of college? To simplify the calculations, assume that Kasuba is born today. His parents will make the first of his four annual tuition payments on his 18th birthday. They will make equal bank deposits on each of his first 17 birthdays, but no deposit at date 0.
Lorez wants all of her grandchildren to go to college and decides to help financially. How much must she give to each child at birth if they are to have $10,000 on entering college 18 years later, assuming 6% interest compounded annually?