Question: B D E F Data Current Principal Payment Purchase Price 16,000,000.00 95.00% 40,000,000.00 Coupon Rate Payment Frequency 4% Quarterly - 25th of Mar/Jun/Sept/Dec Loan Collateral

B D E F Data Current Principal Payment Purchase Price 16,000,000.00

B D E F Data Current Principal Payment Purchase Price 16,000,000.00 95.00% 40,000,000.00 Coupon Rate Payment Frequency 4% Quarterly - 25th of Mar/Jun/Sept/Dec Loan Collateral Value - . . Date 9/25/2021 12/25/2021 3/25/2022 6/25/2022 9/25/2022 12/25/2022 3/25/2023 6/25/2023 9/25/2023 12/25/2023 3/25/2024 6/25/2024 9/25/2024 12/25/2024 3/25/2025 6/25/2025 9/25/2025 12/25/2025 3/25/2026 6/25/2026 9/25/2026 12/25/2026 3/25/2027 Principal Payment Schedule WAL 564,951.65 564,951.65 570,311.16 1,140,622.31 575,670.66 1,727,011.99 581,030.17 2,324,120.69 607,827.72 3,039,138.59 631,945.51 3,791,673.04 637,305.02 4,461,135.11 642,664.52 5,141,316.19 648,024.03 5,832.216.30 653,383.54 6,533,835.42 664, 102.56 7,305,128.15 669,462.07 8,033,544.82 680, 181.09 8,842,354.11 685,540.59 9,597,568.32 690,900.10 10,363,501.55 701,619.12 11,225,905.93 843,646.10 14,341,983.76 879,152.85 15,824,751.29 914,659.59 17,378,532.30 933,417.88 18,668,357.51 935,427.69 19,643,981.52 919,349.18 20,225,681.96 369,427.20 8,496,825.53 . . - . . . . - - Questions Build the complete cash flows, calculate the following and explain in simple terms what each one represents WAL YTM Spread LTV and attachment point Duration . - B D E F Data Current Principal Payment Purchase Price 16,000,000.00 95.00% 40,000,000.00 Coupon Rate Payment Frequency 4% Quarterly - 25th of Mar/Jun/Sept/Dec Loan Collateral Value - . . Date 9/25/2021 12/25/2021 3/25/2022 6/25/2022 9/25/2022 12/25/2022 3/25/2023 6/25/2023 9/25/2023 12/25/2023 3/25/2024 6/25/2024 9/25/2024 12/25/2024 3/25/2025 6/25/2025 9/25/2025 12/25/2025 3/25/2026 6/25/2026 9/25/2026 12/25/2026 3/25/2027 Principal Payment Schedule WAL 564,951.65 564,951.65 570,311.16 1,140,622.31 575,670.66 1,727,011.99 581,030.17 2,324,120.69 607,827.72 3,039,138.59 631,945.51 3,791,673.04 637,305.02 4,461,135.11 642,664.52 5,141,316.19 648,024.03 5,832.216.30 653,383.54 6,533,835.42 664, 102.56 7,305,128.15 669,462.07 8,033,544.82 680, 181.09 8,842,354.11 685,540.59 9,597,568.32 690,900.10 10,363,501.55 701,619.12 11,225,905.93 843,646.10 14,341,983.76 879,152.85 15,824,751.29 914,659.59 17,378,532.30 933,417.88 18,668,357.51 935,427.69 19,643,981.52 919,349.18 20,225,681.96 369,427.20 8,496,825.53 . . - . . . . - - Questions Build the complete cash flows, calculate the following and explain in simple terms what each one represents WAL YTM Spread LTV and attachment point Duration

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please show the Excel Formulas & Abbreviations for Excel for the answers *** OO Time Value of Money Excel Assignment.xlsx GO E41 Y= fx L 75% Q- Search in Sheet A Home Layout Tables Charts SmartArt...

Please help me with heneral journal, general ledger, inventory valuation, bank reconciliation and financial statemnts determined for the inventory The opening balances for the month of September are...

MASTER BUDGET PROJECT i really need help completing this a Master Budget Project 2021 Insert Draw Page Layout Formulas Data Review View Tell me Share X 12 mno Tea - A A BU OY E B Merge Center $ % 3...

Master Budget Project a Master Budget Project 2021 Insert Draw Page Layout Formulas Data Review View Tell me Share X 12 mno Tea - A A BU OY E B Merge Center $ % 3 Conditional Format Formatting a Tale...

please review and help with anything I may have missed. 1. The following events occurred in October: October 1: The business owner used $25,000 from their personal savings account to buy common stock...

Excel Chapter 7-Real Estate Exp19_Excel_Cho7_Cap_Real_Estate Project Description: You are the office manager for a real estate company in northern Utah County. You tracked real estate listings,...

Anal X ID 10 CA Paste BTU ta G43 fx A B D E F G H 25 Step 1 - The Chart of Accounts 26 The chart of accounts includes all of the accounts that you can use to solve your case. You may want to print...

Please do in Excel. Thanks in advance! Now 28. 0. Finds Idees Sast Yes Excel File Edit View Insert Format Tools Data Window Hala Sa 3 Wed Feb 3 3-55 PM Autore OFF 21 - TVMI Student Templates Home...

No the objects here are very readable you just to lazy to put forward any effort. I read everything on here Need Adjusting Journal Entries 1 ABC Corporation 2 Unadjusted Trial Balance 3 December 31,...

ACC 201, Milestone 1 Documents are attached. I am having trouble figuring out what to list each transaction as. OFF Tv HE V TH 28- O HO .00 000 Excel File Edit View Insert Format Tools Data Window...

United Airlines flies to more than 200 domestic and international destinations and operates more than 3,300 lights a day. Although the airline's hubs are strategically located in Chicago, Denver, Los...

Prove that in cosh^-1 x/a = In {x+x-a/a} a and hence evaluate cosh-1.4 correct to 4 decimal places.

Used appropriately, diversification can reduce or eliminate A ) all risk. B ) systematic C ) non - systematic D ) None of the above

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...