I appreciate the kind words Kelley. Thank you for taking the class!

I designed this spreadsheet for post-tax income (Net) so inputting your gross income into the sheets will mess with the calculations.

Here are some tweaks that will allow you to enter your gross paycheck accurately:

1. Enter your gross income into the payroll cells (what I labeled as "Paycheck 1").
2. Under Expenses, add four rows.
3. Label the cell in column B "Federal Income Tax".
4. In the cell next to that enter "=(cell w/gross income)*.1524 then push enter.

This will calculate your federal income tax withholding and add that to your expenses. Multiplying by .1524 is equal to multiplying by 15.25%, the current income tax rate.

5. Repeat this process for each withholding expense. If you aren't sure what percentages are for your state use smartasset.com/taxes/paycheck-calculator.

Once you are done with expenses, move down to your savings (monthly breakdown). Just like we did in class you will want to add a multiplier for the amount that's being saved.

6. Pick a cell (or create a new one) and enter =(cell w/gross income)*.06% for your IRA.
7. Do the same for your savings.

Hopefully, this helps!

Luke Floyd

Aspiring daily, to fail at failing.

72

6

Empresa

Comunidad

Enseñanza

Móvil

Empresa

Comunidad

Enseñanza