Problem: I want to create a statement of cash flow for the year ending 2004 and sources and uses of funds statement for the year ending 2004. See below for the dataset.
|
2004 |
2003 |
| Sales |
$3,785.28 |
$3,485.31 |
| COGS |
$2,287.28 |
$2,147.11 |
| GROSS PROFIT |
$1,498.00 |
$1,338.20 |
| Selling & Admin. Expenses |
$1,203.65 |
$1,085.84 |
| INCOME after DEP & AMOR |
$ 294.35 |
$ 252.36 |
| Interest |
$ 26.07 |
$ 25.59 |
| PRETAX INC |
$ 265.79 |
$ 234.15 |
| Income tax |
$ 68.49 |
$ 72.11 |
| Minority Interest |
$ 4.88 |
$ 4.77 |
| NET INCOME |
$ 192.42 |
$ 157.25 |
|
|
|
| BALANCE SHEET |
|
|
| Csah and Equivalents |
$ 565.23 |
$ 693.59 |
| Receivables |
$ 660.59 |
$ 532.32 |
| Inventories |
$ 458.43 |
$ 352.69 |
| Other current assets |
$ 173.24 |
$ 148.23 |
| total current assets |
$1,857.51 |
$1,726.85 |
| net property and equiptment |
$ 183.79 |
$ 149.76 |
| deferred charges |
$ 44.89 |
$ 22.47 |
| intangibles |
$ 320.26 |
$ 66.98 |
| deposits and other assets |
$ 34.16 |
$ 23.66 |
| total assets |
$2,440.62 |
$1,989.74 |
| INCOME STATEMENT |
|
|
| notes payable |
$ 63.17 |
$ 8.05 |
| accounts payable |
$ 183.85 |
$ 155.90 |
| current portion long term deby |
$ 100.62 |
$ 0.16 |
| accrued expenses |
$ 386.72 |
$ 374.84 |
| income taxes payable |
$ 71.93 |
$ 27.01 |
| total current liabilities |
$ 806.31 |
$ 565.98 |
| long term eby |
$ 360.12 |
$ 353.22 |
| other non-curent liabilities |
$ 45.71 |
$ - |
| minority interest)libilities) |
$ 8.51 |
$ 36.81 |
| total libilities |
$1,220.67 |
$ 956.03 |
| shareholders equity |
|
|
| total shreholders equity |
$1,219.95 |
$1,033.71 |
| total libilities and shareholders equity |
$2,440.62 |
$ 956.03 |