Following are the inputs of ABC Corporation. Year 2015 2016 2017 2018 Growth Rate 8% 8%...

Following are the inputs of ABC Corporation.

Year	2015	2016	2017	2018
Growth Rate	8%	8%	8%	4%
EBIT (1-t)	200	220	240	130
Capex	100	110	120	50
Cost of Equity	10%	10%	10%	10%
Cost of Debt	6%	6%	6%	6%
Debt Ratio	20%	20%	20%	20%
Return on capital	25%	25%	25%	15%

Please calculate value of ABC corporation using discounted cash flow method.

Please provide excel along with formula used

Solutions

Expert Solution

Please find below spreadsheet for calculation and answer. Formula reference also provided for better understanding -

Formula reference -

Capex refers to capital expenditure such buying machinery, buildings etc. It not considered while calculating Earning for the year but to calculate Free cash flow after tax, it must be subtracted from cash earning after tax {EBIT(1-t)}.

Please note - Growth rate and return on capital to be ignored as no special instruction provided in question. please comment if need any further explanation.

C16 ABC Corporation 1 2015 200 100 2016 220 110 -D4+D5 0.1 0.06 0.2 2017 240 120 -E4+E5 0.1 0.06 0.2 2018 130 50 -F4+F5 0.1 0.06 0.2 YEAR 4 EBIT(1-t) Capex 6 Free cash flow after tax (FCF) C4+C5 cost of equity cost of debt debt ratio equity ratio 0.1 0.06 0.2 1-C9 11 WACC (cost of capital) 12 13 PVF (Discount factor) 14 15 16 Value of ABC corporationSUM(C14:F14) 17 -1/(1+C11)^C2-1/(1+D11)AD2-1/(1+E11)^E2-1/(1+F11)AF2 C6 C13 D6 D13 -E6*E13 -F6*F13 Present value of FCF Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet (2) Sheet7

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Q1. Company ABC has the following income: 2014 $10,000 2015 $15,000 2016 $(1,000) 2017 $(30,000) 2018...

Q1. Company ABC has the following income: 2014 $10,000 2015 $15,000 2016 $(1,000) 2017 $(30,000) 2018 $5,000 Please JEs to record loss carryback and forward for 2016, 2017 and 2018 Q2. Company ABC bought an equipment for $20,000 in 2015, with useful life of 5 years $5,000 residual value amortized using straight-line method. Prepare a table to illustrate the differences accounting income vs taxable income caused by this equipment. Assume, this equipment was sold at the end of2017 for $11,000....

1. In 2018, ABC Corporation purchased a new photocopier (asset class 8) with a CCA rate...

1. In 2018, ABC Corporation purchased a new photocopier (asset class 8) with a CCA rate of 20% for $5,000, as well as a new truck (asset class 10) with a CCA rate of 30% for $40,000. Calculate the total CCA for ABC Corporation for each of the first three years. Show your calculations. 2. ABC Corporation is a large retailer that has many stores in Canada. Each location has a store manager who receives a fixed salary regardless of...

1. In 2018, ABC Corporation purchased a new photocopier (asset class 8) with a CCA rate...

1. In 2018, ABC Corporation purchased a new photocopier (asset class 8) with a CCA rate of 20% for $5,000, as well as a new truck (asset class 10) with a CCA rate of 30% for $40,000. * Calculate total CCA for ABC Corporation for each of the first 3 years.( SHOW ALL CALCULATIONS)

2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000...

2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000 Cost of goods sold 72,600 53,400 45,600 33,300 30,000 Dollar amounts stated above are in thousands. a. Compute trend percentages for the above items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. b. State whether the trends are favorable or unfavorable. Required A Required B Compute trend percentages for the above items taken from...

2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200...

2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200 Cost of goods sold 332,087 214,419 173,535 120,176 88,788 Accounts receivable 32,560 25,434 23,715 14,180 12,376 Compute trend percents for the above accounts, using 2014 as the base year. (Round the percents to whole numbers.)

2019 2018 2017 2016 2015 Sales $ 475,208 $ 306,586 $ 248,248 $ 171,798 $ 125,400...

2019 2018 2017 2016 2015 Sales $ 475,208 $ 306,586 $ 248,248 $ 171,798 $ 125,400 Cost of goods sold 244,756 158,059 130,106 89,117 63,954 Accounts receivable 23,095 17,966 16,955 9,999 8,577 Compute trend percents for the above accounts, using 2015 as the base year.

The Murdock Corporation reported the following balance sheet data for 2016 and 2015: 2016 2015 Cash...

The Murdock Corporation reported the following balance sheet data for 2016 and 2015: 2016 2015 Cash $ 80,705 $ 24,755 Available-for-sale securities (not cash equivalents) 17,000 88,000 Accounts receivable 83,000 70,950 Inventory 168,000 147,700 Prepaid insurance 1,770 2,300 Land, buildings, and equipment 1,256,000 1,128,000 Accumulated depreciation (613,000 ) (575,000 ) Total assets $ 993,475 $ 886,705 Accounts payable $ 79,040 $ 151,670 Salaries payable 21,200 26,000 Notes payable (current) 27,700 78,000 Bonds payable 203,000 0 Common stock 300,000 300,000 Retained...

Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61...

Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61 73 68 67 72 75 70 Calculate and interpret the characteristics of it; Make the time series next value forecast by using any method.

Part 1 Between 2015 and 2016, the country of West Fredonia experienced a growth rate of...

Part 1 Between 2015 and 2016, the country of West Fredonia experienced a growth rate of -2.6%. If nominal GDP had increased by 1.3% and the population growth was recorded as 0.4%, then calculate the annual inflation rate in West Fredonia. Give your answer to one decimal._____________ % Part 2 Year Nominal GDP (billions of current $) Inflation rate Population (millions) 2014 3754 2% 117 2015 3898 3% 120 2016 3919 1% 124 Using the information in the table above,...

MCDONALDS balance sheet. Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018...

MCDONALDS balance sheet. Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018 5-year trend Cash & Short Term Investments 2.08B 7.69B 1.22B 2.46B 866M Cash Only 2.08B 7.69B 1.22B 2.46B 866M Short-Term Investments - - - - - Total Accounts Receivable 1.21B 1.3B 1.47B 1.98B 2.44B Accounts Receivables, Net 1.21B 1.3B 1.47B 1.98B 2.44B Accounts Receivables, Gross 1.21B 1.3B 1.47B 1.98B 2.44B Bad Debt/Doubtful Accounts - - - - - Other Receivables - - - -...

Subjects