? 1. Using the numbers from the spreadsheet template, expand the income statement and balance sheet to

?

Transcribed Image Text:

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. 1 2 Sales 3 COGS A 4 Expenses 5 Depreciation 6 EBIT 7 Interest Expense 8 Taxable Income 9 Taxes 10 Net Income 11 12 EPS 13 Dividends per share 14 15 16 17 18 Cash 19 A/R 20 Inventory 21 Other CA 22 Total CA 23 GFA 24 Acc. Depr. 25 Net FA 26 Total Assets 27 28 29 A/P Sheet1 B 2006 2006 $100 $992 $361 $264 $1,717 C 2007 $12,000 $6,600 $1,740 $315 $3,345 $345 $3,000 $1,200 $1,800 $303 $4.88 $1.71 2007 $126 $1,045 $355 $303 $1,829 $10,410 $7,890 $9,150 $9,607 $10,979 $340 D $1,260 E Plowback ratio Dividend payout Market Price 2007 Number of shares Dividends Contribution to RE Book Price $41 F A 28 29 A/P 30 N/P 31 Other CL 32 Total CL 33 LT Debt 34 CS 35 RE 36 Equity 37 TL&NW 38 39 40 41 42 Sources 43 Cash 44 A/R 45 Inventory 46 Other CA 47 GFA 48 Acc. Depr. 49 A/P 50 N/P 51 Other CL 52 LT debt 53 CS 54 RE 55 56. Uses Sheet1 B $303 $119 $1,353 $1,775 $4,332 2006-2007 + C $3,500 $5,900 $9,607 $10,979 $340 $135 $1,150 $1,625 $3,454 S A 43 Cash 44 A/R 45 Inventory 46 Other CA 47 GFA 48 Acc. Depr. 49 A/P 50 N/P 51 Other CL 52 LT debt 53 CS 54 RE 55 56 Uses 57 Cash 58 A/R 59 Inventory 60 Other CA 61 GFA 62 Acc. Depr. 63 A/P 64 N/P 65 Other CL 66 LT Debt 67 CS 68 RE 69 70 71 Sheet1 B C 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. 1 2 Sales 3 COGS A 4 Expenses 5 Depreciation 6 EBIT 7 Interest Expense 8 Taxable Income 9 Taxes 10 Net Income 11 12 EPS 13 Dividends per share 14 15 16 17 18 Cash 19 A/R 20 Inventory 21 Other CA 22 Total CA 23 GFA 24 Acc. Depr. 25 Net FA 26 Total Assets 27 28 29 A/P Sheet1 B 2006 2006 $100 $992 $361 $264 $1,717 C 2007 $12,000 $6,600 $1,740 $315 $3,345 $345 $3,000 $1,200 $1,800 $303 $4.88 $1.71 2007 $126 $1,045 $355 $303 $1,829 $10,410 $7,890 $9,150 $9,607 $10,979 $340 D $1,260 E Plowback ratio Dividend payout Market Price 2007 Number of shares Dividends Contribution to RE Book Price $41 F A 28 29 A/P 30 N/P 31 Other CL 32 Total CL 33 LT Debt 34 CS 35 RE 36 Equity 37 TL&NW 38 39 40 41 42 Sources 43 Cash 44 A/R 45 Inventory 46 Other CA 47 GFA 48 Acc. Depr. 49 A/P 50 N/P 51 Other CL 52 LT debt 53 CS 54 RE 55 56. Uses Sheet1 B $303 $119 $1,353 $1,775 $4,332 2006-2007 + C $3,500 $5,900 $9,607 $10,979 $340 $135 $1,150 $1,625 $3,454 S A 43 Cash 44 A/R 45 Inventory 46 Other CA 47 GFA 48 Acc. Depr. 49 A/P 50 N/P 51 Other CL 52 LT debt 53 CS 54 RE 55 56 Uses 57 Cash 58 A/R 59 Inventory 60 Other CA 61 GFA 62 Acc. Depr. 63 A/P 64 N/P 65 Other CL 66 LT Debt 67 CS 68 RE 69 70 71 Sheet1 B C

Answer rating: 100% (QA)

Calculation of GFA Accumulated depreciation Net FA Details 2006 2007 GFA 8835 7890 945 10410 Less Ac... View the full answer