ExcelBanter - Total Interest Calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Total Interest Calculation (https://www.excelbanter.com/excel-discussion-misc-queries/452716-total-interest-calculation.html)

ShamBos

Total Interest Calculation

Loan Amount 15000
Term 36
Rate 3%
Balloon Payment after 36 months 5000
Payment Interval Monthly
Interest calculation method declining balance

Need formula to calculate total interest due

All times are GMT +1. The time now is 10:38 PM.