Finanicial Analysis For Udacity: Analyze NYSE Data

$ 30.00 — 250.00 USD
I have a data analysis project and it has some requirements to finish the project




Project Goals:
Here are the three tasks that you will complete in the final project.

Task 1:
a.
Identify the question about the data that you will answer based on your data analysis, and include this in your slide presentation.

Your question should include at least one categorical variable (GICS Sector or GICS Sub Industry) and one quantitative variable (one of the financial metrics) and require the use of at least one of the summary statistics.

A tab within the Excel spreadsheet that you submit should include the summary statistics you used to answer your question.

Deliverable: Slide presentation, Spreadsheet with tab for Summary statistics
b.
Your slide presentation should provide at least one visualization to help with your answer.

This visualization might be a bar chart, histogram, scatterplot, box-plot or other visual that you learned to make.
Include your insights from the measures of center and spread and at least one numeric summary statistic in the description.

Deliverable: Slide presentation (includes visualization)
Task 2:

Create a dashboard for a Profit and Loss Statement that calculates the Gross Profit, Operating Profit or EBIT for a company selected from a drop-down list.

Your drop-down list should pull historical fundamentals data to create the P&L Statement.

The P&L statement should include the Gross Profit, Operating Profit or EBIT values for all the years there is historical data available for that company in the dataset.

Deliverable: Spreadsheet with tab for Dynamic P&L statement
Task 3:

Create a financial model for a company (different from Task 2) of your choice that forecasts out the Gross Profit, Operating Profit or EBIT for two more years using three scenarios (Best case, Weak case and Base case).

Your assumptions for revenue growth, gross margin and operating margin should change for each scenario.

The forecasting model should be dynamic for the selection of the case (Weak, Base, Strong).
However, the forecasting model can be static for the chosen company sticker symbol.

Deliverable: Spreadsheet with tab for Forecasting Model
Step One - Get Organized
When you complete your analysis and presentation you’ll want to submit your project.
Get organized before you begin.
I recommend creating a single folder that will eventually contain:

The presentation with the visual and summary
The original data set
A copy of the spreadsheet workbook you will use to do the analysis for your report that contains at least the following tabs:
Data file
Summary statistics
P&L Statement Dashboard
Forecast scenarios

Similar Freelance jobs:

Simple Data Entry Work For All
Hello Freelancers, We need 30 people from any part of the world for simple data entry work. This project is very simple but little tougher than copy paste work. International members are allowed and typing speed should be minimum 12 words per minute.
Full Description of Simple Data Entry Work For All
Assessoria E Consultoria Em Vba/excel/access E Banco De Dados
Necessito de consultoria/assessoramento para criação de projetos em VBA/Excel/ACCESS. a ideia é que eu faça  alguns projetos e/ou acompanhe profissional com mais experiência para adquirir mais conhecimento prático.Valores serão negociados.
Full Description of Assessoria e Consultoria em VBA/EXCEL/ACCESS e Banco de…
Skype Interviewer - Must Be English Fluent!
I need a Skype interviewer who will call new hires based on appoints the new hires have set on a Google Calendar, after the interview, you will send each qualified technician the new hire paperwork. BONUS: 1. Skype phone number will be provided to you for FREE calling into the United States. PAYMENT: 1. Payment is based on each new hire you will call via Skype (everyone gets offered the chance to be hired) at $3.00 per new hired worker.…
Full Description of Skype Interviewer - MUST BE ENGLISH FLUENT!
Opportunity For New Freelancers
I am from India and want a few virtual assistants on a monthly basis, who can work daily 1 hour anytime as per their suitability. I will give a certain task which they have to do on a daily basis. Payments will be proportionately work done. They should have English writing skills with good internet exposure. They have to give daily work report. New freelancers from any country will be considered.
Full Description of Opportunity for new freelancers
Create Proposal Software Or Excel To Word Integraton
We are an energy and solar company who do solar financial modelling for businesses. We currently manually create excel spreadsheets, which we then copy and paste into our proposal templates. We have to then manually write customer details, company name etc. So this is a slow process. We are looking at 2 options 1. Full company software, where you login input the system size, customer details and it will generate a proposal. 2. Simple excel to word integration. If we…
Full Description of Create proposal software or excel to word integraton
Native Canadian-french Speakers Needed | Quebec City
Program: Native Canada Speak French Speak French to pay attention to the first English into French in reading. What you have to get ready: 1) Have a recorder, Sony px470 or better Debugging and preparation of recording equipment Before recording, please adjust the equipment according to the requirements. Recorder settings: Home key - Settings - recording settings: Recording folder: built in memory Scene selection: meeting Recording mode: lpcm 44.1khz/16bit Built in microphone sensitivity: suitable for voice Centralized / spacious: spacious…
Full Description of Native Canadian-French speakers needed | Quebec City
Pre-shipment Inspection In 7130 Juelsminde Denmark
Pre-shipment inspection in 7130 Juelsminde Denmark Date : ASAP - During a week and morning Inspection Location: - Palsgaard A/S Palsgaardvej 10 7130 Juelsminde Denmark Opening hours: -8.00-13.00 - 14.00-17.00 scope of job : visual Inspection : freelancer shall take photos of items (each reference one photo of general appearance of product and item label) -Product is Palsgaard® SSL 3426 , Palsgaard® DMG 5611 & Palsgaard® SA 6610 (mentioned in item label) quantity checking : freelancer has to check quantity…
Full Description of Pre-shipment inspection in 7130 Juelsminde Denmark
Legacy Data Transfer Fixed Assets Using Excel Sap As100
We have one in-house migration activity for our Italy Projects. We received small task regarding Fixed Assets migration ( SAP to SAP). My manager requirements is We can go through option AS100 of excel import file. In this regards I require your support like for preparing excel import file. Still transfer in production. I am looking for freelancer who have adequate knowledge in SAP FICO Functional Consultant
Full Description of Legacy data transfer Fixed assets using Excel SAP…
Native Arabic Speakers Needed | Dubai
What you have to do: 1) Have the app already. Download AMR (Appen Mobile China) China from Google Play or APP store (if you want android version, you could ask me for .apk directly) 2) HAVE A PIN TO LOGIN DIRECTLY 3) Once u enter and ask me PIN mail:511682020(at)qq.com 2-1.enter ProgramID:101 PIN:(U asked me) to sign the agreement. 2-2.back to main 3-3.enter ProgramID:73 PIN:(the same) to record the voice. 3) Follow the APP introduction 4) Make the screenshot when…
Full Description of Native Arabic speakers needed | Dubai
Need 3 Native Male Speakers | Hamburg
Hey. Are you free now? I am looking for 3 male persons born in Germany. What you have to do: 1) Have a recorder, Sony px470 or better Debugging and preparation of recording equipment Before recording, please adjust the equipment according to the requirements. Recorder settings: Home key - Settings - recording settings: Recording folder: built in memory Scene selection: meeting Recording mode: lpcm 44.1khz/16bit Built in microphone sensitivity: suitable for voice Centralized / spacious: spacious recording filter: NCF (noise…
Full Description of Need 3 Native Male Speakers | Hamburg
Estudio De Mercado Lgbt+ Mexico
Busco un estudio de mercado para saber en mexico cuantas asociaciones LGBT+, colectivos o similares hay en cada estado. si son autonomos o subsidiados. Los que hay en las universidades (nombre, contacto, correo, tel) verificados Empresas que cumplen con la politica de inclusion y hayan sido premiadas Personalidades de mi paìs abiertamente gay (politico, del medio, empresarios, artistas, etc) Numeros: Cuanto $$$ representa la comunidad gay en México por sector de consumo Segmentación del mercado e identificación de nichos Información…
Full Description of ESTUDIO DE MERCADO LGBT+ MEXICO
3 Basic Sql And Html Exercises (need It In The Next 24 Hours)
You will find instructions in the PDF attached and then please resolve each Excel file according to the instructions inside each of it and leave the solution in a separate tab/sheet created in the same excel file. The solving deadline is June 23rd 6.00 PM (GMT+1)
Full Description of 3 basic SQL and HTML Exercises (need it…
© 2006 — 2024 hirelancer.com is an affiliate website, listing the freelance projects. We are collaborating with other sites like getFreelancer.com. Feel free to bid on any project and good luck! You will need register first, before bidding or posting projects. Basic memberhsip is always free. We might earn commissions from referring you. You will never ever pay additional fees for we referred you.