Untitled spreadsheet

	A	B	C	D	E	F
1
2	Income	Interest rate	Loan Balance to start	Payment duration (years)	Total interest and Principal	Monthly payment (single)
3	100000	7%	10000	1.80	$13,933.02	645.0833333
4			20000	3.60	$27,866.04
5			30000	5.40	$41,799.05
6			40000	7.20	$55,732.07
7			50000	9.00	$69,665.09
8			60000	10.80	$83,598.11
9			70000	12.60	$97,531.12
10			80000	14.40	$111,464.14
11			90000	16.20	$125,397.16
12			100000	18.00	$139,330.18
13			110000	19.80	$153,263.19
14			120000	21.60	$167,196.21
15			130000	23.40	$181,129.23
16			140000	25.20	$195,062.25
17			150000	27.00	$208,995.26
18			160000	28.80	$222,928.28
19			170000	30.60	$236,861.30
20			180000	32.40	$250,794.32
21			190000	34.20	$264,727.33
22			200000	36.00	$278,660.35
23			210000	37.80	$292,593.37
24			220000	39.60	$306,526.39
25			230000	41.40	$320,459.40
26			240000	43.20	$334,392.42
27			250000	45.00	$348,325.44
28			260000	46.80	$362,258.46
29			270000	48.60	$376,191.47
30			280000	50.40	$390,124.49
31			290000	52.20	$404,057.51
32			300000	54.00	$417,990.53
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