140 likes | 333 Views
Budgets. Building a Budget Spreadsheet. Only the Spinner Knows Your Family. Only the Spinner Knows Your Family’s Income. Make a Choice. Make a Choice. Make a Choice. Make a Choice. WHAT DOES THE SPINNER SAY!.
E N D
Budgets Building a Budget Spreadsheet
The new taxes are complex and escalate depending upon a person or family’s income. They have basically three tiers: • Flat fee: The first tier for lower income taxpayers is fixed, starting at $95 for calendar year 2014 (the first year the mandate is effective), $325 in 2015, and $695 in 2016 and beyond. The total family penalty is capped at 300% of this flat dollar tax — $2,085 in 2016 – for those earning less than about $110,000, according to the CRS. • Percentage of income: The next tier is based upon a percentage of income: 1.0% in 2014, 2.0% in 2015, and 2.5% thereafter. • Cost of a basic health plan: However, as household income increases, eventually the percentage tax will rise to equal the cost of the national average premium for a “bronze-level health plan,” where it is capped. (The bronze plan is expected to be the least expensive plan in the line-up of policies that will be offered through the ObamaCare health insurance exchanges. The Congressional Budget Office estimates that in 2016 the cost of a bronze-level plan for a family would be between $12,000 and $12,500 a year.)
Basic Spreadsheet Formulas Addition =sum(B1+B3) =sum(B1..B10) Subtraction =sum(B3-B5) Multiplication =sum(B1*B10) Division =sum(B10/B1)