Question

In: Finance

Your investment account is expected to earn a 5% return for next two years and then 8% return for next four years after that.


a. Your investment account is expected to earn a 5% return for next two years and then 8% return for next four years after that. You need to withdraw $750 from this account at the end of each month for next six years. After last withdrawal at end of six years, nothing remains in your account. how much is deposited in this account today? (Assume monthly compounding)

b. You just bought a condo for $250,000 and paid $50,000 as down payment. The remaining amount is financed through a loan of 4.5% compounded monthly. The loan is for 15 years. You have to make monthly payments at the end of each month. What is your monthly payment? What is the balance of this loan after ten years? What is the total interest paid on this loan for 15 years?

Solutions

Expert Solution

a)

here first we have to calculate present value for first 2 years and then for 4 years then we have to add both to arrive at persent value

Using financial calculator:

calculating PV for the first 2 years (i.e., 24 months) (present value at t = 0)

[N = 24 ; I/Y = 5%/12 ; PV = ? ; PMT = 750 ; FV = 0 ] compute( CPT button) for PV

present value = 17,095.42 (this is at t = 0)

calculating present value for the next 4 years (48 periods) (Present value at t = 2)

here interest rate = 8%/12

[N = 48 ; I/Y = 8%/12 ; PV = ? PMT = 750 ; FV = 0]

Present value = $30,721.43 (this is at t = 2)

Now we have to bring above present value to time period t = 0, here interest rate will be 5%/12

[N = 24 ; I/Y = 5%/12 ; PV = ? PMT = 0 ; FV = 30,721.43]

Present value at t = 0 will be = 27,803.68

Total Present value = 17,095.42 + 27,803.68 = $44,899.10

So we must Deposit $44,899.10 today

b)

Condo value = 250,000

Down payment = 50,000

so loan amount = 250,000 - 50,000 = 200,000

Time period = 15*12 = 180

Interest rate = 4.5%/12

[N = 180 ; I/Y = 4.5%/12 ; PV = 200000 ; PMT = ? ; FV = 0] compute for PMT

so monthly payments = $1530

Balance after 10 years:

remaining period after 10 years = 5 years (i.e., 5*12 = 60 periods)

we have to calculate PV using calculator

[N = 60 ; I/Y = 4.5%/12 ; PV = ? PMT = 1530 ; FV = 0] compute PV

Loan balance after 10 years = $82,067.53

Total interest paid:

Total amount paid - loan amount

Total amount Paid = 180*1530 = $275,397.58

Interest = 275,397.58 - 200,000 = $75397.58


Related Solutions

An investment is expected to earn you $1,000 eachquarter for the next 13 years. If...
An investment is expected to earn you $1,000 each quarter for the next 13 years. If the appropriate discount rate is 8.0%, how much is this investment worth today? Round to the nearest cent.
A $5000 investment today will return $1,313 each year for the next four years with the...
A $5000 investment today will return $1,313 each year for the next four years with the first payment starting in one year. The NPV of this investment is negative at your required return of 2.5%. Which of the following is closest to the internal rate of return on this project? 2% 4% 1% 3%
Lohn Corporation is expected to pay the following dividends over the next four years: $11, $8,...
Lohn Corporation is expected to pay the following dividends over the next four years: $11, $8, $4, and $2. Afterward, the company pledges to maintain a constant 5 percent growth rate in dividends forever . If the required return on the stock is 13 percent, what is the current share price?
4. what is the future value of a $10,000 investment after 5 years with a 8%...
4. what is the future value of a $10,000 investment after 5 years with a 8% interest rate per year, compounded annually?
You plan to make contributions to your retirement account for the next 20 years. After the...
You plan to make contributions to your retirement account for the next 20 years. After the last contribution, you will retire and begin withdrawing $3000 each month, and you want the money to last an additional 20 years. Assume your account earns 8% interest compounded monthly. a.How much do you need to have saved in 20 years in order to withdraw according to plan? b) How much do you need to deposit into the savings account for the next 20...
Over the next three years, a firm is expected to earn economic profits of $60,000 in...
Over the next three years, a firm is expected to earn economic profits of $60,000 in the first year, $50,000 in the second year, and $20,000 in the third year. After the end of the third year, the firm will go out of business. a. If the risk-adjusted discount rate is 6 percent for each of the next three years, the value of the firm is $________. The firm can be sold today for a price of $________. b. If...
5. A project requires an investment of $100m in two years. It is expected to yield...
5. A project requires an investment of $100m in two years. It is expected to yield $25m after the third year, $25m after the fourth year; in the fifth year it will yield $7m, which will grow at 1% per year over the next five years. What is the project’s NPV at a cost of capital of 15%?
The balance in an investment account years t after the account is opened is given by...
The balance in an investment account years t after the account is opened is given by 7500(1.065t). Compute the average rate of change for 2.5 ≤ t ≤ 3.5. (Round your answer to two decimal places.) Δ balance/ Δt=?
You deposit ​$1000 in an account that pays ​8% interest compounded semiannually. After 5 ​years, the...
You deposit ​$1000 in an account that pays ​8% interest compounded semiannually. After 5 ​years, the interest rate is increased to 8.12​% compounded quarterly. What will be the value of the account after a total of 10 ​years?
Suppose that the returns on an investment are normally distributed with an expected return of 8%...
Suppose that the returns on an investment are normally distributed with an expected return of 8% and standard deviation of 4%. What is the likelihood of making a negative return? (Hint: the area under a curve for 1 std dev is 34.13%, 2 std dev is 47.73% and 3 std dev is 49.87%). A. 47.73% B. 34.13% C. 15.87% D. 2.27%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT