Question

You have reformulated the Imber Aedax Company’s most recent financial statements and extracted the following information:...

You have reformulated the Imber Aedax Company’s most recent financial statements and extracted the following information:

Year ended 31 Dec 2019 $ million
Sales 35,200
Interest expense minus interest income 291
Earnings before tax 13,168
Tax expense 2,384
Comprehensive Income (CE) 11,809
As at 31 Dec 2019 $ million
Net operating working capital (OWC) 936
Net non-current operating assets (NNCOA) 42,287
Net financial obligations (NFO) 11,906

a) Calculate NOA (net operating assets) and CSE (common shareholders’ equity) at the end of 2019.

b) Using the 2019 effective tax rate, calculate NFE (net financial expense) and OI (operating income or NOPAT) for the year 2019.

2020 2021 2022 thereafter
Sales growth 10% 7% 4% 3%
OI / sales 30% 25% 20% 18%
Previous year OWC / this year's sales 2.2% 2% 2%
Previous year NNCOA / this year's sales 105% 100% 98%
NFO / NOA 27.5% 27.5% 27.5% 27.5%

c) Predict sales and OI for the years 2020 to 2022. Predict NOA, NFO and CSE for the years 2020 to 2022.

d) Assuming that the 2019 tax rate continues to apply in future and that the cost of debt before tax shield benefit is 2%, find the after-tax cost of debt.
Assuming that the cost of equity is 4.9% and using information given in the forecast table above, calculate the WACC (weighted average cost of capital). Round it to the nearest one tenth of a percent.
Assuming that NFE equals previous year NFO times the after-tax cost of debt, calculate NFE and CE for the years 2020 to 2022.

e) Calculate predicted AE (abnormal earnings), AOI (abnormal operating income or abnormal NOPAT) and FCF (free cash flow) for the years 2020 to 2022.

Homework Answers

Answer #1

Tax rate = Tax expense*100/Earnings before tax = 2,384million*100/13,168million = 18.1%

Cost of debt after tax shield = cost of debt before tax shield*(1-tax rate) = 2%*(1-0.181) = 2%*0.819 = 1.638%

Value of equity (VOE)= OWC+NNCOA-NFO = 936million+42,287million-11,906million = 31,317million

WACC = [(cost of equity*VOE)+(Cost of debt after tax shield*NFO)]/(OWC+NNCOA) = [(4.9%*31,317million)+(1.638%*11,906million)]/(936million+42,287million) = (1,534.533million+195.02028million)/43,223million = 1,729.55328million/43,223million = 4%

Know the answer?
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
Similar Questions
Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Cisco Systems’ sales, net operating profit...
Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions). Sales $51,469 Net operating profit after tax (NOPAT) 11,066 Net operating assets (NOA) 27,672 Use the parsimonious method to forecast Cisco’s sales, NOPAT, and NOA for years 2017 through 2020 using the following assumptions. Sales growth per year 1.0% for 2017 and 2.0% thereafter Net operating profit...
Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA)...
Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions). Sales $49,247 Net operating profit after tax (NOPAT) 10,575 Net operating assets (NOA) 26,472 Use the parsimonious method to forecast Cisco’s sales, NOPAT, and NOA for years 2017 through 2020 using the following assumptions. Sales growth per year 1.0% for 2017 and 2.0% thereafter Net operating profit margin (NOPM) 21.5% Net operating asset turnover (NOAT),...
Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA)...
Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions). Sales $48,136 Net operating profit after tax (NOPAT) 10,349 Net operating assets (NOA) 25,880 Use the parsimonious method to forecast Cisco’s sales, NOPAT, and NOA for years 2017 through 2020 using the following assumptions. Sales growth per year 1.0% for 2017 and 2.0% thereafter Net operating profit margin (NOPM) 21.5% Net operating asset turnover (NOAT),...
QUESTION 2 Incorrect Mark 0.00 out of 16.00 Flag question Question text Projecting NOPAT and NOA...
QUESTION 2 Incorrect Mark 0.00 out of 16.00 Flag question Question text Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Cisco Systems’ sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions). Sales $49,247 Net operating profit after tax (NOPAT) 10,575 Net operating assets (NOA) 26,472 Use the parsimonious method to forecast Cisco’s sales, NOPAT, and NOA for years 2017 through 2020 using the following assumptions. Sales...
1. You standardize a company’s financial statements as follows. Following the example of Bega Cheese in...
1. You standardize a company’s financial statements as follows. Following the example of Bega Cheese in the textbook, please calculate the following items:             a. NOPAT             b. Net operating working capital c. Net long-term assets             d. Net debt BALANCE SHEET ASSETS INCOME STATEMENT Cash and Marketable Securities 11,511.00 Accounts Receivable 4,430.00 Sales 35,200.00 Inventory 2,650.00 Cost of Goods Sold 11,234.00 Other Current Assets 2,988.00 Gross Profit 23,966.00 Total Current Assets 21,579.00 SG&A 13,179.00 Other Operating Expenses 1,703.00 Long-Term...
Selected information from the comparative financial statements of Sky Company for the year ended December 31,...
Selected information from the comparative financial statements of Sky Company for the year ended December 31, appears below:                                                                                    2020                       2019   Accounts receivable (net) $270,000               $300,000 Inventory 210,000 240,000 Total assets                                                              1,800,000              1,200,000 Current liabilities                                                        210,000                 165,000 Long-term debt                                                          600,000                 450,000 Net credit sales                                                       1,995,000              1,050,000 Cost of goods sold                                                  1,350,000                 795,000 Interest expense                                                           75,000                   37,500 Income tax expense                                                     90,000                   43,500 Net income 225,000                 127,500 Required: Compute the following ratios at December 31, 2020: a.   Inventory turnover for 2020. b.  ...
Sun Devil Inc. completed another successful year including a significant acquisition of Bear Down Co. For...
Sun Devil Inc. completed another successful year including a significant acquisition of Bear Down Co. For the past year, Sun Devil had operating income (OI) of $65 million and net financial expense (NFE) of $5 million during the year. During the year, Sun Devil acquired a competitor, Bear Down, for $200 million in an all equity transaction of newly issued shares. The resulting ending balance in Sun Devil’s common stock equity (CSE) was $450 million. With the acquisition of Bear...
The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to...
The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate also will remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. SCOTT, INC. 2019 Income Statement   Sales $ 759,000   Costs 594,000   Other expenses 30,000   Earnings before interest and taxes $ 135,000   Interest expense 26,000   Taxable income $ 109,000   Taxes (21%)...
The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to...
The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to grow by 30 percent. Interest expense will remain constant; the tax rate and the dividend payout rate also will remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. SCOTT, INC. 2019 Income Statement   Sales $ 752,000   Costs 587,000   Other expenses 23,000   Earnings before interest and taxes $ 142,000   Interest expense 19,000   Taxable income $ 123,000   Taxes (24%)...
Rate of Change Analyses Teicher Company presents the following condensed comparative income statements for 2020, 2019,...
Rate of Change Analyses Teicher Company presents the following condensed comparative income statements for 2020, 2019, and 2018: For Years Ended December 31, 2020 2019 2018 Sales (net) $120,000 $100,000 $85,000 Cost of goods sold (72,000) (55,000) (45,000) Gross profit $48,000 $45,000 $40,000 Operating expenses (22,000) (20,000) (18,000) Operating income $26,000 $25,000 $22,000 Other items:     Dividend revenue 400 500 200     Interest expense (1,200) (1,000) (500) Income before income taxes $25,200 $24,500 $21,700 Income tax expense (8,200) (8,000) (6,000) Net income...