Question

Use the information in the table below to calculate NOPLAT at the end of Year 2....

Use the information in the table below to calculate NOPLAT at the end of Year 2. Income statement Year 0 Year 1 Year 2 Reorganized balance sheet Year 0 Year 1 Year 2

Revenues 2,500.0 2,750.0 3,000.0

Operating working capital 125.0 137.5 150.0

Operating costs (1,500.0) (1,650.0) (1,760.0)

Property and equipment 1,000.0 1,100.0 1,200.0

Depreciation (50.0) (65.0) (80.0) Invested capital 1,125.0 1,237.5 1,350.0

Operating profits 950.0 1,035.0 1,160.0 Debt 100.0 100.0 100.0

Interest (10.0) (10.0) (10.0) Shareholders' equity 1,025.0 1,137.5 1,250.0

Earnings before taxes 940.0 1,025.0 1,150.0

Invested capital 1,125.0 1,237.5 1,350.0 Taxes (225.6) (246.0) (276.0)

Net income 714.4 779.0 874.0

Operating-profit tax rate 24%

A.954.0 B.881.6 C.1,160.0 D.786.6

0 0
Add a comment Improve this question Transcribed image text
Answer #1
P&L
Particulars Year 0 Year 1 Year 2
Revenue from operations
Revenue 2500 2750 3000
Expenses:
Operating cost 1500 1650 1760
Depreciation 50 65 80
Operating profit 950 1035 1160
Interest 10 10 10
Earning before taxes (EBT) 940 1025 1150
Taxes 225.6 246 276
Earning after tax 714.4 779 874

Adjusted tax on opearting profit @ 24% = 278.4

NOPLAT at the end of year 2 = 1160-278.4

= 881.6

Assuming that PPE is net of accumulated depreciation.

Balance sheet
Particulars Year 0 Year 1 Year 2
Assets
PPE 1000 1100 1200
Current Assets 135 147.5 160
1135 1247.5 1360
Equity and liabilities
Share capital 1025 1137.5 1250
Debt 100 100 100
Current liabilities 10 10 10
1135 1247.5 1360
Add a comment
Know the answer?
Add Answer to:
Use the information in the table below to calculate NOPLAT at the end of Year 2....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Question 1 (50 points) FCF items from income and cash flow statements(millions NOK) 2017 2018E 560.0...

    Question 1 (50 points) FCF items from income and cash flow statements(millions NOK) 2017 2018E 560.0 588.0 Sales Operating expenses (excl. depr. and amort.) Depreciation 323.4 85.0 3.0 Amortization 336.0 76.5 5.0 52.0 10.0 10.0 Interest expenses 54.6 15.0 Interest income 15.0 Dividends One time Capex on new plant construction Capital expenditure (Capex) 400.0 0.0 116.5 125.0 Consolidated Balance Sheet (millions NOK) Cash and marketable securities 4.0 Accounts receivable 15.0 75.0 95.0 80.0 102.5 Inventory Goodwill and intangible assets Cumulative...

  • For this and the next 5 questions, please refer to the following Table. Data in millions...

    For this and the next 5 questions, please refer to the following Table. Data in millions of dollars. What is the net operating profit after taxes (NOPAT) for YEAR Income Statement Year 1 Year 2 Sales Operating costs excl depreciation Depreciation EBIT Less: Interest EBT Taxes (40%) Net income to common Common dividends s 1,200.0 $1,000.0 1,020.0 850.0 30.0 25.0 125.0 21.7 20.2 104.8 51.341.9 77,0 62,9 150.0 128.3 60.5 ASSETS İt to save and submit. Click Save AllAnsuers to...

  • Given the following financial statements, calculate: Income statement Year Balance sheet Year Revenues Cost of sales...

    Given the following financial statements, calculate: Income statement Year Balance sheet Year Revenues Cost of sales Selling costs Depreciation Operating profit 200.0 (80.0) (50.0) (20.0) 50.0 Working cash Accounts receivable Inventories Current assets 10 30 10 50 (4.0) Interest expense Gain on sale Earnings before taxes Property, plant, and equipment Prepaid pension assets Total assets 150 5 205 46.0 Taxes Net income (13.8) 32.2 Accounts payable Short-term debt Restructuring reserves Current liabilities 6 12 7 25 Long-term debt 70 Operating...

  • Using the information given below calculate the cash balance at the end of Year 2. Year...

    Using the information given below calculate the cash balance at the end of Year 2. Year 1 Year 2 Cash 10.0 Receivables 30.0 40.0 50.0 Net property plant and equipment 40.0 Total assets 80.0 Payables 10.0 20.0 Debt 20.0 30.0 Common stock 5.0 15.0 Retained earnings 45.0 Total liabilities and equity 80.0 Net income 43.0 49.0 Dividends 26.0 30.0

  • Use the following table, which provides historical data for SnacksCo, a manufacturer of snack foods, to answer the...

    Use the following table, which provides historical data for SnacksCo, a manufacturer of snack foods, to answer the next four questions. Assume an operating tax rate of 30 percent and a cost of capital of 9 percent Income statement Year 1 Year 2 540.0 555.0 Revenues Cost of sales (350.0) (360.5) Selling, general, and (50.5) (S0.0) administrative (10.0) (10.5) Depreciation 130.0 EBIT 133.5 Interest expense (7.5) (7.5) Gain/(loss) on sale of assets (30.0) Earnings before taxes 122.5 96.0 Тахes (24.8)...

  • FREE CASH FLOW Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income...

    FREE CASH FLOW Financial information for Powell Panther Corporation is shown below: Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $1,560.0 $1,200.0 Operating costs excluding depreciation and amortization 1,209.0 1,020.0 EBITDA $351.0 $180.0 Depreciation and amortization 29.0 25.0 Earnings before interest and taxes (EBIT) $322.0 $155.0   Interest 34.0 26.0 Earnings before taxes (EBT) $288.0 $129.0   Taxes (40%) 115.2 51.6 Net income $172.8 $77.4 Common dividends $156.0 $62.0 Powell Panther Corporation: Balance Sheets...

  • Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 22.0 2016 2015 Sales...

    Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 22.0 2016 2015 Sales $1,100.0 $1,000.0 Operating costs excluding depreciation 908.0 850.0 Depreciation and amortization 25.0 21.0 Earnings before interest and taxes $167.0 $129.0 Less Interest 24.0 Pre-tax income $143.0 $107.0 Taxes (40%) 57.2 42.8 Net income available to common stockholders $85.8 $64.2 Common dividends $51.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 $77.0 $14.0 6.0 195.0 231.0 $446.0 252.0 $698.0 $11.0...

  • Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $1,100.0...

    Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2016 2015 Sales $1,100.0 $1,000.0 Operating costs excluding depreciation 908.0 850.0 Depreciation and amortization 25.0 21.0 Earnings before interest and taxes $167.0 $129.0 Less Interest 24.0 Pre-tax income $143.0 $107.0 Taxes (40%) 57.2 42.8 Net income available to common stockholders $85.8 $64.2 Common dividends $77.0 $51.0 22.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2016 2015 Assets Cash $14.0 $11.0 Short-term investments 6.0 5.0...

  • Use the following table, which provides historical data for Snacksco, a manufacturer of snack foods, to...

    Use the following table, which provides historical data for Snacksco, a manufacturer of snack foods, to answer the next four questions. Assume an operating tax rate of 30 percent and a cost of capital of 9 percent. Income statement Year 1 Year 2 Revenues 540.0 555.0 Cost of sales Selling general, and administrative (350.0) (360.5) (50.5) (50.0) Depreciation (10,0) (10.5) EBIT 130.0 133.5 Interest expense (7.5) (7.5) Gain/(loss) on sale of assets (30.0) Earnings before taxes 96.0 - 122.5 (24.8)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT