ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Loan100,000.00PMT(489.02)Date12-Jul-2028CAGR0.80%monthly
3
interest4.20%ASB Value128,237.07CAGR9.63%yearly
4
Tenure 30yearsXIRR10.06%ASB Loan outstanding90,736.46Effective CAGR10.07%yearly
5
Installment monthTotal Net Value37,500.61
6
Intitiation Date12-Jul-2023
7
8
ASB investment100000
9
ASB dividend5.10%
10
Period (month)DateMonthly PaymentInterest PaymentPrincipal PaymentLoan BalancePeriod (Year)DateASB valueAssetReturn
11
012-Jul-2023000100,000.00012-Jul-2023100,000.00ASB100,000.005.10%5100
12
112-Aug-2023(489.02)(350.00)(139.02)99,860.98112-Jul-2024105,100.00
13
212-Sep-2023(489.02)(349.51)(139.50)99,721.48212-Jul-2025110,460.10Liability100,000.004.20%4200
14
312-Oct-2023(489.02)(349.03)(139.99)99,581.49312-Jul-2026116,093.57
15
412-Nov-2023(489.02)(348.54)(140.48)99,441.01412-Jul-2027122,014.34900
16
512-Dec-2023(489.02)(348.04)(140.97)99,300.03512-Jul-2028128,237.07
17
612-Jan-2024(489.02)(347.55)(141.47)99,158.56
18
712-Feb-2024(489.02)(347.05)(141.96)99,016.60
19
812-Mar-2024(489.02)(346.56)(142.46)98,874.14
20
912-Apr-2024(489.02)(346.06)(142.96)98,731.19
21
1012-May-2024(489.02)(345.56)(143.46)98,587.73
22
1112-Jun-2024(489.02)(345.06)(143.96)98,443.77
23
1212-Jul-2024(489.02)(344.55)(144.46)98,299.30
24
1312-Aug-2024(489.02)(344.05)(144.97)98,154.33
25
1412-Sep-2024(489.02)(343.54)(145.48)98,008.86
26
1512-Oct-2024(489.02)(343.03)(145.99)97,862.87
27
1612-Nov-2024(489.02)(342.52)(146.50)97,716.37
28
1712-Dec-2024(489.02)(342.01)(147.01)97,569.36
29
1812-Jan-2025(489.02)(341.49)(147.52)97,421.84
30
1912-Feb-2025(489.02)(340.98)(148.04)97,273.80
31
2012-Mar-2025(489.02)(340.46)(148.56)97,125.24
32
2112-Apr-2025(489.02)(339.94)(149.08)96,976.16
33
2212-May-2025(489.02)(339.42)(149.60)96,826.56
34
2312-Jun-2025(489.02)(338.89)(150.12)96,676.44
35
2412-Jul-2025(489.02)(338.37)(150.65)96,525.79
36
2512-Aug-2025(489.02)(337.84)(151.18)96,374.61
37
2612-Sep-2025(489.02)(337.31)(151.71)96,222.90
38
2712-Oct-2025(489.02)(336.78)(152.24)96,070.67
39
2812-Nov-2025(489.02)(336.25)(152.77)95,917.90
40
2912-Dec-2025(489.02)(335.71)(153.30)95,764.59
41
3012-Jan-2026(489.02)(335.18)(153.84)95,610.75
42
3112-Feb-2026(489.02)(334.64)(154.38)95,456.37
43
3212-Mar-2026(489.02)(334.10)(154.92)95,301.45
44
3312-Apr-2026(489.02)(333.56)(155.46)95,145.99
45
3412-May-2026(489.02)(333.01)(156.01)94,989.98
46
3512-Jun-2026(489.02)(332.46)(156.55)94,833.43
47
3612-Jul-2026(489.02)(331.92)(157.10)94,676.33
48
3712-Aug-2026(489.02)(331.37)(157.65)94,518.68
49
3812-Sep-2026(489.02)(330.82)(158.20)94,360.48
50
3912-Oct-2026(489.02)(330.26)(158.76)94,201.72
51
4012-Nov-2026(489.02)(329.71)(159.31)94,042.41
52
4112-Dec-2026(489.02)(329.15)(159.87)93,882.54
53
4212-Jan-2027(489.02)(328.59)(160.43)93,722.12
54
4312-Feb-2027(489.02)(328.03)(160.99)93,561.13
55
4412-Mar-2027(489.02)(327.46)(161.55)93,399.57
56
4512-Apr-2027(489.02)(326.90)(162.12)93,237.45
57
4612-May-2027(489.02)(326.33)(162.69)93,074.77
58
4712-Jun-2027(489.02)(325.76)(163.26)92,911.51
59
4812-Jul-2027(489.02)(325.19)(163.83)92,747.69
60
4912-Aug-2027(489.02)(324.62)(164.40)92,583.28
61
5012-Sep-2027(489.02)(324.04)(164.98)92,418.31
62
5112-Oct-2027(489.02)(323.46)(165.55)92,252.76
63
5212-Nov-2027(489.02)(322.88)(166.13)92,086.62
64
5312-Dec-2027(489.02)(322.30)(166.71)91,919.91
65
5412-Jan-2028(489.02)(321.72)(167.30)91,752.61
66
5512-Feb-2028(489.02)(321.13)(167.88)91,584.73
67
5612-Mar-2028(489.02)(320.55)(168.47)91,416.26
68
5712-Apr-2028(489.02)(319.96)(169.06)91,247.20
69
5812-May-2028(489.02)(319.37)(169.65)91,077.55
70
5912-Jun-2028(489.02)(318.77)(170.25)90,907.30
71
6012-Jul-2028(489.02)(318.18)(170.84)90,736.46
72
12-Jul-202837,500.61
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