- Helpppp Please 1 (82.62 KiB) Viewed 40 times
HELPPPP PLEASE
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
HELPPPP PLEASE
HELPPPP PLEASE
B C D E F G H K м N 0 ► Green text represent inputs Purple text represent outputs 1 House Price 2 Down Payment 3 Mortgage 4 Mortgage Closing Costs 5 Mortgage Buydown Points 6 Total Mortgage Costs 7 Annual Contract Rate 8 Term (years) 9 Payments per year 10 Total Number of Payments 11 Balloon $2,500,000.00 $50,000.00 $2,450,000.00 $5,000.00 1.75% $47,875.00 4.00% 30 12 360 $500,000.00 Home Equity in 30 years HPA 12 13 14 Mortgage cashflow IRR Monthly IRR Annualized IRR Scenario: Optimistic Base Pessimistic Very Bad Home Equity in 10 years 4.50% 2.50% 0.00% -6.00% 15 16 17 18 House Price Pessimistic Interest Mortgage Payment Cash inflow to borrower Principal Payment Cash outflow from borrower Net Cash Flow to Borrower 19 Month 20 Loan Balance (after pmt) 0 Base Optimistic Very Bad 1 21 22 23 2 3 4 5 24 25 26 27 6 7 8 28 29 9 10 11 12 30 31 32 33 34 35 13 14 15 16 36 37 17 18 38 39 19 40 20 ► Underwriting FA AMORTIZATION SCHEDULE FA CHARTS PA AMORTIZATION SCHEDULE PA ...
B C D E F G H K м N 0 ► Green text represent inputs Purple text represent outputs 1 House Price 2 Down Payment 3 Mortgage 4 Mortgage Closing Costs 5 Mortgage Buydown Points 6 Total Mortgage Costs 7 Annual Contract Rate 8 Term (years) 9 Payments per year 10 Total Number of Payments 11 Balloon $2,500,000.00 $50,000.00 $2,450,000.00 $5,000.00 1.75% $47,875.00 4.00% 30 12 360 $500,000.00 Home Equity in 30 years HPA 12 13 14 Mortgage cashflow IRR Monthly IRR Annualized IRR Scenario: Optimistic Base Pessimistic Very Bad Home Equity in 10 years 4.50% 2.50% 0.00% -6.00% 15 16 17 18 House Price Pessimistic Interest Mortgage Payment Cash inflow to borrower Principal Payment Cash outflow from borrower Net Cash Flow to Borrower 19 Month 20 Loan Balance (after pmt) 0 Base Optimistic Very Bad 1 21 22 23 2 3 4 5 24 25 26 27 6 7 8 28 29 9 10 11 12 30 31 32 33 34 35 13 14 15 16 36 37 17 18 38 39 19 40 20 ► Underwriting FA AMORTIZATION SCHEDULE FA CHARTS PA AMORTIZATION SCHEDULE PA ...