FamVestor_FinancialOverview_Template
 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 8/2/17 Visit www.FamVestor.com/Spreadsheet if you have questions on using this resource.Expenses**
2
NamesJohn DoeJane Doeweeklybi-weeklymonthlyQuarterlySemi-Ann.AnnualTot. Ann.
3
OccupationMechanical EngineerFull-Time MomBudget Allowance*$1,500.00$18,000.00
4
Gross Salary$85,408.00$0.00Gym Membership$180.00$180.00
5
Gross Rental Income$100,000.00Phone$38.00$456.00
6
Total Gross Income$185,408.00Internet$30.00$360.00
7
Total Exp.(Includ. Income Tax)**
-$135,357.84Car Insurance$519.20$1,038.40
8
Total Annual Savings$50,050.16
Biggerpockets ProMember
$29.00$348.00
9
Total Assets(Sav., Inv., IRA, REI)
$1,166,306.41Google Drive Expansion$1.99$23.88
10
Total Liab. (Mort., Loans, Debt)
-$763,959.51Amazon Seller Account$39.99$479.88
11
Net Worth = Assets - Liab.$402,346.90Health Insurance$164.20$4,269.20
12
Savings/Checking/Cash (Liquid)Dental Insurance$33.05$859.30
13
EstablishmentAmountReference*Life Insurance$12.45$323.70
14
Trustco Bank$9,503.31Pg. # 2-4
Est. Income Tax (Fed&NJ)
$6,182.00$6,182.00
15
Picatinny Federal Credit Union$711.97Pg. # 5-8
Soc. Sec. & Medicare Tax
$217.86$5,664.36
16
PNC Bank$432.13Pg. # 9-16Mortgages + HELOC$3,617.00$43,404.00
17
Cash$5,714.00N/AHome Taxes$6,213.25$24,853.00
18
Total$16,361.41Home Insurance$2,693.00$2,693.00
19
Stocks/Roth-Ira* (Semi-Liquid)Sewer$240.00$960.00
20
EstablishmentAmountReference*Water$250.00$1,000.00
21
Scottrade - Stocks Account$16,940.00Pg. # 17-20PSE&G (Util)$265.00$3,180.00
22
Scottrade - Roth-IRA*$40,898.00Pg. # 21-26Home Maint.&Vacan.$835.00$10,020.00
23
Vanguard - Roth-IRA*$39,419.00Pg. # 27-32Church Tithe$200.00$5,200.00
24
Total$97,257.00Navient Loans(Deferred)$0.00
25
Retirement TSP/401k/403b/IRAECSI Student Loans$55.26$663.12
26
EstablishmentAmountReference*Misc. (Unexpected)*$100.00$5,200.00
27
Thrift Savings Plan$52,688.00Pg. # 33-37
Total Exp
$135,357.84
28
Total$52,688.00House$86,110.00
29
Real Estate AssetsDaily Allowance (DA)DA - $11k[IRA] - $18k[401k]Tax&Insur.$17,298.56
30
Mortgage AmountAppraised Value*Equity$205.76$124.30Personal$31,949.28
31
-$442,588.06$630,000.00$187,411.94
32
-$280,000.00$370,000.00$90,000.00Remarks
33
Total Debts*Reference Page Numbers refer to the document labeled 170802_FinancialBinder.pdf       

*All Amounts are as of 08/02/17.

*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.
       
*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.       
       
**The Expenses Spreadsheet Captures all our Recurring expenses. For daily expenditures including Gas, Groceries, Eating out, etc. my Wife and I have a Monthly Budget Allowance of $750 each. Some months there are unexpected expenses(Vacations, etc.) that cause us to go over-budget, typically all that is captured by the Misc. (Unexpected) category that we allow for about $100/week. Right below the Total Expense I have broken out how much of our expenses are due to the House, and how much are personal related expenses, and how much taxes and insurance account for.
34
EstablishmentAmountReference*
35
Home Equity Line of Credit (Garfield)
-$30,000.00n/a
36
Navient Student Loans-$4,895.84n/a
37
ECSI Student Loans-$4,175.61n/a
38
Credit Card Balance-$2,300.00n/a
39
40
41
42
43
44
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...
Main menu