This could take a minute...
Saas Model - FB ads
By: Patrick Brennan
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 Inbound Customers vs. Time
Loading...
Inputs | |
---|---|
Starting State | |
cash_in_bank | $0.00 |
assets | $0.00 |
liabilities | $0.00 |
customer_count | 100 |
Product | |
realization_rate | 100.0 % |
price_of_offer | $300.00 |
cost_to_fulfill | 25.0 % |
time_to_collect | 42 Days |
refund_period | 1 Days |
refund_rate | 0.0 % |
initial contract length/time to renew | 30 Days |
Renewals | |
churn_rate | 1.0 % |
price_of_renewal | $300.00 |
cost_to_sell_renewal | 15.0 % |
cost_to_fulfill_renewal | 25.0 % |
time_to_collect_renewal | 1 Days |
renewal_rate_of_renewals | 99.0 % |
Sales and Martketing | |
cost_to_sell | 15.0 % |
time_to_sell | 5 Days |
average_deals_per_sales_rep_per_month | 2.0 |
Granular | |
granular | true |
Inbound | |
media_spend | $10,633.00 |
Cost per thousand impressions | $73.06 |
Click-through rate | 2.44 % |
funnel_conversion_rate | 5.0 % |
time_to_market_inbound | 1 Days |
lead_to_customer_conversion_rate_inbound | 2.26 % |
Administration | |
transaction_fee | 2.9 % |
fixed_costs_per_month | $3,000.00 |
fixed_cost_increase_per_hundred_customers per month | $2,800.00 |
upfront_investment_costs | $0.00 |
debt | $0.00 |
interest_rate | 0.0 % |
Viral Component | |
viral_component | false |
Valuations | |
tax_rate | 22.0 % |
inflation_rate | 8.0 % |
time_max | 1700 Days |
number_of_shares | 1,000,000 Shares |
DCF Method | |
projection_period_dcf | 1095 Days |
discount_rate | 9.0 % |
growth_rate | 2.0 % |
EBITDA Multiple Method | |
enterprise_multiple_ebitda | 14.0 |
projection_period_ebitda | 1095 Days |
Revenue Multiple Method | |
ev_revenue_multiple | 10.0 |
projection_period_ev_revenue | 1095 Days |
Outputs | |
---|---|
Product and Acquisition | |
@expected_value_of_offer_price | $291.30 |
@cost_to_fulfill_dollars | $72.83 |
@cost_to_market_dollars | $2,649.81 |
@cost_to_sell_dollars | $43.70 |
@customer_acquisition_cost | $2,693.51 |
@expected_value_of_renewal_price | $291.30 |
@cost_to_fulfill_renewal_dollars | $75.00 |
@lifetime_value | $30,000.00 |
Renewals | |
@cost_to_sell_renewal_dollars | $45.00 |
@renewal_profit_per_customer_per_day | $171.30 |
@renewal_profit_per_customer_per_month | $5,209.23 |
Business Modelling | |
Granular | |
Inbound | |
@media_spend_per_day | $349.65 |
@lead_dot_inbound per day | 5.84 Leads |
@lead_dot_inbound per month | 177.55 Leads |
@cost_per_lead_inbound | $59.89 |
@c_dot_inbound per day rounded | 0.13 Customers |
@c_dot_inbound per month rounded | 4.01 Customers |
@cost_per_click | $2.99 |
@inbound_cost_per_customer | $2,693.51 |
Blended | |
@blended_lead_dot per day | 5.84 Leads |
@blended_lead_dot per month | 177.55 Leads |
@outbound_lead_ratio | 0.0 % |
@inbound_lead_ratio | 100.0 % |
@organic_lead_ratio | 0.0 % |
@blended_cost_per_lead | $59.89 |
@blended_lead_conversion_rate | 2.26 % |
@c_dot_blended per day rounded | 0.13 Customers |
@c_dot_blended per month rounded | 4.01 Customers |
@time_to_market_blended | 1.0 Days |
@cost_to_market_blended | $2,649.81 |
@customer_acquisition_cost | $2,693.51 |
@contribution_after_marketing | -$2,475.03 |
@contribution_margin_before_marketing | 75.0 % |
@contribution_margin_after_marketing | -849.65 % |
@profit_per_customer_per_day | -$51.56 |
@customer_acquisition_rate_per_day rounded | 0.13 Customers |
@customer_acquisition_rate_per_month rounded | 4.01 Customers |
@sales_reps_needed | 3 |
Administration | |
@fixed_costs_per_day | $98.65 |
@fixed_costs_per_month (input) | $3,000.00 |
@fixed_cost_increase_per_hundred_customers_per_day | $92.07 |
@cost_of_debt_daily | $0.00 |
@cost_of_debt_monthly | $0.00 |
Valuations | |
@projection_period_dcf (input) | 1,095 Days |
@fct_projection_period | $268.32 |
@int_fct_projection_period | $107,978.47 |
@terminal_value | $1,237,713.27 |
@int_pv_fcf_projection_period | -$8,541.33 |
@DCF_enterprise_value | $1,229,171.94 |
@DCF_equity_value | $1,229,171.94 |
@number_of_shares (input) | 1,000,000 Shares |
@share_price | $1.23 |
@ebitda_multiple_market_cap | $1,217,773.31 |
@ebitda_multiple_market_cap_fcf | $1,363,311.51 |
@ev_revenue_multiple_market_cap | $1,925,742.33 |
@c_consumption | $159,552.07 |
@t_profitability_day | 48 Days |
@t_profitability_month | 2 Months |
@positive_total_cash_day | 1038 Days |
@positive_total_cash_month | 35 Months |
@cash below $0 day | Day 1 |
@additional_debt | -$159,552.07 |
@return_on_starting_cash_day_365 | 0.0 % |