Red are imput fields the other fields will automatically calculate.        
Caluclations are rounded up by standard Excel Round Function. Ex 106.666 = 106.67  
Mortage interest calculations use the 12 months 30 day 360 day formula.  
Calculate days per diem interest you need the monthly payment due date and the closing date.  
1 Lender Hard Money Loan Lender A      
Lender A 100.00%      
Borrower 2yr Interest Only Mortgage      
Interest Rate         
Principal Note        
Annual Interest       
Monthly Interest Payment        
Daily Interest 30 day average    
Total Days Per Diem Interest Due      
Total Per Diem Interest Due    
Borrower Principal Payoff      
Mortgage Balance Pay Off  
Early Prepayment Penalty    Early payment enter penalty amount  
Prepayment Amount      
Due To Lender At Closing          
Principal Due         
Per Diem Interest Due At Closing      
Prepayment Penalty        
Total Due To Lender At Closing