smartly created document, include a cover page with
your name, date, section information, assignment #, and problem #
answer questions, create model as we worked in class/youtube.
Create in excel a table/matrix for:
1. corporate profits by industry, table 6.16D, BEA.gov,
quarterly model for years 2019 to present;
Keep in mind there are about 40 line item entries.
2. Create a table/matrix for year over year on the quarter percentage changes.
Submit as a pdf, using excel. Same cover page (use excel to create this).
Use YouTube provided videos for basis for this work.
Use template for assignments # 3 & #5 & #6.
Answer the below questions, based on the WSJ markets article,
“Record Pace for Corporate Earnings Keeps Stocks Buoyant”, August 8, 2021:
3. As of August 08, 2021, for year 2021, what percentage change has the S&P 500 experienced?
4. What are three occurrences or conditions that may reduce business activity in 2021?
5. Define profit margin (from excel notes).
6. How have US corporate profit margins behaved in 2021?
7. Find the paragraph that describes the year over year earnings percentage change.
Compare the percentage changes in the paragraph to the 2021 Q2 y-o-y percentage change
in overall US corporate profits. (see YouTube videos on corporate profits)
8. Define price to earnings ratio (see excel notes)
9. What is the S&P 50 trading at as of early August 2021?
What is the five year average of this P/E ratio?
10. Define operating profit margin (see excel notes).
11. What is the operating margin for the S&P 500 companies?
12. What does a record operating margin mean? Economically.
13. What do strong corporate earnings mean for stock market valuations?
14. Use consumers products company Colgate Palmolive and
Campbell Soup company as examples,
What is the expected impact of inflation on the profits and
stock process of these companies?
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|