Excel Debt Model Enhancement
Budget: £250 – £750 GBP
I have already built a first-pass loan and debt workbook in Excel. Before I roll it out, I need a fresh set of expert eyes to (1) audit every formula and assumption, and (2) push the file much further with VBA macros.
Scope
• Validate my existing sheets for accuracy, consistency, and transparency.
• Build modular, toggle-driven macros so the user can drop in any debt type—including auto loans, student loans, credit-card balances, or future instruments—and have the model instantly generate repayment schedules, interest waterfalls, and key ratios.
• Keep the interface clean and scalable; one input dashboard should drive every scenario.
• Document your code and logic clearly so it can survive an NDA environment and peer review.
- it will go into an app so the code need to comply with future app development
Acceptance criteria
• No calculation errors on stress-testing; circular references handled or flagged.
• New debt modules integrate seamlessly with current cash-flow and amortisation outputs.
• VBA runs without security warnings and is fully commented.
• A short hand-over video or walkthrough deck is provided.
Security
An NDA is mandatory before I share the workbook.
Response guidance
Send a concise, detailed project proposal outlining your approach, toolset (Excel, VBA, Power Query, etc.), sample timelines, and any similar models you have upgraded.
Scope
• Validate my existing sheets for accuracy, consistency, and transparency.
• Build modular, toggle-driven macros so the user can drop in any debt type—including auto loans, student loans, credit-card balances, or future instruments—and have the model instantly generate repayment schedules, interest waterfalls, and key ratios.
• Keep the interface clean and scalable; one input dashboard should drive every scenario.
• Document your code and logic clearly so it can survive an NDA environment and peer review.
- it will go into an app so the code need to comply with future app development
Acceptance criteria
• No calculation errors on stress-testing; circular references handled or flagged.
• New debt modules integrate seamlessly with current cash-flow and amortisation outputs.
• VBA runs without security warnings and is fully commented.
• A short hand-over video or walkthrough deck is provided.
Security
An NDA is mandatory before I share the workbook.
Response guidance
Send a concise, detailed project proposal outlining your approach, toolset (Excel, VBA, Power Query, etc.), sample timelines, and any similar models you have upgraded.