Finance Home
 










 

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

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