THE MORTGAGE NOTE INVESTOR - THE BOOK'S INPUTS FOR THE BLANK SET
Type these back into the blue cells and the book's figures come back.

1. Mesquite_Lane_and_Oriole_Court_Blank.xlsx, sheet Inputs

   C5    Original note balance                                               142000
   C6    Note rate (annual)                                                  0.09
   C7    Amortization (months)                                               360
   C8    Balloon due at payment number                                       84
   C9    Payments already made at purchase                                   26
   C10   Current value (BPO)                                                 176000
   C11   Value multiplier (scenario: 1.00 base, 0.80 for a 20% fall)         1
   C12   Seller's asking price, % of UPB                                     0.92
   C13   Required net yield                                                  0.11
   C14   Acquisition and diligence costs                                     1250
   C15   Servicer boarding fee                                               150
   C16   Servicing fee per month (performing)                                30
   C17   Partial: number of payments bought                                  36
   C20   Annual default rate (CDR)                                           0.03
   C21   Balloon extension for survivors (months)                            0
   C22   Filing after default (months)                                       5
   C23   Foreclosure sale after default (months)                             13
   C24   Possession after the sale (months)                                  3
   C25   REO marketing to sale (months)                                      4
   C26   REO haircut to value                                                0.1
   C27   Selling costs                                                       0.07
   C28   Repairs, % of value                                                 0.025
   C29   Cash for keys                                                       3000
   C30   Taxes and insurance advanced per month                              345.833333333333
   C31   Servicing per month (non-performing)                                95
   C32   REO upkeep per month                                                150
   C33   Foreclosure legal (half at filing, half at sale)                    2500
   C36   UPB                                                                 31500
   C37   Note rate                                                           0.1
   C38   Payments left (fully amortizing)                                    96
   C39   Price, % of UPB                                                     0.9

   Result: price at 11% net $126,802.91 (90.71% of UPB), 10.63% net at the ask, 10.41% on the overlay
   at a 3% default rate; Oriole 9.78% net, worth $27,118.85 at 11%. For the other rows of Chapter 5's
   table change C20 (0, 0.03, 0.06, 0.10), C11 (1 or 0.80) and C21 (0 or 60).

2. Harlow_Street_and_Calloway_Tape_Blank.xlsx, sheet Inputs

   C5    Original loan                                                       180000
   C6    Note rate                                                           0.0625
   C7    Amortization (months)                                               360
   C8    Payments made before default                                        70
   C9    Months delinquent at purchase                                       19
   C10   Value (BPO)                                                         212000
   C11   Taxes per year                                                      3600
   C12   Insurance per year                                                  1500
   C15   Acquisition and diligence                                           1450
   C16   Boarding                                                            250
   C17   Servicing per month, non-performing                                 95
   C18   Servicing per month, performing                                     30
   C19   Legal, judicial foreclosure                                         6500
   C20   Legal, non-judicial foreclosure                                     2500
   C21   Share of legal paid at filing (month 2)                             0.5
   C22   Cash for keys                                                       3000
   C23   Repairs, % of value                                                 0.025
   C24   REO upkeep per month                                                150
   C25   REO haircut to value                                                0.1
   C26   Selling costs                                                       0.07
   C27   Judicial: foreclosure sale at month                                 30
   C28   Non-judicial: foreclosure sale at month                             10
   C29   Possession after the sale (months, occupied)                        3
   C30   REO marketing to sale (months)                                      4
   C31   Required IRR                                                        0.2
   C34   Reinstatement at month                                              9
   C35   Payments before resale (reinstated or modified)                     12
   C36   Modification at month                                               6
   C37   Buyer's yield on a reperforming note                                0.09
   C38   Borrower's documented P&I budget                                    1050
   C39   Deed in lieu at month                                               10
   C40   REO months after a deed in lieu                                     4
   C41   Deed-in-lieu transaction costs                                      2000
   C42   Probability: reinstatement                                          0.1
   C43   Probability: modification                                           0.3
   C44   Probability: deed in lieu                                           0.15
   C45   Probability: foreclosure                                            0.45
   C46   Leverage: share of price borrowed                                   0.6
   C47   Leverage: interest rate (interest-only)                             0.11
   C50   Taxes, % of value per year                                          0.016
   C51   Insurance, % of value per year                                      0.0075
   C52   Seller's ask, % of UPB                                              0.52
   C53   Required IRR                                                        0.2
   C54   Repairs, % of value (occupied)                                      0.025
   C55   Repairs, % of value (vacant)                                        0.05
   C56   Senior loan rate (second liens)                                     0.045
   C57   Senior months remaining                                             300
   C58   Months of servicing before stopping                                 12
   C59   Settlement, % of total debt                                         0.3
   C60   Settlement month                                                    12

   Sheet Tape, one column per loan (rows 6 to 13; row 14 only for a loan already in foreclosure)

   Row  C-1       C-2       C-3       C-4       C-5       C-6       C-7       C-8       
   6    1         1         1         1         1         1         2         2           Lien
   7    0         1         0         1         0         1         0         1           Judicial
   8    96000     212000    58000     131000    174000    88000     42000     36000       UPB
   9    0.07      0.055     0.0825    0.06      0.0475    0.075     0.095     0.1         Rate
   10   14        26        9         40        11        18        20        31          Delinq.
   11   150000    238000    71000     128000    265000    104000    230000    190000      Value
   12   0         1         1         1         1         0         1         1           Occupied
   13   0         0         0         0         0         0         158000    181000      Senior
   14                                 12                                                  In fc

   Result: floor $69,754.43 (42.12% of UPB), non-judicial $114,834.89, blend $90,675.03; the tape's
   floors sum to $413,483, the pool earns 17.66% at the ask and 5.56% without C-1 and C-5, and the
   book's bid is $333,499 at 30.21%. Fill fewer loans and the pool rows use only the complete ones.
