I will build loan tracker and amortization schedule
EXCEL FINANCIAL SYSTEMS AND DASHBOARD EXPERT
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
País de destino:
Singapur
•
Suiza
•
Estados Unidos
