Announcement

Collapse
No announcement yet.

Calcuating Hawaii 35% tax rebate

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Calcuating Hawaii 35% tax rebate

    When I created a spreadsheet of quotes, I wanted to calculate the 35% Hawaii state tax rebate. Its a funky equation, because it's 35% or $5000 for each 5K of DC panels. I'm posting it here in case it's of help to others.

    The equation looks like:

    =int(B4/5000)*min(G4/B4*5000*0.35, 5000) +min(mod(B4,5000)*G4/B4*0.35, 5000)

    where B4 is the DC size in watts, and G4 is the Cost of the system.

    From the quotes I have so far, the actual state rebate ranges from 19% up to 33%.
Working...
X