04 Case model - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
04 Case model 3/22/2010 7:09 2/17/2006 Chapter 4. Analysis of Financial Statements EXHIBITS: INPUT DATA (for D'Leon) 2006E 2005 2004 Assets Cash $85,632 $7,282 $57,600 Accounts receivable 878,000 632,160 351,200 Inventories 1,716,480 1,287,360 715,200 Total current assets $2,680,112 $1,926,802 $1,124,000 Gross fixed assets 1,197,160 1,202,950 491,000 Less: accumulated depreciation 380,120 263,160 146,200 Net fixed assets $817,040 $939,790 $344,800 Total assets $3,497,152 $2,866,592 $1,468,800 Liabilities and equity Accounts payable $436,800 $524,160 $145,600 Notes payable 300,000 636,808 200,000 Accruals 408,000 489,600 136,000 Total current liabilities $1,144,800 $1,650,568 $481,600 Long-term bonds 400,000 723,432 323,432 Total debt $1,544,800 $2,374,000 $805,032 Common stock (100,000 shares) 1,721,176 460,000 460,000 Retained earnings 231,176 32,592 203,768 Total common equity $1,952,352 $492,592 $663,768 Total liabilities and equity $3,497,152 $2,866,592 $1,468,800 2006E 2005 2004 Net sales $7,035,600 $6,034,000 $3,432,000 Cost of goods sold 5,875,992 5,528,000 2,864,000 Other expenses 550,000 519,988 358,672 Total operating expenses excluding depreciation $6,425,992 $6,047,988 $3,222,672 Earnings before interest, taxes, deprn, and amortization (EBITDA) $609,608 ($13,988) $209,328 Depreciation 116,960 116,960 18,900 Earnings before interest and taxes (EBIT) $492,648 ($130,948) $190,428 Interest expense 70,008 136,012 43,828 Earnings before taxes (EBT) $422,640 ($266,960) $146,600 Taxes (40%) 169,056 (106,784) 58,640 Net Income $253,584 ($160,176) $87,960 This spreadsheet model is designed to be used in conjunction with the chapter's integrated
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/21/2010 for the course BUSINESS AB102 taught by Professor Woo during the Spring '10 term at Nanzan.

Page1 / 6

04 Case model - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online