This could take a minute...
Model 2 db
By: David Brandt
Scroll on charts to zoom.
Click and drag to pan.
Zooming is slower the greater number of datapoints visible.
Click Legend to Hide Data
Click and drag to pan.
Zooming is slower the greater number of datapoints visible.
Monthly Free Cash Flow vs. Time
Loading...
Revenue, Earnings, Cash, Tax vs. Time
Loading...
Customers vs. Time
Total amount of customers through time.
Loading...
New Renewal Customers vs. Time
Loading...
Share Price vs. Time - starting day 365
Click Legend to Hide DataLoading...
New Outbound Customers vs. Time
Loading...
Inputs | |
---|---|
Starting State | |
cash_in_bank | $20,000.00 |
assets | $0.00 |
liabilities | $0.00 |
customer_count | 1 |
Product | |
realization_rate | 93.0 % |
price_of_offer | $5,000.00 |
cost_to_fulfill | 10.0 % |
time_to_collect | 365 Days |
refund_period | 60 Days |
refund_rate | 2.0 % |
initial contract length/time to renew | 365 Days |
Renewals | |
churn_rate | 50.0 % |
price_of_renewal | $5,000.00 |
cost_to_sell_renewal | 10.0 % |
cost_to_fulfill_renewal | 10.0 % |
time_to_collect_renewal | 30 Days |
renewal_rate_of_renewals | 50.0 % |
Sales and Martketing | |
cost_to_sell | 15.0 % |
time_to_sell | 10 Days |
average_deals_per_sales_rep_per_month | 6.0 |
Granular | |
granular | true |
Outbound | |
outbound_salary | $0.00 |
number_of_contacts_per_month per sdr | 1000 |
number_of_sdrs | 1 |
outbound_contact_to_lead_conversion_rate | 1.0 % |
time_to_market_outbound | 7 Days |
lead_to_customer_conversion_rate_outbound | 5.0 % |
Administration | |
transaction_fee | 2.9 % |
fixed_costs_per_month | $10,000.00 |
fixed_cost_increase_per_hundred_customers per month | $0.00 |
upfront_investment_costs | $10,000.00 |
debt | $0.00 |
interest_rate | 6.0 % |
Viral Component | |
viral_component | false |
Valuations | |
tax_rate | 22.0 % |
inflation_rate | 2.0 % |
time_max | 2500 Days |
number_of_shares | 1,000,000 Shares |
DCF Method | |
projection_period_dcf | 1825 Days |
discount_rate | 9.0 % |
growth_rate | 2.0 % |
EBITDA Multiple Method | |
enterprise_multiple_ebitda | 14.0 |
projection_period_ebitda | 1825 Days |
P/E Method | |
pe_multiple | 22.0 |
projection_period_pe | 1825 Days |
Revenue Multiple Method | |
ev_revenue_multiple | 7.0 |
projection_period_ev_revenue | 1825 Days |
Outputs | |
---|---|
Product and Acquisition | |
@expected_value_of_offer_price | $4,515.15 |
@cost_to_fulfill_dollars | $451.52 |
@cost_to_market_dollars | $0.00 |
@cost_to_sell_dollars | $677.27 |
@customer_acquisition_cost | $677.27 |
@expected_value_of_renewal_price | $4,515.15 |
@cost_to_fulfill_renewal_dollars | $500.00 |
@lifetime_value | $9,300.00 |
Renewals | |
@cost_to_sell_renewal_dollars | $500.00 |
@renewal_profit_per_customer_per_day | $117.17 |
@renewal_profit_per_customer_per_month | $3,563.19 |
Business Modelling | |
Granular | |
Outbound | |
@outbound_salary_per_day | $0.00 |
@number_of_contacts_per_day_per_sdr | 32.88 Contacts |
@total_salary per day | $0.00 |
@cost_per_100_contacts | $0.00 |
@outbound_contacts_dot per day | 32.88 Contacts |
@cost_per_lead_outbound | $0.00 |
@lead_dot_outbound per day | 0.33 Leads |
@lead_dot_outbound per month | 10.0 Leads |
@c_dot_outbound per day rounded | 0.02 Customers |
@c_dot_outbound per month rounded | 0.5 Customers |
@outbound_cost_per_customer | $0.00 |
Blended | |
@blended_lead_dot per day | 0.33 Leads |
@blended_lead_dot per month | 10.0 Leads |
@outbound_lead_ratio | 100.0 % |
@inbound_lead_ratio | 0.0 % |
@organic_lead_ratio | 0.0 % |
@blended_cost_per_lead | $0.00 |
@blended_lead_conversion_rate | 5.0 % |
@c_dot_blended per day rounded | 0.02 Customers |
@c_dot_blended per month rounded | 0.5 Customers |
@time_to_market_blended | 7.0 Days |
@cost_to_market_blended | $0.00 |
@customer_acquisition_cost | $677.27 |
@contribution_after_marketing | $3,386.36 |
@contribution_margin_before_marketing | 90.0 % |
@contribution_margin_after_marketing | 75.0 % |
@profit_per_customer_per_day | $8.86 |
@customer_acquisition_rate_per_day rounded | 0.02 Customers |
@customer_acquisition_rate_per_month rounded | 0.5 Customers |
@sales_reps_needed | 1 |
Administration | |
@fixed_costs_per_day | $328.84 |
@fixed_costs_per_month (input) | $10,000.00 |
@fixed_cost_increase_per_hundred_customers_per_day | $0.00 |
@cost_of_debt_daily | $0.00 |
@cost_of_debt_monthly | $0.00 |
Valuations | |
@projection_period_dcf (input) | 1,825 Days |
@fct_projection_period | -$220.98 |
@int_fct_projection_period | -$80,090.46 |
@terminal_value | -$1,055,977.49 |
@int_pv_fcf_projection_period | -$413,177.54 |
@DCF_enterprise_value | -$1,469,155.03 |
@DCF_equity_value | -$1,449,155.03 |
@number_of_shares (input) | 1,000,000 Shares |
@share_price | -$1.45 |
@ebitda_multiple_market_cap | -$999,506.16 |
@ebitda_multiple_market_cap_fcf | -$1,430,400.44 |
@pe_multiple_market_cap | $800,673.87 |
@ev_revenue_multiple_market_cap | $268,396.23 |
@c_consumption | $581,308.08 |
@t_profitability_day | N/A |
@t_profitability_month | N/A |
@positive_total_cash_day | 0 Day |
@positive_total_cash_month | 0 Month |
@cash below $0 day | Day 32 |
@additional_debt | -$581,308.08 |
@return_on_starting_cash_day_365 |