Financial Statement Analysis – Ratio Analysis

Learn horizontal analysis as a key financial statement tool, and explore its relation to vertical and ratio analysis through PowerPoint presentations and Excel worksheets with instructional videos.

Access a downloadable PDA file that serves as a supplement to the instructional video for horizontal analysis in financial statement analysis.

Compare current and prior year figures using horizontal analysis on income statements and balance sheets. Calculate dollar and percentage changes, and examine trends against a base year.

Download an Excel worksheet in the upcoming presentation. Use it to practice financial statement analysis.

Learn to perform horizontal analysis on comparative balance sheets and income statements, calculating dollar and percentage changes between the current and prior year, with ratios guiding cross‑company comparisons.

Download a PDA file to supplement the instructional video on trend analysis. Leverage this resource to reinforce key concepts in trend analysis within financial statement analysis.

Learn how to perform trend analysis by comparing multiple years to a base year, applying base-year percentage changes to income statement and balance sheet items to reveal clear performance trends.

Download an Excel worksheet in the next presentation to practice financial statement ratio analysis with real data.

Explore trend percentages using a base year to compare income statement and balance sheet data across multiple years, with Excel techniques like absolute and mixed references.

Analyze internal users directly involved in operating the company versus external users, and practice test-taking with questions on liquidity and efficiency ratios for meeting short-term obligations.

Engage with financial statement analysis through ratio analysis insights, punctuated by an accounting comic break to reinforce concepts with a light, memorable approach.

Utilize vertical analysis, also known as common-size statements, on balance sheets and income statements as part of the three major tools, and practice with Excel templates and step-by-step instructional videos.

Download a PDA file to accompany the instructional video, providing a supplement for the vertical analysis and common-size statements.

Explore vertical analysis and common size statements by expressing every income statement item as a percentage of sales, comparing current and prior years, and benchmarking against peers.

Access a downloadable Excel worksheet in the upcoming presentation. This provides a hands-on file for practice with ratio analysis during the session.

Master vertical analysis of financial statements by creating common-size percentages for the income statement and balance sheet, using current and prior year comparisons and ratios.

Access a downloadable Excel worksheet in the next presentation to support practical ratio analysis exercises.

Learn to compute current ratios using common size income statements and balance sheet trends, and master step-by-step Excel techniques with absolute references and auto-fill for ratio analysis.

Analyze multiple choice questions on financial statement analysis, using elimination to classify ratio categories, liquidity and efficiency, solvency, profitability, and market prospects, and solve examples that identify solvency and profitability.

Explore multiple-choice questions in financial statement analysis and sharpen test-taking skills, identifying market prospects as the cue for market expectations, and noting industry standards compare a company to industry performance.

Explore ratio analysis within financial statement analysis through an accounting comic break, providing a lighthearted look at key concepts.

Explore liquidity ratios within ratio analysis by overviewing their four subgroups, calculating and analyzing each ratio using Excel worksheets and visualized setups, with step-by-step instructions and downloadable templates.

Access a downloadable PDA file to supplement the instructional video for the PDF - 410 liquidity ratios part 1 lecture in the financial statement analysis course.

Explore liquidity ratios, calculate the current and acid-test ratios, and analyze accounts receivable turnover to assess a firm's ability to meet current obligations and support going concern.

Access a downloadable PDF file as a supplement to the instructional video, focusing on liquidity ratios in part 2.

analyze liquidity ratios such as total asset turnover, inventory turnover, and days sales uncollected, using net sales, average total assets, and cost of goods sold to assess operating efficiency.

Download the Excel worksheet accompanying the presentation to practice ratio analysis and financial statement assessment.

Analyze liquidity and efficiency ratios by building Excel models for two companies, calculating current and quick ratios, turnover, days in inventory, days sales uncollected, and total asset turnover.

Explore current ratio, quick ratio, and working capital in accounting, with a downloadable pda file that supplements the instructional video.

Master current ratio, quick ratio (acid-test), and working capital; learn to calculate, analyze, and interpret liquidity through trial balances and transactional effects.

A downloadable Excel worksheet accompanies the next presentation. Access practical ratio analysis exercises with this Excel file.

Compute and interpret liquidity through the current ratio, quick ratio (acid-test ratio), and working capital. This lecture shows how journal entries affect these ratios using cash, accounts receivable, and inventory.

Explore how current ratio, quick ratio, acid-test ratio, and working capital respond to cash collections, inventory purchases on account, and note payable changes, using Excel calculations.

Examine how current assets, quick assets, and current liabilities drive the current ratio, quick ratio, acid-test ratio, and working capital through cash purchases, inventory shifts, dividends, and bad debt adjustments.

Explore the most common financial analysis tools, focusing on horizontal analysis, vertical analysis, and ratio analysis, through multiple-choice questions and practice test-taking skills.

Explore multiple-choice questions on financial statement analysis, identifying ratio analysis as the method for calculating key relations. Clarify that financial statement analysis reports typically do not include an auditor's statement.

Explore financial statement analysis through ratio analysis with an engaging accounting comic break that clarifies key concepts in a light, memorable way.

Explore solvency ratios in ratio analysis, calculating and interpreting them through downloadable Excel worksheets that include formulas to visualize and practice.

Access a downloadable file that supplements the instructional video on solvency ratios, enhancing your study in financial statement analysis.

Explore solvency ratios that assess long-term viability by analyzing liabilities and equity, including debt ratio, equity ratio, debt-to-equity, and times interest earned, with practical balance sheet and income statement context.

Download an Excel worksheet for the next presentation. Use the file to practice financial statement analysis and apply ratio analysis concepts.

Compute solvency ratios from balance sheet and income statement for two data sets A and B, including debt ratio, equity ratio, debt-to-equity, and time interest earned, using Excel.

Practice two finance multiple choice questions on financial statement analysis. Identify comparative statements for multi-period data and understand horizontal analysis as evaluating changes across time.

Practice solving financial statement analysis multiple choice questions by calculating percent change with a base year using Excel, visualizing the table, and interpreting revenue trends across years 1–3.

Engage with ratio analysis concepts through an accounting comic break that reinforces key ideas from financial statement analysis.

Explore profitability ratios within ratio analysis, learn their calculation and interpretation, and practice with PowerPoint and Excel worksheets featuring three tabs for answers, preformatted data, and blank practice.

Download a pdf file that supplements the instructional video on profitability ratios within financial statement analysis, helping you apply ratio analysis more effectively.

Explore profitability ratios, including profit margin, return on total assets, and return on common stockholders' equity, using net income, net sales, and averages to evaluate performance.

Access and download the Excel worksheet accompanying the upcoming presentation, a practical tool for applying ratio analysis to financial statements.

Analyze profitability ratios by computing profit margin from net income and net sales, and evaluate return on assets and equity using average assets and average equity across two data sets.

Practice financial statement analysis with multiple-choice questions on trend percentages, common-size percentages, and key ratios. Learn to compute base period trends, cash as a share of assets, and working capital.

Explores multiple choice questions on financial statement analysis, guiding test-taking strategies while computing the current ratio from assets and liabilities, and identifying the acid test ratio.

Enjoy a playful accounting comic break that reinforces ratio analysis within financial statement analysis, using engaging, accessible examples to clarify key metrics.

Analyze market prospects ratios within ratio analysis, using external market price information, and practice with PowerPoint presentations and Excel worksheets to visualize and format solutions.

Access a downloadable PDA file to use as a supplement to the instructional video in market prospects ratios for financial statement analysis.

Explore market prospects ratios, including price-earnings and dividend yield, and how market price per share and earnings per share inform valuation for publicly traded companies.

Download an Excel worksheet from the upcoming presentation to practice ratio analysis within financial statement analysis.

analyze market prospects by calculating price-earnings ratio and dividend yield from market price per share and earnings per share, using data for two companies.

Explore financial statement analysis through multiple choice questions, using elimination to identify the accounts receivable turnover ratio from net sales divided by average accounts receivable, with a practice example (16.3).

Practice solving multiple choice questions on financial statement analysis and ratio analysis, including accounts receivable turnover, day sales uncollected, and day sales in inventory.

Explore financial statement analysis using ratio analysis, with an engaging accounting comic break to illustrate key concepts and sharpen financial decision-making.

Practice four-category ratio analysis in Excel with a hands-on problem, including an answer tab, a pre-formatted worksheet with steps and videos, and a blank tab for your own work.

Download the Excel worksheet included in the next presentation to support ratio analysis of financial statements.

Develop Excel-based calculations of key ratios, including current ratio, acid test ratio, inventory turnover, debt to equity, time interest earned, return on total assets, and return on common stockholders equity.

Practice solving financial statement analysis multiple choice questions, calculating the average inventory from beginning and ending balances, and applying the inventory turnover ratio using Excel steps.

Practice multiple choice questions on financial statement analysis, calculate days' sales in inventory and total asset turnover, and identify profit margin from net income divided by net sales.

Accounting comic break within financial statement analysis highlights ratio analysis concepts for readers of financial statement analysis and ratio analysis.

Explore how a financial statement analysis report uses vertical, horizontal, and ratio analysis to benchmark against industry standards. See how software calculates ratios and highlights trends for management decisions.

Explore online financial statement analysis tools and data to calculate and interpret ratios, and benchmark your results against industry standards using free and paid resources.

Examine a sample financial statement analysis report to understand horizontal analysis, vertical analysis, and trend analysis, and apply ratio analysis to assess profitability, liquidity, solvency, and cash flow.

Explore traditional performance evaluation techniques with horizontal analysis, vertical analysis, and trend analysis on the balance sheet and income statement, including year-over-year calculations and graph interpretations.

Explore profitability through key ratios such as gross profit, net profit, return on assets, asset turnover, and return on equity, with analysis of trends and why changes occur.

Analyze solvency ratios in the sample report, including debt-to-equity and interest coverage, and note the 2005–2007 leverage trend.

Analyze liquidity through ratio analysis, examining current and quick ratios, debtor turnover, average collection period, and inventory turnover in sample reports to reveal trends and credit policy implications.

Translate ratio insights into actionable recommendations in sample financial reports. Assess Ashok Leyland’s growth prospects, expansion plans, and valuation signals to inform decision-making.

Learn how to locate publicly traded companies' financial statements online and apply ratio analysis to real data, using Coca-Cola's annual reports, 10-K, and key statements (income, balance sheet, cash flow).

Solve multiple-choice questions on financial statement analysis to compute profit margin from net income and net sales, and identify ratios like return on total assets and total asset turnover.

Explore multiple choice questions on financial statement analysis and practice test-taking skills, focusing on the dividend yield ratio as annual cash dividends per share divided by market price per share.

Analyze financial statements through ratio analysis to explore the use of accounting information. Take an accounting comic break to lighten the material while reinforcing ratio concepts.

Analyze how to use financial statements for decision making through ratio analysis. Learn the main categories—profitability, asset utilization, liquidity, and debt utilization—and key ratios like profit margin and current ratio.

Explore the DuPont system of analysis to decompose return on equity into profit margin, assets turnover, and financial leverage, revealing how ROE links to ROA and debt to assets.