+ Reply to Thread
Results 1 to 3 of 3

Excel math/formula question

  1. #1
    Registered User
    Join Date
    01-04-2019
    Location
    San Diego
    MS-Off Ver
    10
    Posts
    2

    Excel math/formula question

    Hi,

    I'm trying to model out the customer revenue stream for a business based on certain assumptions and was wondering if someone could help me with the same. I need to model out how much revenue the business will make (month-to-month) for a 7-year period given some assumptions around customer growth/churn and the business's subscription model. I've create a preliminary file but wanted to double check and would appreciate if someone could help me with a quick analysis of the same.

    Assumptions are as follows:
    Billing and Usage
    * Customers pay for unlimited storage in advance as follows: $5/month, $50/year (one payment every 12 months, on their annual anniversary of becoming a new customer) and $95/2-years (one payment every 24 months).
    * Signups are distributed amongst the 3 payment plans as follows: 70% monthly, 20% yearly and 10% 2-yearly
    * Renewing customers churn at an annualized rate of 10%/year

    Growth Rates
    * Start with 10,000 customers (assume same distribution as new signups), storing 1 TB each.
    * Add new customers at a rate of 2,000 customers/month.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Excel math/formula question

    We need something to work with (excel template)

  3. #3
    Registered User
    Join Date
    01-04-2019
    Location
    San Diego
    MS-Off Ver
    10
    Posts
    2

    Re: Excel math/formula question

    This is the excel template/calculation that I came up with. Can you let me know if it makes sense?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 11-25-2018, 03:50 PM
  2. [SOLVED] Excel/Math question
    By natetheblade in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-19-2013, 04:56 PM
  3. Replies: 3
    Last Post: 07-10-2013, 06:06 PM
  4. An Excel math question
    By nohotash in forum Excel General
    Replies: 4
    Last Post: 03-05-2010, 01:54 PM
  5. How do I ? math/excel question
    By Madduck in forum Excel General
    Replies: 3
    Last Post: 07-26-2006, 12:45 AM
  6. [SOLVED] Formula Question:don't mess up the math
    By dramajuana in forum Excel General
    Replies: 6
    Last Post: 07-21-2006, 06:50 PM
  7. Replies: 3
    Last Post: 02-16-2006, 07:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1