This could take a minute...
test
By: James Ashley
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...
Inputs | |
---|---|
Starting State | |
cash_in_bank | $0.00 |
assets | $0.00 |
liabilities | $0.00 |
customer_count | 0 |
Product | |
realization_rate | 93.0 % |
price_of_offer | $5,000.00 |
cost_to_fulfill | 10.0 % |
time_to_collect | 300 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 | $7,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 | 20 Days |
average_deals_per_sales_rep_per_month | 1.0 |
Granular | |
granular | true |
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 | $0.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 | $903.03 |
@cost_to_sell_dollars | $677.27 |
@customer_acquisition_cost | $1,580.30 |
@expected_value_of_renewal_price | $6,321.21 |
@cost_to_fulfill_renewal_dollars | $700.00 |
@lifetime_value | $11,160.00 |
Renewals | |
@cost_to_sell_renewal_dollars | $700.00 |
@renewal_profit_per_customer_per_day | $164.04 |
@renewal_profit_per_customer_per_month | $4,988.47 |
Business Modelling | |
Granular | |
Blended | |
@customer_acquisition_cost | $1,580.30 |
@contribution_after_marketing | $2,483.33 |
@contribution_margin_before_marketing | 90.0 % |
@contribution_margin_after_marketing | 55.0 % |
@profit_per_customer_per_day | $7.71 |
@customer_acquisition_rate_per_day rounded | 0.13 Customers |
@customer_acquisition_rate_per_month rounded | 4.0 Customers |
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 | $457.83 |
@int_fct_projection_period | $172,526.84 |
@terminal_value | $2,274,733.59 |
@int_pv_fcf_projection_period | $449,941.36 |
@DCF_enterprise_value | $2,724,674.95 |
@DCF_equity_value | $2,724,674.95 |
@number_of_shares (input) | 1,000,000 Shares |
@share_price | $2.72 |
@ebitda_multiple_market_cap | $2,699,732.93 |
@ebitda_multiple_market_cap_fcf | $3,235,472.22 |
@pe_multiple_market_cap | $6,625,192.44 |
@ev_revenue_multiple_market_cap | $2,108,015.78 |
@c_consumption | $54,172.47 |
@t_profitability_day | 366 Days |
@t_profitability_month | 13 Months |
@positive_total_cash_day | 605 Days |
@positive_total_cash_month | 20 Months |
@cash below $0 day | Day 1 |
@additional_debt | -$54,172.47 |
@return_on_starting_cash_day_365 |