ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Salary Per PersonAffordable Home Loan
3
Person #11$62,000.00$151,409.52
4
Person #22$38,000.00
5
Extra Income (If Any)3$0.00
6
Net Income from Business (If Any)$0.00
7
Alimony or other mandated Income (Non-Taxable)
$0.00
8
Down Payment (20%)$30,281.90
9
Total Gross Income4$100,000.00Annual Interest Rate93.97%
10
Life of the Loan (Years)1030
11
Anticipated Tax Percentage513%Number of Payments per Year12
12
Total Net Income (Annually)$87,000.00Total Number of Payments360
13
Payment per Period (Monthly)
otherwise known as the Mortgage		11$576.19
14
Monthly Net Income6$7,250.00Sum of all Payments$207,427.97
15
Total Interest Cost$86,300.35
16
Total Amount of People (Updated if Needed)2
17
Affordable Auto Loan
18
Savings and Retirement Assets using the Maximum Strategy$4,680.00
19
Traditional or ROTH 401K, 403B, or 457B for Person #174%$19,000.00Payment per Period (Monthly)
otherwise known as Car Note		12$130.00
20
Employer #1 Matching (if Available)$2,480.00
21
Traditional or ROTH 401K, 403B, or 457B for Person #283%$10,000.00Monthly Grocery/Food Cost
22
Employer #2 Matching (if Available)$1,140.00$450.00
23
Traditional or ROTH IRA$12,000.00
24
Health Savings Account (Individual limit for 2019 at $3,500 and $7,000 for Families)$7,000.00Total Monthly Student Loans Payments For the Household13$405.00
25
(Total) Annual Savings on Automatic$51,620.00Annual Student Loan PMTs$4,860.00
26
Additional Personal Savings for the year14$2,500.00
27
Additional PMTs i.e Credit Cards, Personal Loans, etc.15$4,785.00
28
$12,145.00
29
Montly Net Income
After PreTax Savings and Investments		$3,250.00(Monthly) Spending Money16$1,081.73
30
31
32
33
34
35
36
37
38
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