ACCT 202 1/26/26

Weekly Update and Project Management

• It is now Week 3 of the course.

• The instructor plans to review the course material later, including a proposed schedule.

CPA Journal and Company Earnings

• The instructor received emails regarding earnings reports from various companies, including:

  • Starbucks

  • Tesla

  • Southwest Airlines

  • Caterpillar (earnings announcement on Thursday)

  • Deckers Outdoor

  • L3 Harris

  • Marsh & McLennan (the instructor has a long-term investment in this company, started after college).

• An anecdote about tax implications of selling shares:

  • Shares appreciated from $1 to $100.

  • Selling would incur significant taxes; instead, shares are donated to charities, benefiting educational institutions.

Project Overview

• The course project does not primarily revolve around Excel; rather, it evaluates understanding of the company.

• Students are encouraged to:

  • Understand financial data and context rather than focus on spreadsheet aesthetics.

  • Learn to analyze and interpret meaningful information behind numbers.

  • The importance of translating data into insights is emphasized for understanding stock performance.

Student Communications and Support

• The instructor addressed student inquiries received throughout the weekend.

• Encouraged students to share their spreadsheets directly (e.g., via Google Sheets) to facilitate feedback and corrections.

  • Example provided: Diana sent her spreadsheet, allowing direct interaction for cleaning and rectifying formulas.

• The instructor acknowledges that clarity is more critical than aesthetics in initial spreadsheet submissions, advising against prioritizing visual appeal over functional accuracy.

Common Concerns Regarding Spreadsheets

• Misunderstanding of common size statements and financial ratios:

  • Example: Incorrect common size ratios (e.g., values exceeding 100% indicate a fundamental miscalculation).

• Reinforcement that common size should be based on net sales to ensure accuracy.

• The instructor offered a formulaic example to clarify common size calculations:

  • Example: 12 into 40 = 30% (indicating a specific calculation on a standard).

• A clear distinction on balance sheet calculations, stressing that all components must be correctly referenced to avoid inaccuracies in formulas and ratios.

Ratio Calculations and Analysis

• Operating cycle components and RCC days (Receivable Collection Cycle):

  • Ownership of receivables will differ based on the business model (e.g., retailers typically receive immediate payments).

  • For service-oriented businesses, the duration for payment can be significant.

• Encouragement for students to reflect on their business models when calculating various financial metrics.

Detailed Ratio Overviews

• Asset Turnover: Revenue divided by average total assets, encouraged students to calculate presenting the formula accurately:
  $ext{Asset Turnover} = rac{ ext{Net Sales}}{( ext{Total Assets}<em>{ ext{current}} + ext{Total Assets}</em>{ ext{previous}})/2}$

• Times Interest Earned Ratio calculates the ability to cover interest payments:
  $ext{Times Interest Earned} = rac{ ext{Operating Income}}{ ext{Interest Expense}}$

• Debt to Equity Ratio assesses the relationship between total liabilities and equity:
  $ext{Debt to Equity} = rac{ ext{Total Liabilities}}{ ext{Total Equity}}$

• Equity Multiplier gives insight into how much debt a company is using to finance its assets, though the instructor doesn’t find this ratio as relevant.

• Gross Margin calculated as:
  $ext{Gross Margin} = rac{ ext{Gross Profit}}{ ext{Net Sales}}$

• Net Profit Margin and the formula:
  $ext{Net Profit Margin} = rac{ ext{Net Income}}{ ext{Net Sales}}$

• Return on Total Assets to measure profitability related to total assets:
  $ext{Return on Total Assets} = rac{ ext{Net Income}}{( ext{Total Assets}<em>{ ext{current}} + ext{Total Assets}</em>{ ext{previous}})/2}$

• Return on Equity to evaluate return on shareholder investments:
  $ext{Return on Equity} = rac{ ext{Net Income}}{( ext{Total Equity}<em>{ ext{current}} + ext{Total Equity}</em>{ ext{previous}})/2}$

• Earnings Per Share (EPS) - the instructor emphasized the importance of this measure:
  $ext{EPS} = ext{Net Income}/ ext{Number of Outstanding Shares}$

• Price to Earnings (P/E) Ratio relates stock price to earnings per share:
  $ext{P/E Ratio} = rac{ ext{Market Price per Share}}{ ext{Earnings Per Share}}$

Importance of Context in Financial Metrics

• Discussion on how debt isn’t inherently bad; it can enhance financial leverage and investment potential (with examples explaining mortgage scenarios).

• Emphasis on industry comparisons when evaluating performance metrics as financial health and strategies vary across sectors.

Future Directions

• Students are expected to finalize their spreadsheets by Wednesday.

• Upcoming lessons will include cash flow analysis integrated into the projects, aimed to lead towards completion by Friday.

• Reinforcement of the understanding that comprehension of the company’s financials and health is more valuable than merely acquiring a good grade.

• The instructor encourages students to embrace the learning process and clarifies any misconceptions they might have regarding ratio analysis and business evaluations.

Final Remarks

• Encouragement for students to seek clarifications on any point covered.

• Recognition of collective effort and motivation for all to succeed in understanding their companies, underlying ratios, and market contextual analysis.