- C D F G H L M N O P Q R S T U V B 2 500 000 00 50 000 00 1 2 3 Green Text Represent Inputs Purple Text Represent Outpu 1 (68.95 KiB) Viewed 45 times
C D F G H L M N O P Q R S T U V B $2,500,000.00 $50,000.00 1 2 3 Green text represent inputs Purple text represent outputs $5,000.00 1.75% 6 7 4.00% 9 30 12 360 $0.00 10 11 HPA Mortgage cashflow IRR Monthly IRR Annualized IRR Scenario Optimistic Base Pessimistic Very Bad Home Equity Home Equity in 10 years in 30 years 4.50% 2.50% 0.00% -6.00% 12 13 14 15 16 17 18 19 Loan Balance (after pmt Mortgage Paymen Interest 20 $0.00 21 $0.00 $0.00 $ 22 23 24 25 Principal Payment Cash inflow to borrower Cash outflow from borrower Net Cash Flow to Borrower $0.00 $0.00 0.00 $0.00 House Price Optimistic Base Pessimistic Very Bad $2,500,000.00 $2,500,000.00 $2,500,000.00 $2,500,000.00 $2,509,375.00 $2,505,208.33 $2,500,000.00 $2,487,500.00 Home Equity Optimistic Base Pessimistic Very Bad $2,500,000.00 $2,500,000.00 $2,500,000.00 $2,500,000.00 $2,509,375.00 $2,505,208.33 $2,500,000.00 $2,487,500.00 $0.00 $0.00 27 28 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49