Find Jobs
Hire Freelancers

Do some data entry -- 4

$250-750 USD

已关闭
已发布超过 7 年前

$250-750 USD

货到付款
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
项目 ID: 11547128

关于此项目

36提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
36威客以平均价$454 USD来参与此工作竞价
用户头像
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
$526 USD 在10天之内
4.9 (100条评论)
6.3
6.3
用户头像
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
$555 USD 在10天之内
4.5 (44条评论)
4.7
4.7
用户头像
Greetings! I can prepare the report as required ensuring your full satisfaction. Have a Great Weekend! Srinivasan Krishnamoorthi
$250 USD 在5天之内
5.0 (13条评论)
3.3
3.3
用户头像
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.
$250 USD 在7天之内
4.6 (13条评论)
3.7
3.7
用户头像
***** 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
$277 USD 在10天之内
5.0 (8条评论)
3.1
3.1
用户头像
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?
$555 USD 在10天之内
5.0 (1条评论)
2.1
2.1
用户头像
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
$250 USD 在10天之内
5.0 (1条评论)
1.3
1.3
用户头像
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
$277 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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
$555 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$555 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hello sir, I am here and wait for starting your job. Just hire me & start your job.
$555 USD 在15天之内
0.0 (0条评论)
0.0
0.0
用户头像
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.
$555 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$555 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
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.
$277 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
Interested to work on this project
$500 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$555 USD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
I'm well known of excel
$333 USD 在6天之内
0.0 (0条评论)
0.0
0.0
用户头像
i don't want to say by word my work will tell you about me. give me a chance and I'll prove it
$444 USD 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$666 USD 在7天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
sunnyvale, United States
5.0
1
付款方式已验证
会员自9月 15, 2016起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。