ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
FunctionPeriod of LoanValueValueRateRateVariable to seek
Dummy to seek equivalent EIR of Total Cost
2
3
Loan ID
Loan Tenure (in Months)
Loan Amount
Principle Amount (70%) Loaned By Bank
Principle Amount (30%) Loaned by Capital
Cost of Fund (EIR 15%)
Cost of Capital (EIR 6%)
Amount Cost of Fund
Amount Cost of Capital
Total Cost
Equivalent of Total Cost Effective Rate
Dummy Effective Rate
4
A000115 $ 2,000.00 $ 1,400.00 $ 600.00 15%6% $ 144.06 $ 24.28 $ 168.33 12.33%168.3350627
5
B000124 $ 4,000.00 $ 2,800.00 $ 1,200.00 12%4% $ 363.34 $ 50.64 $ 413.98 9.64%413.975092
6
7
413.9750919
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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100