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%