This could take a minute...
Test 4
By: Tran Manh Duc
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 | $100,000.00 |
assets | $200,000.00 |
liabilities | $1,000.00 |
customer_count | 100 |
Product | |
realization_rate | 93.0 % |
price_of_offer | $5,000.00 |
cost_to_fulfill | 10.0 % |
time_to_collect | 90 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 | 2.0 |
Granular | |
granular | true |
Organic | |
organic_views_per_month | 5000 |
organic_view_to_lead_conversion_rate | 30.0 % |
lead_to_customer_conversion_rate_organic | 20.0 % |
time_to_market_organic | 30 Days |
organic_cost_per_month | $0.00 |
Administration | |
transaction_fee | 1.0 % |
fixed_costs_per_month | $100.00 |
fixed_cost_increase_per_hundred_customers per month | $2.00 |
upfront_investment_costs | $20.00 |
debt | $50.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,603.50 |
@cost_to_fulfill_dollars | $460.35 |
@cost_to_market_dollars | $0.00 |
@cost_to_sell_dollars | $690.53 |
@customer_acquisition_cost | $690.53 |
@expected_value_of_renewal_price | $6,444.90 |
@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 | $168.16 |
@renewal_profit_per_customer_per_month | $5,113.85 |
Business Modelling | |
Granular | |
Organic | |
@organic_views_per_day per day | 164.42 |
@organic_views_per_month per month (input) | 5000 |
@lead_dot_organic per day | 49.33 Leads |
@lead_dot_organic per month | 1500.0 Leads |
@c_dot_organic per day rounded | 9.87 Customers |
@c_dot_organic per month rounded | 300.0 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 | 49.33 Leads |
@blended_lead_dot per month | 1500.0 Leads |
@outbound_lead_ratio | 0.0 % |
@inbound_lead_ratio | 0.0 % |
@organic_lead_ratio | 100.0 % |
@blended_cost_per_lead | $0.00 |
@blended_lead_conversion_rate | 20.0 % |
@c_dot_blended per day rounded | 9.87 Customers |
@c_dot_blended per month rounded | 300.0 Customers |
@time_to_market_blended | 30.0 Days |
@cost_to_market_blended | $0.00 |
@customer_acquisition_cost | $690.53 |
@contribution_after_marketing | $3,452.63 |
@contribution_margin_before_marketing | 90.0 % |
@contribution_margin_after_marketing | 75.0 % |
@profit_per_customer_per_day | $24.66 |
@customer_acquisition_rate_per_day rounded | 9.87 Customers |
@customer_acquisition_rate_per_month rounded | 300.0 Customers |
@sales_reps_needed | |
Administration | |
@fixed_costs_per_day | $3.29 |
@fixed_costs_per_month (input) | $100.00 |
@fixed_cost_increase_per_hundred_customers_per_day | $0.07 |
@cost_of_debt_daily | $0.01 |
@cost_of_debt_monthly | $0.25 |
Valuations | |
@projection_period_dcf (input) | 1,825 Days |
@fct_projection_period | -$3.30 |
@int_fct_projection_period | -$1,204.42 |
@terminal_value | -$15,880.05 |
@int_pv_fcf_projection_period | $153,910.00 |
@DCF_enterprise_value | $138,029.95 |
@DCF_equity_value | $436,979.95 |
@number_of_shares (input) | 1,000,000 Shares |
@share_price | $0.44 |
@ebitda_multiple_market_cap | $283,772.35 |
@ebitda_multiple_market_cap_fcf | $434,444.89 |
@pe_multiple_market_cap | $298,950.00 |
@ev_revenue_multiple_market_cap | $298,950.00 |
@c_consumption | $0.00 |
@t_profitability_day | 1 Day |
@t_profitability_month | 1 Month |
@positive_total_cash_day | 0 Day |
@positive_total_cash_month | 0 Month |
@cash below $0 day | Cash is never $0 |
@additional_debt | No additional debt needed |
@return_on_starting_cash_day_365 |