|
I did a quick one for subsale (4.5% interest, 40 yrs, Other fee 4% of sales price), enjoy!:
5 yrs holding, 100% Price Appreciation, 20% Crash Original Price $1,000,000 Highest Price $2,000,000 Crash Price $1,600,000 Interest Paid $219,672 Principal Paid $50,066 Monthly Payment $4,496 Total Payment $269,738 Other Fees $64,000 Principal Remain $949,934 Rent Collected $150,000 Total Profit/Loss $516,394 %profit with rent 52% %profit w/o rent 37% 5yrs holding, 80% Price Appreciation, 20% Crash Original Price $1,000,000 Highest Price $1,800,000 Crash Price $1,440,000 Interest Paid $219,672 Principal Paid $50,066 Monthly Payment $4,496 Total Payment $269,738 Other Fees $57,600 Principal Remain $949,934 Rent Collected $150,000 Total Profit/Loss $362,794 %profit with rent 36% %profit w/o rent 21% 5yrs holding, 60% Price Appreciation, 20% Crash Original Price $1,000,000 Highest Price $1,600,000 Crash Price $1,280,000 Interest Paid $219,672 Principal Paid $50,066 Monthly Payment $4,496 Total Payment $269,738 Other Fees $51,200 Principal Remain $949,934 Rent Collected $150,000 Total Profit/Loss $209,194 %profit with rent 21% %profit w/o rent 6% 5yrs holding, 40% Price Appreciation, 20% Crash Original Price $1,000,000 Highest Price $1,400,000 Crash Price $1,120,000 Interest Paid $219,672 Principal Paid $50,066 Monthly Payment $4,496 Total Payment $269,738 Other Fees $44,800 Principal Remain $949,934 Rent Collected $150,000 Total Profit/Loss $55,594 %profit with rent 6% %profit w/o rent -9%
|