use a blank sheet and model the monthly cash flows for one loan with the following parameters 

b. 300 000 loan, funded by 85% debt and 15% equity 

c. Rate on the loan is 20%, rate on the debt is 12% 

d. The term of the loan is 72 months, the debt is 60 month 

e. The probability of default is 15% 

f. The client also pays insurance to us of 1000 per month, the loss ratio is 65%
Powered by