MicroDrive's Financial Statements are below (all numbers re in millions of dollars) Assets 2006 2007 Cash...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
MicroDrive's Financial Statements are below (all numbers re in millions of dollars) Assets 2006 2007 Cash and equivalents 15 10 Short-term investments 65 Accounts receivable 315 375 Inventories 415 615 Total current assets 810 1,000 Net plant and equipment 870 1,000 Total assets 1680 2,000 Accounts payable 30 60 Notes payable 60 110 Accruals 130 140 Total current liabilities 220 310 Long-term bonds 580 754 Total debt 800 1,064 Common stock (50,000,000 shares) 170 170 Retained earnings 710 766 Total common equity 880 936 Total liabilities and equity 1,680 2,000 INCOME STATEMENT 2007 Net sales $3,000.0 COGS Operating cost - Part I $2,319 Gross Profits $681.0 Operating Expenses Except Depreciation Operating cost - Part Il $297.2 Depreciation (there is no amortization) $100.0 Operating Profit $283.8 Earnings before Income and Taxes (EBIT) S283.8 Less interest $88.0 Earnings before taxes (EBT) or Pre-tax income $195.8 Тахes $78.3 Net Income availabie to common stockholders $117.5 Dividends $61.5 Addition to retained earnings $56.0 Using the data answer the following questions. Assume: i) all short-term operating and financing assets were converted to cash (and used) this year, i) al short-term operating liabilities (to suppliers and other non-investors) were fully paid this year, and i) All PPE that was sold, was sold at Net Book Value (no capital gains or losses), and iv) there are no deferred taxes a. Fil in the sources and uses of cash amount associated with each line item in the table below (if you need to make any additional assumptions, explicitly state them): | Amount Sources of Cash Cash Revenues Collecting Previous Year's Acct. Receivables Money withdrawn in bank Uses of Cash Amount COGS Paid in Cash Operating Expenses Paid in Cash Purchase of Inventory not account sold at Year-end Sale of Marketable Securities Тахes Paying Dividends Sale of PPE Net Interest Expense (on Debt Payments less interest income from marketable securities) Cash Received from Net Issuance of Debt (issuance less retirement) Cash Received from Net Issuance of New Stock Money deposited in bank (issuance iess repurchase) account Purchase of Marketable Securities Purchase of PPE Paying off Accounts Payables & Accruals b. Calculate the cash flow statement for 2007 for Microdrive. C. Calculate the free cash flows for 2007 for Microdrive. MicroDrive's Financial Statements are below (all numbers re in millions of dollars) Assets 2006 2007 Cash and equivalents 15 10 Short-term investments 65 Accounts receivable 315 375 Inventories 415 615 Total current assets 810 1,000 Net plant and equipment 870 1,000 Total assets 1680 2,000 Accounts payable 30 60 Notes payable 60 110 Accruals 130 140 Total current liabilities 220 310 Long-term bonds 580 754 Total debt 800 1,064 Common stock (50,000,000 shares) 170 170 Retained earnings 710 766 Total common equity 880 936 Total liabilities and equity 1,680 2,000 INCOME STATEMENT 2007 Net sales $3,000.0 COGS Operating cost - Part I $2,319 Gross Profits $681.0 Operating Expenses Except Depreciation Operating cost - Part Il $297.2 Depreciation (there is no amortization) $100.0 Operating Profit $283.8 Earnings before Income and Taxes (EBIT) S283.8 Less interest $88.0 Earnings before taxes (EBT) or Pre-tax income $195.8 Тахes $78.3 Net Income availabie to common stockholders $117.5 Dividends $61.5 Addition to retained earnings $56.0 Using the data answer the following questions. Assume: i) all short-term operating and financing assets were converted to cash (and used) this year, i) al short-term operating liabilities (to suppliers and other non-investors) were fully paid this year, and i) All PPE that was sold, was sold at Net Book Value (no capital gains or losses), and iv) there are no deferred taxes a. Fil in the sources and uses of cash amount associated with each line item in the table below (if you need to make any additional assumptions, explicitly state them): | Amount Sources of Cash Cash Revenues Collecting Previous Year's Acct. Receivables Money withdrawn in bank Uses of Cash Amount COGS Paid in Cash Operating Expenses Paid in Cash Purchase of Inventory not account sold at Year-end Sale of Marketable Securities Тахes Paying Dividends Sale of PPE Net Interest Expense (on Debt Payments less interest income from marketable securities) Cash Received from Net Issuance of Debt (issuance less retirement) Cash Received from Net Issuance of New Stock Money deposited in bank (issuance iess repurchase) account Purchase of Marketable Securities Purchase of PPE Paying off Accounts Payables & Accruals b. Calculate the cash flow statement for 2007 for Microdrive. C. Calculate the free cash flows for 2007 for Microdrive.
Expert Answer:
Answer rating: 100% (QA)
answers Souces of Cash Amount Uses of Cash Amount Cash Revenues 2625 COGS paid in cash 2259 Collecting previous years AR 315 Operating expenses paid in cash 15730 Money withdrawn in Bank account Purch... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Annual sales, in millions of dollars for 21 pharmaceutical companies follow. a. Provide a five-number summary. b. Compute the lower and upper limits. c. Do the data contain any outliers? d. Johnson &...
-
The plot shows total payroll in millions of dollars for the 30 major league teams of professional baseball sorted by league (National or American) and division (East, Central, West). a. Identify the...
-
The following data is sales in millions of dollars for the Cassie Cat Company manufactures of grain free canned cat food. Year. 1. 2. 3. 4. 5. 6. 7 Sales. 20. 22. 26. 24. 30. 28. 32 a, Use a three...
-
The ordinary share capital of W Ltd (which is a trading company) is owned 30% by X Ltd, 25% by Y Ltd and 45% by Z Ltd. All of these companies are UK resident and they prepare accounts to 31 March....
-
TPSs are usually used at the boundaries of the organization. What are boundaries in this context? Give three examples of boundaries.
-
Why do nations use a crawling-peg-exchange rate system?
-
Shauna Washington started a business to sell art supplies and related curricula to home school families. The business grew quickly, with sales doubling three times during a five-year period. At that...
-
A partnership has the following account balances: Cash, $70,000; Other Assets, $540,000; Liabilities, $260,000; Nixon (50% of profits and losses), $170,000; Cleveland (30%), $110,000; Pierce (20%),...
-
7.41 Flow through a horizontal 180 pipe bend is shown in Figure P7.12. The pipe diam- eter is constant at 15 cm, and the volume flowrate is 125 L/s. The pressure at the entrance port is 183 kPa, and...
-
Fokine Research Institute has three departments: biology, chemistry, and physics. The institute's controller wants to estimate the cost of operating each department. He has identified several...
-
Green: GG Aurea: GG A How can the unusual results fromthe crosses be explained? The aurea allele behaves as a recessive lethal allele. The green allele behaves as a dominant lethal allele. The aurea...
-
A normal population has mean = 40 and standard deviation = 10. Find the probability that a randomly sampled value is greater than 53.
-
What is induce drag?
-
A normal population has mean = 3 and standard deviation = 1. Find the proportion of the population that is less than 1.
-
What type of airflow is over a finite wing?
-
A normal population has mean = 25 and standard deviation = 11. a. What proportion of the population is greater than 34? b. What is the probability that a randomly chosen value will be less than 10?
-
Show how the mendelow theory is used in product category management
-
Using the parallel-axis theorem, determine the product of inertia of the area shown with respect to the centroidal x and y axes. 6 in. 9 in. 9 in- 4.5 in. in. 4.5 in.
-
This question refers to Problem 21. a. Fit the random model given by Equation 3.4 to the data in Table P-21 by estimating c with the sample mean so t = . Compute the residuals using et = Yt - t - ....
-
List some of the forecasting techniques that should be considered when forecasting a seasonal series. Give examples of situations in which these techniques would be applicable.
-
The sales manager of Hartman Auto Supplies decides to investigate a new independent variable, personal income by region (see Problem 12). The data for this new variable are presented in Table P-13....
-
The following e-mail with an authentic looking e-mail address and logo was received by the controller of a small business: Required a. What should Justin do about these e-mails? b. What should Big...
-
An accountant employed by the organizing committee for the Atlanta Summer Olympic Games was charged with embezzling approximately \($60,000.\) The money allegedly was used to purchase a used...
-
Zaire Company had a \(\$ 26,000\) net loss from operations. Depreciation expense for the year was \(\$ 9,600\), and a dividend of \(\$ 2,000\) was declared and paid. The balances of the current asset...
Study smarter with the SolutionInn App