So I just started using this sheet, want to start tracking for 2017 and filled in Jan 2017's column and adjusted the FI labels.
I went to mortgage and put $0 for 'Start Amount of Table' because I don't own a home hence no mortgage.
Now all of the NW tab has "#VALUE" in the colored columns, why is this so dependent on the mortgage tab?
I populated the white areas of the NW tab for 12/1/2016 with my last balances.
So income/expense/401K/IRA/ROTH, etc.
NetWorth/Liquid and all the colored columns still remain "#VALUE".
How should this be filled out for those of us who don't own a home?
What am I missing here?
If you don't own a home just put in $0 for the appraised value. Put $0 for amount financed, 1 year and 1%. Fill in $0 for Escrow and Extra Principal. Start month of table can be 1 and put $0 for amount financed. That will give the other sheets a $0 dollar amount for the formulas to grab.
Thanks, I did that (put 1/1/2017 as the start date), now in the NW tab Net Worth/Liquid/WR Income tabs just show "#VALUE!". I filled out the white area for following tabs: Income/Expenses, 401K, TIRA, Roth IRA, Taxable, then in Home Equity area, I just put in my current values for Checking and Savings accounts and then in Loan tab, put 0. 2/1/2017 has the current value of all my accounts.
However, the "Current Net Worth" (blue at the top) shows $426 in E column and $342 in F column. Huh? Why so low? Am I not doing something right?
Also in the monthly tabs, what are we supposed to put for the purple "Payroll Taxes"??
Where do I get this from? Taxes (% of gross) is showing "270829.79%". That can't be right.