Starting with this chapter, each chapter in this text will include a spreadsheet assignment based on the financial information of a fictitious company named Handyman.

The first assignments are simple-in this chapter you are asked to do little more than set up financial statement formats and input some numbers. In succeeding chapters, the spreadsheets will get more complex so that by the end of the course you will have constructed a spreadsheet that allows you to forecast operating cash flow for five years in the future and adjust your forecast depending on the operating parameters that you think are most reasonable.

So, let's get started with the first spreadsheet assignment.

The following numbers are for Handyman Company for 2009:

Your assignment is to create a spreadsheet containing a balance sheet and an income statement for Handyman Company.

$10 Long-Term Debt Interest Expense 4 31 27 700 74 50 10 Retained Earnings (as of 1/1/06) Receivables Cash Dividends Accumulated Depreciation 160