Question

In: Finance

Suppose you want to buy a house which is valued at $100,000. You decide to borrow...

Suppose you want to buy a house which is valued at $100,000. You decide to borrow the money
from the bank at an interest rate of 12.5 percent and agree to make equal annual end of year
payments over the next 5 years to fully repay the loan. Also assume you work as a financial
manager at the bank and you want to prepare a loan amortization schedule yourself.
So, prepare the loan amortization schedule showing separate columns for the Year, beginning-
of-year principal, loan payment, interest amount, principal amount and end-of-year principal.

Solutions

Expert Solution


Related Solutions

4. You want to buy a house valued at $1.2 million. For a house this valuable,...
4. You want to buy a house valued at $1.2 million. For a house this valuable, the lenders demand a down payment of 25% and insist that the monthly payment on the 25 year mortgage loan is no more than 30% of your monthly gross income. The quoted rate on a 25 year fixed rate mortgage loan is 2.94% per year. Assume that you can make the down payment. (a): What is the least amount of your yearly gross income...
You want to buy a house and will need to borrow $245,000. The interest rate on...
You want to buy a house and will need to borrow $245,000. The interest rate on your loan is 5.77 percent compounded monthly and the loan is for 30 years. What are your monthly mortgage payments?
Suppose that you decided to buy a new house. The house you want to buy costs...
Suppose that you decided to buy a new house. The house you want to buy costs $520,000 and the interest rate is 7%. You currently have $130,000 and are required to put a 20% down payment plus an additional 3% of the loan amount as closing costs. 1) When will you have enough money for the down payment and closing costs, assuming that the $80,000 is the only investment that you make? 2) Suppose that you plan to buy the...
You want to buy a house that costs $100,000. You have $10,000 for a down payment,...
You want to buy a house that costs $100,000. You have $10,000 for a down payment, but your credit is such that mortgage companies will not lend you the required $90,000. However, the realtor persuades the seller to take a $90,000 mortgage (called a seller take-back mortgage) at a rate of 9%, provided the loan is paid off in full in 3 years. You expect to inherit $100,000 in 3 years; but right now all you have is $10,000, and...
You want to buy a house that costs $100,000. You have $10,000 for a down payment,...
You want to buy a house that costs $100,000. You have $10,000 for a down payment, but your credit is such that mortgage companies will not lend you the required $90,000. However, the realtor persuades the seller to take a $90,000 mortgage (called a seller take-back mortgage) at a rate of 10%, provided the loan is paid off in full in 3 years. You expect to inherit $100,000 in 3 years, but right now all you have is $10,000, and...
if you are buying a house valued at $210,000 with 10% down payment. You will borrow...
if you are buying a house valued at $210,000 with 10% down payment. You will borrow the remaininf 90% of the purchase prices at 6% APR and the loan will be paid off in 30 years, how much do you still owe two months from now?
You want to buy a $1,000,000 house. Suppose you make a20% down payment today, and you...
You want to buy a $1,000,000 house. Suppose you make a20% down payment today, and you finance the rest of your purchase with a 30‐year fixed rate jumbo mortgage of 4.00%.          What will be your monthly mortgage payments?                    How much of your first month’s payment goes toward paying   off interest? How much  goes toward paying off the loan balance?            How much do you still owe after 5 years (i.e., just after your 60th monthly payment)?                        How long...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is 20 years. You obtain a 5-year fixed rate mortgage from TD bank at 2%/year (using Canadian mortgage convention). (a) How much do you owe the bank after the 60th payment? (b) For the 24th monthly payment, how much of it is for interest, and how much of it is for principal repayment? d) What is the present value of the interest portion of the...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is 20 years. You obtain a 5-year fixed rate mortgage from TD bank at 2%/year (using Canadian mortgage convention). (a) What is your monthly payment? (b) How much do you owe the bank after the 60th payment? (c) For the 24th monthly payment, how much of it is for interest, and how much of it is for principal repayment? (d) What is the present value...
Two years ago, you purchase a house of $100,000. You borrow a mortgage with 80% of...
Two years ago, you purchase a house of $100,000. You borrow a mortgage with 80% of LTV (loan to value ratio). The annual interest rate on the mortgage is 6%. Payments are being made monthly, and the loan tem is 30 years. You have found another lender who will refinance only the current outstanding loan balance at 4.5% with monthly payments for 30 years. The new lender will charge three discount points and the refinancing cost is equal to $3,000....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT