Question

In: Accounting

Facts ·       Mortgage Principal at origination 1/1/2020: $10,000,000 ·       Annual Interest Rate at origination: 6% ·      ...

Facts
·       Mortgage Principal at origination 1/1/2020: $10,000,000
·       Annual Interest Rate at origination: 6%
·       Term of Mortgage from origination 1/1/2020: 20 years
·       Purchase Price: $10,000,000 on 1/1/2020
·       The mall owner has stopped paying principal beginning April, 2021, and anticipates being unable to pay even the interest portion beginning September, 2021 unless the CDC allows less strict mask and social distancing requirements.
·       The mall had a fair market value of $20 million on 1/1/2020, and expects a current appraisal to be at about $16 million.
·       Ignore refinancing costs.
·       The securitizations do not qualify for sale accounting, and the creditor retains legal title to the mortgage as well as a 10% participation in the mortgage.
·       Today is August 31, 2021.
1.Create an amortization table that allows for an input each period of the amount that the borrower actually pays. Using the facts of the case, use the amortization table structure to find the principal amount owed as of September 1, 2021.

2.Create a separate restructured loan that is a reasonable alternative to the current unaffordable mortgage.

3.Create an amortization table for the restructured loan with the modifications and expected mortgage payments. If the creditor and borrower would have different accounting treatments for the loan, create an amortization table for the creditor and the borrower.

Solutions

Expert Solution

1] AMORTISATION SCHEDULE
6%
PARTICULARS DATE AMOUNT OUTSTANDING EMI INTEREST PRINCIPAL REPAID AMOUNT OUTSTANDING
Principal at origination 01-01-2020                         1,00,00,000                         1,00,00,000
01-02-2020                         1,00,00,000       71,643                     50,000                                 21,643                            99,78,357
01-03-2020                            99,78,357       71,643                     49,892                                 21,751                            99,56,606
01-04-2020                            99,56,606       71,643                     49,783                                 21,860                            99,34,746
01-05-2020                            99,34,746       71,643                     49,674                                 21,969                            99,12,776
01-06-2020                            99,12,776       71,643                     49,564                                 22,079                            98,90,697
01-07-2020                            98,90,697       71,643                     49,453                                 22,190                            98,68,507
01-08-2020                            98,68,507       71,643                     49,343                                 22,301                            98,46,207
01-09-2020                            98,46,207       71,643                     49,231                                 22,412                            98,23,795
01-10-2020                            98,23,795       71,643                     49,119                                 22,524                            98,01,271
01-11-2020                            98,01,271       71,643                     49,006                                 22,637                            97,78,634
01-12-2020                            97,78,634       71,643                     48,893                                 22,750                            97,55,884
01-01-2021                            97,55,884       71,643                     48,779                                 22,864                            97,33,020
01-02-2021                            97,33,020       71,643                     48,665                                 22,978                            97,10,042
01-03-2021                            97,10,042       71,643                     48,550                                 23,093                            96,86,949
01-04-2021                            96,86,949       48,435                     48,435                                          -                              96,86,949
01-05-2021                            96,86,949       48,435                     48,435                                          -                              96,86,949
01-06-2021                            96,86,949       48,435                     48,435                                          -                              96,86,949
01-07-2021                            96,86,949       48,435                     48,435                                          -                              96,86,949
01-08-2021                            96,86,949       48,435                     48,435                                          -                              96,86,949
01-09-2021                            96,86,949                -                               -                                            -                              96,86,949

2] RESTRUCTURING-

AS DUE TO SPECIAL SITUATION OF PANDEMIC THE MALL OWNER CANNOT REPAY THE DEBT . HE IS WILLING TO RESTRUCTURE THE LOAN AND HENCE TO BENEFIT FROM THE ABOVE THE CREDITOR SHOULD EXTEND A ADDITIONAL LOAN AT SAME RATE

NOW , HERE THE BENEFIT OF ADDITIONAL LOAN IS THAT ,WE ARE PROPOSING THE CREDITOR TO EXTEND A LOAN EQUAL TO 12 INSTALLMENTS TO BE PAID BY THE MALL OWNER WHICH IS SUBSTANTIALLY LOW W.R.T TO THE 60% INCREASE IN THE MALL'S MARKET VALUE

NOW WHEN THE ADDITIONAL LOAN IS DISBURSED A NEW AMORTISATION SCHEDULE WILL BE GENERATED IN WHICH THE MALL OWNER AS WELL AS THE CREDITOR BENEFITS HENCE A WIN WIN SITUATION

ADDITIONAL LOAN - 12*71643=8,59,717.20

NEW OUTSTANDING PRINCIPAL - 105466676

NEW EMI - 75560

NEW TENURE - 240 MONTHS

NEW [SAME] INTEREST RATE - 6%

AS THERE IS A LIMIT ON THE SIZE OF ANSWER I CANNOT INSERT THE WHOLE RESTRUCTURED AMORTISATION TABLE BUT I HAVE SHOWN GLIMPSE WHICH WILL HELP YOU TO UNDERSTAND THE SAME

2] RESTRUCTURED LOAN
6%
PARTICULARS DATE AMOUNT OUTSTANDING EMI INTEREST PAID PRINCIPAL REPAID AMOUNT OUTSTANDING
Principal at origination 01-09-2021                            96,86,949                   -                               -                              96,86,949
01-09-2021                         1,05,46,667           75,560                        52,733                     22,826                         1,05,23,840
01-10-2021                         1,05,23,840           75,560                        52,619                     22,940                         1,05,00,900
01-11-2021                         1,05,00,900           75,560

Related Solutions

Facts · Mortgage Principal at origination 1/1/2020: $10,000,000 · Annual Interest Rate at origination: 6% ·...
Facts · Mortgage Principal at origination 1/1/2020: $10,000,000 · Annual Interest Rate at origination: 6% · Term of Mortgage from origination 1/1/2020: 20 years · Purchase Price: $10,000,000 on 1/1/2020 · The mall owner has stopped paying principal beginning April, 2021, and anticipates being unable to pay even the interest portion beginning September, 2021 unless the CDC allows less strict mask and social distancing requirements. · The mall had a fair market value of $20 million on 1/1/2020, and expects...
You have obtained a mortgage for $100,000 with annual interest rate of 6% that is to...
You have obtained a mortgage for $100,000 with annual interest rate of 6% that is to be paid over 30 years (interest is compounded monthly). Your monthly payment is $600. Complete the first few rows of the loan amortization table (show how you got the number): Months Loan balance Loan payment Interest Principal 1 2 3
Given the following statistics, calculate the mortgage cost percent. Annual mortgage interest $9,000 Annual principal payment...
Given the following statistics, calculate the mortgage cost percent. Annual mortgage interest $9,000 Annual principal payment $2,000 Annual insurance and real estate taxes $8,000 Yearly gross income $120,000
6. Assume the annual interest rate on a $500,000 7-year balloon mortgage is 6 percent. Payments...
6. Assume the annual interest rate on a $500,000 7-year balloon mortgage is 6 percent. Payments will be made monthly based on a 30-year amortization schedule. f. What will be the remaining mortgage balance on the new 4.5 percent loan at the end of year 7 (four years after refinancing)? g. What will be the difference in the remaining mortgage balances at the end of year 7 (four years after refinancing)? h. At the end of year 3 (beginning of...
Consider a $766,200 principal 28 -year mortgage with monthly payments. The annual mortgage rate is 7.40%...
Consider a $766,200 principal 28 -year mortgage with monthly payments. The annual mortgage rate is 7.40% with monthly compounding. Assume that the remaining balance after the 60 th payment is $613,395 . What is the total prepayment made on or before the 5 th anniversary of the mortgage?
You currently have a 30-year fixed rate mortgage with an annual interest rate of 6%. You...
You currently have a 30-year fixed rate mortgage with an annual interest rate of 6%. You have had the mortgage 4 years, and on September 1, 2015 you made your 48th payment. The original principal amount was $280,000 and you monthly payment, without taxes and insurance, are $1,678.74 per month, computed using the Excel function =PMT(0.5%,360,280000,0,0). Starting with your original mortgage your banker calls and says that you could refinance your existing mortgage (6% rate, 30-year original term) into a...
At the time of origination, the expected yield on an adjustable rate mortgage (ARM) should be...
At the time of origination, the expected yield on an adjustable rate mortgage (ARM) should be less than that of a Fixed Rate Mortgage. Discuss.
Consider a 20-year mortgage for $282845 at an annual interest rate of 4.1%. After 6 years,...
Consider a 20-year mortgage for $282845 at an annual interest rate of 4.1%. After 6 years, the mortgage is refinanced to an annual interest rate of 2.5%. What are the monthly payments after refinancing?
Principal and interest payments for a certain mortgage rate areestimated at $12 per $1000 of...
Principal and interest payments for a certain mortgage rate are estimated at $12 per $1000 of loan amount. if the property is listed at $54,000 and the buyer makes a full-price offer, what would the down payment be if the buy only wanted to spend $450 per month for principal and interest payments. Answer is 16,500, i need help knowing what to do and what everything means please, thanks. ( dont have the interest rate and loan term, not given).
Evaluate the mortgage market today (2020). For a prime mortgage, what is the interest rate environment...
Evaluate the mortgage market today (2020). For a prime mortgage, what is the interest rate environment and outlook?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT