1 House Price 2 Down Payment 3 Mortgage 4 Mortgage Closing Costs 5 Mortgage Buydown Points 6 otal Mortgage Costs Annual Contract Rate erm (years) 8 9 ayments per year 10 Total Number of Payments 11 alloon 12 13 14 15 16 17 18 19 Month 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Ready Underwriting 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 B $2,500,000.00 $50,000.00 $2,450,000.00 $5,000.00 1.75% $47,875.00 4.00% 30 12 360 $0.00 Loan Balance (after pmt) $2,450,000.00 $2,446,469.99 Accessibility: Investigate Green text represent inputs Purple text represent outputs Mortgage Payment D FA AMORTIZATION SCHEDULE Interest $11,696.67 $ 8,166.67 FA CHARTS E Principal Payment $3,530.01 F G Cash inflow to borrower $2,450,000.00 PA AMORTIZATION SCHEDULE H Mortgage cashflow IRR Monthly IRR Annualized IRR Cash outflow from borrower PA CHARTS + -$47,875.00 -11,696.67 I Net Cash Flow to Borrower $2,402,125.00 -$11,696.67 1