12 Jan Locate and download the latest Excel 10-K Annual Report from the “Costco SEC Filings” website,
In the Excel file, perform a vertical and horizontal analysis on both the income statement and balance sheet for the most recent year.
Using 3 years of income statement data, perform a trend analysis of the income statement, specifically net sales, operating expenses, and net income.
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:
Explain the purpose of horizontal and vertical analysis along with ratio analysis.
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?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.