Loan Payment Schedule and Balance Tracking Tool in Excel
Basic tool to help private real estate lenders track the payment schedule, calculate principal and interest, and estimate current loan balance. Assumes fully amortizing loan with no interest only. Allows for a term of up to 360 months. (View description of model)
To make this model accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (choose ‘Free’ if you need) or maximum (your paid support helps keep the content coming).
Instructions: 1) set a price, 2) tell us where (email address) to send the model, 3) enter payment details (if applicable), and then 4) click ‘Proceed with Download’. The system will send you a download link, as well as add the file to your ‘My Downloads’ page.