Walkthrough Financial Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJK
1
Unit EconomicsConservative Annual Cashflow
2
Listing Unit Economics12 Mo. AvgAssumptionYear20182019202020212022
3
Average price per listing over the last 3 months$152.00
Gross Sales
$483,777.70$768,602.38$1,674,872.67$6,978,937.10$26,138,183.20
4
Matterport Processing Fee (Should be eliminated by January)$21.00
Gross Expenses
$595,778.63$1,593,796.42$2,118,168.31$5,996,493.08$17,982,617.98
5
Stripe Processing Fee$4.62Net Cash Flow from Operations-$112,000.94-$825,194.04-$443,295.64$982,444.02$8,155,565.22
6
Photo Processing Cost (Currently automating with Machine Learning)$12.00Equity Financing$1,520,000.00$0.00$0.00$0.00$0.00
7
Avg fee paid to photographers$58.00
8
Server costs per home$2.50
Beginning Cash Balance
$30,000.00$1,145,186.16$319,992.12-$123,303.51$859,140.51
9
^^Need to verify
Ending Cash Balance$1,145,186.16$319,992.12-$123,303.51$859,140.51$9,014,705.73
10
Lowest Balance Of The Year$57,552.00$319,992.12-$123,303.51-$235,681.53$951,537.82
11
12
City Count252580200
13
Months of Runway21
14
Photographer Hiring Model
15
Avg. # of homes/mo a photographer20
16
Onboarding photographer costs (Background Check + 2x Shirts + Matterport + Ipad)
$400.00
17
18
19
20
21
City Scaling Assumptions
22
Team Growth
23
Cities per engineer5
24
Cities per operations/marketing5
25
Cities per customer support2
26
Cities per UX/UI5
27
28
Per City Growth Assumptions
29
Avg Listing Growth Per Month Per City119
30
31
Per City Costs Growth$1,620
32
Ad Budget for Facebook$500
33
Ad budget for Adwords$0
34
Budget for Webinars$1,000
35
Mailchimp$120
36
37
38
Employee Related
39
Monthly Expenses Per Employee$275
40
Dropbox$12
41
Google Email Accounts$5
42
Slack$7
43
Github$9
44
Misc. Software (Adobe Suite, Invision)$200
45
Hiscox Business Liability Insurance Per Month$42
<---Need to update
46
47
48
49
HQ Expenses
50
Initial Employee Onboarding (Laptop/Workspace/Shirts)$2,000
51
Budget per employee per retreat (flights/hotel/food/etc)$500
52
Accounting cost per month$500
53
Salesforce Cost
54
Zendesk Cost
55
56
Monthly HQ Expenses
57
Total$313
58
Ultradox (Floreysoft)$100.00
59
SendGrid$10.00
60
PostScanMail$35.00
61
Boomerang$15.00
62
Pipedrive$10.00
63
BuiltInColorado$65.00
64
HotJar$30.00
65
Docsend$15.00
66
Xero$30.00
67
Lastpass$2.50
68
69
Funding Assumptions
70
Capital Raised
71
Seed (July 2018)$1,400,000
72
Series A (July 2020)
73
74
Seasonality
75
January150%
76
February100%
77
March100%
78
April100%
79
May100%
80
June110%
81
July110%
82
August100%
83
September100%
84
October80%
85
November80%
86
December70%
87
88
89
Loading...
 
 
 
Assumptions & Unit Economics
Conservative-Staffing & City Forcasting Plan
Burnrate
Historical Metrics
Compensation
Frameworks
 
 
Main menu