Profit and Yield on Loan
This function calculates the Present Value and yield on a loan taking into account all fees..  Enter the Loan Amount, Balloon Amount, Annual Interest Rate, Monthly Payment, and # of months, Bank Fee and Disposition Fee.  All fields are required other than Monthly Payment.  ou can enter te monthly payment or it will be calculated for you..
Click the calculator icon to calculate the present value

Loan Amount:    
Balloon Amount:    
Annual Interest Rate:   
Cost of Funds:     
Number of Months:     
Monthly Pymt:     Interest Rate Spread:     
Bank Fee:       Value of Fees:    
Residual Insurance Fee:     Total Profit:     
Disposition Fee:    Yield On Loan:     
Calculate