Completed

Excel Spreadsheet statistician or actuary

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.

[login to view URL] - 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.

Skills: Excel, Statistics, Financial Accounting, Statistical Analysis

See more: can build front end excel spreadsheet, google finance data excel spreadsheet, finance yahoo google morningstar scrape excel spreadsheet, excel spreadsheet import data google finance, google finance export excel spreadsheet, insert google finance price excel spreadsheet, add google finance excel spreadsheet, upload excel spreadsheet find google page ranks urls, build widget excel spreadsheet, link excel spreadsheet google maps, put excel spreadsheet google docs, google calendar excel spreadsheet, build excel spreadsheet, convert excel spreadsheet macros google spreadsheet, excel spreadsheet macros google docs, google knowledge excel spreadsheet, build a price query website using an excel spreadsheet, google excel spreadsheet, Build an excel spreadsheet from existing excel data, build excel spreadsheet with forms

About the Employer:
( 10 reviews ) Belrose, Australia

Project ID: #31566501

Awarded to:

(90 Reviews)
5.8

25 freelancers are bidding on average $128 for this job

suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More

$500 AUD in 7 days
(143 Reviews)
7.2
daniyal3214

Hello, I will be glad to assist you with that. I am an experienced Financial Analyst and Excel expert holding years of experience in Financial Analysis, Financial Modeling and Corporate Finance. Lets discuss your proje More

$50 AUD in 1 day
(134 Reviews)
6.8
(121 Reviews)
6.6
(136 Reviews)
6.3
AccountantArman

Sir, I have over 7 years of experience in Excel I am Excel Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 4 years o More

$55 AUD in 2 days
(112 Reviews)
6.0
hamidr2020

Hi, My expertise includes Excel, Accounting, Finance and Analysis. I have read your requirements and checked the basic version ([login to view URL]). I am well versed with all the concepts and skills needed to More

$80 AUD in 1 day
(31 Reviews)
5.2
fastlabindia

Greetings!. I checked your EXCEL Design requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in Outlines in Excel, Templates,Sparklines ,Goal Seek and Solver, Pivot tables, Pivot More

$30 AUD in 2 days
(40 Reviews)
5.4
sobhad20

Hi, I am expert in Excel. I have gone through your project description and i am very much interested in doing your project. I am sure i'll exceed your expectation. Thank you

$200 AUD in 1 day
(62 Reviews)
4.4
hillaryjustin73

Hello, I am a Statistician with two plus years of experience, in statistical modeling BI reporting, data mining, data visualization on structed and and unstructured data to derive predictive business insight. Economet More

$90 AUD in 3 days
(13 Reviews)
4.3
(13 Reviews)
3.8
jacobkitema2021

AN EXPERT IN STATISTICS HELLO DEAR CLIENT, MASTER IN ENGINEERING AN STASTICS Hi there! Thank you for sharing your project requirement, I have carefully read the project description and I would like to take part in thi More

$140 AUD in 1 day
(4 Reviews)
3.1
utkarsh7238

Hey, I have read your requirements and I can do create two spreadsheet one for you and other for end users, I need to talk about your project Let's get connected on chat to discuss your project Thanks

$100 AUD in 2 days
(14 Reviews)
3.4
lechaantonov333

Hi! I'm interested in your project. I can help you with my skill and I have good experiences. I will finish it in time and do my best. Lets discuss more detail in private chat. Thanks for reading my bid.

$140 AUD in 7 days
(3 Reviews)
2.3
heemel25

Hey! Very recently you published a job. By reading the job post, I truly concern about the requirements. I am an SEO Expert with WordPress web developer and I have 8 years work experience about SEO and Wordpress. Pl More

$30 AUD in 30 days
(8 Reviews)
1.7
(3 Reviews)
1.1
piusmwene

I am a statistician by profession. I have more than two years of experience as a data analyst. I am proficient in the following software; SPSS, STATA, SAS, Jamovi, R/Rstudio, Minitab, and Excel. My tutoring method for More

$200 AUD in 7 days
(0 Reviews)
0.0
KK2195

hello I am so excited to do your job and I promise I will not disappointed to you. Jut give me a chance to prove me.

$151 AUD in 7 days
(0 Reviews)
0.0
Ankushkanoujia

Hello I am Ankush a daya entry expert. I have work experience of 7 years with excel. I am expert in excel. I can tour work perfectly

$140 AUD in 7 days
(0 Reviews)
0.0
VBAautomation

Hi, i hope you are doing well I am a professional on SQL server, Microsoft access, excel, PHP and also in power BI. I am doing this job since 2010. Give me the chance so that I can show you my skills through this proj More

$230 AUD in 5 days
(0 Reviews)
0.0
Skprajapti

I have a great knowledge of data entry. And I am a certified data entry operator. My honesty and hard work makes me able to complete this project. Give me a chance to prove myself.

$180 AUD in 1 day
(0 Reviews)
0.0