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

 
View only
 
 
ABCDEFGH
1
Listing Unit EconomicsInputsOutputsNotesPer City & Per Month Growth
2
Average price per listing over the last 3 months$156.00Ad Budget for Facebook$250.00
3
Matterport Processing Fee$19Ad budget for Adwords$250.00
4
Stripe Processing Fee$4.62<--- Change to variable 2.9% + $0.30Total Ad Budget Per Month Per City$500.00
5
~ Gas Reimbursement Per Listing$6.36
6
Gross Expenses Per Listing$81.65Matterport, Stripe, Gas Reimbursement, Equipment Lease/#ofHomeAtFullCapacity & Labor/Listings@FullCapacityDailyMLS Conversion Rate4.13%
7
Variable Cost Per Listing (Paid)$29.98
8
Variable Cost Per Listing (Free)$25.36Organic Traffic Monthly Growth Rate
9
Direct Traffic Multiplier
10
PhotographerReferral Rate
11
Full Time Salary$27,500.00
12
% Raise After X Months3%Average Listings Per Month Per City4000
13
# of months photographer gets considered for a raise12Most Market Share We Can Achieve In A City w/ Photography50%
14
Average we reimburse per month for mileage$350.00
15
Contribution to benefits per month after 2 months of employment
$150.00
16
Average we pay for internet for photographer upload speed$50.00
17
Avg. # of homes/mo a photographer (last 3 months)55Last 3 Month Avg = 47.22Test Data (Part Time Photographer Scenario)
18
Max Listings Photographer Can Do Per Month60Equipment Finance247
19
Monthly financable equipement cost per photographer$247.00Matterport Camera Financed (needs to be updated)Salary (20hrs/mo)13750
20
Upfront Equipment Set Cost$500.00Camera Body + Lense + 2x Tripods (needs to be updated)Part TIme Photographer Cost Per Month (20 Hrs)$1,520.83
21
Paid Vacation & Sick Days Allowed15Gross Expenses Per Listing$85.29
22
Working Days Per Month22
23
One time photographer costs (Background Check + 2x Shirts)
$64.98Not in use yet
24
Working Days Per Month Including (Sick & Vacation Days)21
25
Cost to train photographer before they are on their own$1,461.22Not including trainer salary
26
Full time photographer cost per month$2,841.67Includes Benefits, Equipment Leases, Gas Reimbursement, Internet & Salary
27
28
Photography Training
29
# of photographers trainer can train @ once2
30
Days it takes to train a photographer5
31
# of photographers we can train in one month8
32
Cost of travel & accomodation for photographer training$900.00Flight Ticket of $500 Round Trip & $400 for hotel
33
Photographer Trainer Salary$50,000.00
34
35
36
Future Revenue
37
Revenue per 3D Model$500
38
Growth Rate of Buyers using VR Database (And getting the lead)
20%
39
Revenue per buyer lead$125
40
% of VR leads information we can sell25%
41
42
HQ Related
43
Amount contributed towards new employee equipment$1,000.00
44
Rent per employee$300.00
45
Accounting cost per month$250.00
46
HQ Travel Budget Per Month (Hotel & Airfare)$500.00
47
Monthly Dues/Memberships for Organizations$400.00
48
HQ Meals or Happy Hour per month alotment$500.00
49
# Of Homes Photo Processor Can Do Per Day50
50
# Of Homes Photo Processor Can Do Per Month1,038
51
52
Insurance
53
Hiscox Business Liability Insurance Per Month$42.00
54
55
Software Expenses (non variable)$100.00
56
Docsend per month$15.00
57
CRM Sofware (Highrise)$24.00
58
ScheduleOnce$19.00
59
ReBump$5.00
60
Github$7.00
61
Photoshop$30.00
62
Total Monthly Software Expenses
63
64
Software Expenses (Variable)
65
Mailchimp per city cost$120.00
66
Dropbox per every employee$12.00
67
Google Email Accounts per every employee$5.00
68
Server Costs Per Home$0.60
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
Loading...
 
 
 
Assumptions & Unit Economics
Investor Dashboard
Conversion Metrics
Staffing Plan
City Expansion
City Growth Model
Annual Cashflows
Monthly Cashflows
Annual Income Statement
Monthly Balance Sheet
Monthly Income Statement
Annual Balance Sheet
Sheet32
Burnrate