Exercise #6 Solution

pdf

School

The University of Hong Kong *

*We aren’t endorsed by this school

Course

2382

Subject

Accounting

Date

Nov 24, 2024

Type

pdf

Pages

4

Uploaded by ConstablePuppyMaster3840

Report
Mortgage Pool Year Total Payment Interest Payment Principal Payment Ending Balance 0 $18,000,000 =5M+3.5M+3M+3M+3.5M 1 $3,930,382 PV = 18M Interest rate = 3% Tenor = 5 $540,000 Interest = 3% x 18M $3,390,382 = 3.930M 0.540M $14,609,618 =18M-3.390M 2 $3,930,382 $438,289 $3,492,094 $11,117,524 3 $3,930,382 $333,526 $3,596,857 $7,520,667 4 $3,930,382 $225,620 $3,704,762 $3,815,905 5 $3,930,382 $114,477 $3,815,905 $0 1 2 3 4
Tranche Z Year Interest From Pool Accrued Interest Principal Allocation Total Payment Ending Balance 0 $3,000,000 1 $97,500 =3.25% x 3M $97,500 $0 $0 $3,097,500 = 3M + 0.098M 2 $100,669 $100,669 $0 $0 $3,198,169 3 $103,940 $103,940 $0 $0 $3,302,109 4 $107,319 $0 $2,986,204 =3.705M 0.719M $3,093,523 =0.107M + 2.986M $315,905 5 $10,267 $0 $315,905 $326,172 $0 Tranche A Year Interest Payment Principal Payment Total Payment Ending Balance 0 $5,000,000 1 $125,000 =2.5% x 5M $3,487,882 =3.390M+0.098M $3,612,882 =0.125M + 3.488M $1,512,118 =5M 3.488M 2 $37,803 $1,512,118 $1,549,921 $0 1 1 1 2 2 3 4
Tranche B Year Interest Payment Principal Payment Total Payment Ending Balance 0 $3,500,000 1 $96,250 =2.75% x 3.5M $0 $96,250 $3,500,000 2 $96,250 $2,080,645 =3.492M + 0.101M 1.512M $2,176,895 =0.096M + 2.080M $1,419,355 =3.5M 2.080M 3 $39,032 $1,419,355 $1,458,387 $0 Tranche C Year Interest Payment Principal Payment Total Payment Ending Balance 0 $3,000,000 1 $94,500 =3.15% x 3M $0 $94,500 $3,000,000 2 $94,500 $0 $94,500 $3,000,000 3 $94,500 $2,281,442 =3.597M + 0.104M 1.419M $2,375,942 =0.095M + 2.281M $718,558 =3M 2.281M 4 $22,635 $718,558 $741,193 $0 1 1 2 3 3 4
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Equity Class Year Total Payment from the Pool To Other Tranches Residual Payment 0 -$3,500,000 1 $3,930,382 $3,803,632 $126,750 2 $3,930,382 $3,821,315 $109,067 3 $3,930,382 $3,834,329 $96,053 4 $3,930,382 $3,834,715 $95,667 5 $3,930,382 $326,172 $3,604,210