For a Philippine real-property transfer cost calculator, the biggest thing is this: some items really are percentage-based, but some are only rough market shortcuts. If you want your Excel file to be as accurate as possible, you should not hard-code all five as flat percentages.

Use this logic instead:

1) Capital Gains Tax (CGT) — 6%
This is the cleanest one to automate when the property is a capital asset. The official BIR basis is 6% of the highest of:

1. Gross Selling Price / consideration,
2. BIR zonal value, or
3. Assessor’s fair market value.

So your Excel formula should be based on:

That is more precise than computing 6% on selling price alone. Also, BIR Form 1706 is the form used for onerous transfer of real property classified as a capital asset, and filing/payment is generally within 30 days after the sale/disposition.

Important caveat: CGT applies to capital assets, not ordinary assets. If the seller is habitually engaged in real estate, or the property is inventory / used in business, the tax treatment can shift away from CGT.

---

2) Documentary Stamp Tax (DST) — 1.5%
For transfers of real property, DST is effectively ₱15 per ₱1,000, which is 1.5%. The tax base is likewise the highest of:

1. BIR zonal value,
2. Assessor’s fair market value, or
3. Selling price / consideration.

So your Excel formula can be:

For special cases, the BIR says that when the sale is through mortgage foreclosure or when one contracting party is the government, DST is based on the actual consideration instead.

DST is filed through BIR Form 2000-OT, and the BIR says the return is filed within 5 days after the close of the month when the taxable document was made, signed, issued, accepted, or transferred.

---

3) Transfer Tax / Transfer Fee — do not assume one universal rate
This one is LGU-based, not national. Under the Local Government Code, the rate may be up to 0.5% of 1% for provinces/cities under the Section 135 rule, based on the total consideration or fair market value, whichever is higher.

For Cagayan de Oro, I found an official City Finance Citizens’ Charter snippet stating that for Residential/Agricultural transfers, the transfer tax is 50% of 1%, or effectively 0.5%, based on the total consideration involved or the fair market value, whichever is higher. It also says the tax should be paid within 60 days from execution of the transfer document.

So for the CDO residential/agricultural version of your calculator, this formula is defensible:

Notice I used LGU_FMV, not zonal value. Transfer tax is a local tax, so your base should follow the local rule you are using. The city charter snippet references fair market value, not BIR zonal value.

Best practice for Excel:
Create a lookup table per LGU / property class:

• Residential/Agricultural → 0.50%
• Commercial/Industrial → confirm locally before hard-coding
• Other classes → confirm locally before hard-coding

I did find a non-official copy online suggesting that CDO may use a different rate for commercial/industrial property, but because it was not from an official city source, I would not hard-code it into your production calculator without checking with the City Treasurer or the current CDO Revenue Code.

---

4) Title Registration Fee — your “0.25%” should be treated only as an estimate
This is the one most calculators oversimplify. The official LRA / Registry of Deeds charges are not just a flat 0.25%. The LRA Citizens’ Charter shows a mix of:

• registration fee assessment
• entry fee
• IT service fee per deed/document
• IT service fee per title
• new annotation fee
• per subsequent certificate fee
• annotation carried-over fee
• BIR CAR annotation fee
• legal research fund / extra page fees in some cases.

The same LRA materials also show that fee assessment may depend on consideration value or assessed value, and the LRA even issued a 2025 circular on the application of assessed value in determining registration fees in certain transactions.

So for a serious calculator, I recommend you do not label this simply as “Title Registration Fee = 0.25%.” A better setup is:

• Mode 1: Quick Estimate =0.0025*MAX(SellingPrice,AssessedValue) but clearly mark this as estimate only.
• Mode 2: Detailed LRA Estimate
  Separate fields for:
  • Registration fee
  • Entry fee
  • IT service fee per deed
  • IT service fee per title
  • Annotation fees
  • Extra page fees
  • Legal research fund

That will let you replace the estimate later with the actual Claim Assessment Slip (CAS) from the Registry of Deeds.

---

5) Notarial Fee — do not hard-code as a fixed legal percentage
This is another one that is often shown online as 1% to 2%, but that is usually market practice, not a single nationwide tax rate. The Supreme Court’s notarial rules govern notarial practice, but the official sources I found do not support treating notarial cost for a deed of sale as one mandatory national percentage like CGT or DST. Recent commentary and practice references show that notarial pricing is often fixed amount or percentage-based by local market practice, and can vary by area and complexity.

So for Excel, the best design is:

• Option A: User-entered fixed notarial fee
• Option B: Percentage mode
• Option C: Auto rule: whichever is higher

Example:

Or, if you want flexible settings:

That is much safer than pretending the notarial fee is always 1% or always 2%.

---

Real Estate Calculator Transfer Taxes

Use these base inputs:

• Selling Price
• BIR Zonal Value
• Assessor FMV / Tax Declaration FMV
• LGU FMV or Assessed Value, depending on local transfer-tax rule
• Property Class: Residential / Agricultural / Commercial / Industrial / etc.
• Asset Type of Seller: Capital Asset / Ordinary Asset
• Notarial Mode: Fixed / Percent / Higher-of-both
• Registry Mode: Estimated / Detailed Actual

Use these calculation bases:

A. BIR Tax Base

Use this for:

• CGT if capital asset
• DST on transfer of real property, unless special exception applies.

B. LGU Transfer Tax Base

Use this for:

• CDO transfer tax, based on the official charter wording I found for residential/agricultural property.

C. Registration Base
For quick estimate only:

But keep this as estimated unless replaced by actual Registry assessment.

---

Suggested Excel output formulas

If seller is capital asset:

If seller is ordinary asset, do not use CGT. Real property classified as ordinary asset may instead trigger DST, creditable withholding tax, and often 12% VAT, depending on the seller and the property. BIR RMC 99-2023 and RMC 31-2025 both emphasize that ordinary-asset sales follow a different tax path, and VAT can apply based on the gross selling price or fair market value, whichever is higher, subject to exemptions.

That means your calculator should ideally have a switch like:

Because the correct taxes can change materially.

---

2 Modes:

Quick Estimate Mode

• CGT = 6%
• DST = 1.5%
• Transfer Tax = LGU class-based %
• Registration Fee = estimated
• Notarial Fee = estimated

Compliance Mode

• asks for:
  • capital vs ordinary asset
  • residential vs commercial etc.
  • LGU / city
  • actual assessor FMV
  • actual zonal value
  • actual Registry assessment / CAS
  • actual notarial quote

That will make your calculator much more defensible and reduce wrong estimates.

Bottom line on each line item

• Capital Gains Tax – 6%: valid, but only for capital assets, and compute on the highest proper base, not just selling price.
• Documentary Stamps Fee – 1.5%: valid, and also based on the highest proper base.
• Transfer Fee – 0.5%: valid for CDO residential/agricultural based on the city charter snippet I found, but should be class/LGU-sensitive.
• Title Registration Fee – 0.25%: acceptable only as a quick estimate, not as a precise legal fee. Official LRA charges are more granular.
• Notarial Fee – 1% to 2% or fixed: should be a configurable market fee, not a hard-coded statutory percentage.

1) Recommended input fields

Use one input sheet with these cells:

2) Core tax bases

Use these formula cells:

This structure matches the BIR basis for CGT and DST, and the CDO citizens’ charter wording for transfer tax.

3) Tax formulas to use

A. Capital Gains Tax

For capital assets, BIR Form 1706 applies the 6% capital gains tax to the higher tax base.

Example cell:

B. Documentary Stamp Tax

BIR’s DST guidance for transfers of real property uses the higher of zonal value, assessor FMV, or selling price, and the effective rate is 1.5%.

C. Transfer Tax

For Cagayan de Oro, the citizens’ charter states transfer tax is paid within 60 days and is based on the higher of total consideration or fair market value; your working rate for residential/agricultural can be 0.5% where applicable.

Set B8 from a lookup table instead of hard-coding.

Suggested lookup table:

Then in B8:

D. Registration Fee

The LRA schedule shows this is not just “0.25%”; it includes Entry Fee, IT Service Fee per Deed/Document, a registration fee component, and sometimes additional annotation-related amounts. For a public calculator, use a dual-mode approach: Estimate or Actual.

Use this if B12="Estimate":

Recommended defaults for manual detailed mode from the LRA citizens’ charter:

• Entry Fee: ₱30
• IT Service Fee per Deed/Document: ₱344.93
• Additional fees may apply depending on deed/title/annotations.

You can preload:

E. Notarial Fee

Notarial fees are not a single mandatory nationwide tax percentage like CGT or DST. In practice, they may be fixed, percentage-based, or whichever is higher. Use a flexible rule.

4) Optional logic for ordinary assets

If the seller is disposing of an ordinary asset, the transaction may not use CGT and can instead involve creditable withholding tax and possibly VAT, depending on the taxpayer and the property. BIR RMC 99-2023 clarifies the valuation rules and ordinary-asset treatment context.

VAT

Transfer rate warning

Add a note beside B8:

“Use official local rate for the property class and LGU. CDO 0.5% may apply for residential/agricultural, subject to current local rules.”

7) Most accurate practical formulas

If you want a clean “public calculator” setup, these are the safest defaults:

That structure is consistent with the official BIR and LRA rules, while still keeping your sheet usable.

8) Important precision notes for your users

Add these warning notes in the workbook:

1. CGT applies to capital assets only. Ordinary assets follow different tax rules.
2. DST uses the highest of selling price, zonal value, or assessor FMV.
3. Transfer tax is local-government based. Verify rates per LGU and property class.
4. Registration fee is estimated unless based on actual Registry assessment / official claim slip.
5. Notarial fee is configurable and may vary by practice and complexity.

9) Recommended workbook tabs

Use 4 tabs:

• Inputs
• Rates & Lookups
• Calculator
• Notes / Legal Basis

Suggested lookup tables in Rates & Lookups:

• Property class → transfer tax rate
• Notarial presets → 1%, 1.5%, 2%
• Registry default fees → entry fee, IT fee, annotation fee
• Asset type tax behavior

10) Strongest version for your calculator branding

For users, label the output like this:

• Capital Gains Tax (6%)
• Documentary Stamp Tax (1.5%)
• Transfer Tax / Local Transfer Fee
• Title Registration Fee (Estimated or Actual)
• Notarial Fee
• Estimated Total Transfer Cost

And include:

“This calculator is an estimate and should be verified against current BIR, LRA, and LGU rules before final payment.”

I can next turn this into a cell-by-cell Excel layout, like B2:B20 inputs and D2:D14 formulas, ready for direct pasting into your workbook.

yesThought for 26s

Perfect. Here is a cell-by-cell Excel layout you can copy into your workbook.

Use this as your main calculator structure. For CGT, use 6% of the highest of selling price, zonal value, or assessor FMV. For DST, use 1.5% of that same highest base. For CDO transfer tax, use your LGU rule and rate table; the city’s citizens’ charter indicates transfer tax is computed on the higher of the consideration or fair market value, with residential/agricultural transactions commonly shown at 0.5%. For Registry fees, treat 0.25% only as estimate mode, because LRA’s official schedules also include fixed fees like ₱30 entry fee, ₱344.93 IT service fee per deed/document, and other annotation/title charges