? 1. Using the numbers from the spreadsheet template, expand the income statement and balance sheet to
Fantastic news! We've Found the answer you've been seeking!
Question:
?
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
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these accounting questions
-
At Stevens Manufacturing, workers are organized in teams that combine their efforts to produce complex units of a final product. Stevens is using a facility layout known as a(n): consolidated process...
-
Payout Ratio and Book Value per Share Divac Company has developed a statement of stockholders equity for the year 2010 as follows: Divacs preferred stock is $100 par, 8% stock. If the stock is...
-
Sales for 2014 were $455,150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 11% of net fixed assets, interest was $8,575,000, the corporate tax rate was 40%, and...
-
In Fig. P2.72 gate AB is circular. Find the moment of the hydrostatic force on this gate about axis A. Neglect atmospheric pressure.
-
A collector purchased a quantity of action figures and is going to sell them on eBay. He has 19 Hulk figures. In recent auctions, the mean selling price of similar figures has been $12.11, with a...
-
To accelerate a particle of mass m from rest to speed 0.90c requires work W1. To accelerate the particle from speed 0.90c to 0.99c requires work W2. Determine the ratio W2/W1.
-
The stockholders' equity accounts of Raymund Corporation as of January 1 appear below: During the year, the following transactions occurred: June 7 Declared a 20 percent stock dividend; market value...
-
(Issuance, Exercise, and Termination of Stock Options) On January 1, 2009, Scooby Corporation granted 10,000 options to key executives. Each option allows the executive to purchase one share of...
-
ABC Inc. is a calendar year corporation. Its financial statements for the years n and (n - 1) contained the following errors__________. Year n__________. Ending inventory $6,000 overstated;...
-
For each of the following examples, identify whether the fraud is employee embezzlement, management fraud, investment scam, vendor fraud, customer fraud, or miscellaneous fraud. 1. Marcus bought a...
-
___________ is the theory that says one acts as responsible members of the community. Question 7 options: Masculinity Principle Citizenship Principle Fiduciary Principles Fairness PrincipleWhen a...
-
If an equation obeys Laplace's equation, then at what angle must lines of constant temperature cross lines of constant flux?
-
Indirect business taxes and capital consumption allowance are not income, yet they are included in the calculation of GDP as income received. Why do we add these two nonincome components to the other...
-
Consider the welding situation of the previous problem. This time let's consider the case where we have convective heat transfer from the rod's surface. For a rod of radius, \(r_{o}\), and a heat...
-
Why dont we measure national output by simply counting the total number of goods and services produced each year?
-
As a biochemical engineer you are evaluating a drug delivery system for an artificial protein to combat Alzheimer's. The protein is very large (200,000 molecular weight) and bulky and is sensitive to...
-
To answer this, we'll be using a panel data set called the National Longitudinal Survey of Youth (NLSY), which is a data set that is comprised of individuals who were in their teens or early twenties...
-
DC has unused FTC carryover from 2017 in the separate category for GC income as the result of income generated by a foreign branch. The income was foreign source general category income. In 2018 the...
-
a. Find each product. i. 2/3 3/2 ii. 4/7 7/4 iii. 1/6 6/1 b. On the basis of your results from part (a), use words to describe a property of a fraction and its reciprocal. Then describe the...
-
(5, 8.1) and (9, 2.4) Find an approximate equation y = abx of the exponential curve that contains the given pair of points. Round the values of a and b to two decimal places.
-
The author surveyed some of the students in one of his statistics classes about the distances (in miles) they commute to college. Their responses are described by the histogram shown in Fig. 85. a....
-
A column arrangement similar to Figure \(15-2\) is used for organic liquids. A large reservoir of water is under the column. The water is stirred and solute concentration in the water is constant....
-
For the same system as in Problem 15.D1, the high concentration \(\mathrm{C}_{\mathrm{A}, 0}=1.2 \mathrm{~kg} / \mathrm{m}^{3}\) and \(\mathrm{C}_{\mathrm{A}, \mathrm{L}}=0.9701 \mathrm{~kg} /...
-
What is the Fickian diffusivity of chlorobenzene in liquid bromobenzene at \(300 \mathrm{~K}\) when the mole fraction of chlorobenzene is 0.0332 ? Assume that the diffusivity follows an Arrhenius...
Study smarter with the SolutionInn App