Find Jobs
Hire Freelancers

Do some data entry

$250-750 USD

Closed
Posted over 7 years ago

$250-750 USD

Paid on delivery
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
Project ID: 11545657

About the project

29 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
29 freelancers are bidding on average $470 USD for this job
User Avatar
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
$300 USD in 10 days
4.9 (190 reviews)
7.1
7.1
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$300 USD in 4 days
5.0 (167 reviews)
6.6
6.6
User Avatar
Dear Employer, Ajharul here, I'm specialized in the area of Web Designing, Researching, Web Scraping services. I've completed more then 120+ projects with positive feedback. I've read the project, fully confident to take the responsibility as per your requirements. Please feel free to contact with me. Thank you!
$250 USD in 10 days
4.9 (101 reviews)
6.0
6.0
User Avatar
Dear Sir, I am an MBA having hands on expertise on financial analysis as well as having experience of data gathering from yahoo, google, morning star fro financial analysis. Best regards
$444 USD in 10 days
4.7 (8 reviews)
3.9
3.9
User Avatar
Hello, I am an excel data entry and research freelancer. I read though the full job details extremely carefully and I am absolutely sure that I can complete this project on time and within your budget just as provided in description. Product description is really interesting to work on and I know that I will enjoy in working on this job, analyst and Excel combined is my passion. You can check my profile, all of my clients were 100% satisfied with my work so you have no worries about job completion. I can do it on time and within your budget. I hope you'll like my profile and services, I look forward to your response. Thank you!
$250 USD in 10 days
4.9 (19 reviews)
3.6
3.6
User Avatar
Hello how are you? I'm Noelia Delgadillo and I'm an English-Spanish Translator. I've studied English for a lot of years. Also, I'm an Accountant student and I always use Excel and PowerPoint. I would like to work on your project. Thanks
$250 USD in 5 days
5.0 (1 review)
1.4
1.4
User Avatar
Hello, Thank you for this wonderful opportunity. Your job post has caught my attention because I'm a web-research addict and I’m considering your job post for me with the required capabilities. I have excellent experience in web research, data mining, extracting email address and other related contact information of any business and personals, searching in Google, Bing and Yahoo search engines. I use some secret and useful search engine keywords tricks in order to extract the exact and required information. I have excellent experience in managing the extracted data in MS Excel, MS Work, Google Docs, Google Spreadsheet, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. I am mostly online at Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Hridoy
$250 USD in 10 days
1.1 (9 reviews)
3.7
3.7
User Avatar
Hi! My name is Kaycelyn. I am pretty good in Data Entry / VA, and I can say that Data Entry is my passion. 5 years working experience in Admin Office / Data Entry. I can say my knowledge and skills are perfectly fit for this job. I am hardworking and fast learner. My typing speed is 60WPM with accuracy. Proficient in Microsoft Office, Microsoft Outlook, Internet Explorer and Google Docs. Knowledgeable in Photo Editing using Adobe Photoshop. I also have experience in Product Sourcing / Product Listing in Amazon Marketplace. Knows how to use Amazon Seller Central, Ecom Solutions and Merchantwords. I always put my full effort and time in everything I do. Hoping to be part of your company. Thank you Skype ID: kheizziegamboa Kaycelyn Gamboa
$555 USD in 10 days
5.0 (2 reviews)
0.4
0.4
User Avatar
Hello, i'm David with mallardsite web design and software development group. We've taken a close look at your project. I'm using this medium to promise you that we'll never disappoint you and we'll get the project done within the stipulated time assuming the project can be started as soon as possible. Thank you for your time, David.
$611 USD in 10 days
0.0 (1 review)
0.0
0.0
User Avatar
I am an excellent date capturer with a financial background. On a personal level, I am dedicated and very reliable. Please consider my application.
$688 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$611 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have over 10 years of experience in administration and analysis and a background in IT project management. I am available immediately for part-time assignments. I am detail oriented, results driven, and computer savy. I am experienced in virtual office management, an advanced user of MS Excel and I am professional at all times, even when under pressure. If you hire me, I am confident that you will be happy with the results.
$611 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$444 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am new to this website but I work as a freelancer on another site and have experience in similar projects. Hope it will not be problem for you that I am new and I will get the chance. Hope to hear from you soon. Best regards, Khrystyna
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir/Madam: I am a software developer with extensive work in business systems. I have been working these last years with all kind of Finance docs, from ROI, TCO of my own entrepreunership to MetaTrader4 programming for other customer, always passing to Excel, but also I can work withAany Office or OpenOffice suit app. Even R o QlickView for dashboard and analysis of data by using statistics procedures. Reporting can be done with Acces, or Sun engine in OpenOffice, it depends on youthe output format. About adquisition of data I can do viually or programmatically, I did crawling with Python. So it will be nice to do the work. Do not hesitate message me for any doubt. Sincerely yours.
$677 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$278 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$333 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$722 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i'm an equity data analyst and i look at company information everyday for my work. i am interested in these kind of jobs and have access to paid vendors.
$500 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Accounting,Finance Analysis,Software,Legal Areas of interest and specialization include but are not limited to: ✪PDF (Conversions to/from Ms Office, editing, splitting, forms etc.) ✪Ms Excel (VBA, Macros, Pivots, Dashboards, Managing data, reports, conversions etc.) ✪Ms Word (Formatting, renaming, conversions, graphs etc) ✪Data Processing(Data entry from websites, to websites, to softwares and apps etc.) ✪Ms Powerpoint (Presentations, conversions, linking to database, graphs etc.) ✪Book Keeping (Data uploads, routine entries, reporting etc.) ✪Accounting (Financial Statements, Financial Analyses, Business plan, Finance & Guidance etc.) ✪Transcription Services (Audio / video to text in word etc.) ✪Research (Financial and general research of information from internet etc.) ✪Problem Solving to general issues at work. Send me chat to discuss the project.
$583 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
sunnyvale, United States
5.0
1
Payment method verified
Member since Sep 15, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.