Author Topic: Case Study Spreadsheet updates  (Read 38676 times)

MDM

  • Walrus Stache
  • *******
  • Posts: 8070
Re: Case Study Spreadsheet updates
« Reply #100 on: April 14, 2018, 03:38:46 PM »
Version 11.07
  • Added a tab that evaluates a non-deductible IRA vs. taxable (and, while it's at it, Roth and deductible)
  • Tweaks to the Form 8606 tab

Most recent version: Case Study Spreadsheet

The last 2017 version (9.11) is attached to post https://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/msg1825323/#msg1825323.

MDM

  • Walrus Stache
  • *******
  • Posts: 8070
Re: Case Study Spreadsheet updates
« Reply #101 on: April 21, 2018, 07:53:30 PM »
Version 11.08
  • Updated the 2016 Average Wage Index for Social Security benefit estimates.
  • Minor formatting
The estimates on the 'SocialSecurity' tab match the version 2018.1 anypia.exe numbers within $1/mo for all examples tested, e.g., https://www.ssa.gov/oact/ProgData/retirebenefit1.html.


Most recent version: Case Study Spreadsheet

The last 2017 version (9.11) is attached to post https://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/msg1825323/#msg1825323.

MDM

  • Walrus Stache
  • *******
  • Posts: 8070
Re: Case Study Spreadsheet updates
« Reply #102 on: April 24, 2018, 04:17:17 PM »
Version 11.09
  • Added Form 8962, Premium Tax Credit.
This allows one to see the impact of various Affordable Care Act phaseouts and cliffs on overall marginal rates.

The Premium Tax Credit (PTC) for those with "simple" ACA insurance will be calculated if one enters the   
    - Enrollment Premium (aka the cost if one would receive no Premium tax credit) in cell B113.
    - Advance Premium Tax Credit in cell B114.  Enter this as a negative number.
    - Second Lowest Cost Silver Plan (SLCSP) cost for the year in cell AE99.

At this time, the calculation does not explicitly consider
    - situations not the same for all 12 months (taking monthly averages might or might not be accurate)
    - self-employment health insurance requiring iterative calculations to determine PTC and Form 1040 line 29 amounts.


Most recent version: Case Study Spreadsheet

The last 2017 version (9.11) is attached to post https://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/msg1825323/#msg1825323.

MDM

  • Walrus Stache
  • *******
  • Posts: 8070
Re: Case Study Spreadsheet updates
« Reply #103 on: May 02, 2018, 10:50:33 AM »
Version 11.10
  • Put the HSA family limit back to $6900.  Thanks, IRS....
  • Added columns and fixed typos in the Form8606 tab.

Most recent version: Case Study Spreadsheet

MDM

  • Walrus Stache
  • *******
  • Posts: 8070
Re: Case Study Spreadsheet updates
« Reply #104 on: May 30, 2018, 05:26:18 PM »
Version 11.11
  • Added $25K rental loss limitation.
  • Correct cell reference in state tax estimate for time to FI.
  • Add local income tax to NIIT deductions.
  • Minor formatting changes.

Most recent version: Case Study Spreadsheet