Question

Benjamin, a software engineer, would like to invest in an attractive fund sold by a bank....

Benjamin, a software engineer, would like to invest in an attractive fund sold by a bank. The fund is to buy the stock of Big Bang Company. It is assumed that the fund can pay dividend steadily for the coming 10 years, which will generate an equivalent return of 5% annually, and the bank charge is negligible. He is thinking of investing ($10,000 + 100 D8) at the end of each month in this fund for the purpose of using it for the down payment of purchasing a real property in the future.

(a) How much down payment would he have accumulated at the end of 10th year? (Use 4 decimal places of the interest rate factor to do your calculation and round off your final answer to integer.)

(b) Ten years later, he gets married. Although the fund value has increased a lot and became sufficient for him to pay for the down payment of purchasing a residential property, they still have to borrow ($5,000,000 + 1,000 D8) from a bank. They select a 20 years mortgage plan at 3% annual interest rate. What is the amount of their monthly instalment? (Use 4 decimal places of the interest rate factor to do your calculation and round off your final answer to integer.)

(c) Several years later, they bear a child. They plan to join an education fund today with a guarantee return of 4% annually. Their target is $580,000 (in today dollar value) to be redeemed at the end of 18th year. They plan to save ($10,000 + 100 D8) at the end of each year and increase by ($5,000 + 10 D8) each year starting from Year 2. Can their target be achievable? Show detailed steps of your analysis. (Use 4 decimal places of the interest rate factor to do your calculation and round off your final answer to integer.)


part a n part b with clear steps , for d8=0

Homework Answers

Answer #1

return = 5% annually

r: be the monthly interest rate

(1+r)^12 = (1+5%)^1

r = 0.4074% per month

d8 = 0

Monthly saving = 10000

time = 10 years = 120 months

Future value of savings = 10000*((1+0.4074%)^120 - 1)/(0.4074%) = $1,543,619.3654

(a) Down payment accumulated at end of 10th year = $1,543,619 (nearest integer)

(b)

Loan taken = $5,000,000

tenure = 20 years = 12*20 = 240 months

Interest rate = 3% pa compounded monthly = 3%/12 = 0.25% per month

Let P be the monthly emi

5000000 = (P/0.25%)*(1-1/(1+0.25%)^240)

Solving the above equation, we get

P = $27,729.8799 per month

Monthly installment = $27,730 per month (rounded to nearest integer)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are considering an investment in a mutual fund with a 4% load and an expense...
You are considering an investment in a mutual fund with a 4% load and an expense ratio of 0.5%. You can invest instead in a bank CD paying 6% interest. a. If you plan to invest for two years, what annual rate of return must the fund portfolio earn for you to be better off in the fund than in the CD? Assume annual compounding of returns. b. How does your answer change if you plan to invest for six...
John Freeman is investing $8,006 at the end of each year in a fund that earns...
John Freeman is investing $8,006 at the end of each year in a fund that earns 6% interest. Click here to view factor tables In how many years will the fund be at $92,000? (Round answer to 0 decimal places, e.g. 45.) Years Newman Quincy wants to withdraw $30,000 each year for 8 years from a fund that earns 4% interest. Click here to view factor tables How much must he invest today if the first withdrawal is at year-end?...
You would like to have $41,000 in 15 years. To accumulate this​ amount, you plan to...
You would like to have $41,000 in 15 years. To accumulate this​ amount, you plan to deposit each year an equal sum in the​ bank, which will earn 7 percent interest compounded annually. Your first payment will be made at the end of the year. At the end of 4 years you will receive $9,000 and deposit this in the bank toward your goal of $41,000 at the end of 15 years. In addition to this​ deposit, how much must...
You would like to save annually for buying a car 6 years from today. Suppose the...
You would like to save annually for buying a car 6 years from today. Suppose the first deposit is made today and the last deposit will be made 5 years from now. Assume the car will cost you $30,000 and your deposits earn you interest at 6% p.a, compounded annually. (a) What is your annual deposit amount? (b) Instead of making annual deposits, you would like to make your deposit monthly and the bank is happy to pay your interest...
Stacy Alvarez is investing $381,500 in a fund that earns 11% interest compounded annually. Click here...
Stacy Alvarez is investing $381,500 in a fund that earns 11% interest compounded annually. Click here to view factor tables What equal amounts can Stacy withdraw at the end of each of the next 16 years? (Round factor values to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places, e.g. 458,581.) Yearly withdrawals $ Chris Inc. will deposit $56,600 in a 11% fund at the end of each year for 7 years beginning December 31, 2020. Click...
You are considering an investment in a mutual fund with a 4% load and an expense...
You are considering an investment in a mutual fund with a 4% load and an expense ratio of 0.5%. You can invest instead in a bank CD paying 6% interest. a. If you plan to invest for two years, what annual rate of return must the fund portfolio earn for you to be better off in the fund than in the CD? Assume annual compounding of returns. (Do not round intermediate calculations. Round your answer to 2 decimal places.) b....
You are considering an investment in a mutual fund with a 4% front-end load and an...
You are considering an investment in a mutual fund with a 4% front-end load and an expense ratio of 1.1%. You can invest instead in a bank CD paying 6% interest. If you plan to invest for two years, what annual rate of return must the fund portfolio earn for you to be better off in the fund than in the CD? Assume annual compounding of returns. (Do not round intermediate calculations. Enter your answer as a decimal rounded to...
You are considering an investment in a mutual fund with a 4% front-end load and an...
You are considering an investment in a mutual fund with a 4% front-end load and an expense ratio of 1.1%. You can invest instead in a bank CD paying 6% interest. If you plan to invest for six years, what annual rate of return must the fund portfolio earn for you to be better off in the fund than in the CD? Assume annual compounding of returns (Do not round intermediate calculations. Enter your answer as a decimal rounded to...
1. You would like to have $50,000 in 15 years. To accumulate this amount you plan...
1. You would like to have $50,000 in 15 years. To accumulate this amount you plan to deposit each year an equal sum in the bank, which will earn 7% interest annually. Your first payment will be made at the end of the year. o How much must you deposit annually to accumulate this amount? o If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should this lump-sum deposit be? o At...
Melvin Indecision has difficulty deciding whether to put his savings in Mystic Bank or Four Rivers...
Melvin Indecision has difficulty deciding whether to put his savings in Mystic Bank or Four Rivers Bank. Mystic offers 10% interest compounded semiannually. Four Rivers offers 8% interest compounded quarterly. Melvin has $10,000 to invest. He expects to withdraw the money at the end of 4 years. Which bank gives Melvin the better deal? Check your answer. Use the attached excel sheet to prepare Sue’s bank reconciliation. Problem 12-15: Which bank gives Melvin the better deal? MYSTIC BANK Table 12-1...