Fin 640 Milestone One

Hi, I need help completing the portfolio excel template for each: Apple, Inc. (AAPL), Caterpillar (CAT), Consolidated Edison (ED) Northern Trust (NTRS) and Macy’s (M). As well as answering the prompt in 2-3 pages. I went ahead and added the files down below with all the information needed. Thank you

Apple (AAPL) Stock
Enter Current Fiscal Year in Cell B2:
Historical Fiscal Year-End Data:
2023
2018
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
2019
0
0
0
0
0
0
0
0
0
2020
0
0
0
0
0
0
0
0
0
2021
0
0
0
0
0
0
0
0
0
0
0
0
Apple (AAPL) Bond
Firm
Additional Data May Be Entered Below:
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Shares Outstanding
Debt & Coverage Ratios
Debt/Assets
Debt/Equity
Current Assets/Current Liability
EBITDA/Interest
Debt/EBITDA
Cash Flow Ops/Total Debt
2022
Ind Avg
0
0
Forecasted Fiscal Year-End Data:
2023
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
Shares Outstanding
2024
0
0
0
0
0
0
0
0
0
#DIV/0!
2025
0
0
0
0
0
0
0
0
0
2026
0
0
0
0
0
0
0
0
0
2027
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0
0
0
0
0
Caterpillar (CAT) Stock
Enter Current Fiscal Year in Cell B2:
Historical Fiscal Year-End Data:
2023
2018
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
2019
0
0
0
0
0
0
0
0
0
2020
0
0
0
0
0
0
0
0
0
2021
0
0
0
0
0
0
0
0
0
0
0
0
Caterpillar (CAT) Bond
Firm
Additional Data May Be Entered Below:
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Shares Outstanding
Debt & Coverage Ratios
Debt/Assets
Debt/Equity
Current Assets/Current Liability
EBITDA/Interest
Debt/EBITDA
Cash Flow Ops/Total Debt
2022
Ind Avg
0
0
Forecasted Fiscal Year-End Data:
2023
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
Shares Outstanding
2024
0
0
0
0
0
0
0
0
0
#DIV/0!
2025
0
0
0
0
0
0
0
0
0
2026
0
0
0
0
0
0
0
0
0
2027
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0
0
0
0
0
Consolidated Edison (ED) Stock
Enter Current Fiscal Year in Cell B2:
Historical Fiscal Year-End Data:
2023
2018
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
2019
0
0
0
0
0
0
0
0
0
2020
0
0
0
0
0
0
0
0
0
2021
0
0
0
0
0
0
0
0
0
2022
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Shares Outstanding
0
0
0
0
Consolidated Edison (ED) Bond
Firm
Debt & Coverage Ratios
Debt/Assets
Debt/Equity
Current Assets/Current Liability
EBITDA/Interest
Debt/EBITDA
Cash Flow Ops/Total Debt
Additional Data May Be Entered Below:
0
0
0
0
0
0
0
0
0
Ind Avg
0
Forecasted Fiscal Year-End Data:
2023
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
Shares Outstanding
2024
0
0
0
0
0
0
0
0
0
#DIV/0!
2025
0
0
0
0
0
0
0
0
0
2026
0
0
0
0
0
0
0
0
0
2027
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0
0
0
0
0
Northern Trust (NTRS) Stock
Enter Current Fiscal Year in Cell B2:
Historical Fiscal Year-End Data:
2023
2018
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
2019
0
0
0
0
0
0
0
0
0
2020
0
0
0
0
0
0
0
0
0
2021
0
0
0
0
0
0
0
0
0
2022
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Shares Outstanding
0
0
0
0
Northern Trust (NTRS) Bond
Firm
Debt & Coverage Ratios
Debt/Assets
Debt/Equity
Current Assets/Current Liability
EBITDA/Interest
Debt/EBITDA
Cash Flow Ops/Total Debt
Additional Data May Be Entered Below:
0
0
0
0
0
0
0
0
0
Ind Avg
0
Forecasted Fiscal Year-End Data:
2023
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
Shares Outstanding
2024
0
0
0
0
0
0
0
0
0
#DIV/0!
2025
0
0
0
0
0
0
0
0
0
2026
0
0
0
0
0
0
0
0
0
2027
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0
0
0
0
0
Macy’s (M) Stock
Enter Current Fiscal Year in Cell B2:
Historical Fiscal Year-End Data:
2023
2018
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
2019
0
0
0
0
0
0
0
0
0
2020
0
0
0
0
0
0
0
0
0
2021
0
0
0
0
0
0
0
0
0
2022
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Shares Outstanding
0
0
0
0
Northern Trust (NTRS) Bond
Firm
Debt & Coverage Ratios
Debt/Assets
Debt/Equity
Current Assets/Current Liability
EBITDA/Interest
Debt/EBITDA
Cash Flow Ops/Total Debt
Additional Data May Be Entered Below:
0
0
0
0
0
0
0
0
0
Ind Avg
0
Forecasted Fiscal Year-End Data:
2023
Revenues
Cost of Goods Sold
Selling, General & Administrative Expenses
Research and development
Operating Income
Net Interest Expenditure
Pre-Tax Income
Taxes
Net Income
Earnings Per Share
Shares Outstanding
2024
0
0
0
0
0
0
0
0
0
#DIV/0!
2025
0
0
0
0
0
0
0
0
0
2026
0
0
0
0
0
0
0
0
0
2027
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
0
0
0
0
0