








|
|
ISBN: 0-03-028931-9
Spreadsheet Problem Template
Chapter 2. Template for end-of-chapter spreadsheet problem
This is the financial data shown in the spreadsheet problem for Chapter 2. This data, along with financial
statements created in this problem will be used in the spreadsheet problems for Chapter 3 and Chapter 4.
Laiho Industries December 31 Balance Sheets
(in thousands of dollars)
| |
2000 |
1999 |
| Assets | | |
| Cash and cash equivalents |
$102,850 |
$89,725 |
| Accounts Receivable |
$103,365 |
$85,527 |
| Inventories |
$38,444 |
$34,982 |
| Total current assets |
$244,659 |
$210,234 |
| Fixed assets |
$67,165 |
$42,436 |
| Total assets |
$311,824 |
$252,670 |
| Liabilities and equity | | |
| Accounts payable |
$30,761 |
$23,109 |
| Accruals |
$30,477 |
$22,656 |
| Notes payable |
$16,717 |
$14,217 |
| Total current liabilities |
$77,955 |
$59,982 |
| Long-term debt |
$76,264 |
$63,914 |
| Total liabilities |
$154,219 |
$123,896 |
| Common stock |
$100,000 |
$90,000 |
| Retained Earnings |
$57,605 |
$38,774 |
| Total common equity |
$157,605 |
$128,774 |
| Total liabilities and equity |
$311,824 |
$252,670 |

Copyright © Harcourt College Publishers, A Harcourt
Higher Learning Company. All rights reserved.
|