It is the end of 2017 and you are asked to value the XYZ corp. You have the foll
ID: 2806216 • Letter: I
Question
It is the end of 2017 and you are asked to value the XYZ corp. You have the following financials for this firm.
2017
2018
2019
2020
Income Statement
Sales
1,500,000
2,000,100
2,400,000
COGS
1,200,000
1,600,080
1,920,000
Other Expenses (includes dep)
150,000
200,010
240,000
EBIT
150,000
200,010
240,000
Interest Expense
100,000
100,000
100,000
EBT
50,000
100,010
140,000
Tax
17,500
35,004
49,000
Net Income
32,500
65,007
91,000
Selected items of the balance sheet
NetPPE
80,000
100,000
133,340
160,000
AR
100,000
123,288
164,392
197,260
AP
120,000
147,945
197,270
236,712
The tax rate is 35%. You expect sales to grow at 4% from 2020 on. In addition, the cost of capital for this firm is 12%.
Q. Compute the average historical Sales/NetPPE and average historical Accounts Receivable Days on Hand
2017
2018
2019
2020
Income Statement
Sales
1,500,000
2,000,100
2,400,000
COGS
1,200,000
1,600,080
1,920,000
Other Expenses (includes dep)
150,000
200,010
240,000
EBIT
150,000
200,010
240,000
Interest Expense
100,000
100,000
100,000
EBT
50,000
100,010
140,000
Tax
17,500
35,004
49,000
Net Income
32,500
65,007
91,000
Selected items of the balance sheet
NetPPE
80,000
100,000
133,340
160,000
AR
100,000
123,288
164,392
197,260
AP
120,000
147,945
197,270
236,712
Explanation / Answer
Sales/net PPE
2018 1.5$ million/ 0.1$ million = 15$ million.
2019. 2.0001/0.1334= 15$ million.
2020. 2.4/0.16= 15$ million.
Average historical = 1.9666/0.1311= 15$ million.
Average Accounts receivable= Accounts receivable/ average sales per day.
2018. 123288/4109.59 = 30 days
2019. 164392/5479= 30 days
2020. 197260/6575.34= 30 days.
Average historical 161646.66/5387.97= 30 days
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.