I will build loan tracker and amortization schedule

Parte de la información aparece en idioma inglés.

Kenia

Hablo Inglés

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...
Acerca de este Servicio

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.

Herramientas de visualización:

Microsoft excel

Tipo de modelo:

Flujo de fondos descontados

•

Capital de trabajo

Sector:

Servicios y consultoría de negocios

•

Análisis de Datos

País de destino:

Singapur

•

Suiza

•

Estados Unidos