SimpleMoneySpreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Financial Overview as of:2/2/2019Bills & Recurring ExpensesBackend for Charts, do not touch
2
visit www.FamVestor.com/Spreadsheet for InstructionsAll Recurring Expenses (Memberships, Subscriptions, Etc.)Expenses$142,547
3
NamesJohn DoeJane Doeweeklybi-weeklymonthlyQuarterly6-MonAnnualTot. Ann.Savings$61,120
4
OccupationMech. Eng.MomGym Membership$15$180
5
Credit Score795766Phone$38$456Cash$10,510
6
Gross Salary$99,927Internet$30$360Stocks$135,880
7
Gross Rental/Passive Income$103,740Car Insurance$519$1,038Retirement$91,285
8
Total Gross Income$203,667Google One Account$2$24Real Estate$298,098
9
Total Exp.(Includ. Income Tax)**-$142,547Amazon Seller Account$40$480Debt$53,615
10
Total Annual Savings$61,120Date Night Babysitter$50$2,600
11
Total Assets(Sav., Inv., IRA, REI)$1,237,675Health Insurance$164$4,269Monthly Spending Limit$7,493
12
Total Liab. (Mort., Loans, Debt)-$755,517Dental Insurance$33$859Monthly Budget$2,400
13
Net Worth = Assets - Liab.$482,158Life Insurance$12$324Savings$5,093
14
Savings/Checking/Cash (Liquid)Est. Income Tax (Fed&NJ)*$6,182$6,182
15
EstablishmentAmountReference*Soc. Sec. & Medicare Tax$218$5,664NetWorth Now$482,158
16
Trustco Bank$2,626Pg. # 2-4Mortgages + HELOC$3,617$43,404NW at Year End$570,991
17
Picatinny Federal Credit Union$2,029Pg. # 5-8Home Taxes$6,213$24,853NW in 5 Years$1,048,167
18
PNC Bank$3,855Pg. # 9-16Home Insurance$2,693$2,693NW in 10 Years$1,850,557
19
Cash$2,000N/ASewer$240$960
20
Total$10,510Water$250$1,000
21
Stocks/Roth-Ira* (Semi-Liquid)PSE&G (Util)$265$3,180
22
EstablishmentAmountReference*Home Maint.&Vacan.$835$10,020
23
Scottrade - Stocks Account$29,058Pg. # 17-20Church Tithe$200$5,200
24
Scottrade - Roth-IRA*$54,688Pg. # 21-26ECSI Student Loans(Deff.)$0
25
Vanguard - Roth-IRA*$52,134Pg. # 27-32$0
26
Total$135,880$0
27
Retirement TSP/401k/403b/IRATotal$113,747
28
EstablishmentAmountReference*Personal$10,338
29
Thrift Savings Plan$91,285Pg. # 33-37Monthly Spend Limit (MSL)Tax&Ins.$17,299
30
Monthly Spend Limit (MSL)MSL - $12k[IRA's] - $19k[401k's]Housing$86,110
31
Total$91,285$7,493$4,910
32
Real Estate Assets
33
Mortgage Amnt (4Fam + 3Fam)Appraised Value*EquityMonthly Budget for Out-of-Pocket Expenses
34
-$429,099$630,000$200,901CategoryGroceriesEating OutGas&MaintPersonalTravelGifts/BdaysTotal Budget
35
-$272,803$370,000$97,197Monthly Amount$1,000$1,000$200$200$2,400
36
Total DebtsPercentage of Budget42%0%0%42%8%8%$80 a Day
37
EstablishmentAmountReference*$28800 a Year
38
Home Equity Line of Credit (Garf.)-$53,000n/aFinancial Independence (FI) Percentage Goals & Stats
39
ECSI Student Loans-$527n/aFI % = Passive Income (PI) / Exp.
+ PI Needed?
+ NetWorth (4% rule) Needed?
Networth Goal
Years to Acheive (YTA)YTA w/ 7%
40
Credit Card Balance-$87n/a86.32%$19,494$487,345$1,000,0008.54.6
41
42
Remarks
43
* To Edit Your Own Version: Go to FILE -> Make a Copy….

* Do not edit any of the fields in BOLD.

* One may withdraw all the contributions from a Roth-IRA at any time penalty free. It is only the Gains that will be penalized if withdrawn before 59.5 years of age. https://investor.vanguard.com/ira/ira-distribution-rules

* Federal Income Tax is estimated based on previous year’s tax returns.

* Right below the Total Expense I have broken out how much of our expenses are due to the House/Rental Properties, and how much are personal related expenses, and how much taxes and insurance account for.

----------------------------------------- (REMARKS to FINANCIAL LENDER -------------------------------------------------------
*Reference Page Numbers refer to the document labeled 190204_FinancialBinder.pdf

*All Amounts are as of 02/04/19.

*Rental Income can be verified through signed leases and deposits in Bank Statements.

*Appraised Value is based on the Appraisal that was conducted by "Atterbury& Associates" on 8/26/16 for our Four-Family Residence/Investment-Property, see attached appraisal document.
44
Total-$53,615
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...