Need help solving this problem. Please show each step thoroughly. Thank you
a.
Saving Target = $140,000
Interest Rate = 6%
Period = 18 years
Using TVM calculation,
PMT = [PV = 0, FV = 140000, T = 18, R = 6]
PMT = $4,529.92
So, one needs to save $4,529.92 every year to reach goal of $140,000 after 18 years
b.
Period = 18 years + 5 years(for college) = 23 years
Saving target = $180,000
Interest Rate = 6%
PMT = [PV = 0, FV = 180000, T = 23, R = 6]
PMT = $3,830.13
So, one needs to save $3,830.13 every year to reach goal of $180,000 after 23 years
Need help solving this problem. Please show each step thoroughly. Thank you nie Witte Google Chrome...
Assume that your parents wanted to have $100,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned 10.5% per year on their investments. a. How much would they have to save each year to reach their goal? b. If they think you will take five years instead of four to graduate and decide to have $140,000 saved just in case, how much...
Assume that your parents wanted to have $100,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned 6.5% per year on their investments. a. How much would they have to save each year to reach their goal? b. If they think you will take five years instead of four to graduate and decide to have $140,000 saved just in case, how much...
Please show all steps and label inputs,
thanks!
Assume that your parents wanted to have $150,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned 5.0% per year on their investments. a. How much would they have to save each year to reach their goal? b. If they think you will take five years instead of four to graduate and decide to...
Assume that your parents wanted to have $120,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and eamed 11.5% per year on their investments. a. How much would they have to save each year to reach their goal? b. If they think you will take five years instead of four to graduate and decide to have $160,000 saved just in case, how much...
Assume that your parents wanted to have $160,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned 8% per year on their investments. a) How much would they have to save each year to reach their goal? b) If they think you will take five years instead of four to graduate and decide to have $200,000 saved just in case, how much...
Assume that your parents wanted to have $ 120000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned 8.5 % per year on their investments. a. How much would they have to save each year to reach their goal? b. If they think you will take five years instead of four to graduate and decide to have $ 160000 saved just in...
Assume that your parents wanted to have $80.000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your brt day and earned 120% per year other a. How much would they have to save each year to reach their goal? b. If they think you will take five years instead of four to graduate and decide to have $120,000 saved just in case, how much would...
Quiz: Chapter 4 Quiz (Copy) Time Remaining: 01:55:01 Submit Quiz This Question: 1 pt This Quiz: 9 pts possible 3 of 9 Assume that your parents wanted to have $160,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and eamed 6.0% per year on their investments. a. How much would they have to save each year to reach their goal? b. If they...
Assume that your parents wanted to have $150,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and earned 12.0% per year on their investments b. If they think you will take five years instead of four to graduate and decide to have $190,000 saved just in case, how much would they have to save each year to reach their new goal?
please help me solve this problem with excel formulas please and
thank you!!
A financial planning service offers a unique program for parents to save for a child's college education. Starting on the child's 12th birthday, annual deposits are made. The first deposit is $5,000 and the required deposit increases by $1000 each year, until the child's 18th birthday, when the final deposit is made. Beginning on the child's 19th birthday, four annual withdrawals of $10,000 can be made. Assuming...