Capitalized Interest Calculator (ASC 835-20)

Calculates weighted-average accumulated expenditures from up to eight draws, applies a two-tier capitalization rate, tests avoidable interest against the actual-interest ceiling, and reports the capitalized amount under both US GAAP and IFRS — built for controllers and technical accounting staff closing a period with construction in progress on the books, replacing the single-rate worksheet that quietly overstates the asset.

✓ Applies the specific borrowing rate only up to the borrowing amount, with the weighted average of other debt on the excess✓ Runs both rate methods side by side and prices the difference✓ Caps avoidable interest at actual interest incurred and flags when the ceiling binds✓ Shows the US GAAP / IFRS split on investment income earned on undrawn proceeds✓ Reproduces the standard Kieso E10-8 and E10-10 solutions exactly✓ Free Excel download✓ No signup required

Download This Calculator

Get the Excel spreadsheet behind this calculator to use offline, customize for your own draw schedule and debt stack, and publish as a web tool using Sheetflow.

Two-Tier Capitalization Rate

Applies the specific construction-loan rate to the base only up to the borrowing amount, then the weighted average of your other debt on the excess — instead of stretching one rate across a base that exceeds the loan, the most common error in the computation.

Both Methods, Priced

Runs the two-tier method and the single blended rate side by side and reports the dollar spread between them — so you can see the value of the rate election before you commit to one and document why.

Ceiling and the GAAP/IFRS Split

Caps avoidable interest at the actual interest incurred, flags when the ceiling binds, and shows the US GAAP versus IFRS difference on investment income earned on undrawn loan proceeds — the reconciling item dual reporters have to carry.

Frequently Asked Questions

What is capitalized interest and which assets qualify?

Capitalized interest is borrowing cost that goes onto the balance sheet as part of an asset's cost instead of onto the income statement as expense. The logic is that historical cost should include everything necessary to bring an asset to the condition and location required for its intended use — and if an asset takes a year to build, the financing cost during that year is part of what it cost you.

Three conditions must all hold before the meter starts running: expenditures for the asset have been made, activities necessary to get the asset ready are in progress, and interest cost is being incurred. Drop any one and capitalization stops. An extended interruption in construction suspends it; a brief seasonal pause generally doesn't.

Qualifying assets fall into two buckets. Assets constructed for the entity's own use — a building, a plant, special-purpose equipment. And assets built as discrete projects for sale or lease, like a ship or a real estate development. Inventory routinely manufactured in large quantities doesn't qualify, and neither does an asset already in use or already ready for use.

Land is the one that catches people. Land being developed qualifies, and the interest gets capitalized to the structure being built on it rather than to the land itself. Land held for speculation doesn't qualify at all, because nothing is being done to it.

Capitalization ends when the asset is substantially complete and ready for its intended use — not when the final invoice clears, and not when you actually start using it.

How do I calculate weighted-average accumulated expenditures?

Weight each expenditure by the portion of the period it was outstanding, then add the weights up. An expenditure made at the start of the year carries a full year of financing cost; one made in December carries one month.

Using the calculator's four default draws on a calendar year: $360,000 outstanding 10 months weights to $300,000. $600,000 for 7 months weights to $350,000. $1,500,000 for 6 months weights to $750,000. $1,500,000 for 1 month weights to $125,000. Total cash out is $3,960,000, but the raw weighted average is $1,525,000 — that's the average investment actually tied up in the project.

Then two adjustments most worksheets skip.

Add prior-period capitalized interest. Interest capitalized last year is now part of the asset's cost, so it's part of the accumulated expenditure base this year. The defaults add $85,000.

Subtract progress payments received. If the asset is a discrete project being built for a customer and they've paid you along the way, that money isn't tied up — it reduces the base. The defaults subtract $150,000.

Final base: $1,460,000.

Two mechanical points. Expenditures are measured on a cash basis, not accrual — an invoice accrued but unpaid isn't an expenditure yet unless the accrual itself bears interest. And the weights always use twelfths of a year against annual rates, which is why the calculator keeps "months outstanding" separate from "months in the reporting period." Shorten the reporting period and the ceiling drops without the weights moving.

Should I use the specific borrowing rate or the weighted-average rate?

You have a choice, and most textbook summaries obscure it. The weighted-average technique is the primary method, because borrowed money is usually fungible and can't honestly be traced to one asset. Where a financing plan genuinely associates a specific new borrowing with the asset, you may apply that borrowing's rate to the portion of the expenditure base up to the borrowing amount, with the weighted average of your other debt applied to the excess. It's an option, not a mandate.

The defaults show why it matters. The base is $1,460,000. The construction loan is $1,000,000 at 6%, so the first $1,000,000 earns $60,000. The remaining $460,000 rides general debt — $600,000 at 13% and $200,000 at 10%, a weighted average of 12.25% — for another $56,350. Two-tier avoidable interest: $116,350.

Blend everything into one rate instead and you get 8.7778% across all $1,800,000 of debt, applied to the full base: $128,155. That's $11,805 more capitalized — a larger asset, a smaller current-period interest expense, and more depreciation to unwind over the asset's life.

Neither number is wrong. They're two permitted answers to the same facts, and the spread is the value of the election. What is wrong is applying the specific rate to the entire base when the base exceeds the borrowing, which is the most common error in this computation and inflates capitalized interest without any support in the standard.

Pick a method, document why, and apply it consistently.

Why is my capitalized interest less than the calculated amount?

Because avoidable interest is a computation, not an entitlement. You capitalize the lesser of avoidable interest or actual interest incurred during the period. The amount capitalized can never exceed what you actually paid.

At the defaults there's headroom: avoidable is $116,350 against $158,000 of actual interest, so the full amount capitalizes and $41,650 stays in interest expense. The calculator shows a "ceiling is binding: No" flag and $41,650 of headroom.

Change one thing and it flips. Replace the general debt with a single $500,000 loan at 9%. Actual interest drops to $105,000 while avoidable rises to $107,250, because the excess tier now rides a rate you barely carry. The ceiling binds, you capitalize $105,000 instead of $107,250, and interest expense for the period is zero.

That situation — a thinly financed entity spending heavily on construction — is exactly when the ceiling matters, and it's the check that separates a defensible schedule from a rough one. The calculator's reconciliation line confirms capitalized plus expensed equals actual, every time.

One thing that does not reduce the ceiling under US GAAP: interest earned on the unexpended portion of a construction loan. Park a drawdown in a deposit account for two months and the income you earn is reported separately. It does not offset the amount eligible for capitalization.

What is the difference between US GAAP and IFRS on capitalized interest?

The headline difference is investment income, and it's the one that produces real variances for dual reporters.

Under IAS 23, borrowing costs eligible for capitalization on funds borrowed specifically for the asset are reduced by any investment income earned on the temporary investment of those borrowings. Under ASC 835-20, they are not — the income is reported on its own and the full avoidable interest capitalizes.

The calculator's defaults carry $18,000 of income on undrawn proceeds. US GAAP capitalizes $116,350. IFRS capitalizes $98,350. Same construction, same debt, same period, an $18,000 difference in the carrying amount of the asset — which then flows through depreciation for the asset's whole life.

The standard textbook illustration is starker. An entity with $800,000 of weighted-average expenditures against a 10% specific borrowing computes $80,000 of avoidable interest and earns $250,000 on the unexpended loan proceeds. US GAAP capitalizes the full $80,000. IFRS nets the income and capitalizes nothing.

Two smaller differences worth knowing. IFRS defines eligible borrowing costs more broadly, taking in finance charges on lease liabilities and certain foreign exchange differences treated as interest adjustments. And IFRS applies its capitalization rate to the expenditure base net of progress payments or grants received — the calculator handles that adjustment for both frameworks, since US practice reaches the same place on discrete projects. The calculator reports both figures and the difference so a dual reporter can see the reconciling item directly rather than rebuilding the schedule twice.

Transform Your Excel Models into Web Tools

Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.

Calculations are for estimation and planning purposes and do not constitute accounting advice. Capitalization of interest under ASC 835-20 and IAS 23 depends on facts and judgments specific to each asset and reporting framework. Users should verify important results for their specific situations. No signup required. Calculations performed securely.