Excel template previewWorked example of the accrual spread approach used in monthly close — straight-line and usage-driven accruals, period allocation, automatic reversal, and reviewer tie-out.
ExcelCloseAudit
Excel template previewIndirect-method cash flow built per entity, then eliminated and rolled up to consolidated cash. Designed for operators with multiple legal entities sharing intercompany activity.
ExcelModelingConsolidation
Excel template previewFive-year explicit free cash flow projection, WACC build, perpetuity terminal value, and implied exit EBITDA multiple cross-check. Equity bridge adjusts enterprise value.
ExcelValuationModeling
Excel template previewAccount-level reconciliation format with GL balance, supporting subledger / external balance, reconciling items with aging, and preparer / reviewer sign-off.
ExcelCloseAudit
Excel template previewThree-statement financial model (Excel)
Integrated income statement, balance sheet, and cash flow statement model with formula-linked statements, supporting schedules, and historical-to-forecast structure.
ExcelModeling
Excel template previewDCF valuation model (Excel)
Discounted cash flow valuation model with five-year explicit forecast, terminal value calculation, WACC tab, and sensitivity analysis on discount rate and terminal growth.
ExcelValuation
Excel template previewWACC build worksheet (Excel)
Step-by-step weighted average cost of capital build with CAPM inputs, size premium, country-specific risk premium, after-tax cost of debt, and target capital structure inputs.
ExcelValuation
Excel template previewLBO model — sources and uses (Excel)
Leveraged buyout model with sources and uses of funds, debt schedule with multiple tranches, returns analysis, and IRR sensitivity to exit multiple and hold period.
ExcelValuationM&A
Excel template previewTrial balance reconciliation template (Excel)
Structured trial balance reconciliation with variance flags, supporting documentation references, preparer and reviewer sign-off lines, and tickmark legend.
ExcelCloseAudit
Excel template previewMonth-end close checklist (Excel)
Standard month-end close checklist with task ownership, due dates, dependencies, and sign-off lines. Aligned to a typical 7-10 business day close cycle.
ExcelClose
Excel template previewBalance sheet account reconciliation template (Excel)
Standardized balance sheet account reconciliation format covering GL balance, supporting balance, reconciling items, and conclusion. Per AS 1215 and AU-C 230 documentation requirements.
ExcelCloseAudit
Excel template previewAudit PBC list tracker (Excel)
Prepared-by-client list tracker with item ownership, due dates, status, auditor notes, and follow-up tracking. Designed to support both PCAOB and AICPA audit engagements.
ExcelAudit
Excel template previewLead schedule workpaper template (Excel)
Audit-ready lead schedule template with tickmark legend, preparer/reviewer signoff lines, prior-period comparison, and supporting workpaper indexing.
ExcelAudit
Excel template previewLease schedule and ROU calculation — ASC 842 (Excel)
Lease accounting workbook implementing ASC 842 for lessees: right-of-use asset and lease liability calculation, classification test, amortization schedule, and required disclosures.
ExcelGAAPLeases
Excel template previewRevenue contract assessment — ASC 606 (Excel)
Five-step revenue recognition assessment workbook implementing ASC 606: contract identification, performance obligation analysis, transaction price determination, allocation, and recognition pattern.
ExcelGAAPRevenue
Excel template previewGoodwill impairment testing template — ASC 350 (Excel)
Goodwill impairment testing workbook with reporting unit identification, qualitative (Step 0) assessment, and quantitative (Step 1) fair value comparison per ASU 2017-04.
ExcelGAAPIntangibles
Excel template previewDeferred tax calculation — ASC 740 (Excel)
Deferred tax asset and liability calculation workbook with temporary difference tracking, tax rate application, valuation allowance assessment, and effective tax rate reconciliation.
ExcelGAAPTax
Excel template previewWorking capital schedule (Excel)
Working capital analysis with trailing twelve months calculation, seasonality adjustment, target peg analysis, and daily working capital tracking for transaction support.
ExcelModelingM&A
Excel template previewFixed asset register and depreciation schedule (Excel)
Fixed asset register with asset detail, in-service date, useful life, depreciation method, accumulated depreciation, and disposal tracking. Supports straight-line and accelerated methods.
ExcelAssets
Excel template previewCapitalization table template (Excel)
Capitalization table tracking common stock, preferred stock by series, options, warrants, and SAFE notes with fully diluted ownership calculation and waterfall analysis.
ExcelEquityCompensation
CSV template previewChart of accounts — general business (CSV)
Importable CSV chart of accounts following standard four-tier hierarchy (Type, Sub-Type, Account, Sub-Account) applicable to general commercial and industrial entities under Article 5 of Regulation S-X.
CSVAccounting