A PERSON REQUIRED TO DO SOME FINANCIAL ANALYSIS .
Budget ₹1500-12500 INR
Assignment tasks
Select a company listed on an internationally recognised and well- established Stock Exchange (see below for choice of company):
Discuss how successful the company has been at delivering value to its shareholders over the past 5 years.
Complete an EVA analysis of your company for the last 3 years. Clearly show your work rather than using final EVA numbers from another source. show how did you calculate the Beta for the last 3 years with chart illustration.(SLOPE regression analysis)
Analyse the Total Shareholder Return (TSR) of the company for the past 5 years, including any key events and compare with a similar company or appropriate benchmark. chart illustration for TSR over 5 years comparing your company with 2 competitors.
Undertake a current valuation of the equity in this company, using the following methods:
Net Asset Value.
Comparable Ratios (e.g. P/E, P/B, EV/EBITDA). You will need to look at both past results and comparable firms to analyse and justify an appropriate valuation. Note that simply multiplying the current ratio by the recent earnings (or book value or EBITDA) is not sufficient. Ratios has to be compared vs competitors as well as industry average (in this case industry is Consumer goods)
Discounted Free Cash Flow. You will need to forecast each component of free cash flow (e.g. Sales, costs, capex, etc.) for at least 5 years of forecast cash flows and estimate a terminal value, and then discount them back at the appropriate cost of capital which you estimate yourself. Make sure to justify all of your assumptions. You can find information to support your forecasts from sources including the MD&A section of the company’s annual report (or its competitors), news stories, industry trade publications and government or think tank studies on the industry. Videos on how to estimate cost of capital and how to forecast free cash flow can be found in Canvas under the appropriate Unit.
Attempt to reconcile any differences in value that you obtain by using these different methods and state (with reasons) what value you think is correct for the company.
You must clearly explain all of your assumptions used in the valuations.
Guidelines
The report should include:
Brief introduction on the company (not more than 200 words)
a key point summary of your conclusions
graphical illustration, where appropriate
a bibliography of sources of information used and references to texts or other material drawn upon. You should follow Harvard referencing guidelines.
detailed tables, extracts or copies of financial information should be placed in the appendices if they are necessary to understand your report. You should only include appendices if you refer to them in the body of the report. You do not need to include the entire financial statements.
You should not embed spreadsheets in the Word document as they will not be seen by the marker. You should only copy those tables which are important for the reader to understand your work.
Financial data available includes the FAME (Financial Analysis Made Easy) database. Other special reports, for example, Company Focus, are available from the Financial Times Share Service, or brokers’ circulars issued from time to time by the broking arm of numerous finance houses. Data can also be found online from the company websites, [login to view URL], [login to view URL] and other internet sources.
23 freelancers are bidding on average ₹12659 for this job
Hi I'm Venkat. I'm an financial analyst and I have been working as an analyst for over 4+ years. I have a good reputation as an analyst. I'm looking forward to put together my best qualities to good use in fulfillin More
Hi there, I believe to be a perfect fit to help you with your FINANCIAL ANALYSIS project if you are looking for professional work. Please find below my relevant experience and qualifications for your review: U More
Hello. I am Edgar Díaz. I am Urban Planner With a MBA and Specialist in Project Management (PMI) I can handle many Financial, administrative, Econometric and Mathematical softwares (MSProject, Primavera, Simul8, Excel, More
Dear Client My name is Aditya Thakur and I have done Btech and MBA in Corporate Strategy from the world’s most famous and renowned institutes. I am an expert in Business Analysis, Financial Analysis and Accounting. I More
I have a good hands on working with Advanced Excel, R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboards and Web Application. My ar More
Am a certified financial analyst with extensive experience in accounting and finance management. I hold a bachelors of science degree in Actuarial science and a CPA(K). Kindly indulge me we discuss further.
The financial analysis and valuation is my preferred area of work as it gives me an upper edge to utilize my knowledge and experienced based learning that I have acquired over the years. the ratio analysis is easy on More
I am a CFA and FRM. I am quoting low because i am new here at freelancer. I have a decade experience of equity research.
Hi, I'm doing MBA in financial markets from University school of management studies, GGSIPU . I'VE done these types of work before and I'm confident that it can be done on time with ease by me. Relevant Skills and Exp More
1. Knowledge of research method in accounting, financial, management and economic field. 2. Editor Research paper in accounting, financial, management and economic field (by Arabic, Persian, and English language). More
Hi There, I am a business consultant with expertise in data analysis including company financials. This engagement will take 5 days and I’d want to have a daily review with you ( if suitable with you, I’m sure we can More
I am a Cost and Management Accountant having more than 8 years of experience in preparing Financial Statements. I am new here but have knowledge and confidence to complete your task with 100% accuracy with low cost.
