Solution for google sheets calculator

I am looking for a freelancer to help solve a timing problem for a financial calculator. It essentially needs to be dynamic based on a date. The problem is described in the spreadsheet attached. I've attached an excel spreadsheet, but am working in google sheets

Skills and Experience:
- Strong knowledge of Google Sheets and its formulas
- Proficiency in financial calculations and formulas
- Experience in creating user-friendly interfaces for data input using manual input methods
- Ability to generate accurate and clear numeric outputs for the calculations.