Find Jobs
Hire Freelancers

Build financial models in Excel of publicly traded companies

$750-1500 USD

Closed
Posted almost 15 years ago

$750-1500 USD

Paid on delivery
We need financial models built in excel on a number of publicly traded companies listed on U.S. stock exchanges. Each company will have 3 statements, an income statement, balance sheet and statement of cash flows. The historic data on a quarterly basis for the last three years needs to be entered. The data is typically available in the investor relations (about us) segment of a company's web site in the form of historic press releases. it is also available at [login to view URL] in the form of 10ks and 10qs (which are filings that publicly traded stocks need to file with the government) We also may be able to provide you with most of the historic quarterly data as well as annual data in excel spreadsheets. You will have to arrange it properly so that the line items match up appropriately between the quarters and years. Also, you will have to enter in the data on revenue by product line and profitability by product line if the company provides it. If having this core data in excel would have a significant impact on your bid, please let us know and we can provide it. All relevant financial metrics should be included as well. examples would be expenses as a % of revenue, Days sales outstanding...and so on. There are many more. Please see the sample spreadsheet that we have included. An understanding of financial statement analysis is quite important. These metrics will then be used to drive forecasts of future results for the company for all three statements which should tie together. We are including a sample excel financial model for your reference, and which actually can be used as a sort of template for other models. This one is of symantec (SYMC). We want to start off with this work to be done in phase one for 30 companies. Over time, we hope to expand the project to 100s of companies. We would prefer to work with individuals that have some experience doing financial analysis and forecasting and a deep familiarity with excel.
Project ID: 434608

About the project

63 proposals
Remote project
Active 15 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

About the client

Flag of UGANDA
Weston, Uganda
0.0
0
Member since May 14, 2009

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.