[Solved] Financial Statement Analysis Memo

Assignment Prompt & Instructions

[>Accounting homework help](https://www.sweetstudy.com/fields/business-finance-accounting)

_**art 1: Excel**_

Locate and download the latest Excel 10-K Annual Report from the "Costco SEC Filings" website,

1. In the Excel file, perform a vertical and horizontal analysis on both the income statement and balance sheet for the most recent year.
2. Using 3 years of income statement data, perform a trend analysis of the income statement, specifically net sales, operating expenses, and net income.
3. In a new sheet in the Excel file, compute the following ratio analysis for the most recent 2 years:

_Ratio Analysis for the Most Recent 2 Years:_

– Current Ratio
– Accounts Receivable Turnover Ratio
– Inventory Turnover Ratio
– Profit Margin Ratio
– Return on Assets Ratio
– Return on Common Stockholders' Equity
– Earnings Per Share
– Debt to Total Assets Ratio
– Cash Debt Coverage Ratio

_**Part 2: Memo**_

After reviewing the horizontal and vertical analysis of equity, revenue, and profit for the 2 years and the liquidity, profitability, and solvency ratios, prepare a 700-1,000-word memo as though you were the financial advisor and explain the following:

1. Explain the purpose of horizontal and vertical analysis along with ratio analysis.
2. Based on the trend analysis and data presented, do you think Costco's financial performance will decrease, stay flat, or increase in the next few years? Would Costco be a good investment at this point, why or why not?