FIN 550 Final Project Excel Workbook

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

550

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by Bossaboo89

**CHOOSE ONE (1) OF THE COMPANIES LISTED BELOW FOR YOU 1. Insert your selected company name in the yellow highlighted cell: 2. Start your copy with the row where your company name appears. 3. Then scroll down to the row of the weighted average cost of capital. Then paste this information into r Lowe's Companies Inc. (Stock Ticker: LOW) - (NAICS Code: 444110) Dollars and Shares in Millions, Except Per-Share Data Most Recent Calendar or Fiscal Year End—Then Two Prior Years Year Enter Years 2021 Net Cash Provided by Operating Activities $ 11,049.00 Capital Expenditures $ 1,971.00 Free Cash Flows $ 9,078.00 Cash Dividends per Share $ 3.20 Dividend Yield 1.25% Diluted Earnings per Common Share $ 10.06 Shareholder’s Equity $ 1,437.00 Total Common Shares Outstanding 731000.00 Common Stock Closing Price per Share $ 256.15 Effective Tax Rate (Use 20%) 20% Weighted Average Cost of Capital (Use 5%) 5% Johnson & Johnson (Stock Ticker: JNJ) - (NAICS Code: 325412) Dollars and Shares in Millions, Except Per-Share Data Most Recent Calendar or Fiscal Year End—Then Two Prior Years Year Enter Years Net Cash Provided by Operating Activities $ -

Capital Expenditures $ - Free Cash Flows $ - Cash Dividends per Share $ - Dividend Yield #DIV/0! Diluted Earnings per Common Share $ - Shareholder’s Equity $ - Total Common Shares Outstanding Common Stock Closing Price per Share $ - Effective Tax Rate (Use 20%) % Weighted Average Cost of Capital (Use 5%) % Target: (Stock Ticker: TGT) - (NAICS: Code 452210) Dollars and Shares in Millions, Except Per-Share Data Most Recent Calendar or Fiscal Year End—Then Two Prior Years Year Enter Years Net Cash Provided by Operating Activities $ - Capital Expenditures $ - Free Cash Flows $ - Cash Dividends per Share $ - Dividend Yield #VALUE! Diluted Earnings per Common Share $ - Shareholder’s Equity $ - Total Common Shares Outstanding Common Stock Closing Price per Share $ Effective Tax Rate (Use 20%) % Weighted Average Cost of Capital (Use 5%) %

Kroger Companies: (Stock Ticker: KR) - (NAICS Code: 445110) Dollars and Shares in Millions, Except Per-Share Data Most Recent Calendar or Fiscal Year End—Then Two Prior Years Year Enter Years Net Cash Provided by Operating Activities $ - Capital Expenditures $ - Free Cash Flows $ - Cash Dividends per Share $ - Dividend Yield #VALUE! Diluted Earnings per Common Share $ - Shareholder’s Equity $ - Total Common Shares Outstanding Common Stock Closing Price per Share $ Effective Tax Rate (Use 20%) % Weighted Average Cost of Capital (Use 5%) % Chevron: (Stock Ticker: CVX) - (NAICS Code: 324110) Dollars and Shares in Millions, Except Per-Share Data Most Recent Calendar or Fiscal Year End—Then Two Prior Years Year Enter Years Net Cash Provided by Operating Activities $ - Capital Expenditures $ - Free Cash Flows $ - Cash Dividends per Share $ -

Your preview ends here