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

MDM

  • Walrus Stache
  • *******
  • Posts: 8168
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: 8168
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: 8168
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: 8168
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: 8168
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

MDM

  • Walrus Stache
  • *******
  • Posts: 8168
Re: Case Study Spreadsheet updates
« Reply #105 on: June 27, 2018, 05:48:22 PM »
Version 11.12
  • Added the new Section 199A deduction for qualified pass-through business income.
  • Minor formatting changes.
Please use QBI Pass-through deduction in the case study spreadsheet for suggestions, corrections, and comments on the Section 199A calculations.  Although, any such replies made here won't be ignored. ;)

Most recent version: Case Study Spreadsheet

HudsonMK

  • 5 O'Clock Shadow
  • *
  • Posts: 2
Re: Case Study Spreadsheet updates
« Reply #106 on: July 07, 2018, 07:10:00 AM »
I searched a bit in the forums and on the spreadsheet but could not find it myself. Where does one just put their existing savings on the spreadsheet? I expected to see it near A172, but the accompanying cell has no calculation included. I am using a google sheets version of the spreadsheet, so I thought i'd double check if this was correct or not.  Edit: Oh, I see the calculations tab is primarily for tax calculations with some convenient calculations. I misunderstood that when I first asked this question, but I'll leave this post up in hopes someone can point me to other portions of the spreadsheet properly. Thank-you!
« Last Edit: July 07, 2018, 07:54:03 AM by HudsonMK »

MDM

  • Walrus Stache
  • *******
  • Posts: 8168
Re: Case Study Spreadsheet updates
« Reply #107 on: July 07, 2018, 01:10:14 PM »
Where does one just put their existing savings on the spreadsheet? I expected to see it near A172....
Correct!

Specifically, in B173:B176, depending on what type of accounts one has.

It's probably best to ignore emergency funds held in savings accounts, as those pretty much just sit there and (at best) keep up with inflation.

Using Excel definitely works best.  Based on the lack of responses to https://forum.mrmoneymustache.com/ask-a-mustachian/any-google-sheets-knowledge/ and https://forum.mrmoneymustache.com/ask-a-mustachian/any-libreoffice-calc-knowledge-86335/, it seems Excel is just better.