Free Excel Templates

Software Cost Capitalization Model (Excel)

One unlocked four-tab Excel calculator covering ASC 350-40 after ASU 2025-06, cloud computing implementation costs, and ASC 985-20 greater-of amortization and NRV testing.

Enter your eligible engineering hours, loaded hourly rate, contractor fees, cloud hosting term, or external product revenue forecast. In the pre-loaded example, 4,000 direct hours at $95 per hour plus $100,000 of contractors capitalize $480,000 ($160,000 annual amortization), $300,000 of cloud setup amortizes at $60,000 per year over 60 months, and ASC 985-20 records $108,000 of Year 1 amortization.

Get the Excel template

One unlocked Excel workbook, zero macros, zero circular references. Free: enter your email address and the download opens at once, along with the other free accounting models.

Software_Cost_Capitalization_Model.xlsx (9 KB)

You join the reader list: one email when a new free model or book comes out. Unsubscribe in one click. Already subscribed? Enter the same address. How your address is used.

The handbook behind this model

This calculator is a clean standalone extract of the seven-tab workbook in The Software Costs Accounting Handbook, which walks a complete US GAAP company through Legacy ASC 350-40 vs. ASU 2025-06, agile sprints, stock-based compensation, capitalized interest, abandonment write-offs, cloud ERP vs. IFRIC 2021, ASC 985-20 NRV write-downs, EBITDA covenants, transition adjustments and Section 174A deferred taxes.

Paperback PDF edition, $19.99 Book page and full workbook

What is inside the workbook

1. Internal-Use Software
ASU 2025-06 authorization and probable-to-complete gates, eligible engineering hours times loaded hourly rate (excluding G&A overhead), external contractor costs, total capitalization, and monthly/annual straight-line amortization.
2. Cloud Implementation
Eligible hosting implementation outlays amortized over the non-cancelable base term plus reasonably certain renewals, combined with annual SaaS subscription fees in operating expense.
3. External Software 985-20
Product-by-product comparison of revenue-ratio amortization against straight-line amortization, plus the year-end Net Realizable Value write-down calculation.
4. Checks
Automated reconciliation block whose cell B2 must equal 0 before any number leaves the spreadsheet.

What the pre-loaded example returns

MeasureValue
Internal-use software capitalized cost (ASC 350-40)$480,000
Internal-use annual straight-line amortization (36 months)$160,000
Cloud implementation capitalized asset (ASU 2018-15)$300,000
Cloud annual implementation amortization (60 months)$60,000
External-use software Year 1 amortization (ASC 985-20 greater-of)$108,000
External-use software Year 1 ending NBV$132,000

Every number in the template is an illustrative teaching example, independent of the book's case. On the Internal-Use Software tab, 4,000 direct hours at $95 per hour produce $380,000 of eligible payroll plus $100,000 of third-party coding fees for $480,000 capitalized ($160,000 per year over 36 months). On the Cloud Implementation tab, $300,000 of setup costs amortizes over 60 months ($60,000 per year) alongside $180,000 in annual hosting fees. On the External Software 985-20 tab, $240,000 of post-feasibility cost faces Year 1 revenue of $900,000 out of $2,000,000 total anticipated revenue (45.0%), so revenue-ratio amortization ($108,000) exceeds straight-line ($80,000), leaving $132,000 at year-end.

Rules described as read in November 2026 (FASB ASC 350-40, ASU 2025-06, ASU 2018-15, and ASC 985-20). Education only, not accounting or audit advice.

Questions controllers ask

Does this Excel model reflect ASU 2025-06?

Yes. The Internal-Use Software tab includes both ASU 2025-06 gates: management funding commitment and probable-to-complete clearance (no unresolved significant development uncertainty). If either gate is set to 0, capitalized cost drops to $0.

How does the model treat cloud computing implementation costs?

The Cloud Implementation tab amortizes eligible setup, configuration, and integration costs over the non-cancelable term plus reasonably certain renewals, and pairs that amortization with the annual SaaS fee to show the combined operating expense impact.

Does it include external-use software under ASC 985-20?

Yes. The External Software 985-20 tab computes the greater of the revenue-ratio method and straight-line amortization on a product-by-product basis, and runs the mandatory year-end Net Realizable Value write-down check.

Are any cells locked or macros required?

No. Every input cell is blue, every calculated cell is an unlocked live Excel formula, there are zero circular references, and the Checks tab verifies all four reconciliations equal zero.