ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
S.No.ONE-TIME CHARGESAMOUNTAMORTIZATIONAMORTIZATION PERIODAMOUNTCOMMENT
3
1=Yes, 0=Noin Months
4
1One-Time Charges by Broker$15,500.00024$0.00
5
2One-Time Setup Fee by Solution Provider$18,000.00024$0.00
6
3One-Time Setup Fee for Mobile$0.00024$0.00
7
4One-Time Setup Fee for Web$0.00024$0.00
8
5One-Time Setup Fee for Customization$0.00024$0.00
9
6One-Time Setup Fee for API$0.00024$0.00
10
7One-Time Setup Fee for Debit Card Processing$0.00024$0.00
11
8One-Time Setup Fee for Bank Account$0.00024$0.00
12
9One-Time Setup Fee for Legal$0.00024$0.00
13
10One-Time Setup Fee for Hosting/AWS$0.00024$0.00
14
11One-Time Setup Fee for KYC$5.00112$0.42Please make sure in the modeling itself, only ONE of them is used. You cannot have a model of both KYC and KYB. At least in this spreadsheet model.
15
12One-Time Setup Fee for KYB$100.00112$8.33
16
TOTAL$33,605.00$0.00Amortized amount over the period defined. Does not include KYB/KYC
17
18
19
S.No.MONTHLY RECURRING CHARGESAMOUNTCOMMENT
20
21
1Broker$0.00Insert your comments
22
2Solution Provider for Regulatory Coverage$1,800.00
23
3Mobile App$0.00
24
4Web App$0.00
25
5AWS Hosting$600.00
26
6API$0.00
27
7Card Processing$0.00
28
8Bank Account$0.00
29
9Compliance/Reporting$1,000.00
30
10Other Monthly Recurring Fee "A"$0.00
31
11Crypto Compliance Fee$600.00
32
12Amortized Amount$0.00Derived from the One-Time Charges (Amortized Amount Total)
33
TOTAL$4,000.00Total Monthly Recurring Cost
34
35
36
S.No.TRANSACTION CHARGESAMOUNTCHARGING AMOUNTSCOMMENT
37
38
1Average Transaction Value (A)$20,000.00Let's say for Debit Cards
39
2Number of Transactions Per Month (A)75These are the monthly transaction numbers for Debit Cards
40
3Total Volume/Revenue Booked or Processed (A)$1,500,000.00Total Value Processed per month for Debit Cards
41
4Volume Fee (A)$8,250.000.55%The Volume Fee Charged by the Solution Provider
42
5Transaction Fee for Debit Cards (Fixed) (A)$375.00$5.00Network Fees
43
6Transaction Fee for Debit Cards (%) (A)$0.000.00%Debit Card Rates
44
7.1KYC$15.63Ratio50.00%Amortized Cost of KYC
45
7.2KYB$0.00Ratio0.00%Amortized Cost of KYB
46
8Monthly Costs$1,714.29Monthly Cost (Ammortized) Included Based on the Number of Transaction Percentage
47
9Total Fees for Debit Card Transactions (A)$10,354.91
48
10Average Transfer Cost0.6903%
49
11Average Cost of Transfer in USD$138.07
50
51
52
12Average Transaction Value (B)$25,000.00For ACH Transactions
53
13Number of Transactions Per Month (B)100Number of monthly transactions
54
14Total Volume/Revenue Booked or Processed (B)$2,500,000.00Total value processed per month for ACH transactions
55
15Volume Fee (B)$13,750.000.55%The Volume Fee Charged by the Solution Provider
56
15Transaction Fee for ACH (Fixed) (B)$500.00$5.00ACH Charges
57
16.1KYC$0.00Ratio0.00%Amortized Cost of KYC
58
16.2KYB$416.67Ratio50.00%Amortized Cost of KYB
59
17Monthly Costs$2,285.71Monthly Cost (Ammortized) Included Based on the Number of Transaction Percentage
60
18Total Fees for ACH Transactions (B)$16,952.38
61
19Average Transfer Cost0.6781%
62
20Average Cost of Transfer in USD$169.52
63
64
65
21Total Revenue$4,000,000.00
66
22Total Fee/Expenses$27,307.29
67
23Actual Transfer Amount$3,972,692.71
68
24Total Number of Transactions175
69
25Average Transfer Cost0.6827%
70
26Average Transfer Cost in Dollar Terms$153.60
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