loan amortization

Hi all, I have a pretty large portfolio loan amortization model I built. It's 45MB right now. I have a few issues I have been running into. 1- I utilized the error checking and i do not have any circular references but the model won't refresh unless I enable iterative calculations. Any...

Hi Everyone, With the way things have become over the past few years, I decided to use my time wisely and started to keep a tab on a few things, one of which is my mortgage. However, I wanted something much more in depth and struggled to find much, specially when it came to variable loan (with...

HI, I have a table of loans, each row is a loan, I would like to generate the amortization schedule of all the loans. I was thinking to generate all the amortization schedules to one single table so I can upload it to a data model and then browse through pivot tables and create dashboards...

Hi Examples of Loan Amortization schedules using Excel's PMT, IPMT functions are available, with a fixed interest and fixed tenure values. I have a loan which has a variable interest depending on the central banks' reference value. Due to the variable interest, the monthly payment is kept...

Hello! So I have found a 'loan amortization schedule' template in the Excel templates section which has just about everything I need on it. What I can't work out is how to add a one time deposit amount to the template. It has an optional extra payments section, but that adds the amount to each...