Excel for Finance Intermediate Lesson 2: NPV, IRR, XIRR and Payback
Compare two projects with NPV and IRR, find the payback year, and measure a real SIP return with XIRR using actual dates.
Read article →Excel for Finance
GST, TDS, depreciation, reconciliations and MIS reports in Excel — Indian finance examples.
Excel for Finance Intermediate Lesson 1: Loan Schedules and the Effect of Prepayment
Excel for Finance Intermediate Lesson 1: Loan Schedules and the Effect of Prepayment
EMI, interest and principal split, year-1 interest for tax, outstanding balance and how many EMIs a ₹2 lakh prepayment saves, with PMT, IPMT, PPMT,…
Read article →Excel for Finance Lesson 4: Monthly MIS P&L From a GL Extract
Excel for Finance Lesson 4: Monthly MIS P&L From a GL Extract
Turn a general-ledger or trial-balance extract into a monthly P&L: map heads to groups, SUMIFS by month and type, gross profit, EBITDA, net profit,…
Read article →Excel for Finance Lesson 3: Receivables Ageing and Collections
Excel for Finance Lesson 3: Receivables Ageing and Collections
Track receivables in Excel: outstanding per invoice, days past due from the due date, ageing buckets, customer-wise outstanding, collection efficiency and a DSO estimate,…
Read article →Debtors Ageing Report in Excel: 0–30, 31–60, 61–90 and 90+ Days
Debtors Ageing Report in Excel: 0–30, 31–60, 61–90 and 90+ Days
Build a receivables ageing report in Excel: days overdue from the due date, bucket labels, SUMIFS totals by bucket and customer, a pivot version,…
Read article →Excel for Finance Lesson 8: Financial Ratios From the P&L and Balance Sheet
Excel for Finance Lesson 8: Financial Ratios From the P&L and Balance Sheet
Calculate and read the key ratios in Excel: gross and net margin, current and quick ratio, debt-equity, interest coverage, debtor and inventory days, ROE…
Read article →Excel for Finance Lesson 7: Fixed Asset Register and Depreciation
Excel for Finance Lesson 7: Fixed Asset Register and Depreciation
Keep a fixed asset register in Excel: SLM depreciation with SLN, WDV at block rates, months of use in the first year, the half-rate…
Read article →Excel for Finance Lesson 6: Budget vs Actual With Variances
Excel for Finance Lesson 6: Budget vs Actual With Variances
Build a budget vs actual report: variance and variance %, favourable/adverse logic that differs for income and costs, conditional formatting, largest variances, and a…
Read article →Excel for Finance Lesson 5: 13-Week Cash Flow Forecast
Excel for Finance Lesson 5: 13-Week Cash Flow Forecast
Build a rolling 13-week cash flow forecast in Excel: weekly collections and payments, running closing balance, minimum-cash alerts, the lowest point, and how to…
Read article →Build a Monthly MIS Report in Excel From Scratch (Complete Guide)
Build a Monthly MIS Report in Excel From Scratch (Complete Guide)
A complete, reusable monthly MIS workbook: raw data sheets, a mapping table, SUMIFS-driven P&L and KPI pages, variance vs budget and last year, conditional…
Read article →Loan Amortisation Schedule in Excel: EMI, Interest, Principal and Prepayments
Loan Amortisation Schedule in Excel: EMI, Interest, Principal and Prepayments
Build a full loan amortisation schedule in Excel: EMI with PMT, month-by-month interest and principal, yearly totals with CUMIPMT/CUMPRINC, outstanding balance, prepayment scenarios and…
Read article →Export Tally Data to Excel and Build a Sales Dashboard
Export Tally Data to Excel and Build a Sales Dashboard
Export TallyPrime reports to Excel properly, clean the export, and build a sales dashboard: party-wise and item-wise totals, monthly trend, top customers and a…
Read article →