I have some work, in an Excel spreadsheet. Financial Analysis Project
On your first job assignment as an equity analyst, you need to analyze one of two companies: Alphabet, Inc. (GOOG) or Facebook (FB).
Please complete the following tasks:
1. Download the annual income statements, balance sheets, and cash flow statements for the last 4 fiscal years from Google, SEC Website, Annual reports, MarketWatch or other site. Enter each company's stock symbol and then go to "financials". Copy and paste the financial statements into Excel. You can also use a subscription software, such as CapitalIQ, and utilize the Excel plug-in.
2. Find historical stock prices for each firm (Yahoo! Finance, [login to view URL] is one site that has this information). Enter the stock symbol, click on "historical prices" in the left column, and enter the proper date range to cover the last day of the month corresponding to the date of each financial statement. Use the closing stock prices (not the adjusted close). To calculate the firm's market capitalization at each date, multiply the number of shares outstanding (see "Basic Weighted Shares Outstanding") by the firm's historic stock price.
3. For each for the 4 years of statements, compute the following ratios for each firm:
Valuation Ratios
Price-earnings ratio (for EPS use diluted EPS total)
Profitability Ratios
Operating margin (Use operating income after depreciation)
Net profit margin
Return on equity
Financial Strength Ratios
Current ratio
Deb-equity ratio (indicate Book or Market)
4. Obtain industry averages for each firm from [login to view URL] ([login to view URL]). Enter the stock symbol at the top of the page in the "Symbol lookup" and then click on the "Financials" button, and then click on "Search". Scroll down to "Valuation ratios", and compare the firm's ratios to the available industry ratios for the most recent year. (Ignore the "Company" column as your calculations will be different.) Comment on each firm's valuation compared to its industry.
5. Analyze the performance (from profitability ratios) of each firm versus its industry and comment on any trends in each individual firm's performance.
6. Identify any strengths or weakness you find in each firm.
Notes:
The statements from MarketWatch seem to group things differently: For example, in their gross profit ("gross income") calculation, they include depreciation & amortization under COGS.
To calculate operating income, you don't have to subtract D&A again since it's already reflected in "gross income". What you need to do is to take out "SG&A expense" and "other operating expense" to get operating income. Some of you get negative operating income, because you subtracted SG&A, R&D, and other SG&A from gross income. But actually SG&A is the sum of R&D, and other SG&A.
Sorry for the confusion. If you found a clearer format of financial statements for the two companies, feel free to use them. I don't really care of the source of information, as long as they are official!
Points breakdown (20 points)
#1: 4
#2: 3
#3: 6
#4: 3
#5: 4
#6: 4
Dear Sir/Ma'am,
I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements.
I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet.
I am ready to hear the details of the project more in detail now.
I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price.
If you have questions or doubts about anything, please feel free to ask me.
Sincerely,
Mir
Being a long time investor I have knowledge of Balance Sheets Analysis. I have regularly used Google & Yahoo to monitor stock prices. I had created macros to chart live prices. These however are no longer required as Google provides live charts for NSE & BSE. I have not used subscription software, used only what is freely available. I expect to to a good job of your project
Hi, I am a professional freelancer with MBA, and I have done ratio analysis. I can complete your task effectively and efficiently in a timely manner. I can show you the analysis I had done for my client.
*****
Hello,
I would like to complete your project. Please reply to me on PM for more discussion.
If you want to know about my experience, Please visit -https://www.freelancer.com/u/sajibdigital.html
Thanks,
Sajib
Hey. This is an easy task. I am a financial analyst. I specialize in the US stock market. I would be interested to work with you. This is a test job? If so, how do I send it to you?
Dear Sir/Madam,
I am reasonably aware of your project. I have been experienced as a Financial Analyst in a Brokerage house. I am sure; I would be your right choice. I am dedicated and passionate about my work to provide responsible, quality work. Good Communication availability and timely work to my recipient.
Regards,
Asad Ur Rahman
Hi,
Am ready and willing to complete this project for you within time. Am a long time experienced guy in this field and therefore promising you a 100 % satisfaction of your project. Feel free to get in touch with me and lets start off. Kind regards, Samuel
HI
I am Sam though new to freelancer but working at upwork from 6 years
I have team of Professionals who will deliver your task on time
give chance
Thanks
I believe that I am the best candidate for this position because of my experience in data entry and my ability to adapt to any situation. I have a passion for success and goal oriented demeanor that would push me to accomplish my set tasks. Also, with my personable character I can work well and communicate with others to contribute to team efforts. In all I feel that my previous work experience proves that.
My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
I am a Responsible worker/staff. I take my job as my responsibility. I am fast learner, Can do Multi tasking, Proactive, and has initiative towards work.
I have respect with my colleagues and boss.