Adam has his eyes set on buying an apartment in New Kingston within the next 6 years. Based on investment advice, the Apartment will cost $4 Million Dollars in total payouts. Adam will however benefit from a one million dollars deposited in his bank account as a gift from his grandparents. Adam approached a mortgage bank to finance the rest of the money required. He will be given six years at an interest rate of 9 % to complete the payments. a) Calculate the annual payments to be made on the loan each year. b) Prepare the Amortization schedule for the duration of the Loan. c) Adam was given another option of paying 10 % on the same loan compounded semi annually for 6 years, show how the Amortization Schedule would look for the first three (3) payments.

Adam has his eyes set on buying an apartment in New Kingston within the next 6 years. Based on investment advice, the Apartment will cost $4 Million Dollars in total payouts. Adam will however benefit from a one million dollars deposited in his bank account as a gift from his grandparents. Adam approached a mortgage bank to finance the rest of the money required. He will be given six years at an interest rate of 9 % to complete the payments. a) Calculate the annual payments to be made on the loan each year. b) Prepare the Amortization schedule for the duration of the Loan. c) Adam was given another option of paying 10 % on the same loan compounded semi annually for 6 years, show how the Amortization Schedule would look for the first three (3) payments.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Pierre is deciding whether he should rent or buy a house. Assuming that renting an apartment will cost of him $1,500 per month and the mortgage on a house is $3,500 per month. If he rents, he considers investing the difference between monthly rental cost and mortgage cost in a Balanced Fund earning 8% per year. If the house he purchases in Oshawa, Ontario costs about $800,000 and he intends on paying off the mortgage after 25 years. If he decides to sell the house in 25 years and the house appreciates at a rate of 4% per year: Question 1 What would be the better outcome, renting or buying and by how much? (Show your work and include all financial calculators) Calculate the investment value of renting versus home ownership. Question 2 Based on your answer in Question 1, what factors would make you change your mind and choose the other. List a minimum of 3 reasons or factors and elaborate as to why.
Frances plans to save money for a down payment on a house using an investment account that pays an interest rate of 5.3% per year. She wants to have $425, 000 available five years from today. Frances intends to deposit an amount today and at the end of each of the next five years into her investment account (i. e. she will make a total of six deposits, all of the same amount). How much will each of these deposits be? (Enter your answer to two decimal places)
Hanifa is planning to construct his dream house. For this, he needs to borrow $4M from a local bank. The bank’s financing terms allows Hanifa to borrow any amount for a term of 5 years, with 6% interest per annum. The said interest is to be collected in advance by the bank. How much must be the principal amount of Hanifa’s loan so that his financing needs is met?
Jerry intends to use the money from his loan (and his personal savings if necessary) to make an investment in his friend Elaine's business. In return, Elaine has predicted the following returns on Jerry's investment: Four half-yearly payments of $10,000, the first being exactly 6 months from today, • Four half-yearly payments of $20,000, the first being exactly 6 months after the final $10,000 payment described above, and • Two half-yearly payments of $25,000, the first being exactly 6 months after the final $20,000 payment described above (i.e. there are 10 half-yearly payments in total, the final one occurring exactly 5 years from today). Whilst Elaine is a trusted friend and a capable businesswoman, Jerry has some doubts. To make a more conservative assessment of the investment, Jerry will expect a higher rate of return. Jerry decides that he requires the following return on his investment: • 12% p.a. effective for the first 2 years of the investment, and • 15% p.a. compounding…
Allan plan to go to London to visit friends in three years. The trip is expected to cost a total of RM10,000 at that time. His parents have deposited RM5,000 for him in a Certificate of Deposit paying 6% interest annually, maturing three years from now. His uncle has agreed to pay for all remaining expenses. If he is going to put his uncle’s gift in an investment earning 10% over the next three years, how much must he deposit today, so he can visit his friends three years from today.
Syariqul Haq is trying to save up for a big vacation. He plans to take a trip around Japan when he graduates in four years. If he can earn 8 percent return on investment semiannually, calculate the amount that he needs to deposit every year to have RM10,000 upon his graduation.
Jennifer is planning a trip to Alaska in 5 years. She has calculated that she will need $15,000 to cover her expenses. Her bank offers money market investments at a rate of 4.5% compounded annually. What should Jennifer invest now to have the needed funds?
Syariqul Haq is trying to save up for a big vacation. He plans to take a trip around Japan when he graduates in four years. If he can earn 8 percent return on investment semiannually, calculate the amount that he needs to deposit every year to have RM10,000 upon his graduation. (b) Hakimi borrow RM15,000 education loan from Maybank. Payments are being made in instalments at the end of each year. He borrows for 10 years at an interest rate 5 percent per annum. Calculate the amount that Hakimi has to payback for every year.
Jannah is planning to visit her friends in London in three-year time from now. She needs a total of RM30,000 for that purpose. She has deposited RM12,000 in her savings account which pays 4% interest annually. Her parents promised to finance the balance by putting a sum of money in an investment earning 15% annually. How much do you think her parents must deposit now in order for her to have a total of RM30,000 at the end of year three?
he Sandhill are planning for a retirement home. They estimate they will need $228,000 4 years from now to purchase this home. Assuming an interest rate of 11%, what amount must be deposited at the end of each of the 4 years to fund the home price?
George has planned ahead and identified his dream house purchase in 3 years’ time. The current value of the house is $580 000. It is expected that the house will increase in value at a rate of 4.5% p.a. 4) How much does he need to borrow from the bank at the end of year 3 to buy the house? (Assume George will borrow 90% from the bank)
The Martinez are planning for a retirement home. They estimate they will need $212,000 4 years from now to purchase this home. Assuming an interest rate of 12%, with four equal amounts being deposited at the beginning of the period. What amount must be deposited at the beginning of each period?