Building an ASC 842 amortization schedule in Excel is manageable for one lease. With five or more, the manual approach breaks down fast. Here’s exactly how the schedule works — and what it takes to maintain it at scale.
The ROU asset at commencement equals the lease liability plus initial direct costs plus prepaid rent minus lease incentives received. Most teams get the lease liability right but miss the adjustments. Here’s how to calculate it correctly.
Runway is simple to define and surprisingly easy to miscalculate. Here’s the formula, how to avoid the common errors, and how to build a scenario model that gives you a defensible number for investors and the board.
Burn rate is the single number that tells you how long your startup can survive. This guide walks through the gross and net burn formulas, shows you how to build a dynamic burn rate model in Excel with real cell references, and flags the mistakes that make most spreadsheet models dangerously optimistic.
When runway gets tight, generic advice like ‘cut costs’ doesn’t help. This guide covers 12 specific levers a finance team can pull to extend runway — with concrete numbers, worked examples, and a framework for modeling the impact of each one.
Deferred revenue is the single largest liability on most SaaS balance sheets, and tracking it accurately in Excel gets painful fast. This guide walks through building a deferred revenue waterfall schedule from scratch, with working formulas, journal entries, and a reconciliation framework that holds up under audit.
A step-by-step guide to building a fixed asset depreciation schedule in Excel. Covers three depreciation methods with formulas, worked examples, journal entries, and the register structure you need for audit-ready reporting. Includes a link to a pre-built audit-ready workbook.
Your board deck needs SaaS metrics. Your investors want them monthly. Here is how to build a SaaS metrics dashboard in Excel that finance actually controls — with formulas, worked examples, and the common mistakes that make dashboards unreliable.