I will build loan tracker and amortization schedule

Kenya

I speak English

EXCEL FINANCIAL SYSTEMS AND DASHBOARD EXPERT

Xero Level I Certified | Excel & AI Automation Specialist I don't just do data entry; I build systems that show you money. I turn messy Xero/QuickBooks data into visual CEO Reports and Dashboards whe...
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

Industry:

Business services & consulting

•

Data analytics

Target country:

Singapore

•

Switzerland

•

United States