Browse categories
Explore
Fiverr Pro
English
$
USD
I will create a loan amortization schedule and calculator in excel
Former Bank Manager, Excel Reconciliations, Loan Calculators and Data Cleaning
Former bank manager and accountant with 10+ years in banking, accounting and audit, plus an MBA in Finance and a computer science degree. I help small businesses and individuals with Excel work that h...
About this Gig
Need to know exactly what a loan will cost, or how much you'd save by paying extra? I'll build you a clear, reusable loan calculator in Excel.
I'm a former bank manager with 8 years in accounting and audit, and an MBA in Finance. My calculators use standard formulas you can check, not hidden macros.
What you get:
- Payment calculator: change the amount, rate or term and everything updates
- Full amortization schedule: interest, principal and balance for every payment
- Extra-payment scenarios: interest saved and new payoff date
- Charts of your balance over time
- Monthly, fortnightly, weekly, quarterly or yearly payments
- Unlocked Excel or Google Sheets file you can reuse
Works for mortgages, car loans, business loans, student loans and personal loans.
Please note: I build calculators and schedules. I don't give financial or investment advice.
Not sure which package fits? Message me your loan details before ordering.
Visualization Tools:
Microsoft Excel
Type of model:
Scenario analysis
•
Other
Target country:
Canada
•
United Kingdom
•
United States
My Portfolio
FAQ
Will the schedule match my lender's statement?
Usually to the cent if you give me the exact rate, start date and payment rules. Lenders differ in rounding; send a statement and I'll match it.
Can I change the numbers later?
Yes. Change the yellow input cells and the payment, schedule and charts update automatically.
Does it work in Google Sheets?
Yes. I can deliver it in Excel or Google Sheets.
Can it handle variable rates or interest-only periods?
Yes, in the Premium package. Message me the details first so I can confirm.
Do you give financial advice?
No. I build the calculator so you can see the numbers clearly. Decisions are yours or your adviser's.
