Linda is 10 years old. Her parents want to save for 4 years of college, starting at 18. Her parents want to deposit X today and on birthdays 11,12, …. 17. On birthdays 18, 19, 20, 21 they plan to take out $20,000 – the total cost of education. How much do her parents need to save each year? Assume the discount rate is 10%. Solve the following ways: Using trial and error, is the $4,000/per year enough? Using Goal Seek, solve for the annual deposit necessary to meet their financial goals.

The Jeffersons have asked you what would be needed to fund the children’s future college costs. Assume each child will begin college at age 18 and graduate in four years. Assume current costs are $24,000 per year and are expected to increase by 5% per year and investments earn 7%.   A.      Assuming no existing assets are dedicated to college, what is the annual savings amount required to fund the children’s education? The Jeffersons’ goal is to have an amount at the beginning of the freshman year for each child that is sufficient to fund a serial payment covering the $24,000 of current costs of college adjusted for inflation for each of the four years of college. Please include your calculator keystroke inputs [PV, I/YR, N, FV, and PMT (if needed)] for each step of this calculation. Also include whether any PMTs are in the end mode or the begin mode. B.      What would you say to the Jeffersons about their education funding situation? Write a script of a single paragraph as if you…

Justin and Kennedy are saving for their daughter Aliyah's college education. Aliyah just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $15,000 a year, but they are expected to increase at a rate of 2.5% a year. Aliyah should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Justin and Kennedy have accumulated $10,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $5,500 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 8%. How large must the annual payments at t = 5, 6, and 7 be to cover Aliyah's anticipated college costs? a. $5,960.00 b.…

John and Daphne are saving for their daughter Ellen's college education. Ellen just turned 10 (at t= 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $14,500 a year, but they are expected to increase at a rate of 3.5% a year. Ellen should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, John and Daphne have accumulated $14,000 in their college savings account (at t= 0). Their long-run financial plan is to add an additional $5,000 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 9%. How large must the annual payments at t = 5, 6, and 7 be to cover Ellen's anticipated college costs? a. $3,326.86 b. $2,970.41 C.…

You have two 8-years old twin children, and you anticipate that when they will turn 18 (exactly 10 years from now) they will need $500,000 to cover living and tuition college expenses. Suppose that the discount rate is 10%. 1. If you want to meet this negative cash flow only with current savings, how much would you need to set aside right now? 2. Suppose, instead, that want to meet this negative cash flow only saving a constant amount at the end of each year, for the next 10 years. What is the amount you should set aside each year?

Suppose that you need $30,000 for your last year of college. You could go to a private lending institution and apply for a signature student loan; rates range from 7% to 14%. However, your Aunt Sally is willing to loan you the money from her retirement savings, with no repayment until after graduation. All she asks is that in the meantime you pay her each month the amount of interest that she would otherwise get on her savings (since she needs that to live on), which is 4%.What is your monthly payment to her, and how much interest will you pay her over the year (9 months)?(Fill in the blanks below and give your answers as whole numbers.)The amount of interest per month you would pay Aunt Sally is $__(1)__ .The total interest you will pay her over the year (9 months)is $__(2)__ .

Use a financial calculator or computer software program to answer the following questions: a) Melanie is trying to save money for retirement and has a future goal of $750,000 at the end of 20 years. Determine the present value of her goal using a discount rate of 12%. b) How would the present value change if the $750,000 is to be received at the end of 15 years instead? Explain the impact and show your work?

Nathan and Jordan are saving for their daughter Kaliah's college education. Kaliah just turned 10 (at t = 0), and she will be entering college 8 years from now (at t = 8). College tuition and expenses at State U. are currently $14,500 a year, but they are expected to increase at a rate of 3.5% a year. Kaliah should graduate in 4 years--if she takes longer or wants to go to graduate school, she will be on her own. Tuition and other costs will be due at the beginning of each school year (at t = 8, 9, 10, and 11). So far, Nathan and Jordan have accumulated $12,000 in their college savings account (at t = 0). Their long-run financial plan is to add an additional $5,500 in each of the next 4 years (at t = 1, 2, 3, and 4). Then they plan to make 3 equal annual contributions in each of the following years, t = 5, 6, and 7. They expect their investment account to earn 10%. How large must the annual payments at t = 5, 6, and 7 be to cover Kaliah's anticipated college costs? O a. $3,779.16 O b.…

Mavis never went to university, so when her daughter, Charita was to go to university, Mavis wanted to ensure that she had sufficient savings. Charita starts university tomorrow. Mavis' goal is for savings today that cover four years of $25,000 per year for tuition (to be paid at the beginning of the year), plus a lump sum of $50,000 available at the beginning of the 5th year to cover further studies. How much does Mavis have in available funds, assuming a discount rate of 7%, compounded semi-annually? Question 8Select one: a. $128,431 b. $ 122,417 c. $125, 907 d. $124, 695

Amanda and Zack are saving for their first child. They know he/she will be expensive and would like an extra $5000 in the bank when the baby comes. Amanda and Zack are not planning to have a baby for at least 3 years. They found a savings account that will earn 4.7% interest compounded quarterly. How much money should they invest to be financially prepared for their first child? Round to the nearest dollar.