Please show your working and formula (If possible) -------------------------- Suppose you take out an $840,000, 20-year...

Please show your working and formula (If possible)

--------------------------

Suppose you take out an $840,000, 20-year mortgage loan to buy a residential apartment. The interest rate on the mortgage is 4.65% per annum, and payments are required to be made annually at the end of each year.

Question:

Construct a mortgage amortisation table showing loan balance at the beginning of each period, annual repayment amount, interest payment, the amortisation of the loan and the loan balance for each year.

Solutions

Expert Solution

Sl.	Beginning	Interest	Principal	Repayment amountt	Balance
1	840000	39060	26358.02	65418.02	813641.98
2	813641.98	37834.35	27583.67	65418.02	786058.32
3	786058.32	36551.71	28866.31	65418.02	757192.01
4	757192.01	35209.43	30208.59	65418.02	726983.43
5	726983.43	33804.73	31613.29	65418.02	695370.14
6	695370.14	32334.71	33083.31	65418.02	662286.84
7	662286.84	30796.34	34621.68	65418.02	627665.16
8	627665.16	29186.43	36231.59	65418.02	591433.57
9	591433.57	27501.66	37916.36	65418.02	553517.22
10	553517.22	25738.55	39679.47	65418.02	513837.75
11	513837.75	23893.46	41524.56	65418.02	472313.2
12	472313.2	21962.56	43455.46	65418.02	428857.74
13	428857.74	19941.88	45476.14	65418.02	383381.6
14	383381.6	17827.24	47590.78	65418.02	335790.83
15	335790.83	15614.27	49803.75	65418.02	285987.08
16	285987.08	13298.4	52119.62	65418.02	233867.47
17	233867.47	10874.84	54543.18	65418.02	179324.29
18	179324.29	8338.58	57079.44	65418.02	122244.86
19	122244.86	5684.39	59733.63	65418.02	62511.23
20	62511.23	2906.77	62511.25	65418.02	0

Interest = Previous balance * interest rate

Principal = Yearly payment - interest

Balance = Previous balance - principal

jeff jeffy answered 7 months ago

Next > < Previous

Related Solutions

PLEASE SHOW WORKING IF POSSIBLE AS WELL. THANK YOU. 1) Suppose there is a market for...

PLEASE SHOW WORKING IF POSSIBLE AS WELL. THANK YOU. 1) Suppose there is a market for electronic bikes that is currently at equilibrium. If the consumers of electronic bikes had an increase in income which resulted in a rightward parallel shift of the demand for electronic bikes, then at any given price, the price elasticity of demand will have: A) increased in absolute terms. B) decreased in absolute terms. C) remained unchanged. D) increased, decreased or stayed the same. It...

show formula and detail step,please Thank you! 3. Suppose your company needs $20 million to build...

show formula and detail step,please Thank you! 3. Suppose your company needs $20 million to build a new assembly line. Your target debt–equity ratio is .75. The flotation cost for new equity is 7 percent, but the flotation cost for debt is only 3 percent. Your boss has decided to fund the project by borrowing money because the flotation costs are lower and the needed funds are relatively small. a. What do you think about the rationale behind borrowing the...

Suppose you take out a 20-year mortgage for a house that costs $394818. Assume the following:...

Suppose you take out a 20-year mortgage for a house that costs $394818. Assume the following: The annual interest rate on the mortgage is 5%. The bank requires a minimum down payment of 10% at the time of the loan. The annual property tax is 2% of the cost of the house. The annual homeowner's insurance is 0.9% of the cost of the house. The monthly PMI is $54 Your other long-term debts require payments of $566 per month. If...

Suppose you take out a 20-year mortgage for a house that costs $264,857. Assume the following:...

Suppose you take out a 20-year mortgage for a house that costs $264,857. Assume the following: The annual interest rate on the mortgage is 3%. The bank requires a minimum down payment of 11% at the time of the loan. The annual property tax is 2.5% of the cost of the house. The annual homeowner's insurance is 0.9% of the cost of the house. The monthly PMI is $87 Your other long-term debts require payments of $624 per month. If...

Suppose you take out a 20-year mortgage for a house that costs $386,150. Assume the following:...

Suppose you take out a 20-year mortgage for a house that costs $386,150. Assume the following: The annual interest rate on the mortgage is 3%. The bank requires a minimum down payment of 19% at the time of the loan. The annual property tax is 2.1% of the cost of the house. The annual homeowner's insurance is 0.6% of the cost of the house. The monthly PMI is $54 Your other long-term debts require payments of $555 per month. If...

Suppose you take out a 20-year mortgage for a house that costs $332,294. Assume the following:...

Suppose you take out a 20-year mortgage for a house that costs $332,294. Assume the following: The annual interest rate on the mortgage is 4%. The bank requires a minimum down payment of 18% at the time of the loan. The annual property tax is 1.6% of the cost of the house. The annual homeowner's insurance is 0.7% of the cost of the house. The monthly PMI is $70 Your other long-term debts require payments of $937 per month. If...

Suppose you take out a $107,000, 20-year mortgage loan to buy a condo. The interest rate...

Suppose you take out a $107,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 4%. To keep things simple, we will assume you make payments on the loan annually at the end of each year. a. What is your annual payment on the loan? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. Construct a mortgage amortization. (Do not round intermediate calculations. Round your answers to 2 decimal places.) c....

Amortizing loans. Suppose that you take out a $200,000, 20-year mortgage loan to buy a condo....

Amortizing loans. Suppose that you take out a $200,000, 20-year mortgage loan to buy a condo. The interest rate on the loan is 6%, and payments on the loan are made annually at the end of each year. What is your annual payment on the loan? Construct a mortgage amortization table in Excel similar to Table 2.1, showing the interest payment, the amortization of the loan, and the loan balance for each year. What fraction of your initial loan payment...

Suppose you take out a loan for school this year for $9000. The bank expects that...

Suppose you take out a loan for school this year for $9000. The bank expects that the rate of inflation for next year will equal 2%. You and the bank agree that in one year’s time, you will pay back the full amount at an interest rate of 5%. Next year though, there is a sudden rise in inflation, causing inflation to equal 12%. Based upon this information, answer the following questions. How much will you...

You take out a $200,000 mortgage for 20 years at 6%. a. What is your monthly payment?

You take out a $200,000 mortgage for 20 years at 6%.a. What is your monthly payment?b. What is the principle and interest on the first payment?c. What is the principle and interest on the twelfth payment?d. How much interest will you pay over the 20 years?

Subjects