In: Finance
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:
Answer both parts of the question in the text box below. Round your final answer to 2 decimal points
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)2 = 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)300)/((1.00168737)300-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 |
Related SolutionsThe 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...
Which of the following is true about real estate pricing? Real estate prices are always the...Which of the following is true about real estate pricing?
Real estate prices are always the same as the value of the real
estate.
Real estate prices are a function of the value of the real
estate.
Real estate prices are clearly observable in the market.
Real estate prices can be influenced by the number of buyers
and sellers active in the market.
What type of easement is usually used for commercial
purposes?
Appurtenant easement
Negative easement
Gross Easement.
Dominant...
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...
The impact of COVID-19 on user behaviour and ecommerce There’s no doubt that the crisis caused...The impact of COVID-19 on user behaviour and ecommerce
There’s no doubt that the crisis caused by the global Coronavirus
(COVID-19) pandemic has created an incredibly difficult business
climate. Businesses are being presented with many new challenges as
international borders close, bricks-and-mortar businesses shut
their doors, and people are told to isolate at home. Many companies
face temporary or even permanent closures, with staff facing months
of financial uncertainty and worry.
Consumer behaviour has been forced to immediately change, and...
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?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|