Question

In: Finance

Please use the following balance sheets and income statements to solve this problem (all numbers in...

Please use the following balance sheets and income statements to solve this problem (all numbers in Million USD)

Ariba Company

2018

2017

Net Sales and Revenues

2018

2017

Cash and cash equivalents

$3,000.

$ 3,000.

Net Sales

26,000.

28,000.

Marketable securities

$ 350.

$ 230.

Cost of sales

18,000.

20,000.

Account receivables

$25,000

$28,000.

Research and dev expenses

1,000.

1,000.

Other receivables

$1,000.

$ 900.

Selling expenses

2,000.

2,000.

Inventories

$ 3,000.

$ 3,000.0

Interest expense

760.

680.

Prepaid expenses

$ 5,000.

$ 4,000.

Non-operating expenses

1000.

960.

Property & equipment - net

$11,000.

$10,000.

Total

24,000

26,000.

Goodwill

$ 800.7

$ 700.0

Income before Income Taxes

2,000.

2,000.

Intangible assets - net

$ 4,000.1

$ 4,000.

Provision for income taxes

700.

800.

Total Assets

$57,000.

$57,000.

Income of Consolidated Group

1,000.

1,00.

LIABILITIES

Short-term borrowings

$6,000.2

$ 8,000.

Account payables

$5,000.1

$ 4,000.

Accrued expenses

7,000.1

$ 7,000.

Deferred revenues

$ 160.0

$ 160

Long-term borrowings

$21,000.

$23,000.

Other liabilities

$ 8,000.5

$ 6,000.

Total liabilities

$50,000.

$51,000.

STOCKHOLDERS' EQUITY

Common stock

$2,000.

$ 2,000

Treasury stock

(15,000.)

(15,000.)

Retained earnings

$23,000.

$23,000.

Comprehensive income/loss

(5,000.0)

(4,000)

Total stockholders' equity

$ 6,000

$ 6,000

Calculate Ariba’s Free Cash Flow during 2018 and explain the meaning of the free cash flow you have calculated to Aribia’s investors.

Solutions

Expert Solution

Free Cash flows is the portion of cash available in the hands of the company after paying all the capital expenditure and satisfying all the working capital needs.

Free cash flow = NOPAT+depreciation-(Capital Expenditure+Working Capital investment)

NOPAT - Net operating profit after taxes

Calculation :- (Million $)

EBT 2000

(-)Taxes 700

EAT 1300

(+)non operating expenses 1000

NOPAT 2300

(+)Depreciation -

(-)Capital Expenditure(WN1) 1100

(-)Working Capital Changes(WN2) -780  

Free cash flow 1980

WN1 : Capital Expenditure

Investment in Property and Goodwill = (11,000-10,000)+(800-700) = 1,000+100 = 1,100

WN2 : Working Capital changes

Changes in Accounts receivables, inventories, marketable securities, other receivables and prepaid expenses

Less changes in Accounts payables, short term borrowing andaccrued expenses

=(25000-28000)+(350-230)+(1000-900)+(5000-4000)-(6000-8000)-(5000-4000)

=-3000+120+100+1000+2000-1000

=-780

Assumptions:-

  • Depreciation is not provided for
  • Goodwill shown in the financials is the purchased goodwill
  • other liabilities are assumed as long term liabilties
  • decimals change in assets i.e 0.1 are ignored.

Related Solutions

Which of the following is a difference between balance sheets and income statements? a. Balance sheets...
Which of the following is a difference between balance sheets and income statements? a. Balance sheets are also known as profit and loss statements, whereas income statements are also known as statements of financial position. b. Balance sheets are used to track a business's liquidity, efficiency, and profitability over time compared to other businesses in its industry, whereas income statements are quantitative plans through which managers decide how to allocate available money to best accomplish company goals. c. Balance sheets...
Use the following balance sheets and income statement to answer this question Tully Corp (all in...
Use the following balance sheets and income statement to answer this question Tully Corp (all in $ Million) 2018 2019 LIABILITIES AND EQUITY 2018 2019 Current assets: Accounts payable 540.0 398.1 Cash and cash equivalents 1,148.1 1,188.6 Accrued liabilities 1,086.5 1,301.5 Short-term investments 902.6 848.4 Deferred revenue 449.3 510.2 Accounts receivable, net 386.5 485.9 Long-term debt 549.5 549.6 Inventories 965.8 1,241.5 Other long-term financing liabilities 347.8 345.3 Prepaid expenses 391.9 435.2 Total liabilities 2,973.1 3,104.7 Total current assets 3,794.9 4,199.6...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing retailer in the high-end market) and TJX Companies (clothing retailer in the value-priced market). (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (example: 0.2345 = 23.5%). Income Statement ($ millions) ANF TJX Sales $3,469 $21,942 Cost of goods sold 1,257 Answer% 16,040 Answer% Gross profit 2,212...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing in the high-end market) and TJX Companies (clothing retailer in the value priced market), for the fiscal year ended January 30, 2016. (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (ex: 0.2345 = 23.5%) Income Statement ($ thousands) ANF TJX Sales $3,518,680 $30,944,938 Cost of goods...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance Sheets 2019 2018 Assets Cash and equivalents $80   $65   Accounts receivable 275   300   Inventories 375   250         Total current assets $730   $615   Net plant and equipment 2,300   1,490   Total assets $3,030   $2,105   Liabilities and Equity Accounts payable $150   $85   Accruals 75   50   Notes payable 130   55         Total current liabilities $355   $190   Long-term debt 450   290   Common stock 1,225   1,225   Retained earnings 1,000   400   Total liabilities...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance Sheets Assets 2019 2018 Cash and equivalents $100   $85   Accounts receivable 275   300   Inventories 375   250         Total current assets $750   $635   Net plant and equipment 2,300   1,490   Total assets $3,050   $2,125   Liabilities and Equity Accounts payable $150   $85   Accruals 75   50   Notes payable 150   75         Total current liabilities $375   $210   Long-term debt 450   290         Total liabilities 825   500   Common stock 1,225   1,225   Retained earnings...
Quantitative Problem: Rosnan Industries' 2018 and 2017 balance sheets and income statements are shown below. Balance...
Quantitative Problem: Rosnan Industries' 2018 and 2017 balance sheets and income statements are shown below. Balance Sheets: 2018 2017   Assets Cash and equivalents $100   $85   Accounts receivable 275   300   Inventories 375   350       Total current assets $750   $735   Net plant and equipment 2,000   1,490   Total assets $2,750   $2,225     Liabilities and Equity Accounts payable $150   $85   Accruals 75   50   Notes payable 150   175       Total current liabilities $375   $310   Long-term debt 450   290       Total liabilities $825   $600   Common stock 1,225   1,225   Retained earnings...
Quantitative Problem: Rosnan Industries' 2013 and 2012 balance sheets and income statements are shown below. Balance...
Quantitative Problem: Rosnan Industries' 2013 and 2012 balance sheets and income statements are shown below. Balance Sheets: 2013 2012 Cash and equivalents $100   $85   Accounts receivable 275   300   Inventories 375   250         Total current assets $750   $635   Net plant and equipment 2,300   1,490   Total assets $3,050   $2,125   Accounts payable $150   $85   Accruals 75   50   Notes payable 150   75         Total current liabilities $375   $210   Long-term debt 450   290   Common stock 1,225   1,225   Retained earnings 1,000   400   Total liabilities and equity $3,050   $2,125  ...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance Sheets: 2019 2018 Cash and equivalents $ 60 $ 45 Accounts receivable 275 300 Inventories 375 350       Total current assets $ 710 $ 695 Net plant and equipment 2,000 1,490 Total assets $ 2,710 $ 2,185 Accounts payable $ 150 $ 85 Accruals 75 50 Notes payable 110 135 Total current liabilities $ 335 $ 270 Long-term debt 450 290 Common stock 1,225 1,225...
Quantitative Problem: Rosnan Industries' 2014 and 2013 balance sheets and income statements are shown below. Balance...
Quantitative Problem: Rosnan Industries' 2014 and 2013 balance sheets and income statements are shown below. Balance Sheets: 2014 2013 Cash and equivalents $80   $65   Accounts receivable 275   300   Inventories 375   350         Total current assets $730   $715   Net plant and equipment 2,000   1,490   Total assets $2,730   $2,205   Accounts payable $150   $85   Accruals 75   50   Notes payable 130   155         Total current liabilities $355   $290   Long-term debt 450   290   Common stock 1,225   1,225   Retained earnings 700   400   Total liabilities and equity $2,730   $2,205  ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT