Short Term Rental Spreadsheet for download - Stessa [VIEW ONLY - DOWNLOAD OR MAKE A COPY TO EDIT]

	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Short Term Rental Spreadsheet				Having trouble keeping this spreadsheet up to date? Let Stessa automate performance tracking for you: https://www.stessa.com/
2
3			Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
4
5	Revenues
6
7	Airbnb		$ 2,000.00	$ 2,500.00	$ 2,000.00										$ 6,500.00
8	Vrbo		$ 2,000.00	$ 2,500.00	$ 1,500.00										$ 6,000.00
9	Direct		$ 500.00	$ 1,000.00	$ 1,000.00										$ 2,500.00
10	Other		$ 200.00	$ 300.00	$ 250.00										$ 750.00
11	Total Revenues		$ 4,700.00	$ 6,300.00	$ 4,750.00	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 15,750.00
12
13	Performance Metrics
14
15	Available Nights		31	28	31
16	Booked Nights		17	18	17
17	Occupancy		55%	64%	55%	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
18	ADR		$ 276.47	$ 350.00	$ 279.41	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
19	RevPAR		$ 151.61	$ 225.00	$ 153.23	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
20
21	Unique Bookings		4	5	3
22	ALOS		4.25	3.60	5.67	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
23
24	Management	15%	$ 705.00	$ 945.00	$ 712.50	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 2,362.50
25	Booking Fees	5%	$ 235.00	$ 315.00	$ 237.50	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 787.50
26
27	Expenses
28
29	Electricity		$ 50.00	$ 50.00	$ 50.00										$ 150.00
30	Gas		$ 50.00	$ 50.00	$ 50.00										$ 150.00
31	Water		$ 50.00	$ 50.00	$ 50.00										$ 150.00
32	Sewer		$ 25.00	$ 25.00	$ 25.00										$ 75.00
33	Internet		$ 50.00	$ 50.00	$ 50.00										$ 150.00
34	Maintenance		$ 100.00	$ 100.00	$ 100.00										$ 300.00
35	Taxes		$ 100.00	$ 100.00	$ 100.00										$ 300.00
36	Insurance		$ 100.00	$ 100.00	$ 100.00										$ 300.00
37	HOA		$ 75.00	$ 75.00	$ 75.00										$ 225.00
38	Cleaning		$ 150.00	$ 150.00	$ 150.00										$ 450.00
39	Supplies		$ 200.00	$ 200.00	$ 200.00										$ 600.00
40	Towels/Linens		$ 100.00	$ 100.00	$ 100.00										$ 300.00
41	Welcome Gifts		$ 150.00	$ 150.00	$ 150.00										$ 450.00
42	Other														$ -
43	Other														$ -
44	Other														$ -
45	Total Expenses		$ 2,140.00	$ 2,460.00	$ 2,150.00	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 6,750.00
46
47	Net Operating Income		$ 2,560.00	$ 3,840.00	$ 2,600.00	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 9,000.00
48
49	Mortgage		$ 1,500.00	$ 1,500.00	$ 1,500.00										$ 4,500.00
50
51	Cash Flow		$ 1,060.00	$ 2,340.00	$ 1,100.00	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 4,500.00
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