Two companies, A and B, decide to acquire asset worth $15 million. Company A decides to purchase the asset whereas Company B will develop internally by its R&D unit with $15 million expenses in Year 1. The asset has a limited life of 3 years with no salvage value and hence will be amortized over 3 years using straight line. Create income statement, balance sheet and cash flow statement for both companies and calculate net profit margin and return on assets.
| Company A (Purchased) | Company B (Internally Developed) | |||||||
| Year 0 | Year 1 | Year 2 | Year 3 | Year 0 | Year 1 | Year 2 | Year 3 | |
| Income statement | ||||||||
| Revenue | 100 | 100 | 100 | 100 | 100 | 100 | ||
| Cash exp exc. R&D | 50 | 50 | 50 | 50 | 50 | 50 | ||
| R&D | ||||||||
| Depreciation | ||||||||
| Income before taxes | ||||||||
| Taxes – 30% | ||||||||
| Net income | ||||||||
| Cash flow statement | ||||||||
| Cash from operations: | ||||||||
| Net income | ||||||||
| Depreciation | ||||||||
| Cash from investing | ||||||||
| Change in cash | ||||||||
| Balance sheet | ||||||||
| Cash | 15 | 10 | ||||||
| Gross PPE | 0 | 0 | ||||||
| Depreciation | ||||||||
| Net PPE | 0 | 0 | ||||||
| Total assets | 15 | 10 | ||||||
| Retained earnings | 0 | 0 | ||||||
| Common stock | 15 | 10 | ||||||
| Total equity | 15 | 10 | ||||||
| Net profit margin | ||||||||
| Return on assets |
Two companies, A and B, decide to acquire asset worth $15 million. Company A decides to...
A company has an operating income of $100 million, depreciation of $15 million, an asset sale of $50 million, a capital expenditure of $10 million, and an increase in net working capital of $10 million. Calculate this company’s free cash flow for the year.
1.) Use the Income Statement and Balance Sheet below to calculate the companies free cash flow. Income Statement 2017 Net Sales 675 Cost of goods sold 210 Depreciation 50 EBIT 415 Interest Paid 15 EBT 400 Taxes (30%) 120 Net Income 280 Dividends 105 Addition to Retained Earnings 175 Assets 2016 2017 Liabilities and Shareholders equity 2016 2017 Current Assets Current Liabilities Cash 100 125 Accounts Payable 200 250 Accounts Receivable 250 350 Notes Payable 150 225 Inventory 400 375...
How to do question (b)?
Digital Bhd Balance Sheet as o' 31 D,cember 2017 2018 milion) nillion) million Cash 300 Fixed assets Fixed assets at cost 1.566 (610 2,373 2,718 Acoumulated depreciation Total Assets 6)1.135 1.250 2,055 2.635 Current liabilties Accounts payable Other aceruas Long-term Liablities 10% Debentures de 2000 Total Liabilities 81 20 30 1,000 1,764 701 1,361 Shareholders Equity Common stock, RM 1 par, 100.000,000 shares issued and outstand 100 105 2,535 100 105 344 1,250 Share Premium...
1.)Company ABC has sales of $1,650,000, cost of goods sold of $600,000, EBIT of $450,000, interest expense of $70,000, and a tax rate of 27%. If the company paid $57,000 in dividends what is the addition to retained earnings. 2.)At the beginning of the year, a firm had current assets of $121,306 and current liabilities of $124,509. At the end of the year, the current assets were $122,418 and the current liabilities were $103,718. What is the change in net...
1. Company ABC has sales of $1,850,000, cost of goods sold of $1,000,000, EBIT of $350,000, interest expense of $65,000, and a tax rate of 27%. If the company paid $51,000 in dividends what is the addition to retained earnings. 2. Nitro Enterprise had beginning net fixed assets of $218,470 and ending net fixed assets of $209,411. During the year, assets with a combined book value of $6,943 were sold. Depreciation for the year was $42,822. What is the amount...
Brookline Specialty Hospital, a not-for-profit provider, had revenues of $12 million in 2018. Expenses other than depreciation totaled 75% of revenues. Brookline purchased fixed assets for $50 million in 2010 and expects to sell these assets for $20 million at the end of their 20-year lifetime. a. Calculate Brookline’s annual depreciation expense. b. Construct Brookline’s income statement for Year Ended December 31, 2018. c. Calculate Brookline’s net income, total profit margin, and approximate cash flow. In one sentence, provide an...
225 Comparative Balance Sheets and some additional information for Red Company are given below. All figures in the table below are in millions of dollars. Red reports on a fiscal year ending December 31" Green Company Balance 2000 2001 Sheet as of Dec 31 Assets Cash 25 20 Accounts Receivable 45 90 Allowance for Bad Debts (15) (20) Merchandize Inventories 160 135 Land 200 Plant and Equipment 420 420 Accumulated Depreciation (160) (170) Total Assets 700 Liabilities and Equity Accounts...
14. What is company's margin of safety in units for projected Year 16? 15. What is the company's margin of safety as a percentage for projected Year 16? not for the projected Year 16 relative to Year 15 and 16. Is the margin of safety as a percentage improving or by how much? Eoxtrot Manufacturing Company, LLC Functional Format Income Statement Latest Operating Year Proforma for Year Year 15 15% Next Operating 16% ear 16 a units sold Average price...
Last year Cole Furnaces had $5 million in operating income (EBIT). The company had a net depreciation expense of $1 million and an interest expense of $1 million; its corporate tax rate was 40%. The company has $14 million in operating current assets and $4 million in operating current liabilities; it has $15 million in net plant and equipment.. Assume that Cole’s only noncash item was depreciation. a. What was the company’s net income for the year? b. What was...
1.4 Consider the following financial information for a company (in millions of dollars) Partial income statement (latest year ending December 31, 2017): Sales $900 Cost of goods sold ($350) Other expenses ($200) Depreciation ($120) Interest expenses ($30) Partial balance sheet (as of December 31) 2016 2017 Cash $30 $20 Receivables $200 $250 Inventories $220 $210 Net fixed assets $500 $520 Accounts payable $100 $120 Accruals $80 $100 Short-term debt $50 $10 Long-term debt $270 $270 a) Assuming an income...