Using Yahoo Finance to gain access to the data of a popular
stock/company: Create a 2 year Comparative In-Direct Cash Flow Statement,
Create a 2 year Comparative Income Statement, Create a 2 year Common-Size
Income Statement, Create a 2 year Comparative Balance Sheet, Create a 2 year
Common-Size Balance Sheet, Analyze Liquidity and Efficiency – Teach the Why, Analyze Solvency – Teach the
Why, Analyze Profitablitity – Teach the Why, Analyze Market Prospects – Teach the
Why, Graph 2 yrs IS,BS or CF.
All of these things are what is required. These requirements are also listed in the rubric of the attached Excel file titled: “Take Home Final”. All of the work will need to be done and inputted into that same “Take Home Final” Excel file. The work that will be done will need to be based off of and look as similar as possible to the Excel file which has also been attached titled “Take Home Final Example”. The work that is done needs to be done in the same way as the given example, as this was an example from the course instructor themself; and obviously, the instructor chose Telsa as their company/stock/data, so it needs to be on something different than that. The attached image is from the instructor, giving their step by step on how to complete the assignment.
