10.xlsx

Sheet1

Module 10 Financial Fact Sheet - Scarlett Company and Gable Company
Information from year end balance sheets Information from current period income statement
Scarlett Company Gable Company Scarlett Company Gable Company
Assets Sales $ 397,600.00 $ 671,500.00
Cash $ 24,000.00 $ 40,500.00 Cost of Goods Sold $ 294,600.00 $ 484,000.00
Accounts Recevables $ 81,100.00 $ 74,500.00 Interest Expense $ 8,100.00 $ 14,400.00
Current Notes Receivables $ 15,600.00 $ 13,000.00 Income Tax Expense $ 9,700.00 $ 16,300.00
Merchandise Inventory $ 90,800.00 $ 86,000.00 Net Income $ 37,850.00 $ 65,700.00
Prepaid Expenses $ 13,700.00 $ 14,100.00 EPS, Basic $ 2.00 $ 3.00
Plant Assets $ 180,900.00 $ 256,300.00
Total Assets $ 406,100.00 $ 484,400.00
Liabilities and Equity Beginning of the year balances
Current Liabilites $ 95,500.00 $ 105,000.00 Accoutns Receivables $ 76,200.00 $ 77,300.00
Long Term Notes Payable $ 97,000.00 $ 97,300.00 Current Notes Receivables $ - 0 $ - 0
Common Stock, $10 par $ 140,000.00 $ 145,000.00 Merchandise Inventory $ 109,100.00 $ 84,500.00
Retained Earnings $ 73,600.00 $ 137,100.00 Total Assets $ 387,400.00 $ 447,000.00
Total Liabilities and Equity $ 406,100.00 $ 484,400.00 Common Stock, $10 par $ 137,000.00 $ 145,000.00
Retained Earnings $ 53,100.00 $ 113,700.00

Sheet2

Sheet3