Browse categories
Explore
Fiverr Pro
English
$
USD
I will build an excel debt loan repayment and interest dashboard
I am an expert at Accounting, Finance, and Business Management sectors with almost 10 years experiences. Financial Statements, Financial Projections, and Financial Modeling are my expertise.
About this Gig
Are you managing loans in separate spreadsheets and struggling to track repayments, interest, outstanding balances, and upcoming due dates?
I will build a structured Excel debt and loan dashboard tailored to your financing facilities.
Your model can include:
Loan drawdowns and repayment schedules
Fixed or floating interest calculations
SOFR or other reference-rate inputs
Accrued interest and outstanding principal
Upcoming payment and maturity alerts
Facility-level summaries and management dashboard
Interest-rate sensitivity and scenario analysis
Covenant monitoring for Premium orders
Every workbook is designed with clearly separated inputs, calculations, and outputs, making it transparent, editable, and practical for recurring finance reporting.
This service is suitable for SMEs, finance teams, holding companies, project companies, and asset-heavy businesses.
For this Gig, one account means one loan facility or debt tranche.
Please contact me before ordering if you have complex repayment waterfalls, more than 10 facilities, multiple currencies, or extensive historical reconciliation.
The model supports internal financial monitoring and does not constitute legal, tax, or audit
Visualization Tools:
Microsoft Excel
Type of model:
Sensitivity analysis
•
Scenario analysis
•
Other
Industry:
Energy
•
Financial services
•
Transportation & automotive
Target country:
Worldwide
FAQ
Question: What information do you need to begin?
Answer: Please provide the confirmed principal amount, drawdown date, outstanding balance, repayment schedule, maturity date, interest rate or margin, reference-rate mechanics, payment frequency, fees, and reporting currency. You may anonymise confidential information.
Question: What does one account mean in your packages?
Answer: One account means one loan facility or debt tranche. For example, a company with three separate loan agreements would normally require three accounts.
Question: Can you calculate SOFR or other floating interest rates?
Answer: Yes. I can model SOFR or another reference rate using the reset dates, margin, day-count convention, interest period, and other commercial terms confirmed by you.
Question: Can you modify my existing Excel loan workbook?
Answer: Yes, subject to reviewing its structure, formulas, and data quality. Please contact me before ordering and provide a sample or screenshots with confidential information removed.
Question: Will you interpret my loan agreement?
Answer: I can translate client-confirmed commercial terms into an Excel model, but I do not provide legal interpretation. Any ambiguous terms must be confirmed by you, your lender, or your professional adviser.
Question: Can you include covenant monitoring?
Answer: Yes. Covenant monitoring is available in the Premium package when you provide the confirmed covenant definitions, testing dates, thresholds, and required financial data.
Question: Will my financial information remain confidential?
Answer: Yes. I will use your information only for the agreed Fiverr order and minimise unnecessary data collection. You may replace company, lender, and account names with anonymised labels.
Question: What is included in a revision?
Answer: Revisions cover formula corrections and reasonable presentation adjustments within the original scope. Additional facilities, currencies, assumptions, scenarios, source files, or outputs are treated as additional scope.
