Excel Spreadsheet statistician or actuary
Budget: $30 – $250 AUD
I need a skilled statistician or actuary to build an excel or google style sheet or form with simple set inputs for users and graphs showing assumptions based on building a recurring revenue on a monthly basis over 36 months with an assumed growth rate and less a churn rate. I'd like 2 versions, one for ourselves and another for end users to only use the input fields. Likely 2-3 hours work and needed asap.
https://halgatewood.com/mrr/ - this is a basic version, i need this plus additional income streams.
4 x income streams - each with their own growth and churn rate
1 x asset value for the assumed income stream
There are 4 x income streams, this is an example of 1 income stream
1. SUBSCRIPTION VALUE IE. $100
2. NEW SUBSCRIPTIONS PER MONTH IE. 20
3. MULTIPLIED BY THE PERCENTAGE RETAINED OF THE GROSS SUBSCRIPTION VALUE IE. ($100 X 20) X50%
4. PLUS MONTHLY GROWTH RATE IE. 2% OR 24% PA
5. LESS MONTHLY CHURN RATE IE. 0.7% OR 8.4% PA
= ASSUMED MONTHLY NEW VALUE
Output should be monthly over 36 months minimum.
https://halgatewood.com/mrr/ - this is a basic version, i need this plus additional income streams.
4 x income streams - each with their own growth and churn rate
1 x asset value for the assumed income stream
There are 4 x income streams, this is an example of 1 income stream
1. SUBSCRIPTION VALUE IE. $100
2. NEW SUBSCRIPTIONS PER MONTH IE. 20
3. MULTIPLIED BY THE PERCENTAGE RETAINED OF THE GROSS SUBSCRIPTION VALUE IE. ($100 X 20) X50%
4. PLUS MONTHLY GROWTH RATE IE. 2% OR 24% PA
5. LESS MONTHLY CHURN RATE IE. 0.7% OR 8.4% PA
= ASSUMED MONTHLY NEW VALUE
Output should be monthly over 36 months minimum.