Prepaid Expense Template .xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	T	U
1
2	PREPAID EXPENSE TEMPLATE
3
4	YOUR COMPANY NAME								YEAR
5	XXXXXX								20XX
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25	PREPAID SCHEDULE					Note:Grey Cells are automatically calculated. Do not change
26	Description	Opening Balance	Start Date	End date	Length of Service	Jan-23	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Expense for the FY	Prepaid Balance
27	Health Insurance	$100,000	Jan-23	Jun-23	6	$16,667	$16,667	$16,667	$16,667	$16,667	$16,667	$0	$0	$0	$0	$0	$0	$100,000	$0
28	Hosting	$4,000	Jan-23	Jun-25	30	$133	$133	$133	$133	$133	$133	$133	$133	$133	$133	$133	$133	$1,600	$2,400
29	Medical Insurance	$100,000	Jan-23	Jun-24	18	$5,556	$5,556	$5,556	$5,556	$5,556	$5,556	$5,556	$5,556	$5,556	$5,556	$5,556	$5,556	$66,667	$33,333
30	Software License	$3,000,000	Jan-23	Jun-26	42	$71,429	$71,429	$71,429	$71,429	$71,429	$71,429	$71,429	$71,429	$71,429	$71,429	$71,429	$71,429	$857,143	$2,142,857
31	Other Expense 1	$1,000,000	Jan-23	Dec-28	72	$13,889	$13,889	$13,889	$13,889	$13,889	$13,889	$13,889	$13,889	$13,889	$13,889	$13,889	$13,889	$166,667	$833,333
32	Other Expense 2	$1,000	Jan-23	Apr-23	4	$250	$250	$250	$250	$0	$0	$0	$0	$0	$0	$0	$0	$1,000	$0
33	Other Expense 3	$200,000	Jan-23	Jun-30	90	$2,222	$2,222	$2,222	$2,222	$2,222	$2,222	$2,222	$2,222	$2,222	$2,222	$2,222	$2,222	$26,667	$173,333
34	Other Expense 4	$350,000	Jan-23	Mar-25	27	$12,963	$12,963	$12,963	$12,963	$12,963	$12,963	$12,963	$12,963	$12,963	$12,963	$12,963	$12,963	$155,556	$194,444
35	Other Expense 5	$3,250,000	Jan-23	Mar-29	75	$43,333	$43,333	$43,333	$43,333	$43,333	$43,333	$43,333	$43,333	$43,333	$43,333	$43,333	$43,333	$520,000	$2,730,000
36	Other Expense 6	$1,000	Jan-23	Jan-32	109	$9	$9	$9	$9	$9	$9	$9	$9	$9	$9	$9	$9	$110	$890
37	TOTAL	$8,006,000				$166,451	$166,451	$166,451	$166,451	$166,201	$166,201	$149,534	$149,534	$149,534	$149,534	$149,534	$149,534	$1,895,409	$6,110,591
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