Follow

# Project Admin Center - Tax Options

The Inventory Center provides several tax options that can be applied to units. To make a tax option available for selection on a unit, check the box beside the desired tax in the Project Admin Center. The calculations for each tax option are as follows:

_____________________________________________________________________________

5% (Formula) – Includes a rebate depending on the purchase price and applies if the purchaser paid 5% GST.

• Price = Total Sales Revenue
• Tax Rate = 5%
• Tax = Price * 0.05
• Rebate Percent = 36%
• Maximum Rebate = \$6,300
• If Price is >= \$450,000, Rebate = 0
• If Price is <= \$350,000, Rebate = Tax * 0.36
• If Price is > \$350,000 but < \$450,000, Rebate = ((\$450,000 – Price) / \$100,000) * (Tax * 0.36 to maximum of \$6,300)

Examples:

a) Price = \$300,000, Tax = \$15,000, Rebate = \$5,400, Tax – Rebate = \$9,600

Tax:

• \$300,000 * 0.05 = \$15,000

Rebate:

• \$15,000 * 0.36 = \$5,400

b) Price = \$400,000, Tax = \$20,000, Rebate = \$3,150, Tax – Rebate = \$16,850

Tax:

• \$400,000 * 0.05 = \$20,000

Rebate:

• \$20,000 * 0.36 = \$7,200 (max is \$6,300)
• \$450,000 – \$400,000 = \$50,000
• \$50,000 / \$100,000 = 0.5
• \$6,300 * 0.5 = \$3,150

c) Price = \$500,000, Tax = \$25,000, Rebate = \$0

Tax:

• \$500,000 * 0.05 = \$25,000

Rebate:

• Price is >= \$450,000, therefore Rebate is \$0

_____________________________________________________________________

6% (Formula) – Includes a rebate depending on the purchase price and applies if the purchaser paid 6% GST.

• Price = Total Sales Revenue
• Tax Rate (GST) = 6%
• Tax = Price * 0.06
• Rebate Percent = 36%
• Maximum Rebate = \$7,560
• If Price is >= \$450,000, Rebate = 0
• If Price is <= \$350,000, Rebate = Tax * 0.36
• If Price is > \$350,000 but < \$450,000, Rebate = ((\$450,000 – Price) / \$100,000) * (Tax * 0.36 to maximum of \$7,560)

Examples:

a) Price = \$300,000, Tax = \$18,000, Rebate = \$6,480, Tax – Rebate = \$11,520

Tax:

• \$300,000 * 0.06 = \$18,000

Rebate:

• \$18,000 * 0.36 = \$6,480

b) Price = \$400,000, Tax = \$24,000, Rebate = \$3,780, Tax – Rebate = \$20,220

Tax:

• \$400,000 * 0.06 = \$24,000

Rebate:

• \$24,000 * 0.36 = \$8,640 (max is \$7,560)
• \$450,000 – \$400,000 = \$50,000
• \$50,000 / \$100,000 = 0.5
• \$7,560 * 0.5 = \$3,780

c) Price = \$500,000, Tax = \$30,000, Rebate = \$0

Tax:

• \$500,000 * 0.06 = \$30,000

Rebate:

• Price is >= \$450,000, therefore Rebate is \$0

_____________________________________________________________________

7% (Formula) – Includes a rebate depending on the purchase price and applies if the purchaser paid 7% GST.

• Price = Total Sales Revenue
• Tax Rate = 7%
• Tax = Price * 0.07
• Rebate Percent = 36%
• Maximum Rebate = \$8,750
• If Price is >= \$450,000, Rebate = 0
• If Price is <= \$350,000, Rebate = Tax * 0.36 to maximum of \$8,750
• If Price is > \$350,000 but < \$450,000, Rebate = ((\$450,000 – Price) / \$100,000) * (Tax * 0.36 to maximum of \$8,750)

Examples:

a) Price = \$300,000, Tax = \$21,000, Rebate = \$7,560, Tax – Rebate = \$13,440

Tax:

• \$300,000 * 0.07 = \$21,000

Rebate:

• \$21,000 * 0.36=\$7,560

b) Price = \$400,000, Tax = \$28,000, Rebate = \$4,375, Tax – Rebate = \$23,625

Tax:

• \$400,000 * 0.07 = \$28,000

Rebate:

• \$28,000 * 0.36 = \$10,080 (max is \$8,750)
• \$450,000 – \$400,000 = \$50,000
• \$50,000 / \$100,000 = 0.5
• \$8,750 * 0.5 = \$4,375

c) Price = \$500,000, Tax = \$35,000, Rebate = \$0

Tax:

• \$500,000 * 0.07 = \$35,000

Rebate:

• Price is >= \$450,000, therefore Rebate is \$0

____________________________________________________________________

12% BC HST (2010) – Includes a rebate depending on the purchase price and applies if 12% HST became payable on the purchase before April 1, 2012.

• Price = Total Sales Revenue
• Tax Rate = 12% (Federal = 5%; Provincial = 7%)
• Federal Tax = Price * 0.05
• Provincial Tax = Price * 0.07
• Federal Rebate Percent = 36%
• Provincial Rebate Percent = 71.43%
• Federal Maximum Rebate = \$6,300
• Provincial Maximum Rebate = \$26,250
• Provincial Rebate = Provincial Tax * 0.7143 to maximum of \$26,250
• See 5% (Formula) for Federal Rebate calculations.

Examples:

a) Price = \$300,000, Tax = \$36,000, Rebate = \$20,400.30, Tax – Rebate = \$15,599.70

Tax:

• \$300,000 * 0.05 = \$15,000 (Federal)
• \$300,000 * 0.07 = \$21,000 (Provincial)
• \$15,000 (Federal) + \$21,000 (Provincial) = \$36,000

Rebate:

• \$15,000 * 0.36 = \$5,400 (Federal)
• \$21,000 * 0.7143 = \$15,000.30 (Provincial)
• \$5,400 (Federal) + \$15,000.30 (Provincial) = \$20,400.30

b) Price = \$400,000, Tax = \$48,000, Rebate = \$23,150.40, Tax – Rebate = \$24,849.60

Tax:

• \$400,000 * 0.05 = \$20,000 (Federal)
• \$400,000 * 0.07 = \$28,000 (Provincial)
• \$20,000 (Federal) + \$28,000 (Provincial) = \$48,000

Rebate:

• \$20,000 * 0.36 = \$7,200 (Federal max is \$6,300)
• \$450,000 – \$400,000 = \$50,000
• \$50,000 / \$100,000 = 0.5
• \$6,300 * 0.5 = \$3,150 (Federal)
• \$28,000 * 0.7143 = \$20,000.40 (Provincial)
• \$3,150 (Federal) + \$20,000.40 (Provincial) = \$23,150.40

c) Price = \$600,000, Tax = \$72,000, Rebate = \$26,250, Tax – Rebate = \$45,750

Tax:

• \$600,000 * 0.05 = \$30,000 (Federal)
• \$600,000 * 0.07 = \$42,000 (Provincial)
• \$30,000 (Federal) + \$42,000 (Provincial) = \$72,000

Rebate:

• Price is >= \$450,000, therefore Federal Rebate is \$0
• \$42,000 * 0.7143 = \$30,000.60 (max is \$26,250), therefore Provincial Rebate is \$26,250

_____________________________________________________________________

12% BC HST (2012) – Includes a rebate depending on the purchase price and applies if the HST became payable on the purchase after March 31, 2012, and before April 1, 2013.

• Price = Total Sales Revenue
• Tax Rate = 12% (Federal = 5%; Provincial = 7%)
• Federal Tax = Price * 0.05
• Provincial Tax = Price * 0.07
• Federal Rebate Percent = 36%
• Provincial Rebate Percent = 71.43%
• Federal Maximum Rebate = \$6,300
• Provincial Maximum Rebate = \$42,500
• Provincial Rebate = Provincial Tax * 0.7143 to maximum of \$42,500
• See 5% (Formula) for Federal Rebate calculations.

Examples:

a) Price = \$300,000, Tax = \$36,000, Rebate = \$20,400.30 , Tax – Rebate + \$15,599.70

Tax:

• \$300,000 * 0.05 = \$15,000 (Federal)
• \$300,000 * 0.07 = \$21,000 (Provincial)
• \$15,000 (Federal) + \$21,000 (Provincial) = \$36,000

Rebate:

• \$15,000 * 0.36 = \$5,400 (Federal)
• \$21,000 * 0.7143 = \$15,000.30 (Provincial)
• \$5,400 (Federal) + \$15,000.30 (Provincial) = \$20,400.30

b) Price = \$400,000, Tax = \$48,000, Rebate = \$23,150.40, Tax – Rebate = \$24,849.60

Tax:

• \$400,000 * 0.05 = \$20,000 (Federal)
• \$400,000 * 0.07 = \$28,000 (Provincial)
• \$20,000 (Federal) + \$28,000 (Provincial) = \$48,000

Rebate:

• \$20,000 * 0.36 = \$7,200 (Federal max is \$6,300)
• \$450,000 – \$400,000 = \$50,000
• \$50,000 / \$100,000 = 0.5
• \$6,300 * 0.5 = \$3,150 (Federal)
• \$28,000 * 0.7143 = \$20,000.40 (Provincial)
• \$3,150 (Federal) + \$20,000.40 (Provincial) = \$23,150.40

c) Price = \$900,000, Tax = \$108,000, Rebate = \$42,500.00, Tax – Rebate = \$65,500

Tax:

• \$900,000 * 0.05 = \$45,000 (Federal)
• \$900,000 * 0.07 = \$63,000 (Provincial)
• \$63,000 (Provincial) + \$45,000 (Federal) = \$108,000

Rebate:

• \$63,000 * 0.7143 = \$45,000.90 (max is \$42,500), therefore Provincial Rebate is \$42,500
• Price is >= \$450,000, therefore Federal Rebate is \$0

_____________________________________________________________________

12% BC HST Transitional Rules (2013) – Where construction began before April 1, 2013, but ownership and possession occurred after, purchasers pay transitional tax of 2% of full house price instead of the 7% Provincial of the HST. No Provincial tax rebate applies. Transitional rules are in place until March 31, 2015.

• Price = Total Sales Revenue
• Tax Rate = 7% (Federal = 5%; Provincial = 2%)
• Federal Tax = Price * 0.05
• Provincial Tax = Price * 0.02
• Federal Rebate Percent = 36%
• Provincial Rebate Percent = 0%
• Federal Maximum Rebate = \$6,300
• See 5% (Formula) for Federal Rebate calculations.

Examples:

a) Price = \$300,000, Tax = \$21,000, Rebate = \$5,400, Tax – Rebate = \$15,600

Tax:

• \$300,000 * 0.05 = \$15,000 (Federal)
• \$300,000 * 0.02 = \$6,000 (Provincial)
• \$15,000 (Federal) + \$6,000 (Provincial) = \$21,000

Rebate:

• \$15,000 * 0.36 = \$5,400 (Federal)
• Provincial Rebate is \$0

b) Price = \$400,000, Tax = \$28,000, Rebate = \$3,150, Tax – Rebate = \$24,850

Tax:

• \$400,000 * 0.05 = \$20,000 (Federal)
• \$400,000 * 0.02 = \$8,000 (Provincial)
• \$20,000 (Federal) + \$8,000 (Provincial) = \$28,000

Rebate:

• \$20,000 * 0.36 = \$7,200 (Federal max is \$6,300)
• \$450,000 – \$400,000 = \$50,000
• \$50,000 / \$100,000 = 0.5
• \$6,300 * 0.5 = \$3,150 (Federal)
• Provincial Rebate is \$0

c) Price = \$500,000, Tax = \$35,000, Rebate = \$0

Tax:

• \$500,000 * 0.05 = \$25,000 (Federal)
• \$500,000 * 0.02 = \$10,000 (Provincial)
• \$25,000 (Federal) + \$10,000 (Provincial) = \$35,000

Rebate:

• Price is >= \$450,000, therefore Federal Rebate is \$0
• Provincial Rebate is \$0

_____________________________________________________________________

13% ON HST (2010) – Includes a rebate depending on the purchase price and applies if the HST became payable on the purchase after June 30, 2010.

• Price = Total Sales Revenue
• Tax Rate = 13% (Provincial = 8%; Federal = 5%)
• Provincial Tax = Price*.08
• Federal Tax = Price*.05
• Provincial Rebate Percent = 75%
• Federal Rebate Percent = 36%
• Provincial Tax Maximum Rebate = \$24,000
• Federal Maximum Rebate = \$6,300
• Provincial Rebate = Provincial Tax * 0.75 to maximum of \$24,000
• See 5% (Formula) for Federal Rebate calculations.

Examples:

a) Price = \$300,000, Tax = \$39,000, Rebate = \$23,400, Tax – Rebate = \$15,600

Tax:

• \$300,000 * 0.05 = \$15,000 (Federal)
• \$300,000 * 0.08 = \$24,000 (Provincial)
• \$15,000 (Federal) + \$24,000 (Provincial) = \$39,000

Rebate:

• \$15,000 * 0.36 = \$5,400 (Federal)
• \$24,000 * 0.75 = \$18,000 (Provincial)
• \$5,400 (Federal) + \$18,000 (Provincial) = \$23,400

b) Price = \$425,000, Tax = \$55,250, Rebate = \$25,575, Tax – Rebate = \$29,675

Tax:

• \$425,000 * 0.05 = \$21,250 (Federal)
• \$425,000 * 0.08 = \$34,000 (Provincial)
• \$21,250 (Federal) + \$34,000 (Provincial) = \$55,250

Rebate:

• \$21,250 * 0.36 = \$7,650 (Federal max is \$6,300)
• \$425,000 – \$400,000 = \$25,000
• \$25,000 / \$100,000 = 0.25
• \$6,300 * 0.25 = \$1,575 (Federal)
• \$34,000 * 0.75 = \$25,500 (Provincial max is \$24,000)
• \$1,575 (Federal) + \$24,000 (Provincial) = \$25,575

c) Price = \$500,000, Tax = \$65,000, Rebate = \$24,000, Tax – Rebate = \$41,000

Tax:

• \$500,000 * 0.05 = \$25,000 (Federal)
• \$500,000 * 0.08 = \$40,000 (Provincial)
• \$25,000 (Federal) + \$40,000 (Provincial) = \$65,000

Rebate:

• Price is >= \$450,000, therefore Federal Rebate is \$0
• \$40,000 * 0.75=\$30,000 (max is \$24,000), therefore Provincial Rebate is \$24,000

_____________________________________________________________________

14.5% QC HST (2012) – Includes a rebate depending on the purchase price and applies if the purchase agreement was entered into on or after January 1, 2012, but before January 1, 2013, and ownership and possession were transferred after December 31, 2011.

• Price = Total Sales Revenue
• Tax Rate = 14.975% (Provincial stated as 9.5% but = 9.975% factoring 9.5% into the rebate calculation; Federal = 5%)
• Provincial Tax = Price * 0.09975
• Federal Tax = Price * 0.05
• Provincial Rebate Factor = Federal Rebate * 0.095
• Provincial Rebate Percent = 49.1429%
• Federal Rebate Percent = 36%
• Provincial Maximum Rebate = \$9,804
• Federal Maximum Rebate = \$6,300
• If Price is >= \$300,000, Provincial Rebate = Provincial Rebate Factor
• If Price is <= \$200,000, Provincial Rebate = (Provincial Tax * 0.491429) + Provincial Rebate Factor
• If Price is > \$200,000 but < \$300,000, Provincial Rebate = ((\$300,000 – Price) / \$100,000) *
• (Provincial Tax * 0.491429 to maximum of \$9,804) + Provincial Rebate Factor
• See 5% (Formula) for Federal Rebate calculations.

Examples:

a) Price = \$150,000, Tax = \$22,462.50, Rebate = \$10,309.51, Tax – Rebate = \$12,152.99

Tax:

• \$150,000 * 0.05 = \$7,500 (Federal)
• \$150,000 * 0.09975 = \$14,962.50 (Provincial)
• \$7,500 (Federal) + \$14,962.50 (Provincial) = \$22,462.50

Rebate:

• \$7,500 * 0.36 = \$2,700 (Federal)
• \$14,962.50 * 0.491429 = \$7,353.01
• \$2,700 * 0.095 = \$256.50 (Provincial Rebate Factor)
• \$7,353.01 + \$256.50 = \$7609.51 (Provincial)
• \$2,700 (Federal) + \$7,609.51 (Provincial) = \$10,309.51

b) Price = \$250,000, Tax = \$37,437.50, Rebate = \$9,829.50, Tax – Rebate = \$27,608

Tax:

• \$250,000 * 0.05 = \$12,500 (Federal)
• \$250,000 * 0.09975 = \$24,937.50 (Provincial)
• \$12,500 (Federal) + \$24,937.50 (Provincial) = \$37,437.50

Rebate:

• \$12,500 * 0.36 = \$4,500 (Federal)
• \$24,937.50 * 0.491429 = \$12,255.01 (Provincial max is \$9,804)
• \$300,000 – \$250,000 = \$50,000
• \$50,000 / \$100,000 = 0.5
• \$9,804 * 0.5 = \$4,902
• \$4,500 * 0.095 = \$427.50 (Provincial Rebate Factor)
• \$4,902 + \$427.50 = \$5,329.50 (Provincial)
• \$4,500 (Federal) + \$5,329.50 (Provincial) = \$9,829.50

c) Price = \$350,000, Tax = \$52,412.50, Rebate = \$6,898.50, Tax – Rebate = \$45,514

Tax:

• \$350,000 * 0.05 = \$17,500 (Federal)
• \$350,000 * 0.09975 = \$34,912.50 (Provincial)
• \$17,500 (Federal) + \$34,912.50 (Provincial) = \$52,412.50

Rebate:

• \$17,500 * 0.36 = \$6,300 (Federal)
• \$6,300 * 0.095 = \$598.50 (Provincial Rebate Factor)
• \$6,300 (Federal) + \$598.50 (Provincial) = \$6,898.50

d) Price = \$450,000, Tax = \$67,387.50, Rebate = \$0

Tax:

• \$450,000 * 0.05 = \$22,500 (Federal)
• \$450,000 * 0.09975 = \$44,887.50 (Provincial)
• \$22,500 (Federal) + \$44,887.50 (Provincial) = \$67,387.50

Rebate:

• Price is >= \$450,000, therefore Federal Rebate is \$0
• Price is >= \$450,000, therefore Provincial Rebate is \$0

____________________________________________________________________

14.975% QC HST (2013) – Includes a rebate depending on the purchase price and applies if the purchase agreement was entered into after December 31, 2012.

• Price = Total Sales Revenue
• Tax Rate = 14.975% (Federal = 5%; Provincial = 9.975%)
• Tax = Price * 0.14975
• Provincial Rebate Percent = 50%
• Provincial Tax Maximum Rebate = \$9,975
• Provincial Tax = Price * 0.09975
• Provincial Rebate = Provincial Tax * 0.50 to maximum of \$9,975
• Maximum Rebate = \$9,975
• If Price is >= \$300,000, Rebate = 0
• If Price is <= \$200,000, Rebate = Tax * 0.50
• If Price is > \$200,000 but < \$300,000, Rebate = ((\$300,000 – Price) / \$100,000) * (Tax * 0.50 to maximum of \$9,975)
• See 5% (Formula) for Federal tax rebate calculations.

Examples:

a) Price = \$150,000, Tax = \$22,462.50, Rebate = \$10,181.25, Tax – Rebate = \$12,281.25

Tax:

• \$150,000 * 0.05 = \$7,500 (Federal)
• \$150,000 * 0.09975 = \$14,962.50 (Provincial)
• \$7,500 (Federal) + \$14,962.50 (Provincial) = \$22,462.50

Rebate:

• \$7,500 * 0.36 = \$2,700 (Federal)
• \$14,962.50 * 0.5 = \$7,481.25 (Provincial)
• \$2,700 (Federal) + \$7,481.25 (Provincial) = \$10,181.25

b) Price = \$250,000, Tax = \$37,437.50, Rebate = \$9,487.50, Tax – Rebate = \$27,950

Tax:

• \$250,000 * 0.05 = \$12,500 (Federal)
• \$250,000 * 0.09975 = \$24,937.50 (Provincial)
• \$12,500 (Federal) + \$24,937.50 (Provincial) = \$37,437.50

Rebate:

• \$12,500 * 0.36 = \$4,500 (Federal)
• \$24,937.50 * 0.5 = \$12,468.75 (Provincial max is \$9,975)
• \$300,000 – \$250,000 = \$50,000
• \$50,000 / \$100,000 = 0.5
• \$9,975 * 0.5 = \$4,987.50 (Provincial)
• \$4,500 (Federal) + \$4,987.50 (Provincial) = \$9,487.50

c) Price = \$350,000, Tax = \$52,412.50, Rebate = \$6,300, Tax – Rebate = \$46,112.50

Tax:

• \$350,000 * 0.05 = \$17,500 (Federal)
• \$350,000 * 0.09975 = \$34,912.50 (Provincial)
• \$17,500 (Federal) + \$34,912.50 (Provincial) = \$52,412.50

Rebate:

• \$17,500 * 0.36 = \$6,300 (Federal)
• Price is >= \$350,000, therefore Provincial Rebate is \$0

d) Price = \$450,000, Tax = \$67,387.50, Rebate = \$0

Tax:

• \$450,000 * 0.05 = \$22,500 (Federal)
• \$450,000 * 0.09975 = \$44,887.50 (Provincial)
• \$22,500 (Federal) + \$44,887.50 (Provincial) = \$67,387.50

Rebate:

• Price is >= \$450,000, therefore Federal Rebate is \$0
• Price is >= \$450,000, therefore Provincial Rebate is \$0

_____________________________________________________________________

Custom – Enter the tax percentage as a whole number, e.g. enter 5% tax as 5. Tax will be calculated by multiplying the Total Sales Revenue by the entered amount divided by 100. No rebate is applied.

• Price = Total Sales Revenue
• Tax = Total Sales Revenue * tax amount entered / 100

Example:

• Total Sales Revenue = \$450,000
• Custom amount entered = 5
• Tax = \$22,500 (\$450,000 * 0.05)