I have already developed a project identical to the one you have specified. It features:
- Ordinary payments calculation (principal + interests).
- Extraordinary payments. Funds are automatically allocated to fees, interests, late interests and principal.
- Management of overdue quantities.
The solution is entirely developed in excel formulas. No need for VBA.
MS Office / MS Excel advanced expert. 30 years experience in MS Excel and VBA programming. Web scraping, office automation, management dashboards, data mining and analysis, Montecarlo simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models.