You just graduated from college and decide to start saving for a down payment to buy a house 5 years from today. You estimate you will need $20,000 in 5 years for the down payment. (Note: a down payment is a deposit a home buyer must make in order to get a mortgage loan from a bank to buy the house.)
3a.
Assume you can earn 6% interest (APR) on your savings, and you make a deposit in your savings account quarterly. How much do you need to save each quarter (every three months) in order to reach your goal, if you make your deposit at the end of each quarter? Briefly show your calculations.
3b
Assume you can earn 6% interest (APR) on your savings, and you make a deposit in your savings account quarterly. How much do you need to save each quarter (every three months) in order to reach your goal, if you make your deposit at the beginning of each month? Briefly show your calculations.
Amount required in 5 years = FV = $20000
Number of quarters = n = 5*4 = 20 quarters
Quarterly Interest Rate = r = 0.06/4 = 0.015
Let the amount deposited each quarter be P
(3a) Amount is deposited at end of each quarter
=> FV = P(1+r)n-1 +....+ P(1+r)2 + P(1+r) + P = P[(1+r)n -1]/r
=> 20000 = P[(1+0.015)20 -1]/0.015
=> P = 20000*0.015/[(1+0.015)20 -1] = $864.91
(3b) Amount is deposited at beginning of each quarter
FV = P(1+r)n +....+ P(1+r)2 + P(1+r) = P [((1 + r)n - 1) / r](1 + r)
=> 20000 = P [((1 + 0.015)20 - 1) / 0.015](1 + 0.015)
=> P = 20000*(1+0.015) / [((1 + 0.015)20 - 1) / 0.015] = $877.89
You just graduated from college and decide to start saving for a down payment to buy...
You just graduated from college and decide to start saving for a down payment to buy a house 5 years from today. You estimate you will need $20,000 in 5 years for the down payment. (Note: a down payment is a deposit a home buyer must make in order to get a mortgage loan from a bank to buy the house.) 1. Assume you can earn 6% interest (APR) on your savings, and you want to make a single deposit...
Suppose you start saving today for a $40,000 down payment that you plan to make on a house in 5 years. Assume that you make no deposits into the account after the initial deposit. For the account described below, how much would you have to deposit now to reach your $40,000 goal in 5 years. An account with daily compounding and an APR of 7% You should invest $ (Do not round until the final answer. Then round to two...
In order to buy a house you want to accumulate a down payment of $15,000. You can do that by putting a certain sum of money every month in a savings account for the next four years. The account credits interest at the rate of six percent. What is your required monthly deposit? Relevant Periods= Relevant Rate= Deposit Amount=
Suppose you want to save $50,000 as a down payment to purchase a house in 7 years. You plan on saving money at the beginning of each month starting today. If you can earn 3.60% APR on your investment over the time frame, how much must you save each month to reach your goal?
You are saving for a down payment on an apartment. Every 6 months you plan to deposit $2,500 into your tax-free savings account that earns 3.75% effective. How many years will it take to accumulate $18,506 in your tax-free savings account? You will make the first deposit six months from now. 8.0 years 3.5 years 7.0 years 4.0 years 14.0 years
I just need to check my answers: 17: You want to buy a house in 5 years and expect to need $35000 for a down payment. If you have $11000 to invest, how much interest do you have to earn (compounded annually) to reach your goal? (Enter your answers as a decimal rounded to 4 decimal places, not a percentage. For example, enter 0.0843 instead of 8.43%) 18: You decide that the loan in question 2 is too large for...
1. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in a savings plan earning 6% compounded monthly. If you want to withdraw $4,000 at the beginning of each month, how long before the savings plan is exhausted? 2. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in a savings plan earning 6% compounded monthly. If you want the plan to last 40 years, how much can you withdraw...
1. You are trying to accumulate a $40,000 down payment to purchase a home. You can afford to save $1,000 per quarter. If these quarterly investments earn an annual rate of 7%, how many quarters will it take you to reach your goal? Provide steps for financial calculator
ANSWERS ARE GIVEN, PLEASE GIVE EXCEL FORMULAS!!! Suppose you have the option to buy a parcel of vacant land to build your first home. The option is for a 10-year period, and the purchase price is $105,000. You do not intend to exercise the option until the end of the 10th year, which means you have 10 years to accumulate the required $105,000 in cash to buy the land. Given you have access to a savings account that pays 3...
You decide to buy a house that costs 250,00. Your down payment is 20% of the price of the house and you take out a loan for the remaining balance. The bank charges an interest rate of 5% compounded quarterly. If you pay back the loan over 30 years what will be the amount of each monthly payment? please show the formula in your answer