Data Analysis and Forecasting using Python
Budget: ₹600 – ₹1,500 INR
I am looking for a Python expert who can help me with data analysis and forecasting. The project involves working with Time Series data and the main goal is to predict future trends. The ideal candidate should be proficient in Python and have experience in data analysis and visualization. The preferred output format for the results is visualizations such as graphs and csv file.
Detailed Description:
Module1: Write code to fetch following data in a file or files or store these in an object (which should be accessible as and when required)
1. Sales/Total Revenue (for past 5 years i.e. Jan 2018 to Dec 2022)
2. Gross Profit (for past 5 years i.e. Jan 2018 to Dec 2022)
3. Unlevered Free Cash Flow to Firm (FCFF)
4. Present Value of Free Cash Flow (FCFF* Discount Factor)
Weighted Average Cost of Capital (WACC): Will derived this from Bloomberg Terminal/Will provide the number
Discount Period: Program the mentioned formula
From
01-Apr-23
To
31 Dec 2023
31 Dec 2024
31 Dec 2025
31 Dec 2026
31 Dec 2027
Difference (No. Days): 275 and so on
**Divide the difference by 365
Discount Factor: Program the mentioned formula
=1/(1+WACC)^(Discount Period)
Reference:
https://finance.yahoo.com/quote/KDP?p=KDP&.tsrc=fin-src
Install library yahoo-fin: pip install yahoo-fin
Found this tutorial help: https://www.youtube.com/watch?v=IMCbi6cvRmY
https://www.timeanddate.com/date/durationresult.html?m1=4&d1=1&y1=2023&m2=12&d2=31&y2=2023&ti=on
Module2:
Write code to forecast (next 5 years) based on historical data fetched in module 1.
- Use ARIMA/Prophet or any other proficient library to forecast
Module 3:
We need to plot the data
- Year vs Sale/Revenue and Year vs Gross Profit
- Free Cash Flow to Firm (FCFF) and Present Value of Free Cash Flow
Along with these printed somewhere on corner:
Firm Title: KDP (Keurig Dr Pepper Inc)
Valuation Date: 01-Apr-23
Latest FYE: 31-Dec-22
WACC: 6.75%
KDP DCF Value: https://www.alphaspread.com/security/nasdaq/kdp/dcf-valuation/base-case#dcf-value-calculation
Current Share Price: https://finance.yahoo.com/quote/KDP/
Module 4:
- Download everything in a consolidated CSV/EXCEL file
Preferably programmers from India, [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions]
Detailed Description:
Module1: Write code to fetch following data in a file or files or store these in an object (which should be accessible as and when required)
1. Sales/Total Revenue (for past 5 years i.e. Jan 2018 to Dec 2022)
2. Gross Profit (for past 5 years i.e. Jan 2018 to Dec 2022)
3. Unlevered Free Cash Flow to Firm (FCFF)
4. Present Value of Free Cash Flow (FCFF* Discount Factor)
Weighted Average Cost of Capital (WACC): Will derived this from Bloomberg Terminal/Will provide the number
Discount Period: Program the mentioned formula
From
01-Apr-23
To
31 Dec 2023
31 Dec 2024
31 Dec 2025
31 Dec 2026
31 Dec 2027
Difference (No. Days): 275 and so on
**Divide the difference by 365
Discount Factor: Program the mentioned formula
=1/(1+WACC)^(Discount Period)
Reference:
https://finance.yahoo.com/quote/KDP?p=KDP&.tsrc=fin-src
Install library yahoo-fin: pip install yahoo-fin
Found this tutorial help: https://www.youtube.com/watch?v=IMCbi6cvRmY
https://www.timeanddate.com/date/durationresult.html?m1=4&d1=1&y1=2023&m2=12&d2=31&y2=2023&ti=on
Module2:
Write code to forecast (next 5 years) based on historical data fetched in module 1.
- Use ARIMA/Prophet or any other proficient library to forecast
Module 3:
We need to plot the data
- Year vs Sale/Revenue and Year vs Gross Profit
- Free Cash Flow to Firm (FCFF) and Present Value of Free Cash Flow
Along with these printed somewhere on corner:
Firm Title: KDP (Keurig Dr Pepper Inc)
Valuation Date: 01-Apr-23
Latest FYE: 31-Dec-22
WACC: 6.75%
KDP DCF Value: https://www.alphaspread.com/security/nasdaq/kdp/dcf-valuation/base-case#dcf-value-calculation
Current Share Price: https://finance.yahoo.com/quote/KDP/
Module 4:
- Download everything in a consolidated CSV/EXCEL file
Preferably programmers from India, [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions]