In this tutorial we will automate financial analysis in excel.

• We will use Python to achieve that.
• The full code is available in Jupyter notebook
• This will Automate Financial Analysis in Excel

In this video you will learn

• How to create multiple sheet excel sheets for financial analysis
• How to get financial statements online
• We will get 10+ years of income statement
• We will get 10+ years of cash flows
• Then we will use Revenue, Earnings Per Share (EPS) and Free Cash Flow (FCF)
• We will calculate the percentage change (growth) from year to year.
• Then we will export it to Excel
• We will create a double chart for each of the 3 datasets

Get the Jupyter notebook here:

https://www.learnpythonwithrune.org/c…

Subscribe: https://www.youtube.com/c/LearnPythonwithRune/featured

#python #excel