Question

In: Finance

The Simpsons, owners of a spa on the island of Montreal, have been hard-hit by the...

The Simpsons, owners of a spa on the island of Montreal, have been hard-hit by the pandemic. Before they were forced to close their spa, their take home income, after taxes but before living expenses, was $7,000 a month. The Simpsons spent all of their take-home cash flow and even more, by borrowing on a line of credit (LOC). The day their spa was closed the balance on their LOC was $8,520. Normally they use the LOC to clear the balance on their several credit cards each month. Terms of the LOC include a repayment of 3% of principal every month plus interest charged at a rate of 0.5% per month. Three years ago the Simpsons took out a $532,000 mortgage to purchase a home in Beaconsfield. Payments are monthly at a rate of 3.6%, compounded semi-annually. The original amortization period was 20 years and they have made 34 payments to date. The Simpson’s mortgagor has offered them the possibility of suspending payments for the next 4 months. Nevertheless, they will still owe the interest they would have paid on each payment. Furthermore, the future value of the unpaid interest after 4 months will mean that they will have to pay interest on the outstanding interest should they take up this offer.

a) Excluding the balance on their LOC, what minimum emergency fund should the Simpsons have held to meet unforeseen events?  What type of investment would be suitable for such a fund?

b) How much would the couple have to pay on the LOC for the month following closure of their spa?  What impact would not making the payment have on their credit rating?  Please explain.

c) What is the monthly payment on the Simpson’s mortgage?  What is the balance after 34 months?  Round to the nearest dollar

d) Draw up the Simpson’s mortgage amortization table for the next four months (i.e. for payments 35-38).  Their monthly mortgage rate is 0.2978%.  Round to the nearest dollar.

e) How much interest will the Simpsons owe at the end of the 4-month period?  (Mortgage payments are made at the end of the month.)  Round to the nearest dollar.  Remember, they will be obliged to pay interest on their interest. If they are given the choice of adding this to their mortgage balance or paying it immediately in cash, what would you recommend, and why?

Solutions

Expert Solution

a. they should have held a fund that pays atleast $ 7000 per month for their living expenses.
Investments that pay monthly annuities , ie. Fixed sums at monthly intervals , would have been preferable.
b) Amount the couple would have to pay on the LOC for the month following closure of their spa=
(8520*(3%+0.5%))=
298.2
Not making the payment ,will certainly affect the credit-rating o the card-holder ,by the lender & also future interest rates for the defaulting borrower , may be higher than for others. He is definite to be red-marked & watched over, if he misses any installment.
c)Monthly payment on the Simpson’s mortgage  
Monthly payment=PV of mortgage/Annuity Factor,i=0.2978%(given in d.); n=20*12=240
ie. 532000/((1-1.002978^-240)/0.002978)=
3105.54
Mortgage principal Balance after 34 months=
FV of original balance at end Mth 34 -FV of annuity at end mt. 34
ie. (Original Loan amt.*(1+r)^n)-(Mthly.pmt.*((1+r)^n-1)/r)
Plugging in the variables, in the above formula,
ie. (532000*(1+0.002978)^34)-(3105.54*((1+0.002978)^34-1)/0.002978)=
477654
d)Simpson’s mortgage amortization table for the next four months (i.e. for payments 35-38).  Their monthly mortgage rate is 0.2978%.  
Mth. Mthly pmt. Tow. Int. Tow. Mort. Mort. Bal.
34 477654
35 3106 1422 1683 475971
36 3106 1417 1688 474282
37 3106 1412 1693 472589
38 3106 1407 1698 470891

e.

Interest the Simpsons will owe at the end of the 4-month period--they are obliged to pay interest on their interest, if they take up the mortgagor's offer of mortgage- payments suspension for the next 4 months---instead of the normal end-of-mth, mortgage payments --- rounded to nearest $
Sum of future values of month 35-38 interest amounts as in Table in Part-4
ie.(1422*1.002978^3)+(1417*1.002978^2)+(1412*1.002978^1)+1407=
5683
If they are given the choice of adding this to their mortgage balance or paying it immediately in cash, they should pay in cash immediately--otherwise, again interest to be paid will be compounded, ie. Interest needs to be paid on interest.

Related Solutions

Mini-Case B (6 marks) The Simpsons, owners of a spa on the island of Montreal, have...
Mini-Case B The Simpsons, owners of a spa on the island of Montreal, have been hard-hit by the pandemic. Before they were forced to close their spa, their take home income, after taxes but before living expenses, was $7,000 a month. The Simpsons spent all of their take-home cash flow and even more, by borrowing on a line of credit (LOC). The day their spa was closed the balance on their LOC was $8,520. Normally they use the LOC to...
In the early months of 2020, many sectors in Hong Kong have been hit hard by...
In the early months of 2020, many sectors in Hong Kong have been hit hard by the COVID19 outbreak. Investigate how the COVID19 affects the various aspects of the economy, such as Gross Domestic Product (GDP), import and export, economic growth/economic recession, unemployment, and cost of living (inflation/deflation)? Have the government remedial policies been able to revitalize the economy? What appropriate policies should be taken to revitalize the economy of Hong Kong if your group were one of the policy-makers...
Q1 Required) "Black-owned businesses have been hit especially hard by the pandemic," Sheryl Sandberg, Facebook's chief...
Q1 Required) "Black-owned businesses have been hit especially hard by the pandemic," Sheryl Sandberg, Facebook's chief operating officer, wrote in a Thursday blog post announcing the new initiative. "But we know that millions of people want to help." This project will demonstrate the simplicity of creating a small business to function effectively in a global market. Create a marketing plan for a wood selling company You must identify and articulate the strategic and tactical elements that will play a role...
The world has been hit hard by the latest COVID-19 pandemic, and health services and authorities...
The world has been hit hard by the latest COVID-19 pandemic, and health services and authorities in every country are struggling to reduce spread, fight disease and protect the population. Strict restrictions on movement, social distance and locking in certain cities have been imposed on people and businesses since the outbreak in Wuhan, China in December 2019. However, these widespread lockdowns, social distances and restrictions have led to major changes in human activity and have therefore produced some jarring effects...
he coal mining industry has been hard-hit by environmental regulations. Recently, however, a combination of increased...
he coal mining industry has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies has led to an improved market demand for coal. WHC has just been approached by Mid-Cen Electric Company with a request to supply coal for its electric generators for the next eight years. WHC does not have enough excess capacity at its existing mines to guarantee the contract. The company is considering opening a strip mine...
Alliston spa, a California company, has been expanding in the Northeast. It has opened a spa...
Alliston spa, a California company, has been expanding in the Northeast. It has opened a spa in Stowe, Vermont, and another in the Berkshires, Massachusetts, and is now planning to open a third one in the East End’s South Fork of Long Island, New York. Alliston is eyeing an unused space owned by Orange Shores Inn. The space is located on the third floor of the main building. About 1/5 of the 10,000 sq. ft. space will be used to...
Heather's Horse Spa (HHS) is an establishment that boards, trains, and pampers horses while their owners...
Heather's Horse Spa (HHS) is an establishment that boards, trains, and pampers horses while their owners are on vacation. Heather sells her service as an "enchanting vacation experience for your horse while you vacation elsewhere." Horse feed, shampoos, ribbons, and other supplies are treated as variable indirect costs. Consequently, there are no direct materials involved in the vacation service. Other overhead costs including indirect labor, depreciation on the barn, and advertising are fixed. Both variable and fixed overhead are allocated...
ndustries are hard hit by COVID-19 and the hospitality industry is no exception, as a Front...
ndustries are hard hit by COVID-19 and the hospitality industry is no exception, as a Front Office Manager, discuss with examples five (5) benefits of adopting yield management in your operations in this season. NOTE.PLEASE DISCUSS DO NOT JUST LIST THE BENEFIT BUT RATHER EXPLAIN.
In September 2018, A powerful earthquake hit the Japanese island of Hokkaido. As a result. Toyota...
In September 2018, A powerful earthquake hit the Japanese island of Hokkaido. As a result. Toyota was forced to suspend production at a key plant, disrupting the supply of components to Toyota's factories across Japan as well as other countries, including the U.S. and Canada.   The earthquake and a recent typhoon in Japan highlight how vulnerable global supply chains can be to natural disasters. Discuss: The advantages and disadvantages of relying on a limited number of production facilities for critical...
So far we far we have been discussing the advantages of HIT, but have not considered...
So far we far we have been discussing the advantages of HIT, but have not considered its disadvantages. Discuss at least three (3) of the disadvantages or challenges that can be encountered by adoption of the HIT, such as EHR (Electronic Health Record) or HIE (health Information Exchange).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT