Debt Management Calculation Setup -- 2
Budget: $250 – $750 USD
I’m preparing a simple financial model focused exclusively on debt management and need reliable calculations built around one key input: the total outstanding debt.
Your job is to create a clear, well-structured calculator—preferably in Excel or Google Sheets—that takes that single figure and outputs the metrics I need to monitor and plan repayments with confidence. While future iterations may expand to interest rates or term lengths, for this stage I only want the model to work from the principal amount.
Deliverables
• An unlocked spreadsheet with all formulas visible and documented inline
• A brief note (max one page) explaining how each figure is derived and where to place the “Jumlah utang” input
Acceptance criteria
• All formulas must recalculate correctly when the total debt value changes
• No external add-ins or macros—standard functions only, so the file opens anywhere
If you’ve built lean debt trackers before and can hand back a clean, audit-ready sheet, I’d love to work with you.
Your job is to create a clear, well-structured calculator—preferably in Excel or Google Sheets—that takes that single figure and outputs the metrics I need to monitor and plan repayments with confidence. While future iterations may expand to interest rates or term lengths, for this stage I only want the model to work from the principal amount.
Deliverables
• An unlocked spreadsheet with all formulas visible and documented inline
• A brief note (max one page) explaining how each figure is derived and where to place the “Jumlah utang” input
Acceptance criteria
• All formulas must recalculate correctly when the total debt value changes
• No external add-ins or macros—standard functions only, so the file opens anywhere
If you’ve built lean debt trackers before and can hand back a clean, audit-ready sheet, I’d love to work with you.