Table A below is a simplified CMO structure with two sequential-pay tranches A and B. Payments are made to Tranche A first then to Tranche B....

I have uploaded one Microsoft Word with my question inside.

Do take note there are 2 parts, (a) & (b)

You are to answer the question in EXCEL.

Kindly give the answers in detailed explanation and with the template given.

Great tips will be given if I do find the answers in excellent form.

Thank you.

Regards,John