Homework Assignment #2
1. Please use SQLite3 and the financial data provided
Homework Assignment #2
1. Please use SQLite3 and the financial data provided in class(sp500_mafa2024.db) to estimate the ROA, Profit Margin, Asset Turnover, PPE (property, plant and equipment) to Total assets, Debt to Total Assets ratios for the information technology industry, and the consumer staples industry respectively from 2012 to 2022. Furthermore, please provide histograms of these ratios for each industry. You need to submit the python code and the histogram outputs.
2. Please explain how business models drive the characteristics of financial ratios for these two industry.