Use the savings plan formula to answer the following question. Your goal is to create a college fund for your child. Suppose you find a fund that offers an APR of 7%. How much should you deposit monthly to accumulate $87,000 in 16 years? You should invest $_] each month. (Do not round until the final answer. Then round to two decimal places as needed.
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: Consider the two savings plans below. Compare the balances in each plan after 14 years, Which person…
A: given data yolanda deposits 300 every month Apr = 4% = 4/12 = 4/1200 = 1/300 future value after 14…
Q: ur client has asked you what would be needed to fund your 2 children’s future college costs. Assume…
A: Future planning is needed for the education of the children and you have to save for that.
Q: How much money must you deposit in an account each year to fund your children’s education? Your…
A: Information Provided: College expenses = $45,000 Interest rate = 5%
Q: You plan to send your first born child to College for a 4-year degree with 4 annual payments. Your…
A: The present value is the value of the sum received at time 0 or the current period. It is the value…
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: You want to have a $40,000 college fund in 6 years. How much will you have to deposit now in an…
A: Using the present value function in excel
Q: You are saving for the college education of your two children. One child will enter college in 5…
A: Present value of annuity formula along with future value of annuity formula is used to calculated…
Q: You want to set up a college savings plan for your daughter. She is currently 10 years old and will…
A: An Annuity is a series of payments of fixed amounts and at fixed intervals. These can be of two…
Q: 4. Suppose you make an annual contribution of BD300 each year to a college education fund for a…
A: An annuity: An annuity is a fixed, constant contribution that is made at fixed intervals over a…
Q: John needs to invest to help with his child's college fund. How much would he have to invest to have…
A: Given: Amount = $67,300 Years =13 Interest rate = 2.17%
Q: Consider the two savings plans below. Compare the balances in each plan after 15 years. Which person…
A: Future Value of annuity : To know the which plan is better we have to calculate the future value of…
Q: Suppose you make an annual contribution of BD100 each year to a college education fund for a niece.…
A: Here, Annual Deposits is BD100 Interest Rate is 6.5% Current Age is 4 years Last Deposit is made on…
Q: Consider the two savings plans below. Compare the balances in each plan after 12 years. Which person…
A: Time Period is 12 years Deposits of Yolanda is $350 per month Deposits of Zach is $4,200 per year…
Q: Holly wants to have $250,000 to send a recently born child to college. She sets up a 529 plan and…
A: Future value (FV) = $ 250,000 Annual interest rate (R) = 6% Number of annual investment (N) = 17…
Q: Use the savings plan formula to answer the following question. Your goal is to create a college fund…
A: The saving plan formula can be used to determine the fund that would be accumulated with periodic…
Q: You would like to have enough money saved to receive a growing annuity for 25 years, growing at a…
A: Solution-PV of growing annuityi=0.04r=0.12
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: I expect to save $100,000 in 15 years for my kid's college savings account. Assuming I get a return…
A: Discounting is a technique to compute the present value (PV) of future cashflows by using an…
Q: If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much…
A: PV=FV/(1+i)^n (PV= present value FV= Future value i= discount rate n= Number of period ) FV=…
Q: Please provide working to the solution for the question below: Suppose you are 40 years old and…
A: Solution:- When an equal amount is deposited each period, it is called annuity. We know, Present…
Q: You would like to have $200,000 in a college fund in 15 years. How much do you need today if you…
A: Present Value refers to the discounted value of a single cash flow or multiple cash flows today…
Q: Suppose that you want to create a "college fund" for your newborn child and place $300 in a bank…
A: Answer - Future Value Formula - = P [ (1+i)n - 1] / I Given, P = 300 i = 0.07 n = 20 years…
Q: Your goal is to have a college fund for your child. Suppose you find a fund that offers an APR of…
A: Given: Futur value "FV" = $85000 Number of years = 15 Number of months "n" = 15*12 = 180 Annual rate…
Q: Imagine that you are a professional personal financial planner. One of your clients asks you the…
A: Annual Interest (r) = 5% Part A Annual Saving = 3,700,000 Time Period (N) = 15 years Future Value =…
Q: You plan to send your first born child for a 4-year degree with 4 annual payments. Your first…
A: According to the time value rule, a sum of money today can earn an interest amount by investing it…
Q: You would like to have enough money saved to receive a growing annuity for 25 years, growing at a…
A: The present value of the growing annuity is the current worth of a cash flow series growing at a…
Q: When your first child is born, you begin to save for college by depositing $600 per month in an…
A: Annuity means number of payments which are equal in size and made at equal interval of time. Person…
Q: Your parents will retire in 16 years. They currently have $400,000 saved, and they think they will…
A:
Q: When your first child is born, you begin to save for college by depositing $225 per month in an…
A: Future value is calculated by multiplying the present value with the 1+r factor for the given rate…
Q: A couple wants to save for their daughter's college expense. The daughter will enter college eight…
A: Future value is the value of assets at a future date for a given growth rate. It is given as: FV =…
Q: You are saving for the university education of your two children. They are two years apart in age;…
A: Deposits should be made to make the university expenses for both children. Hence, first present…
Q: You want to create an endowment income of $35,000 per year for Oxfordshire Charity, bit the first…
A: The amount that should be invested today is the present value of all future endowment payments.…
Q: What lump sum do parents need to deposit in an account earning 10%, compounded monthly, so that it…
A: The present value of a future amount can be calculated by using this equation Present value =Future…
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: Consider the two savings plans below. Compare the balances in each plan after 14 years. Which person…
A: P = PMT [((1 + r)n - 1) / r] Where: P = Future value PMT = Annuity paymentr = Interest raten =…
Q: Suppose that you made this investment on the occasion of the birth of your daughter. Your plan is to…
A: Future value can be found out if a person wants now how much money he/she will have after some n…
Q: You want to create a college fund for a child who is now 3 years old. The fund should grow to…
A: According time value of Money, FV=PV×1+rn
Q: Suppose you wish to invest in an annuity so that you will have $120,000 at some future date for your…
A: We invest $350 monthly at a interest rate of 5.85% per month in order to give the child $120,000 at…
Q: A couple wants to set up a college savings account for their grandchild. If the account earns 4.4%…
A: We need to calculate Present value of $50000, using time value of money formulae.
Q: Suppose you want to use this fund to buy a $279,000 houseboat when you retire in 40 years. How much…
A: Future Value = $279,000 Interest Rate = 4.75% Time Period = 40 Years
Q: You calculate that you will need $75,000 in ten years to be able to pay for your daughter's college…
A: The question is based on the concept of Financial Accounting.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
- If you are saving the same amount each month in order to buy a new sports car when the new models are released, which of the following will help you determine the savings needed? A. future value of one dollar ($1) B. present value of one dollar ($1) C. future value of an ordinary annuity D. present value of an ordinary annuityUse the savings plan formula to answer the following question. Your goal is to create a college fund for your child. Suppose you find a fund that offers an APR of 7%. How much should you deposit monthly to accumulate $90,000 in 15 years? ... You should invest $ each month. (Do not round until the final answer. Then round to two decimal places as needed.) ******Your goal is to create a college fund for your child. Suppose you find a fund that offers an APR of 5%. How much should you deposit monthly to accumulate $85,000 in 15 years?
- 4. Suppose you make an annual contribution of BD100 each year to a college education fund for a niece. She is 4 years old now, and you will start next year and make the last deposit when she is 18. The fund is a money market account earning 6.5%/year. What will it be worth immediately after the last deposit? You may also set up spreadsheet solutionSuppose you have estimated that you will need $2,500 per month in your retirement to meet your expenses and live comfortably, and that you have found or chosen a fund (account) which pays monthly interest 4% APR . What principal, or balance, will your account need to maintain in order to be able to pay you this amount each month? Round/take your answer to the nearest cent.4. Suppose you make an annual contribution of BD300 each year to a college education fund for a niece. She is 4 years old now, and you will start next year and make the last deposit when she is 18. The fund is a money market account earning 6.5%/year. What will it be worth immediately after the last deposit? You may also set up spreadsheet solution AGE Beginning Balance Ending Balance Deposit Interest
- Use the savings plan formula to answer the following question. Your goal is to create a college fund for your child. Suppose you find a fund that offers an APR of 4%. How much should you deposit monthly to accumulate $81,000 in 17 years? You should invest $ each month?Use the savings plan formula to answer the following question Your goal is to create a college fund for your child Suppose you find a fund that offers an APR of 7%. How much should you deposit monthly to accumulate $82,000 in 12 years? You should invest $ each month (Do not round until the final answer. Then round to two decimal places as needed) 9 hp fio P11 O > 0 fre P ** ** { [ prt sc delete ←backspace 1 home num lock enterUse the savings plan formula to answer the following question:. Suppose you find a fund that offers an APR of 5%. How much should you deposit monthly to accumulate $82000 in 17 years?
- You are planning for your child's future and would like to set up a savings account for their college tuition. You suspect that you don't want to make a lump sum, so you decide to make equal monthly deposits. After calculating, you plan to have $100,000 in the account in 18 years. You found an account that gives 2% APR compounded monthly. Find the amount of your monthly deposits needed to obtain your projected future value.* Suppose someone wants to accumulate $65,000 for a college fund over the next 15 years. Determine whether the following investment plans will allow the person to reach the goal. Assume the compounding and payment periods are the same. The person deposits $120 per month into an account with an APR of 5%. Will the person meet the goal? Select the correct choice below and fill in the answer box to complete your choice. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.) OA. No, because the amount that will be in the college fund, $ B. Yes, because the amount that will be in the college fund, $ is less than the goal of $65,000. " is more than the goal of $65,000. "8. Your goal is to have a college fund for your child. Suppose you find a fund that offers an APR of 5% compounded monthly. Use Excel to create a table with months as the first column, payment in the second column and amount in account as the third. Use the table to determine how much should you deposit monthly to accumulate $85000 in 15 years.