Fermé

Do some Excel Work - Data Entry for financial modelling

I require data entry for the financials of a ASX listed company, Cabcharge Ltd. The stock code is CAB.

I require this to be done in excel spreadsheet in a specific format.

I have uploaded an example from another financial model which is how i wish this model to look.

Please change all the data to that relevant to CAB including segment revenue breakdowns and match all the different line items from the annual reports and company presentations.

I will require a detailed income statement, cash flow statement and balance sheet all dating back to 2013 and done in 1H, 2H and then Full year combined.

I will also require a valuation summary & annualised returns summary as shown in the example with all the relevant formulas linking up. Please dont worry about the peer analysis.

Full summary of what is required below:

Profit Loss

• As per company financials structure.

• Split into halves not full year only.

• Revenue growth rates.

• EBITDA margins.

• NPAT margins.

• Implied interest rate on debt.

• Tax rate.

Cash Flow Statement

• As per company financials structure.

• Cash flow from operations percentage conversion against EBITDA.

• Cash @ end of year must match with balance sheet cash amount.

Balance Sheet

• Structure as per company financials.

• Net debt figure.

Valuation

• ROE

• ROIC

• ROA

• Free Cash Flow Pre Expansion Capex Post Maintenance Capex to Market Cap

• Free Cash Flow Pre Expansion Capex Post Maintenance Capex to Enterprise Valuation

• EV

• EV/EBITDA

• EV/EBIT

• EPS

• EPS Growth

• PEG

• P/E

• Payout Ratio

• DPS

• Yield

Compétences : Saisie de Données, Traitement de Données, Excel

en voir plus : what is data structure in c, what is data structure, what is data in data structure, data entry, virtual assistant, data processing, excel, web scraping, finance, web search, financial analysis, what is a data structure in c, what is a data structure, what data structure, tax rates 2016, market analysis reports, line line segment, how data entry is done, excel work in company, excel for data analysis

Concernant l'employeur :
( 0 commentaires ) Sydney, Australia

Nº du projet : #10793096

20 freelance font une offre moyenne de $144 pour ce travail

vsolcorp

Hello, Sir I am from vSol CORP. We are 19 people team, worked on more than 500 completed projects. We provide round the clock service. Kindly interview us to review our competencies & hire us for best desired results. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(255 Commentaires)
7.7
facebooklikes007

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(126 Commentaires)
6.5
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 81 works on Freelancer where majori Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(114 Commentaires)
6.2
swatsgupts123

Dear Sir, I have gone through the attached excel sheet, yes i can see that all the requirement is already been made in this excel sheet for other company. i have to find the input that is required for company Cabcharg Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(59 Commentaires)
6.1
RRconsultant

Hi there, I am an equity research analyst with ~10 years experience in financial modeling. Besides the things asked for I can even provide a DCF valuation of the company. Look forward to hear back from you. Th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(36 Commentaires)
5.7
saranaone

I can complete your requirement ontime with good quality results. I have 30Hrs/week for you Thanks in advance!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(37 Commentaires)
5.2
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(39 Commentaires)
5.7
klnbala

Hi I am pleased to inntroduce myself as a finance and excel expert with good reviews in academic assignments, financial modelling and accounting. I have done more annual report analysis projects of ASX listed com Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(18 Commentaires)
4.5
ashoksharma1

Dear Sir/Madam, I am writing in response to your job offer. I am a Chartered Accountant student(currently in CA Final) from India and received my Bachelor of Commerce from University of Rajasthan.I worked for a C Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(6 Commentaires)
4.6
accountantshetty

I am an accountant with 15+ years of experience in UK statutory and management accounts. I am also an avid investor in stock market and have some experience in fundamental analysis. I will be able to do this as Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(17 Commentaires)
4.3
brtodi

This is a task which would need certain kind of intelligence. We understand the your requirement . Let us schedule a discussion. We would put a person who would ensure that your needs and deliverable can be interlinked Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(24 Commentaires)
5.1
swajantalukdar

Hello if you show me the process once exactly which formate and what you want then i can solve your problem perfectly. Regards Atiar Talukdar

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(20 Commentaires)
4.2
johnosullivan

A proposal has not yet been provided

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(3 Commentaires)
3.7
mubbarikali

I can do this very well. I do my work with 100% accuracy. Please read Reviews of my previous clients. ... I am a full time freelancer and have no other job of any kind. I really want to build a serious career on this Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(9 Commentaires)
2.5
vinay2929vw

As I am IT freelancer not much into finance and banking, but my better half is banker which she know all the financial and can assist you in your work. She had 9 years of experience with Top most bank I am placing Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
jahanzebabbasivw

Hello ! i am Chartered Accountant by profession ,i am looking for work hire me. I can Perform accounting and finance work which is listed below. 1 System Stup Up and Integration 2 Data entry 3 Repor Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
0.0
marianoaloi

I worked at planning area where I need made many excel spreadsheet with information of Projects, Resources Humans , Budgets , Costs, and others analytics informations. So , my experience is very good and can help i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
HelloASMWorld

Dear Buddy, I write in response to your ad seeking a Data Entry Clerk for your company. As a highly competent Data Entry Clerk, I would bring a friendly attitude, flexible schedule, and fast-paced typing abilities t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(1 Évaluation)
0.0
hladkym

I have extensive experience working with Excel and creating spreadsheets for company financials. Please contact me if you have any questions.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
sumaiya176

I have done both my Bachelor and Master in Finance. I worked as a researcher in a capital market brokerage house. I have experience of doing stock analysis and also I am an expert user of Excel.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0