Fixed Fee Loan Calculator

	A	B	C	D	E	F
1	Merchant Cash Advance Loan Calculator - Fixed Monthly Repayments
2	by Bill D'Alessandro (@billda)
3	You can hire me to optimize your financial stack.
4
5	INSTRUCTIONS: Edit only the 3 blue cells below. Cells in black are auto-calculated. The table at the bottom breaks out how the math is done for each daily repayment.
6
7	Loan Principal	$100,000
8	"Fixed Fee" %	9%
9	Term (Months)	6
10	Amount to Repay	$109,000
11
12	Actual Blended APR	44.10%
13
14		Disbursement / Payment	Principal Paid	Fee Paid	Months Principal Outstanding	Effective APR on Principal
15	Month 0	-$100,000
16	Month 1	$18,167	$16,667	$1,500	1	108.0%
17	Month 2	$18,167	$16,667	$1,500	2	54.0%
18	Month 3	$18,167	$16,667	$1,500	3	36.0%
19	Month 4	$18,167	$16,667	$1,500	4	27.0%
20	Month 5	$18,167	$16,667	$1,500	5	21.6%
21	Month 6	$18,167	$16,667	$1,500	6	18.0%
22	Month 7	0	0	0	7
23	Month 8	0	0	0	8
24	Month 9	0	0	0	9
25	Month 10	0	0	0	10
26	Month 11	0	0	0	11
27	Month 12	0	0	0	12
28	Month 13	0	0	0	13
29	Month 14	0	0	0	14
30	Month 15	0	0	0	15
31	Month 16	0	0	0	16
32	Month 17	0	0	0	17
33	Month 18	0	0	0	18
34	Month 19	0	0	0	19
35	Month 20	0	0	0	20
36	Month 21	0	0	0	21
37	Month 22	0	0	0	22
38	Month 23	0	0	0	23
39	Month 24	0	0	0	24
40	Month 25	0	0	0	25
41	Month 26	0	0	0	26
42	Month 27	0	0	0	27
43	Month 28	0	0	0	28
44	Month 29	0	0	0	29
45	Month 30	0	0	0	30
46	Month 31	0	0	0	31
47	Month 32	0	0	0	32
48	Month 33	0	0	0	33
49	Month 34	0	0	0	34
50	Month 35	0	0	0	35
51	Month 36	0	0	0	36
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