Palma wants to establish a fund for her granddaughter's college education. What lump sum must she deposit in an account that pays an annual interest rate of 6%, compounded monthly, if she wants to have $10,000 in 10 years?

Palma wants to establish a fund for her granddaughter's college education. What lump sum must she deposit in an account that pays an annual interest rate of 6%, compounded monthly, if she wants to have $10,000 in 10 years?

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: What lump sum do parents need to deposit in an account earning 10%, compounded monthly, so that it…

A: Two questions appear on the board. They are unrelated and are not sub parts. Hence, only the first…

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

A: To open the "FV function" window - MS-Excel --> Formulas --> Financials --> FV.

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: Money to accumulate in Sinking Fund= $18,000.00 Time period= 4 years Interest rate= 6.84% compounded…

Q: Alicia and Warren plan to send their son to university. To pay for this they will contribute 12…

A: Let the annual contribution = A Annual withdrawal (W) = $39900 r = 4.5% per annum We need to find…

Q: Carolyn is helping to save for her granddaughter’s college fund. It will probably take 18 years…

A: Future value required (FV) = $150,000 Interest rate (r) = 6% Number of annual payments (n) = 18…

Q: A newborn child receives a $9,000 gift toward a college education from her grandparents. How much…

A: As per the given information: Principal amount or amount of money deposited (P) - $9,000 Time period…

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: Harry and Lisa Perry have agreed to pay for their granddaughter's college education and need to know…

A: Given information: Annual interest rate is 4% Annuity payment is $25,000 Number of years is 5

Q: New parents wish to save for their newborn's education and wish to have $40,000 should the parents…

A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

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

A: The present value function or concept can be used to determine the present value of a future sum or…

Q: Will and Jane Sparks are establishing a college fund for their 1-year-old daughter, Jennifer. They…

A: The question gives the following information:

Q: . How much should you deposit monthly to accumulate $85,000 in 15 years?

A: Future Value of Annuity: It represents the future worth of current annuity payments made…

Q: Brittany's parents want their child to go to the same college that they did. After talking with the…

A: Working of the amount put down by the Brittany’s Parents is shown: Hence, the amount deposited will…

Q: Christina plans to contribute $1,200 a year to her niece’s college education. Her niece will…

A: Future value of annuity refers to the total value of annual cash flows over a period of time at a…

Q: Kate Rose is setting up an annuity for a memorial scholarship. What lump sum does she need to set…

A: Given information: Annual interest rate is 7% Annuity payment is $2,500 Number of years is 10

Q: Will and Jane Sparks are establishing a college fund for their 1-year-old daughter, Jennifer. They…

A: As per the given information: Amount = $40,000Annualized rate of return (r) = 8%No. of years (n) =…

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

Q: New parents wish to save for their newborn's education and wish to have $45,000 at the end of 16…

A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

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

A: The question is based on the concept of time value of money with annuity payment , used the equation…

Q: Mr. Bates is creating a college investment fund for his daughter. He will putin $850 at the end of…

A: The question is based on the concept of calculation of future value of period fix payment, which is…

Q: Allain Dupre wants to set up a scholarship fund for his school. The annual scholarship payment is to…

A: Using excel PV function

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: a young woman, 22 years old, has just graduated from college. she accepts a good job and desires to…

A: Dear student, we need to use excel NPER function to calculate number of years of deposit that…

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

A: Given information: Future value is $150,000 APR is 7% Number of years is 6

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: Melissa agrees to contribute $500 to the alumni fund at the end of each year for the next 6 years.…

A: Yearly Contribution is $500. Total years is 6 Years Current Interest rate is 3.5%(Compounded…

Q: What lump sum do parents need to deposit in an account earning 11%, compounded monthly, so that it…

A: Given: Interest rate = 11% Future value = $90,000 Years = 16 Compounding is monthly

Q: Janet's parents want her to go to the same college that they did. They decided to pay a lump sum…

A: Lump sum Payment as on today (PV)=$126,000 Duration (n)=8*4=32 periods Rate per period (i)=6%4=0.015

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: Heather needs to invest to help with her child's college fund. How much would she have to invest to…

A: Money’s value declines with the time. Discounting is a way which is used to get the PV of future…

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: Ann and Tom want to establish a fund for their grandson's college education. What lump sum must…

A: Using excel PV function

Q: Mrs. Lorez wants all of her grandchildren to go to college and decides to help financially. How much…

A: Future Value(FV) is $10,000 Time period(NPER) is 18 years Interest rate(I/Y) is 6% compounded…

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

A: We'll use compound interest formula to determine the amount of deposit (principal amount): A=P1+rnnt…

Q: What lump sum do parents need to deposit in an account earning 10%, compounded monthly, so that it…

A: As per our guidelines we are supposed to answer only one question (if there are multiple questions…

Q: It is Jerry's 14th birthday and his parents plan to invest some money so that they will have $17 000…

A: Amount required at 18th birthday = $17000 Quarterly interest rate (r) = 0.0215 (i.e. 0.086 / 4)…

Q: Your friend is celebrating her 30th birthday today and wants to start saving for her anticipated…

A: Annual deposit refers to the amount that is deposited or invested each year at given interest rate…

Q: Your oldest daughter is about to start kindergarten in a private school. Tuition is $10,000 per…

A: Calculation of Present Value:There are 2 issues with the annuity. The one with the current tuition…

Q: on. How much should be deposited?

A: Present Value of Annuity: It represents the present worth of the future value of the annuity and is…

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

A: To calculate the deposit amount we will use the present value formula as follows: Deposit amount =…

Q: Your oldest daughter is about to start kindergarten at a private school. Tuition is $10,000 per…

A: Formula: PV cash flow=Payment×1+rn1+rn

Q: Grandparents plan to open an account on their grandchild's birthday and contribute each month until…

A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…

Q: Clarissa wants to fund a growing perpetuity that will pay $10,000 per year to a local museum,…

A: Present value of the growing perpetuity is the amount she needs to fund today This can be calculated…

Q: Madison and Colton plan to send their son to university. To pay for this they will contribute 12…

A: Given information: Contribute 12 equal yearly payments APR is 4.9% Withdrawals of $34,000

Q: Arnett College predicts that in 18 years it will take $⁢350,000 to attend the college for four…

A: An annual percentage rate (APR) is the interest rate to be paid each year on a loan, credit card, or…

Q: If he deposits 2000 at the end of every year into a special account for seven years and the bank…

A: This problem can be solved in light of annuity and future value. Total amount in the deposit account…

Concept explainers

Cost of Credit

The cost of credit is an extra amount that the borrower has to pay besides the loan amount. These credit charges may vary from loan to loan. The cost of credit includes interest charges, maintenance charges, and arrangement charges. Some of the costs are mandatorily collected by the lender based on the loan amount and tenure of the loan. The cost of credit is also called finance charges of the credit.

Question

100%

Palma wants to establish a fund for her granddaughter's college education. What lump sum must
she deposit in an account that pays an annual interest rate of 6%, compounded monthly, if she
wants to have $10,000 in 10 years?

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

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

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

Brenda Young desires to have $16,500 eight years from now for her daughter’s college fund. If she will earn 12 percent (compounded annually) on her money, what amount should she deposit now?
Zachary wants to set up a fund for her son's education such that she could withdraw $1,764.00 at the beginning of every 3 months for the next 3 years. If the fund can earn 4.60% compounded semi-annually, what amount could she deposit today to provide the payment?
Parvati wants to donate enough money to Camosun College to fund an ongoing annual bursary of $2,750 to a deserving finance student. How much must she donate today in order for the first payment to to be given out in one year? Assume an interest rate of j2=4%.
Your daughter is expected to the university next year. It is estimated that she will need 10,000 each year for the for years university education. You are planning to deposit a lump sum in an account that will yield 10% per anum to cater for her university education. How much should be deposited?
4) Dottie has decided to set up an account that will pay her granddaughter $5,000 a year indefinitely. How much should Dottie deposit in an account paying 8 percent annual interest?
Heather needs to invest to help with her child's college fund. How much would she have to invest to have $63,400 after 11 years, assuming an interest rate of 2.16% compounded monthly?
A couple wants to begin saving money for their daughter's education. $16,000 will be needed on the child’s 18th birthday, $18,000 on the 19th birthday, $20,000 on the 20th birthday, and $22,000 on the 21st birthday. Assume 5% interest with annual compounding. The couple is considering two methods of accumulating the money. a. How much money would have to be deposited into the account on the child's first birthday to accumulate enough money to cover the education expenses? (Note: A child’s “first birthday” is celebrated 1 year after the child is born.) b. What uniform annual amount would the couple have to deposit each year on the child’s first through seventeenth birthdays to accumulate enough money to cover the education expenses?
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?
Parvati wants to donate enough money to Camosun College to fund an ongoing annual bursary of $1,500 to a deserving finance student. How much must she donate today in order for the first payment to start in five years? Assume an interest rate of j1=4%. Your Answer: Answer
Parvati wants to donate enough money to Camosun College to fund an ongoing annual bursary of $2,250 to a deserving finance student. How much must she donate today in order for the first payment to start in one year? Assume an interest rate of j=4%. Your Answer: Answer
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?
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?