I can perfectly help you in designing such a dynamic and automated Excel spreadsheet which can help you in determining how much principal is left to be repaid, interest accrued and various other variables. I can definitely help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
I will be happy to discuss in detail.