I will build loan tracker and amortization schedule
EXCEL FINANCIAL SYSTEMS AND DASHBOARD EXPERT
Sobre este Serviço
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.
Ferramentas de visualização:
Microsoft Excel
Tipo de modelo:
Fluxo de caixa descontado
•
Capital de trabalho
País de Destino:
Cingapura
•
Suíça
•
Estados Unidos
