Question

In: Finance

6. You are saving for a new house and you put $25,000 per year in an...

6. You are saving for a new house and you put $25,000 per year in an account paying 4.5%. The first payment is made today.

A.) How much will you have at the end of 3 years? (Show Work)

B. Also build a table/schedule to show your account each year (include beginning balance and ending balance each year, interest earned).

Solutions

Expert Solution

Given that I am saving $25,000 each year for 3 years

Rate of interest is 4.5%, lets us assume this rate is annual interest rate

A) Today, I make first payment $25,000

So, for 1st year, my interest amount = $25000 * 4.5% = $1125

Also, I deposit my payment at beginning of year 1 i.e., $25000

Therefore, at the beginning of year 1, my amount = $25000 + $1125 + $25000 = $51125

So, for 2nd year, my interest amount = $51125 * 4.5% = $2300.625

Also, I deposit my payment at beginning of year 2 i.e., $25000

Therefore, at the beginning of year 2, my amount = $51125+ $2300.625 + $25000 = $78425.625

So, for 3rd year, my interest amount = $78425.625 * 4.5% = $3529.153125

Also, I deposit my payment at beginning of year 3 i.e., $25000

Therefore, at the beginning of year 3 my amount = $78425.625+ $3529.153125+ $25000 = $106954.7781

Interest during the 3rd year = $106954.7781 * 4.5% = $4812.965016

Therefore total amount at end of 3 years = $106954.7781 + $4812.965016 = $111767.7431

So, amount at the end of 3 years is $111,767.74 (rounded off to two decimals)

B) The below table represents the account for 3 years

Amount deposited

Opening balance

Interest

Per annum (4.5%)

Closing balance

At present

$25000

$25000

$1125

$26125

1st year

$25000

$51125

$2300.625

$53425.625

2nd year

$25000

$78425.625

$3529.153125

$81954.77813

3rd year

$25000

$106954.7781

$4812.965016

$111767.7431


Related Solutions

You are saving for a new house and you put $20,000 per year in an account...
You are saving for a new house and you put $20,000 per year in an account paying 8%. The first payment is made today. How much will you have at the end of 3 years? A. $51,541.19 B. $55,665.29 C. $64,928.00 D. $70,122.24 E. $75,732.19
After selling your house and purchasing a new house you have $25,000 left you wish to...
After selling your house and purchasing a new house you have $25,000 left you wish to invest. The first option you have is a one year T-Bill with a par value of $25,000 which costs $23,250. Your second option is to invest in a 12 month CD with a 6.5% interest rate. Of these two available options which would allow you to receive a higher rate of return. Make sure to show your calculations.
You are excited to start saving money. You plan to put $20 per week into an...
You are excited to start saving money. You plan to put $20 per week into an investment that you think will pay you 10.4% per year. You plan to make your first deposit today. How much will you have in 10 years? Suppose there are 52 weeks in a year. (Enter only numbers and decimals in your response. Round to 2 decimal places.)
You want to buy a new car for $25,000. You put $2000 down and are given...
You want to buy a new car for $25,000. You put $2000 down and are given $2000 as trade-in for your current car. You take out a loan for the remaining $21,000. The terms of the loan are an annual interest rate of 4.8% compounded monthly. You are to make 60 equal monthly payments (end of month) to pay off the loan. how can i get the answer using excel
You put $500 per month in the bank today earning 6% per year. How much will...
You put $500 per month in the bank today earning 6% per year. How much will be in the account in 5 years if the interest compounds annually? What if it compounds monthly?
Suppose you paint your house this year, using $200 of paint bought this year and saving...
Suppose you paint your house this year, using $200 of paint bought this year and saving $900 in labor that would have been paid to a painting company. How much does GDP increase this year? a. $900, since paint is considered a durable good. b. $200. c. 1,100, since your labor value is imputed. d. $0, since this is do-it-yourself activity.
You are planning to buy a house in New Jersey. You put a 20% down payment,...
You are planning to buy a house in New Jersey. You put a 20% down payment, and 15-year mortgage rates are at 4.2% -Price of the house is $400,000. a. Calculate the monthly payments. b- Calculate the 1st month interest payment. c-Calculate the 1st month principal payments
You are planning to buy a house in New Jersey. You put a 20% down payment,...
You are planning to buy a house in New Jersey. You put a 20% down payment, and 15-year mortgage rates are at 4.2% -Price of the house is $400,000. A. Calculate the 1st month interest payments B.Calculate the 1st month principal payments C.  Calculate the monthly payments. Place answer in the box below and use 2 decimals and no $ sign
You are offered an annuity investment that will pay you $ 25,000 per year for 10...
You are offered an annuity investment that will pay you $ 25,000 per year for 10 years     beginning in 20 years. These payments will be made at the beginning of each year and your discount rate is expected to be 8%. You will need to make payments at the end of each year for the next 20 years (also at 8%) in order to receive the annuity investment. What is the present value of the annuity investment as of...
You are saving for the down payment on a house. The houses in the area you...
You are saving for the down payment on a house. The houses in the area you prefer have an average selling price of $450,000 and you need a 10% down payment to ensure your mortgage payments are not too high. You have $30,000 saved that you can invest today at 6.5% (annual compounding). a) How long before you will have enough for the down payment saved? b) You want to buy the house sooner. In addition to the $30,000 saved...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT