I will build loan tracker and amortization schedule
EXCEL FINANCIAL SYSTEMS AND DASHBOARD EXPERT
About this Gig
I will build automated individual loan tracker with auto calc single row entryThis is my own loan system - you enter 4 things only and everything auto calculates.What you will get in Excel:Single Row Entry: Enter Borrowed Amount, Rate %, Months - DoneAuto PMT Calculation: Monthly Payment =PMT formula autoAuto Monthly Rate, Today, Month Now, CumulativeAuto End Date, TOTAL, InterestAuto Status: PARTIALLY PAYING, HALFWAY etcAuto Balance Remaining and Profit This MonthAuto Total Profit Earned So FarAll cells auto-update. Green cells are for input only. No manual work.Works for: Personal loans, Business loans, SACCO, Chama, Microfinance, Private lendersWhat I need from you: Borrowed amount, interest rate, months.I only do Excel loan tracker - no PowerPoint, no extra reports, just clean working Excel as in screenshot.
Visualization Tools:
Microsoft Excel
Type of model:
Discounted cash flow
•
Working capital
Target country:
Singapore
•
Switzerland
•
United States
