Question

Suppose that 6 months from now, the COVID crisis has caused real estate prices to fall 20% and you are confident that they will bounce back. You have decided to buy a condo on Four Winds Drive, a short walk from the new subway stop at Keele and Finch. You plan to live there with a friend while you finish off your BBA and then commute to downtown where you expect to work after graduation. The condo will cost $400,000 and your parents have provided you the down payment money of $100,000. And the bank is quoting 2.50% quoted rate based on a 25-year amortization, which will be compounded semi-annually in accordance with Canadian law.

Required:

1. What would be the amount of monthly payments on the mortgage?
2. What would be the principal outstanding after five (5) years?

Answer both parts of the question in the text box below. Round your final answer to 2 decimal points

Answer 1

a)Given the amount of loan required inorder to buy the house is $3,00,000

Now the rate offered by bank is 2.5%

Given that this rate is compounded semi-annually

Hence let us calculate the monthly rate

Let X bet the six month rate , Now

(1+X)² = 1.025

Hence X = 1.012423

Now monthly rate will be 1.012423/6 = 0.168737

The formula for calculating the monthly equalised installments is.

[P x R x (1+R)^N]/[(1+R)^N-1], where P stands for the loan amount or principal, R is the interest rate per month.

Hence the equalised monthly installment the amount is

= (3,00,000 * 0.00168737 *(1.00168737)³⁰⁰)/((1.00168737)³⁰⁰-1)

= 3,00,000 * 0.00168737 * 2.519096

= 1275.195

Hence the monthly payment amount is $1275.19

b) Now the loan amortization schedule can be shown as below.

Month	Opening Investment	Interest	Monthly installement	Closing balance
1	3,00,000	506.21	1275.195	2,99,231.02
2	2,99,231.02	504.91	1275.195	2,98,460.74
3	2,98,460.74	503.61	1275.195	2,97,689.15
4	2,97,689.15	502.31	1275.195	2,96,916.27
5	2,96,916.27	501.01	1275.195	2,96,142.08
6	2,96,142.08	499.70	1275.195	2,95,366.59
7	2,95,366.59	498.39	1275.195	2,94,589.79
8	2,94,589.79	497.08	1275.195	2,93,811.68
9	2,93,811.68	495.77	1275.195	2,93,032.25
10	2,93,032.25	494.45	1275.195	2,92,251.51
11	2,92,251.51	493.14	1275.195	2,91,469.45
12	2,91,469.45	491.82	1275.195	2,90,686.07
13	2,90,686.07	490.50	1275.195	2,89,901.37
14	2,89,901.37	489.17	1275.195	2,89,115.35
15	2,89,115.35	487.84	1275.195	2,88,328.00
16	2,88,328.00	486.52	1275.195	2,87,539.32
17	2,87,539.32	485.19	1275.195	2,86,749.31
18	2,86,749.31	483.85	1275.195	2,85,957.97
19	2,85,957.97	482.52	1275.195	2,85,165.29
20	2,85,165.29	481.18	1275.195	2,84,371.28
21	2,84,371.28	479.84	1275.195	2,83,575.92
22	2,83,575.92	478.50	1275.195	2,82,779.23
23	2,82,779.23	477.15	1275.195	2,81,981.18
24	2,81,981.18	475.81	1275.195	2,81,181.80
25	2,81,181.80	474.46	1275.195	2,80,381.06
26	2,80,381.06	473.11	1275.195	2,79,578.97
27	2,79,578.97	471.75	1275.195	2,78,775.53
28	2,78,775.53	470.40	1275.195	2,77,970.73
29	2,77,970.73	469.04	1275.195	2,77,164.58
30	2,77,164.58	467.68	1275.195	2,76,357.06
31	2,76,357.06	466.32	1275.195	2,75,548.18
32	2,75,548.18	464.95	1275.195	2,74,737.94
33	2,74,737.94	463.58	1275.195	2,73,926.33
34	2,73,926.33	462.22	1275.195	2,73,113.35
35	2,73,113.35	460.84	1275.195	2,72,299.00
36	2,72,299.00	459.47	1275.195	2,71,483.27
37	2,71,483.27	458.09	1275.195	2,70,666.17
38	2,70,666.17	456.71	1275.195	2,69,847.69
39	2,69,847.69	455.33	1275.195	2,69,027.83
40	2,69,027.83	453.95	1275.195	2,68,206.59
41	2,68,206.59	452.56	1275.195	2,67,383.95
42	2,67,383.95	451.18	1275.195	2,66,559.94
43	2,66,559.94	449.79	1275.195	2,65,734.53
44	2,65,734.53	448.39	1275.195	2,64,907.72
jeff jeffy Next > < Previous Related Solutions The economic disruptions caused by COVID-19 have caused a dramatic fall in oil prices. On April... The economic disruptions caused by COVID-19 have caused a dramatic fall in oil prices. On April 20th, 2020, the price of oil even became negative. Using a supply and demand diagram, explain clearly why this is happening Covid 19 is a crisis primarily caused by biology, but it has resulted in economies shutting... Covid 19 is a crisis primarily caused by biology, but it has resulted in economies shutting down worldwide. The US government has already introduced a stimulus package close to $2 trillion, about one-tenth of total GDP and is working on another stimulus. The Federal Reserve has lowered interest rates and is more involved in private lending than ever before. The European Union, Japanese goernment, and others are spending hundreds of billions to keep the economy afloat. Do you believe a... Suppose a real estate agent is interested in comparing the asking prices of mid-range homes in... Suppose a real estate agent is interested in comparing the asking prices of mid-range homes in Brisbane and Canberra. The real estate agent conducts a small telephone survey in the two cities, asking the prices of mid-range homes. A random sample of 21 listings in Brisbane resulted in a sample average price of $507,600, with a standard deviation of 9,200. A random sample of 26 listings in Canberra resulted in a sample average price of $496,000, with a standard deviation... The fallout from the financial crisis of 2008 included an overheated real estate market, fueled by... The fallout from the financial crisis of 2008 included an overheated real estate market, fueled by home purchase incentives, poor lending practices, and securitization through high-risk, mortgage-backed securities, which led to a near collapse of global capital markets. As a consequence, many have argued that if the financial institutions had been required to report their loans (and loan-backed investments) at fair value instead of cost, large losses would have been reported earlier. This would have signaled regulators to the problems... The recent outbreak of COVID-19 has caused a severe public health crisis as well as substantial... The recent outbreak of COVID-19 has caused a severe public health crisis as well as substantial economic disruption for every American. Policymakers have been considering legislation to help manage the pandemic and mitigate the economic burden on families and businesses. So far, lawmakers have enacted four separate pieces of legislation, costing approximately $2.4 trillion. Below is a quick recap of that legislation. Coronavirus-Related Legislative Actions to Date As an initial response, policymakers enacted legislation in early March that provided $8.3... Which of the following would cause prices to rise and real GDP to fall in the... Which of the following would cause prices to rise and real GDP to fall in the short run? Question options: an increase in the expected price level an increase in the capital stock an increase in the quantity of labor available The COVID-19 crisis will certainly cause a fall of global trade. Why Germany is upset with... The COVID-19 crisis will certainly cause a fall of global trade. Why Germany is upset with Spain with respect of how Spain managed trade surplus and government surplus money? Present specific data to support your argument. Firm dynamics in the COVID-19 crisis. Analyze the impact of the COVID-19 crisis from a firm... Firm dynamics in the COVID-19 crisis. Analyze the impact of the COVID-19 crisis from a firm dynamics perspective. Assume that the productivity of all firms is the product of an economy wide parameter z times an idiosyncratic firm-level productivity that varies by firm and over time as an AR(1) process. What does the basic model predict regarding entry, exit, employment, wages? How does the policy of loans converted to grants to keep employment at the firm level affect the equilibrium? A. The local real estate reported a sampling of house prices in a certain area as:... A. The local real estate reported a sampling of house prices in a certain area as: $56,000; $78,000; $64,000; $190,000; $60,000; $74,000; $56,000. What would be the best, most realistic house price to report, and why? the Mean, the Median, the mode A deviation value is just how far is a single value from the mean. This is several subtraction problems. b. For the series of values 12, 15, 17, 22, 24: Calculate the Mean and show what the deviations... A. The local real estate reported a sampling of house prices in a certain area as:... A. The local real estate reported a sampling of house prices in a certain area as: $56,000; $78,000; $64,000; $190,000; $60,000; $74,000; $56,000. What would be the best, most realistic house price to report, and why? the Mean, the Median, the mode A deviation value is just how far is a single value from the mean. This is several subtraction problems. b. For the series of values 12, 15, 17, 22, 24: Calculate the Mean and show what the deviations... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions A steady-flow adiabatic turbine (expander) accepts gas at conditions T1, P1 and discharges at conditions T2,... Question B1 In 2002, Musk sold his second internet startup, PayPal, to eBay for $1.5 billion.... Part 5: CLO 5 Question 1 David, the project manager, is now working on procurement planning... . The following is a key exchange protocol used by two clients, A and B, to... Abnormal Psychology Discussion Prompt: I’d like us to think about this- What is abnormal? Consider the... There are different types of risk involved in foreign exchange. One type of risk is risk... ACCT Corp. is a manufacturer of truck trailers. On 1 January 2020, ACCT Corp. leased a... ADVERTISEMENT About @ 2020 WizEdu