Ratio Analysis Spreadsheet Assignment

Input Sheet

Ratio Analysis Spreadsheet
Use this spreadsheet for the ratio analysis required in the Units 4 and 5 Individual Projects.
Company Name
Year of the company’s MOST RECENT annual report (10-K)
Liquidity Ratios: How well can a company pay its current debts quickly if the need arises?
Enter the following information to calculate your company’s liquidity ratios.
Current Assets (located on the balance sheet) This Year Caution: Use Current Assets, not Total Assets.
Last Year
Current Liabilities (located on the balance sheet) This Year Caution: Use Current Liabilities, not Total Liabilities.
Last Year
Cash Balance (located on the balance sheet) This Year Note: This may be listed as Cash and Cash Equivalents.
Last Year
Net Receivables (located on the balance sheet) This Year Note: This may be listed as Accounts Receivable or simply Receivables.
Last Year
Marketable Securities (located on the balance sheet) This Year Note: This may be listed as Short Term Investments.
Last Year
Efficiency (Control) Ratios: How well is a company utilizing its current resources to generate assets?
Enter the following information to calculate your company’s efficiency ratios.
Accounts Receivable (located on the balance sheet) This Year Note: This may be listed as Accounts Receivable or simply Receivables.
Last Year
Sales (located on the income statement) This Year Note: This may be listed as Revenues on the income statement.
Last Year Note: If multiple revenue sources, use sales (if it exists) or total revenues.
Cost of Goods Sold (located on the income statement) This Year Note: This may be listed as Cost of Sales or Cost of Revenues.
Last Year
Inventory (located on the balance sheet) This Year Note: If there is no inventory, put an X in the yellow box in cell A37.
¬ put an X in this box if there is no inventory listed Last Year
Fixed Assets (located on the balance sheet) This Year Note: This may be listed as property, plant, and equipment (net).
Last Year
Leverage (Debt) Ratios: How much is the company relying on debt? Can the company meet its interest obligations?
Enter the following information to calculate your company’s leverage ratios.
Total Liabilities (located on the balance sheet) This Year Caution: Use total liabilities, not current liabilities.
Last Year
Total Assets (located on the balance sheet) This Year Caution: Use total assets, not current assets.
Last Year
Total Stockholder’s Equity (located on the balance sheet) This Year Caution: Use the total amount, not just the amount listed as stock.
Last Year
Earnings Before Interest and Taxes (located on income stmt.) This Year Note: This is usually reported right below operating income.
Last Year Note: If you don’t see EBIT, use the income/loss reported right before interest expense.
Interest Expense (located on the income statement) This Year
Last Year
Profitability Ratios: Is the company profitable?
Enter the following information to calculate your company’s profitability ratios.
Total Revenues (located on the income statement) This Year Note: This may simply be listed as Net Sales or Net Revenues.
Last Year
Gross Profit (located on the income statement) This Year Note: This is usually reported right below Cost of Sales or Cost of Revenue.
Last Year
Operating Profit (located on the income statement) This Year Note: This may be reported as Operating Income or Income from Continuing Operations.
Last Year
Net Income (located on the income statement) This Year Note: This may be listed as net income from continuing operations.
Last Year Note: This may be listed as net income attributable to common shareholders.
Total Assets (located on the balance sheet) This Year Caution: Use total assets, not current assets.
Last Year
Total Stockholder’s Equity (located on the balance sheet) This Year Caution: Use the total amount, not just the amount listed as stock.
Last Year

Results Sheet

2-Year Ratio Analysis
Company Being Analyzed: 0
Years Being Analyzed: 0 AND -1
RATIO RESULTS
Liquidity Ratios
0 -1
Current Ratio ERROR:#DIV/0! ERROR:#DIV/0!
Quick Ratio ERROR:#DIV/0! ERROR:#DIV/0!
Working Capital $ – 0 $ – 0
Efficiency (Control) Ratios
0 -1
Accounts Receivable Turnover ERROR:#DIV/0! times ERROR:#DIV/0! times
Days Collection Period ERROR:#DIV/0! days ERROR:#DIV/0! days
Inventory Turnover ERROR:#DIV/0! times ERROR:#DIV/0! times
Days to Sell Inventory ERROR:#DIV/0! days ERROR:#DIV/0! days
Fixed Asset Turnover ERROR:#DIV/0! times ERROR:#DIV/0! times
Leverage (Debt) Ratios
0 -1
Debt-to-Asset Ratio ERROR:#DIV/0! ERROR:#DIV/0!
Debt-to-Equity Ratio ERROR:#DIV/0! ERROR:#DIV/0!
Times Interest Earned ERROR:#DIV/0! times ERROR:#DIV/0! times
Profitability Ratios
0 -1
Gross Profit Margin ERROR:#DIV/0! ERROR:#DIV/0!
Operating Profit Margin ERROR:#DIV/0! ERROR:#DIV/0!
Net Profit Margin ERROR:#DIV/0! ERROR:#DIV/0!
Return on Assets ERROR:#DIV/0! ERROR:#DIV/0!
Return on Equity ERROR:#DIV/0! ERROR:#DIV/0!

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Open chat
1
You can contact our live agent via WhatsApp! Via +1 817 953 0426

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 30% with the discount code STARS