Please fill out the 2 excel sheets below based on the financial health of a large company, preferably Walmart.

Company Name
Horizontal Analysis of Income Statement
	Recent Year vs Year -1		Year -1 vs Year -2
	$ Change	% Change	$ Change	% Change
Net Sales
Cost of Goods Sold
Gross Profit
Operating Expenses
Income from Operations
Other Revenue and Gains
Other Expenses and Losses
Income before Income Taxes
Income taxes
Net Income
Earnings per share
Company Name
Horizontal Analysis of Balance Sheet
	Recent Year vs Year -1		Year -1 vs Year -2
	$ Change	% Change	$ Change	% Change
Assets
Current Assets
Cash and Equivalents
Net Receivables
Inventory
Other current assets
Total Current Assets
Property, plant, & Equip
Total Assets
Liabilities
Current Liabilities
Payables
Short term/current long term debt
Other current liabilities
Total current liabilities
Long-term debt
Total Liabilities
Stockholder's Equity
Common Stock
Additional PICap
Retained Earnings
Total Stockholder's Equity
Total Liab & Stockholder's Equity

Company Name
Ratio Analysis
	Recent Year	Year - 1	Year -2
Short Term Debt
Cash Ratio
Quick Ratio
Current Ratio
Liquidity
A/R Turnover
Days to collect A/R
Inventory Turnover
Days to sell Inventory
Long-Term Debt
Debt to Equity
Times Interest Earned
Profitability
Earning per Share
Gross Profit Percentage
Profit Margin
Return on Assets
Return on Common Equity