This could take a minute...
Magnitude Education (Updated VSL + Meta Ads)
By: Mahsun Avci
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 | 0 |
Product | |
realization_rate | 100.0 % |
price_of_offer | $10,000.00 |
cost_to_fulfill | 10.0 % |
time_to_collect | 10 Days |
refund_period | 14 Days |
refund_rate | 0.92 % |
initial contract length/time to renew | 365 Days |
Renewals | |
churn_rate | 50.03 % |
price_of_renewal | $5,000.00 |
cost_to_sell_renewal | 0.0 % |
cost_to_fulfill_renewal | 0.0 % |
time_to_collect_renewal | 1 Days |
renewal_rate_of_renewals | 30.0 % |
Sales and Martketing | |
cost_to_sell | 0.0 % |
time_to_sell | 5 Days |
average_deals_per_sales_rep_per_month | 1.0 |
Granular | |
granular | true |
Inbound | |
media_spend | $15,000.00 |
Cost per thousand impressions | $9.94 |
Click-through rate | 1.3 % |
funnel_conversion_rate | 2.0 % |
time_to_market_inbound | 10 Days |
lead_to_customer_conversion_rate_inbound | 15.0 % |
Organic | |
organic_views_per_month | 10000 |
organic_view_to_lead_conversion_rate | 0.044 % |
lead_to_customer_conversion_rate_organic | 40.0 % |
time_to_market_organic | 30 Days |
organic_cost_per_month | $0.00 |
Administration | |
transaction_fee | 2.9 % |
fixed_costs_per_month | $33,000.00 |
fixed_cost_increase_per_hundred_customers per month | $0.00 |
upfront_investment_costs | $0.00 |
debt | $0.00 |
interest_rate | 6.0 % |
Viral Component | |
viral_component | false |
Valuations | |
tax_rate | 28.0 % |
inflation_rate | 2.0 % |
time_max | 1095 Days |
number_of_shares | 1,000,000 Shares |
DCF Method | |
projection_period_dcf | 498 Days |
discount_rate | 9.0 % |
growth_rate | 2.0 % |
EBITDA Multiple Method | |
enterprise_multiple_ebitda | 14.0 |
projection_period_ebitda | 500 Days |
P/E Method | |
pe_multiple | 22.0 |
projection_period_pe | 500 Days |
Revenue Multiple Method | |
ev_revenue_multiple | 7.0 |
projection_period_ev_revenue | 500 Days |
Outputs | |
---|---|
Product and Acquisition | |
@expected_value_of_offer_price | $9,710.00 |
@cost_to_fulfill_dollars | $971.00 |
@cost_to_market_dollars | $247.47 |
@cost_to_sell_dollars | $0.00 |
@customer_acquisition_cost | $247.47 |
@expected_value_of_renewal_price | $4,855.00 |
@cost_to_fulfill_renewal_dollars | $0.00 |
@lifetime_value | $13,569.29 |
Renewals | |
@cost_to_sell_renewal_dollars | $0.00 |
@renewal_profit_per_customer_per_day | $4,855.00 |
@renewal_profit_per_customer_per_month | $147,640.55 |
Business Modelling | |
Granular | |
Inbound | |
@media_spend_per_day | $493.26 |
@lead_dot_inbound per day | 12.9 Leads |
@lead_dot_inbound per month | 392.35 Leads |
@cost_per_lead_inbound | $38.23 |
@c_dot_inbound per day rounded | 1.94 Customers |
@c_dot_inbound per month rounded | 58.85 Customers |
@cost_per_click | $0.76 |
@inbound_cost_per_customer | $254.87 |
Organic | |
@organic_views_per_day per day | 328.84 |
@organic_views_per_month per month (input) | 10000 |
@lead_dot_organic per day | 0.14 Leads |
@lead_dot_organic per month | 4.4 Leads |
@c_dot_organic per day rounded | 0.06 Customers |
@c_dot_organic per month rounded | 1.76 Customers |
@organic_cost_per_month (input) | $0.00 |
@organic_cost_per_day | $0.00 |
@organic_cost_per_lead | $0.00 |
@organic_cost_per_customer | $0.00 |
Blended | |
@blended_lead_dot per day | 13.05 Leads |
@blended_lead_dot per month | 396.75 Leads |
@outbound_lead_ratio | 0.0 % |
@inbound_lead_ratio | 98.89 % |
@organic_lead_ratio | 1.11 % |
@blended_cost_per_lead | $37.81 |
@blended_lead_conversion_rate | 15.28 % |
@c_dot_blended per day rounded | 1.99 Customers |
@c_dot_blended per month rounded | 60.61 Customers |
@time_to_market_blended | 10.0 Days |
@cost_to_market_blended | $247.47 |
@customer_acquisition_cost | $247.47 |
@contribution_after_marketing | $8,491.53 |
@contribution_margin_before_marketing | 90.0 % |
@contribution_margin_after_marketing | 87.45 % |
@profit_per_customer_per_day | $339.66 |
@customer_acquisition_rate_per_day rounded | 1.99 Customers |
@customer_acquisition_rate_per_month rounded | 60.61 Customers |
@sales_reps_needed | 61 |
Administration | |
@fixed_costs_per_day | $1,085.17 |
@fixed_costs_per_month (input) | $33,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) | 498 Days |
@fct_projection_period | $14,805.18 |
@int_fct_projection_period | $5,541,528.43 |
@terminal_value | $78,574,411.51 |
@int_pv_fcf_projection_period | $5,881,191.39 |
@DCF_enterprise_value | $84,455,602.90 |
@DCF_equity_value | $84,455,602.90 |
@number_of_shares (input) | 1,000,000 Shares |
@share_price | $84.46 |
@ebitda_multiple_market_cap | $87,020,270.94 |
@ebitda_multiple_market_cap_fcf | $89,027,992.31 |
@pe_multiple_market_cap | $145,186,346.57 |
@ev_revenue_multiple_market_cap | $46,195,655.73 |
@c_consumption | $408.16 |
@t_profitability_day | 2 Days |
@t_profitability_month | 1 Month |
@positive_total_cash_day | 3 Days |
@positive_total_cash_month | 1 Month |
@cash below $0 day | Day 1 |
@additional_debt | -$408.16 |
@return_on_starting_cash_day_365 | 0.0 % |