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
Borrower 2yr Interest Only Mortgage
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
Due To Lender At Closing
Per Diem Interest Due At Closing
Total Due To Lender At Closing