Using PMT and IPMT/PPMT is definitely the right approach for building the individual amortization schedules. If you have many loans, I'd suggest keeping each loan's schedule on a separate tab and building a master 'Dashboard' tab. You can use XLOOKUP or SUMIFS to pull the current outstanding...
