Comprehensive Accounting Exam 2 Study Guide: Internal Controls, Receivables, Merchandising, Inventory Cost Flows, and Financial Ratios

Internal Control Framework and the Regulatory Environment

  • Sarbanes-Oxley Act of 2002 (SOX):

    • Primary Responsibility: Company management holds the primary legal and operational responsibility for establishing and maintaining an adequate system of internal control over financial reporting.
    • Auditor Role: External independent auditors review, assess, and attest to management's internal control assertions, but they do not establish or maintain the system.
    • Governance: The board of directors and its audit committee provide oversight, while internal auditors evaluate operational efficiency and adherence to controls internally, yet primary statutory accountability remains with executive management.
  • Core Objectives of Internal Control Systems:

    • Reliability of financial reporting: Ensuring that published financial statements are dependable, prepared in conformity with Generally Accepted Accounting Principles (GAAP), and free from material misstatement.
    • Effectiveness and efficiency of company operations: Streamlining operational activities, protecting company resources from misuse, and optimizing performance.
    • Compliance with applicable laws and regulations: Ensuring adherence to federal, state, local, and securities regulations.
    • Scope Exclusion: Internal control systems are designed to safeguard company processes and assets; they do not exist to consolidate departments within the accounting function.
  • COSO Internal Control Framework Components:

    • Control Environment: The overarching tone at the top set by board leadership and executive management regarding integrity and ethical standards.
    • Risk Assessment: Identifying, evaluating, and managing operational and reporting risks that could impede entity objectives.
    • Control Activities: Specific policies, mechanisms, and procedures enacted to address identified risks and enforce organizational directives.
    • Information and Communication: The timely identification, capture, and dissemination of operational and financial information throughout the entity.
    • Monitoring: Ongoing evaluations and separate assessments of internal control performance over time.
    • Distinction Between Components and Activities: Segregation of duties is a specific control activity, not one of the five foundational internal control components.
  • Key Internal Control Activities and Practical Applications:

    • Safeguarding of Assets and Records: Physical protection of resources and information. For example, maintaining inventory storage areas secured with locked facilities and strictly limited access prevents unauthorized removal and theft.
    • Segregation of Duties (Separation of Functions): Incompatible responsibilities must be dispersed among multiple individuals so no single worker controls all phases of a transaction. A violation occurs when a retail cashier operates the cash register and simultaneously records daily receipts in the accounting journal, which combines asset custody with recordkeeping and exposes the firm to undetected misappropriation.
    • Independent Checks on Recorded Amounts: Periodic internal reconciliations and surprise counts conducted by workers who do not handle the underlying asset or primary journal entries.
    • Clearly Defined Authority and Responsibility: Establishing official lines of authorization so that every financial commitment requires appropriate managerial sign-off.

Cash, Cash Equivalents, and Liquidity Management

  • Concept of Liquidity:

    • Definition: Liquidity represents the speed and ease with which an asset can be converted into cash without significant loss of value.
    • Relative Asset Liquidity Hierarchy: Cash equivalents are the most liquid non-cash assets, followed in descending order of liquidity by accounts receivable, merchandise inventory, and prepaid expenses (such as prepaid insurance).
  • Composition of Cash and Cash Equivalents:

    • Included Items: Readily available balances such as petty cash funds, checking accounts at banks, savings accounts at banks, and short-term debt instruments maturing within 90 days90\,\text{days} (or 3 months3\,\text{months}) of acquisition.
    • Excluded Items: Financial instruments with maturity horizons exceeding 90 days90\,\text{days} at purchase. For example, a bank certificate of deposit (CD) with an original term of 1 year1\,\text{year} is classified separately as a short-term investment or marketable security rather than a cash equivalent.

Receivables Management and Bad Debt Accounting

  • Distinction Between Accounts Receivable and Notes Receivable:

    • Accounts Receivable: Informal short-term credit arrangements resulting from credit sales on open accounts, typically non-interest bearing if paid within standard trade credit periods (3030 to 60 days60\,\text{days}).
    • Notes Receivable: Formal written promissory agreements that explicitly state a principal face amount, an agreed-upon annual interest rate, and a fixed maturity date at which principal and accrued interest must be repaid.
  • Promissory Note Interest Calculations:

    • Interest Formula: Simple interest is a mathematical function of three specific variables: principal (amount borrowed), annual interest rate, and time (length of the loan period expressed as a fraction of a year):         Interest=Principal×Annual Interest Rate×Time\text{Interest} = \text{Principal} \times \text{Annual Interest Rate} \times \text{Time}
    • Worked Example (Art Shoes Note Receivable):
      • Transaction Terms: Face amount of $45,000\$45,000, term of 12 months12\,\text{months}, and an annual interest rate of 10%10\%, issued on July 1.
      • Accrual Period: July 1 to December 31 represents 6 months6\,\text{months}.
      • Accrued Interest Revenue on December 31:             \text{Interest Revenue} = \45,000 \times 0.10 \times \frac{6}{12} = \2,2502,250
    • Worked Example (Promissory Note Payable Accrual):
      • Note Terms: Face amount of $12,000\$12,000, term of 4 years4\,\text{years}, and an annual interest rate of 12%12\%.
      • Accrual Period: 6 months6\,\text{months}.
      • Accrued Interest Expense:             \text{Interest Expense} = \12,000 \times 0.12 \times \frac{6}{12} = \720720
  • Allowance Method for Bad Debts:

    • Theoretical Foundation: Adheres to the matching principle by estimating uncollectible account losses in the exact period that the corresponding credit sales occur, prior to individual account defaults.
    • Classification of Allowance for Doubtful Accounts: A contra-asset account with a normal credit balance, reported on the balance sheet directly paired against gross accounts receivable.
    • Net Realizable Value (NRV): The estimated net cash expected to be collected from receivables:         Net Realizable Value=Gross Accounts Receivable−Allowance for Doubtful Accounts\text{Net Realizable Value} = \text{Gross Accounts Receivable} - \text{Allowance for Doubtful Accounts}
    • Worked Example (Abbot Safe & Lock Valuation):
      • Data: Gross Accounts Receivable at December 31 equals $325,000\$325,000; Allowance for Doubtful Accounts after year-end adjustment equals $35,000\$35,000; Annual Credit Sales equal $3,200,000\$3,200,000; Bad Debt Expense equals $20,000\$20,000.
      • Balance Sheet Net Realizable Value:             Net Realizable Value=$325,000−$35,000=$290,000\text{Net Realizable Value} = \$325,000 - \$35,000 = \$290,000
  • Estimation Methods for Bad Debts:

    • Percentage of Net Credit Sales Method (Income Statement Approach):
      • Calculates the periodic bad debt expense directly from net credit sales.
      • Formula for Bad Debt Expense:             Bad Debt Expense=Net Credit Sales×Estimated Uncollectible Percentage\text{Bad Debt Expense} = \text{Net Credit Sales} \times \text{Estimated Uncollectible Percentage}
      • Net Credit Sales Computation:             Net Credit Sales=Gross Credit Sales−Sales Returns and Allowances−Sales Discounts\text{Net Credit Sales} = \text{Gross Credit Sales} - \text{Sales Returns and Allowances} - \text{Sales Discounts}
      • Effect on Allowance: The calculated bad debt expense is credited directly into the allowance account, adding to any existing pre-adjustment balance.
    • Aging of Accounts Receivable Method (Balance Sheet Approach):
      • Estimates the target ending balance required in the Allowance for Doubtful Accounts based on the age distribution of uncollected receivables.
      • Adjustment Calculation: The bad debt expense recorded is the incremental amount required to bring the unadjusted allowance balance up to the calculated target balance.
    • Worked Case Study (A&B Foods Year-End Bad Debt Accounting):
      • Provided Records: Gross credit sales equal $2,100,000\$2,100,000; Sales returns equal $150,000\$150,000; Accounts receivable at December 31 equals $420,000\$420,000; Unadjusted credit balance in Allowance for Doubtful Accounts equals $25,000\$25,000; Estimated uncollectible accounts via aging analysis equals $75,000\$75,000.
      • Net Credit Sales Calculation:             Net Credit Sales=$2,100,000−$150,000=$1,950,000\text{Net Credit Sales} = \$2,100,000 - \$150,000 = \$1,950,000
      • Bad Debt Expense Calculation at 4%4\% of Net Credit Sales:             \text{Bad Debt Expense} = \1,950,000 \times 0.04 = \78,00078,000
      • Ending Balance in Allowance for Doubtful Accounts:             Ending Allowance Balance=Unadjusted Balance+Bad Debt Expense=$25,000+$78,000=$103,000\text{Ending Allowance Balance} = \text{Unadjusted Balance} + \text{Bad Debt Expense} = \$25,000 + \$78,000 = \$103,000
      • Alternative Context: If the company had instead utilized the aging of accounts receivable method, the ending allowance balance would be set directly to $75,000\$75,000, and the bad debt expense recognized would have been $75,000−$25,000=$50,000\$75,000 - \$25,000 = \$50,000.
  • Dynamics of Accounts Receivable Write-Offs:

    • Journal Entry for Specific Account Write-Off:
      • Debit: Allowance for Doubtful Accounts
      • Credit: Accounts Receivable
    • Impact on Balance Sheet Values: Writing off a confirmed uncollectible account reduces gross accounts receivable and reduces the allowance account by identical amounts. Consequently, the net realizable value of accounts receivable remains completely unchanged immediately following the write-off.
    • Worked Example:
      • Initial Position: Gross accounts receivable equals $50,000\$50,000; Allowance for doubtful accounts equals $5,000\$5,000.
      • Initial Net Realizable Value:             NRVInitial=$50,000−$5,000=$45,000\text{NRV}_{\text{Initial}} = \$50,000 - \$5,000 = \$45,000
      • Transaction: Write-off of an uncollected account of $1,000\$1,000.
      • Post-Write-Off Balances: Gross receivables become $49,000\$49,000; Allowance balance becomes $4,000\$4,000.
      • Post-Write-Off Net Realizable Value:             NRVAfter Write-Off=$49,000−$4,000=$45,000\text{NRV}_{\text{After Write-Off}} = \$49,000 - \$4,000 = \$45,000
  • Reconstructing Accounts Receivable Balances:

    • T-Account Formula:         Ending Accounts Receivable=Beginning Accounts Receivable+Credit Sales−Cash Collections−Write-Offs\text{Ending Accounts Receivable} = \text{Beginning Accounts Receivable} + \text{Credit Sales} - \text{Cash Collections} - \text{Write-Offs}
    • Worked Example:
      • Beginning accounts receivable equals $175,000\$175,000.
      • Total credit sales on account equal $550,000\$550,000.
      • Cash collections from customers equal $650,000\$650,000.
      • Ending accounts receivable balance calculation:             Ending Accounts Receivable=$175,000+$550,000−$650,000=$75,000\text{Ending Accounts Receivable} = \$175,000 + \$550,000 - \$650,000 = \$75,000

Sales Transactions, Merchandising, and Discounts

  • Structure of Credit Terms (x/y,n/zx/y, n/z):

    • xx: The cash discount percentage granted to the buyer.
    • yy: The discount period duration in days from invoice date.
    • nn: Net invoice amount due.
    • zz: The total credit period duration in days.
    • Example Terms (2/10,n/302/10, n/30): The customer may deduct 2%2\% from the gross invoice amount if paid within 10 days10\,\text{days}; otherwise, the entire net amount is due within 30 days30\,\text{days}.
    • Example Terms (1/10,n/301/10, n/30): A 1%1\% cash discount applies if payment occurs within 10 days10\,\text{days}; the net invoice amount must be paid within 30 days30\,\text{days}.
  • The Gross Method of Recording Receivables and Sales:

    • Initial Entry: The seller records the receivable and sales revenue at full gross price without anticipating discounts.
    • Case (Action Signs):
      • Terms: Credit sales of $10,000\$10,000, terms 2/20,n/302/20, n/30.
      • Journal Entry upon Sale: Accounts Receivable is debited for $10,000\$10,000, and Sales Revenue is credited for $10,000\$10,000.
    • Payment Received Within Discount Window:
      • The buyer receives the discount; the seller records Cash (net amount), Sales Discounts (contra-revenue account), and credits Accounts Receivable (gross amount).
      • Case (Alfredo Corporation):
        • Sale terms: Gross price $100,000\$100,000, terms 2/10,n/302/10, n/30, sold January 2.
        • Payment date: January 8 (6 days6\,\text{days} elapsed, within 10-day10\text{-day} limit).
        • Sales Discount Recorded: \100,000 \times 0.02 = \2,0002,000.
        • Cash Received: $100,000−$2,000=$98,000\$100,000 - \$2,000 = \$98,000.
      • Case (Receivable Payment Calculation):
        • A company collecting an outstanding balance of $20,000\$20,000 within 10 days10\,\text{days} under terms 2/10,n/302/10, n/30 recognizes a sales discount equal to 2% of $20,0002\% \text{ of } \$20,000 (which evaluates to $400\$400).
      • Case (Eli Company / Faulkner, Inc. - Discount Taken):
        • Sale: March 5, 2021; 100 decor packs @ $20\$20 list price = $2,000\$2,000 gross invoice; terms 1/10,n/301/10, n/30.
        • Payment Date: March 14, 2021 (9 days9\,\text{days} elapsed, qualifying for discount).
        • Cash Received:                 \text{Discount} = \2,000 \times 0.01 = \2020Cash Received=$2,000−$20=$1,980\text{Cash Received} = \$2,000 - \$20 = \$1,980
    • Payment Received After Discount Expiration:
      • Full invoice amount is paid; no sales discount is recognized ($0\$0 discount).
      • Case (Coffski, Inc.): Invoice of $1,000\$1,000 dated June 10 with terms 1/10,n/301/10, n/30. The discount window expires on June 20. If paid on July 9, the transaction falls within the allowable 30-day30\text{-day} net credit window (due July 10), requiring payment of the full $1,000\$1,000.
      • Case (Eli Company / Faulkner, Inc. - Discount Forfeited): If Faulkner pays the invoice on March 31, 2021 (exceeding the 10-day10\text{-day} cutoff), the sales discount recognized is $0\$0, and the cash collected is $2,000\$2,000.
  • Computation of Net Sales:

    • Formula:         Net Sales=Gross Sales−Sales Discounts−Sales Returns and Allowances\text{Net Sales} = \text{Gross Sales} - \text{Sales Discounts} - \text{Sales Returns and Allowances}
    • Worked Example:
      • Gross Sales equal $40,000\$40,000.
      • Sales Discounts equal $800\$800.
      • Sales Returns equal $1,600\$1,600.
      • Net Sales Calculation:             Net Sales=$40,000−$800−$1,600=$37,600\text{Net Sales} = \$40,000 - \$800 - \$1,600 = \$37,600

Inventory Accounting, Valuation, and Cost Flows

  • Inventory Cost Principles and Freight Terminology:

    • Freight-in (Transportation-in): Shipping costs incurred by the buyer to transport merchandise into the company. Freight-in is capitalized as a direct component of the cost of inventory, never categorized as an operating expense.
    • Freight-out (Delivery Expense): Shipping costs paid by the seller to transport goods to customers. Freight-out is treated as a selling/operating expense.
  • Shipping Terms and Title Transfer:

    • F.O.B. Shipping Point (Free On Board Shipping Point):
      • Title and ownership transfer from the seller to the buyer at the shipping point when the carrier takes possession of the goods.
      • The buyer owns goods in transit and is responsible for paying freight costs (freight-in).
      • Worked Case (Satoor, Inc. / Taye Company):
        • Transaction: Satoor, Inc. purchased goods from Taye Company on July 7 for $15,000\$15,000, terms 1/10,n/301/10, n/30, shipped F.O.B. shipping point on July 7. Satoor received the goods on July 10 and settled payment on July 15.
        • Title Transfer Date: Title transferred on July 7.
        • Freight Responsibility: The buyer (Satoor, Inc.) pays transportation costs.
    • F.O.B. Destination (Free On Board Destination):
      • Title transfers only when the merchandise physically arrives at the buyer's destination facility.
      • The seller owns the goods in transit and bears shipping costs (freight-out).
  • Cost of Goods Sold (COGS) Formula:

    • Basic Inventory Equations:         Cost of Goods Available for Sale=Beginning Inventory+Net Purchases\text{Cost of Goods Available for Sale} = \text{Beginning Inventory} + \text{Net Purchases}Net Purchases=Gross Purchases−Purchase Returns and Allowances−Purchase Discounts+Freight-in\text{Net Purchases} = \text{Gross Purchases} - \text{Purchase Returns and Allowances} - \text{Purchase Discounts} + \text{Freight-in}Cost of Goods Sold=Cost of Goods Available for Sale−Ending Inventory\text{Cost of Goods Sold} = \text{Cost of Goods Available for Sale} - \text{Ending Inventory}
    • Purchases Calculation via COGS Model (Bihary Company):
      • Beginning Inventory equals $2,250\$2,250.
      • Ending Inventory equals $1,500\$1,500.
      • Cost of Goods Sold equals $9,750\$9,750.
      • Formula Restructuring:             Purchases=Cost of Goods Sold+Ending Inventory−Beginning Inventory\text{Purchases} = \text{Cost of Goods Sold} + \text{Ending Inventory} - \text{Beginning Inventory}Purchases=$9,750+$1,500−$2,250=$9,000\text{Purchases} = \$9,750 + \$1,500 - \$2,250 = \$9,000
    • Comprehensive COGS Determination (Gbane Company):
      • Given Data: Purchases = $218,400\$218,400; Freight-in = $13,200\$13,200; Purchase Returns and Allowances = $10,080\$10,080; Inventory on January 1 = $31,800\$31,800; Inventory on December 31 = $34,560\$34,560.
      • Net Purchases:             Net Purchases=$218,400−$10,080+$13,200=$221,520\text{Net Purchases} = \$218,400 - \$10,080 + \$13,200 = \$221,520
      • Cost of Goods Available for Sale:             Cost of Goods Available for Sale=$31,800+$221,520=$253,320\text{Cost of Goods Available for Sale} = \$31,800 + \$221,520 = \$253,320
      • Cost of Goods Sold:             Cost of Goods Sold=$253,320−$34,560=$218,760\text{Cost of Goods Sold} = \$253,320 - \$34,560 = \$218,760
  • Perpetual Inventory System Journal Entries (Purchase Discounts):

    • Under a perpetual inventory system, cash purchase discounts taken reduce the carrying cost of Merchandise Inventory directly.
    • Analysis of Entry (Jentzen Corp.):
      • October 15 Entry: Debit Accounts Payable $4,000\$4,000, Credit Merchandise Inventory $40\$40, Credit Cash $3,960\$3,960.
      • Transaction Meaning: Jentzen Corp. paid for merchandise previously purchased on credit within the terms window, securing a 1%1\% purchase discount ($40/$4,000=1%\$40 / \$4,000 = 1\%) and disbursing the net cash balance.
  • Acceptable Inventory Costing Methods under GAAP:

    • Acceptable Cost Flow Assumptions: Specific identification, First-In, First-Out (FIFO), Last-In, First-Out (LIFO), and Weighted Average / Moving Average.
    • Unacceptable Methods: Retail cost (retail inventory method is an estimation technique rather than a standalone standard cost flow valuation method for financial accounting statements).
    • Cost Flow Assumptions vs. Ending Inventory Representation:
      • FIFO Cost Flow: Assumes the earliest units acquired are sold first. Therefore, the units remaining in ending inventory represent the most recent purchase(s), not the oldest.
      • LIFO Cost Flow: Assumes the most recent units acquired are sold first. Therefore, the units remaining in ending inventory represent the oldest purchase(s), not the most recent.

Comprehensive Inventory Cost Flow Analysis (Perpetual System)

  • Klump Co. Master Case Study Data:

    • June 1 (Beginning Inventory): 50 units50\,\text{units} @ $18.00=$900.00\$18.00 = \$900.00
    • June 4 (Purchase): 115 units115\,\text{units} @ $18.20=$2,093.00\$18.20 = \$2,093.00
    • June 5 (Sale): 100 units100\,\text{units}
    • June 10 (Purchase): 75 units75\,\text{units} @ $18.25=$1,368.75\$18.25 = \$1,368.75
    • June 24 (Sale): 40 units40\,\text{units}
    • June 30 (Ending Physical Count): 100 units100\,\text{units}
    • Aggregate Totals:         Total Units Available=50+115+75=240 units\text{Total Units Available} = 50 + 115 + 75 = 240\,\text{units}Total Cost of Goods Available for Sale (COGAS)=$900.00+$2,093.00+$1,368.75=$4,361.75\text{Total Cost of Goods Available for Sale (COGAS)} = \$900.00 + \$2,093.00 + \$1,368.75 = \$4,361.75Total Units Sold=100+40=140 units\text{Total Units Sold} = 100 + 40 = 140\,\text{units}Ending Inventory Units=240−140=100 units\text{Ending Inventory Units} = 240 - 140 = 100\,\text{units}
  • Perpetual First-In, First-Out (FIFO) Costing:

    • Sale on June 5 (100 units100\,\text{units}):
      • Sells all 50 units50\,\text{units} from June 1 inventory @ $18.00=$900.00\$18.00 = \$900.00
      • Sells 50 units50\,\text{units} from June 4 purchase @ $18.20=$910.00\$18.20 = \$910.00
      • Cost of Goods Sold for June 5: $900.00+$910.00=$1,810.00\$900.00 + \$910.00 = \$1,810.00
      • Inventory Remaining: 65 units65\,\text{units} @ $18.20=$1,183.00\$18.20 = \$1,183.00
    • Purchase on June 10 (75 units75\,\text{units} @ $18.25\$18.25):
      • Inventory Layers: 65 units65\,\text{units} @ $18.20\$18.20 and 75 units75\,\text{units} @ $18.25\$18.25
    • Sale on June 24 (40 units40\,\text{units}):
      • Sells 40 units40\,\text{units} from oldest available layer (65 units65\,\text{units} @ $18.20\$18.20):             COGS for June 24=40×$18.20=$728.00\text{COGS for June 24} = 40 \times \$18.20 = \$728.00
    • Total Month COGS (FIFO):         Cost of Goods Sold=$1,810.00+$728.00=$2,538.00\text{Cost of Goods Sold} = \$1,810.00 + \$728.00 = \$2,538.00
    • Ending Inventory at June 30 (FIFO):
      • Remaining Layers: 25 units25\,\text{units} @ $18.20=$455.00\$18.20 = \$455.00 plus 75 units75\,\text{units} @ $18.25=$1,368.75\$18.25 = \$1,368.75
      • Total Value:             Ending Inventory=$455.00+$1,368.75=$1,823.75\text{Ending Inventory} = \$455.00 + \$1,368.75 = \$1,823.75
      • Verification via COGAS:             Ending Inventory=$4,361.75−$2,538.00=$1,823.75\text{Ending Inventory} = \$4,361.75 - \$2,538.00 = \$1,823.75
  • Perpetual Last-In, First-Out (LIFO) Costing:

    • Inventory prior to June 5 Sale: 50 units50\,\text{units} @ $18.00\$18.00 and 115 units115\,\text{units} @ $18.20\$18.20.
    • Sale on June 5 (100 units100\,\text{units}):
      • Sells 100 units100\,\text{units} from most recent layer (June 4 purchase @ $18.20\$18.20):             COGS for June 5=100×$18.20=$1,820.00\text{COGS for June 5} = 100 \times \$18.20 = \$1,820.00
      • Inventory Layers Remaining: 50 units50\,\text{units} @ $18.00=$900.00\$18.00 = \$900.00 and 15 units15\,\text{units} @ $18.20=$273.00\$18.20 = \$273.00
    • Purchase on June 10 (75 units75\,\text{units} @ $18.25\$18.25):
      • Inventory Layers: 50 units50\,\text{units} @ $18.00\$18.00, 15 units15\,\text{units} @ $18.20\$18.20, and 75 units75\,\text{units} @ $18.25\$18.25
    • Sale on June 24 (40 units40\,\text{units}):
      • Sells 40 units40\,\text{units} from latest purchase (June 10 layer @ $18.25\$18.25):             COGS for June 24=40×$18.25=$730.00\text{COGS for June 24} = 40 \times \$18.25 = \$730.00
      • Remaining from June 10 layer: 35 units35\,\text{units} @ $18.25=$638.75\$18.25 = \$638.75
    • Total Month COGS (LIFO):         Cost of Goods Sold=$1,820.00+$730.00=$2,550.00\text{Cost of Goods Sold} = \$1,820.00 + \$730.00 = \$2,550.00
    • Ending Inventory at June 30 (LIFO):
      • Remaining Layers: 50 units50\,\text{units} @ $18.00=$900.00\$18.00 = \$900.00, 15 units15\,\text{units} @ $18.20=$273.00\$18.20 = \$273.00, and 35 units35\,\text{units} @ $18.25=$638.75\$18.25 = \$638.75
      • Total Value:             Ending Inventory=$900.00+$273.00+$638.75=$1,811.75\text{Ending Inventory} = \$900.00 + \$273.00 + \$638.75 = \$1,811.75
      • Verification via COGAS:             Ending Inventory=$4,361.75−$2,550.00=$1,811.75\text{Ending Inventory} = \$4,361.75 - \$2,550.00 = \$1,811.75
  • Perpetual Moving Average Costing:

    • Step 1: Position on June 4 prior to sale:
      • Total Units: 50+115=165 units50 + 115 = 165\,\text{units}
      • Total Cost: $900.00+$2,093.00=$2,993.00\$900.00 + \$2,093.00 = \$2,993.00
      • Average Cost per Unit:             \text{Unit Cost}_1 = \frac{\2,993.00}{165} \approx \18.13939418.139394
    • Step 2: Sale on June 5 (100 units100\,\text{units}):         COGS for June 5=100×$18.139394=$1,813.94\text{COGS for June 5} = 100 \times \$18.139394 = \$1,813.94Remaining Cost=$2,993.00−$1,813.94=$1,179.06(65 units)\text{Remaining Cost} = \$2,993.00 - \$1,813.94 = \$1,179.06\quad (65\,\text{units})
    • Step 3: Purchase on June 10 (75 units75\,\text{units} @ $18.25=$1,368.75\$18.25 = \$1,368.75):
      • New Total Units: 65+75=140 units65 + 75 = 140\,\text{units}
      • New Total Cost: $1,179.06+$1,368.75=$2,547.81\$1,179.06 + \$1,368.75 = \$2,547.81
      • Recalculated Moving Average Cost per Unit:             \text{Unit Cost}_2 = \frac{\2,547.81}{140} \approx \18.19864318.198643
    • Step 4: Sale on June 24 (40 units40\,\text{units}):         COGS for June 24=40×$18.198643=$727.95\text{COGS for June 24} = 40 \times \$18.198643 = \$727.95Remaining Units=140−40=100 units\text{Remaining Units} = 140 - 40 = 100\,\text{units}
    • Total Month COGS (Moving Average):         Cost of Goods Sold=$1,813.94+$727.95=$2,541.89\text{Cost of Goods Sold} = \$1,813.94 + \$727.95 = \$2,541.89
    • Ending Inventory at June 30 (Moving Average):         Ending Inventory=100×$18.198643=$1,819.86\text{Ending Inventory} = 100 \times \$18.198643 = \$1,819.86
      • Verification via COGAS:             Ending Inventory=$4,361.75−$2,541.89=$1,819.86\text{Ending Inventory} = \$4,361.75 - \$2,541.89 = \$1,819.86

Financial Ratios and Performance Metrics

  • Profitability Ratios (All-4-U Company Comprehensive Dataset):

    • Company Performance Data:
      • Net Sales: $8,000,000\$8,000,000
      • Cost of Goods Sold: $4,500,000\$4,500,000
      • Gross Profit: $3,500,000\$3,500,000
      • Operating Income: $800,000\$800,000
      • Net Income: $500,000\$500,000
      • Accounts Receivable (Prior Year December 31): $1,500,000\$1,500,000
      • Accounts Receivable (Current Year December 31): $1,300,000\$1,300,000
    • Gross Profit Ratio (Gross Margin Percentage):         Gross Profit Ratio=Gross ProfitNet Sales=$3,500,000$8,000,000=43.75%≈44%\text{Gross Profit Ratio} = \frac{\text{Gross Profit}}{\text{Net Sales}} = \frac{\$3,500,000}{\$8,000,000} = 43.75\% \approx 44\%
    • Operating Margin Ratio (Operating Income Ratio):         Operating Margin Ratio=Operating IncomeNet Sales=$800,000$8,000,000=10%\text{Operating Margin Ratio} = \frac{\text{Operating Income}}{\text{Net Sales}} = \frac{\$800,000}{\$8,000,000} = 10\%
    • Net Profit Margin Ratio (Return on Sales):         Net Profit Ratio=Net IncomeNet Sales=$500,000$8,000,000=6.25%≈6%\text{Net Profit Ratio} = \frac{\text{Net Income}}{\text{Net Sales}} = \frac{\$500,000}{\$8,000,000} = 6.25\% \approx 6\%
    • Accounts Receivable Turnover Ratio:
      • Average Accounts Receivable Computation:             Average Accounts Receivable=$1,500,000+$1,300,0002=$1,400,000\text{Average Accounts Receivable} = \frac{\$1,500,000 + \$1,300,000}{2} = \$1,400,000
      • Turnover Ratio Calculation:             Accounts Receivable Turnover=Net SalesAverage Accounts Receivable=$8,000,000$1,400,000≈5.71\text{Accounts Receivable Turnover} = \frac{\text{Net Sales}}{\text{Average Accounts Receivable}} = \frac{\$8,000,000}{\$1,400,000} \approx 5.71
  • Inventory Efficiency Ratios (Pham Enterprises Dataset):

    • Company Operating Data:
      • Net Sales: $450,000\$450,000
      • Cost of Goods Sold: $299,500\$299,500
      • Beginning Inventory (January 1): $48,400\$48,400
      • Ending Inventory (December 31): $49,670\$49,670
    • Inventory Turnover Ratio:
      • Definition: Measures the number of times average inventory is sold during a reporting cycle.
      • Average Inventory Calculation:             Average Inventory=Beginning Inventory+Ending Inventory2=$48,400+$49,6702=$49,035\text{Average Inventory} = \frac{\text{Beginning Inventory} + \text{Ending Inventory}}{2} = \frac{\$48,400 + \$49,670}{2} = \$49,035
      • Turnover Calculation:             Inventory Turnover Ratio=Cost of Goods SoldAverage Inventory=$299,500$49,035≈6.108\text{Inventory Turnover Ratio} = \frac{\text{Cost of Goods Sold}}{\text{Average Inventory}} = \frac{\$299,500}{\$49,035} \approx 6.108
    • Average-Days-to-Sell Inventory (Days Sales in Inventory):
      • Definition: Measures the average number of days required to transform merchandise inventory into sales revenue.
      • Days in Inventory Calculation using a 365-day365\text{-day} year:             Average-Days-to-Sell=365Inventory Turnover Ratio=3656.10788≈59.76 days\text{Average-Days-to-Sell} = \frac{365}{\text{Inventory Turnover Ratio}} = \frac{365}{6.10788} \approx 59.76\,\text{days}