loan payments

I am working on a simple interest loan tracker spreadsheet. The goal is to split a payment into principal and interest, apply the principal against the balance, and track if any payments have been missed. If a payment has been missed (change status to a 3 is the trigger to show a missed...

Hi, I know Excel has a payment formula that can be used to calculate loan payments. However this formula uses the 360 method, which my bank doesn't use. I want to get as close as possible to what they will calculate as my payment amount for a fully amortizing installment loan. How could I go...

I'm looking to set up a spreadsheet to keep track of payments on a small personal loan. I got a template, but it's not exactly what I wanted. I want to set it up with formulas to auto figure out balances. Below is a snippet of the spreadsheet I have so far. It's a loan for a car to a friend. no...

Can someone help me with this one? Thanks!

Hi Team, I was going through your videos and had a small query, that needed some answers. Hope you could help. Query : 1) if employees are paying loan amount with different yearly interest rates with every new request, whereas the fixed amount is 35,000, and the amount to be paid to the...

I am trying to calculate the payments on a loan, where the interest is calculated daily and the first payment period is not equal with the remaining periods. For example on a short term loan of 4 weeks, with weekly payments but the period form the start of the loan until the first payment is...