Estimate the gain before considering the tax

The gain on a property sale and the money left in your bank account are different figures. This worksheet illustrates a gain by comparing an entered net disposal value with an adjusted acquisition value. It does not calculate Spanish capital-gains tax, choose a tax rate, apply an exemption or decide which costs qualify.

Use adviser-confirmed amounts wherever the field refers to an eligible cost or adjustment. An invoice is useful evidence, but the fact that money was spent does not automatically establish its tax treatment. The appropriate calculation can depend on the owner, residence position, dates, history of use and applicable rules. The tool keeps those decisions outside its arithmetic.

The six inputs

• Sale proceeds before expenses: the disposal amount being modelled, before the separate selling-expense deduction.
• Eligible selling expenses: the amount your adviser says belongs in this adjustment.
• Original acquisition price: the acquisition amount being used for the ownership interest under consideration.
• Eligible acquisition costs: additional amounts confirmed as part of that acquisition value.
• Eligible capital improvements: qualifying additions, kept separate from routine maintenance and repairs.
• Accumulated depreciation adjustment: the amount confirmed as reducing the acquisition value in the case being assessed.

Do not enter the outstanding mortgage as an acquisition cost or selling expense simply because it will be repaid at completion. Loan repayment affects sale cash flow, but it is not treated as an eligible gain adjustment by this worksheet. Use the seller proceeds calculator for a separate cash-flow illustration.

The worksheet formula

Net disposal value is entered sale proceeds minus entered eligible selling expenses. Adjusted acquisition value is original price plus eligible acquisition costs plus eligible improvements, minus the entered depreciation adjustment. The illustrated gain is net disposal value minus adjusted acquisition value. A negative answer is displayed as an estimated loss before tax adjustments.

The calculator rejects selling expenses above the sale proceeds and a depreciation adjustment that would make the entered acquisition value negative. These are boundaries for this simplified worksheet, not a statement that every real-world transaction fits this structure. If your adviser’s calculation requires other adjustments, use their calculation rather than trying to disguise those adjustments in an unrelated input.

Worked example

Suppose a sale is modelled at €350,000, with €10,000 of eligible selling expenses. The net disposal value is €340,000. The original acquisition price is €250,000, eligible acquisition costs are €20,000, and eligible improvements are €15,000. Before depreciation, the acquisition value in this illustration is therefore €285,000.

An entered €5,000 depreciation adjustment reduces that value to €280,000. The illustrated gain is €340,000 minus €280,000: €60,000. That is not a €60,000 tax bill. The tool has not applied any rate, relief, ownership allocation or other tax adjustment. It has simply shown the difference between the two entered values.

Keep improvements and repairs separate

Create an evidence schedule before entering an improvement figure. For each item, record the date, supplier, property, description, invoice, payment evidence and the treatment proposed by your adviser. Avoid combining a structural improvement and routine decoration under one unexplained total. A clear schedule makes it easier to identify what is being claimed and why.

If the property has been rented, flag its use history rather than assuming all spending can be added to the acquisition value. The treatment of expenditure and depreciation needs to be consistent with the relevant tax calculation. The calculator does not reconstruct historic returns, establish a minimum adjustment or decide how an inherited or gifted acquisition should be valued.

Match the ownership interest

Keep every input on the same basis. If your adviser is calculating one owner’s interest, use the corresponding sale amount, acquisition amount and adjustments throughout. Do not enter the full property sale price alongside half the acquisition cost. Equally, do not divide only the final answer without first confirming whether the owners have the same acquisition history and adjustments.

A property acquired in stages, inherited in part or held with different rights may require more than one calculation. The tool does not allocate usufruct, bare ownership or jointly held interests. Explain the ownership history to the adviser, retain the supporting deeds and use a case-specific schedule where a single worksheet would conceal important differences.

Gain, withholding and completion money

A deduction from the money paid at completion is not automatically the final tax on the gain. Keep any applicable payment-on-account or withholding mechanism separate from the gain calculation. This page deliberately does not deduct withholding from the gain, treat it as an eligible acquisition expense or present it as a guaranteed refund later.

For a broader view, read the capital-gains overview and the non-resident withholding guide. Use the actual transaction advice when preparing a completion statement. A cash-flow worksheet and a tax computation should be reconcilable, but they answer different questions and should keep their different inputs visible.

What the result excludes

The worksheet does not assess residence, relief for a main home, reinvestment, age-related rules, historic acquisition provisions, currency translation, indexation or losses carried from other transactions. It does not calculate municipal plusvalía, interest, penalties or filing deadlines. It also does not decide the correct valuation when a transaction is between connected parties or is not an ordinary sale.

Those exclusions matter because the same apparent sale profit can lead to different outcomes for different owners. Do not apply a rate found in an unrelated article to the displayed gain and describe the result as a confirmed liability. Ask for the applicable basis, adjustments and filing steps to be set out together in advice for your circumstances.

Prepare the evidence pack

Gather the acquisition deed, sale documentation, relevant invoices, payment records, ownership details and a chronology of occupation and rental use. Add any earlier professional calculations or tax records that explain the acquisition basis and depreciation history. If a document is missing, record the gap; do not fill it with a guessed number simply to make the worksheet balance.

Keep a separate list of estimated amounts and confirmed amounts. The calculation can be rerun when a missing invoice or final selling charge becomes available. Ask your adviser to confirm which changes affect the gain, which affect completion cash only, and which need treatment elsewhere. That distinction will make the final reconciliation far easier to follow.

Use the calculator with a clear record

Write down the inputs, the date of the exercise and the decision you are trying to inform. Mark provisional figures as provisional. If you compare two scenarios, keep the unchanged inputs visible and explain the assumption that changed. This makes the output easier to discuss with another owner, a lender or an adviser without losing the basis of the calculation.

The form runs in your browser. The supplied calculator does not send the entered figures to a server or add them to the website’s analytics events. Results appear after selecting Calculate estimate. Browser extensions and other software are outside this implementation. A text or lightweight agent view provides the guidance and worked examples but does not run the interactive form.

Practical questions

Are these current market figures? No. The default numbers are illustrations. Replace them with your own clearly sourced amounts. The tool does not look up interest rates, property values, exchange rates or quotations.

Can I use the answer as an approved budget? Treat it as a scenario. The relevant lender, professional or contracting party must confirm matters within their responsibility. A mathematically correct result does not establish eligibility, permission or the completeness of the inputs.

What if a field does not fit my case? Keep a separate calculation for a more complex case. Do not put an unexplained adjustment into another field merely to reach a preferred total. An explicit exclusion is easier to review than a result whose inputs conceal different assumptions.