FIN 550 Final Project Excel Workbook G Doc

.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: Lowe's Companies Inc 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 2023 Net Cash Provided by Operating Activities $ 8,589.00 Capital Expenditures $ 1,829.00 Free Cash Flows $ 6,760.00 Cash Dividends per Share $ 4.40 Dividend Yield 2.12% Diluted Earnings per Common Share $ 10.17 Shareholder’s Equity $ (14,254.00) Total Common Shares Outstanding 601000.00 Common Stock Closing Price per Share $ 207.84 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 $ -

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%) % Pepsico, Inc.: (Stock Ticker: PEP) - (NAICS Code: 312111) 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 28%) % Weighted Average Cost of Capital (Use 5%) % Southwest Airlines Co.: (Stock Ticker: LUV) (NAICS Code: 481111)

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%) % General Electric Company: (Stock Ticker: GE) - (NAICS Code: 333611) 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%) % Notes: North American Industry Classification System Codes: The North American Industry Calculation System or NAICS is a classification of business establishments by type of economic activity (process of production).

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version