Zoho Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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

	Amount of Loan		3,000,000.00
	Annual Interest Rate		11.00%
	Number of Payments		240

	Monthly Payment		30,965.65

Number	Payment	Interest	Principal	Balance
0				3,000,000.00
1	30,965.65	27,500.00	3,465.65	2,996,534.35
2	30,965.65	27,468.23	3,497.42	2,993,036.93
3	30,965.65	27,436.17	3,529.48	2,989,507.45
4	30,965.65	27,403.82	3,561.83	2,985,945.61
5	30,965.65	27,371.17	3,594.48	2,982,351.13
6	30,965.65	27,338.22	3,627.43	2,978,723.70
7	30,965.65	27,304.97	3,660.68	2,975,063.01
8	30,965.65	27,271.41	3,694.24	2,971,368.77
9	30,965.65	27,237.55	3,728.10	2,967,640.67
10	30,965.65	27,203.37	3,762.28	2,963,878.39
11	30,965.65	27,168.89	3,796.77	2,960,081.62
12	30,965.65	27,134.08	3,831.57	2,956,250.05
13	30,965.65	27,098.96	3,866.69	2,952,383.36
14	30,965.65	27,063.51	3,902.14	2,948,481.22
15	30,965.65	27,027.74	3,937.91	2,944,543.31
16	30,965.65	26,991.65	3,974.00	2,940,569.31
17	30,965.65	26,955.22	4,010.43	2,936,558.88
18	30,965.65	26,918.46	4,047.20	2,932,511.68
19	30,965.65	26,881.36	4,084.29	2,928,427.39
20	30,965.65	26,843.92	4,121.73	2,924,305.65
21	30,965.65	26,806.14	4,159.52	2,920,146.14
22	30,965.65	26,768.01	4,197.65	2,915,948.49
23	30,965.65	26,729.53	4,236.12	2,911,712.37
24	30,965.65	26,690.70	4,274.96	2,907,437.41
25	30,965.65	26,651.51	4,314.14	2,903,123.27
26	30,965.65	26,611.96	4,353.69	2,898,769.58
27	30,965.65	26,572.05	4,393.60	2,894,375.98
28	30,965.65	26,531.78	4,433.87	2,889,942.11
29	30,965.65	26,491.14	4,474.52	2,885,467.60
30	30,965.65	26,450.12	4,515.53	2,880,952.06
31	30,965.65	26,408.73	4,556.92	2,876,395.14
32	30,965.65	26,366.96	4,598.70	2,871,796.44
33	30,965.65	26,324.80	4,640.85	2,867,155.59
34	30,965.65	26,282.26	4,683.39	2,862,472.20
35	30,965.65	26,239.33	4,726.32	2,857,745.88
36	30,965.65	26,196.00	4,769.65	2,852,976.23
37	30,965.65	26,152.28	4,813.37	2,848,162.86
38	30,965.65	26,108.16	4,857.49	2,843,305.37
39	30,965.65	26,063.63	4,902.02	2,838,403.35
40	30,965.65	26,018.70	4,946.95	2,833,456.39
41	30,965.65	25,973.35	4,992.30	2,828,464.09
42	30,965.65	25,927.59	5,038.06	2,823,426.03
43	30,965.65	25,881.41	5,084.25	2,818,341.78
44	30,965.65	25,834.80	5,130.85	2,813,210.93
45	30,965.65	25,787.77	5,177.88	2,808,033.04
46	30,965.65	25,740.30	5,225.35	2,802,807.69
47	30,965.65	25,692.40	5,273.25	2,797,534.45
48	30,965.65	25,644.07	5,321.59	2,792,212.86
49	30,965.65	25,595.28	5,370.37	2,786,842.49
50	30,965.65	25,546.06	5,419.60	2,781,422.90
51	30,965.65	25,496.38	5,469.28	2,775,953.62
52	30,965.65	25,446.24	5,519.41	2,770,434.21
53	30,965.65	25,395.65	5,570.00	2,764,864.21
54	30,965.65	25,344.59	5,621.06	2,759,243.14
55	30,965.65	25,293.06	5,672.59	2,753,570.55
56	30,965.65	25,241.06	5,724.59	2,747,845.97
57	30,965.65	25,188.59	5,777.06	2,742,068.90
58	30,965.65	25,135.63	5,830.02	2,736,238.88
59	30,965.65	25,082.19	5,883.46	2,730,355.42
60	30,965.65	25,028.26	5,937.39	2,724,418.03

Sheet1

Sheet2

Sheet3