Loan Modeling: Balloon Payment

[@user-hc8cr1vq9u]

how would this work if you pay interest monthly and the principle is paid in full at maturity?

[@docbrownexcels]

In this model, to make that happen you would start by setting the required payment equal to the principal balance times the monthly interest rate (annual rate divided by 12). Then you would set the balloon payment equal to the principal balance, and you should get the payment schedule you are referring to. Make sure the extra payment is still set to zero.

[@hamzam9361]

Hello can you kindly share the excel files so I can see the formulas for reference?

[@docbrownexcels]

You can download it at www.davidclaytonbrown.com/excel-resources

[@francoisesper5701]

@@docbrownexcels Could I please receive the Excel file? I've already submitted a request. Thank you.