C D E F G H 45 2006 2007 7 8 5 Sales 6 COGS Expenses Depreciation $12,000 $6,600 $1,740 $315 9 EBIT $3,345 10 Interest Expense $345 11 Taxable Income $3,000 12 Taxes $1,200 13 Net Income $1,800 Plowback ratio Dividend payout 14 Market Price-2007 $41 15 EPS $4.88 Number of Shares 16 Dividends per share $1.71 Dividends 17 Contribution to RE 18 Book Price 19 20 2006 2007 21 Cash $100 $126 22 A/R $992 $1,045 23 Inventory $361 $355 24 Other CA $264 $303 25 Total CA $1,717 $1,829 26 GFA 27 Acc. Depr. 28 Net FA $7,890 $9,150 29 Total Assets $9,607 $10,979 30 31 32 A/P $303 $340 33 N/P $119 $135 34 Other CL $1,353 $1,150 35 Total CL $1,775 $1,625 36 LT Debt $4,332 $3,454 37 CS 38 RE 39 Equity 40 TL&NW $3,500 $5,900 $9,607 $10,979 1. Using the numbers from the spreadsheet template, expand the income statement and balance sheet to include GFA, Accumulated Depreciation, CS and RE. Find the Dividends and Contribution to RE (and percentages), book price, and number of shares. Include assumptions and documentation about how you reached your answers. 2. Do a sources and uses statement with percentages