Question
In: Finance
Your firm may purchase certain assets from a struggling competitor. The competitor is asking $50,000,000 for...
Your firm may purchase certain assets from a struggling competitor. The competitor is asking $50,000,000 for the assets. Last year, the assets produced revenues of $15,000,000. Revenues earned in the next year (i.e., year 1) and in future years are estimated using the information in the table below.
Your staff expects that the following assumptions will hold over the operating period:
- The assets will be viable for another 10 years but will be worthless at the end of the 10 year period
- The assets are qualified by the IRS for depreciation using the straight-line method
- A constant tax rate of 20%
Your staff has also identified three key areas of uncertainty, which include
|
Worst-Case |
Base-Case |
Best-Case |
|
|
Cash Expenses as a % of Revenues |
60% |
55% |
45% |
|
WACC |
20% |
15% |
8% |
|
Revenue Growth Rate |
-10% |
0% |
7% |
|
Probability |
10% |
80% |
10% |
Develop the annual pro forma after-tax cash flow statement for each scenario.
Note: I am pretty sure the other "experts" who answered the question previously had major flaws in their math.
Solutions
Expert Solution
| a] | BASE CASE [Growth rate = 0%]: | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Revenue | $ 1,50,00,000 | $1,50,00,000 | $ 1,50,00,000 | $ 1,50,00,000 | $ 1,50,00,000 | $ 1,50,00,000 | $ 1,50,00,000 | $ 1,50,00,000 | $ 1,50,00,000 | $ 1,50,00,000 | ||
| Cash expenses [55%] | $ 82,50,000 | $ 82,50,000 | $ 82,50,000 | $ 82,50,000 | $ 82,50,000 | $ 82,50,000 | $ 82,50,000 | $ 82,50,000 | $ 82,50,000 | $ 82,50,000 | ||
| Depreciation [50000000/10] | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | ||
| NOI | $ 17,50,000 | $ 17,50,000 | $ 17,50,000 | $ 17,50,000 | $ 17,50,000 | $ 17,50,000 | $ 17,50,000 | $ 17,50,000 | $ 17,50,000 | $ 17,50,000 | ||
| Tax at 20% | $ 3,50,000 | $ 3,50,000 | $ 3,50,000 | $ 3,50,000 | $ 3,50,000 | $ 3,50,000 | $ 3,50,000 | $ 3,50,000 | $ 3,50,000 | $ 3,50,000 | ||
| NOPAT | $ 14,00,000 | $ 14,00,000 | $ 14,00,000 | $ 14,00,000 | $ 14,00,000 | $ 14,00,000 | $ 14,00,000 | $ 14,00,000 | $ 14,00,000 | $ 14,00,000 | ||
| Add: Depreciation | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | ||
| OCF | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | ||
| Capital expenditure | $ 5,00,00,000 | |||||||||||
| Annual after tax cash flow | $ -5,00,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | $ 64,00,000 | |
| b] | BEST CASE [Growth rate = 7%]: | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Revenue | $ 1,60,50,000 | $1,71,73,500 | $ 1,83,75,645 | $ 1,96,61,940 | $ 2,10,38,276 | $ 2,25,10,955 | $ 2,40,86,722 | $ 2,57,72,793 | $ 2,75,76,888 | $ 2,95,07,270 | ||
| Cash expenses [45%] | $ 72,22,500 | $ 77,28,075 | $ 82,69,040 | $ 88,47,873 | $ 94,67,224 | $ 1,01,29,930 | $ 1,08,39,025 | $ 1,15,97,757 | $ 1,24,09,600 | $ 1,32,78,272 | ||
| Depreciation [50000000/10] | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | ||
| NOI | $ 38,27,500 | $ 44,45,425 | $ 51,06,605 | $ 58,14,067 | $ 65,71,052 | $ 73,81,025 | $ 82,47,697 | $ 91,75,036 | $ 1,01,67,289 | $ 1,12,28,999 | ||
| Tax at 20% | $ 7,65,500 | $ 8,89,085 | $ 10,21,321 | $ 11,62,813 | $ 13,14,210 | $ 14,76,205 | $ 16,49,539 | $ 18,35,007 | $ 20,33,458 | $ 22,45,800 | ||
| NOPAT | $ 30,62,000 | $ 35,56,340 | $ 40,85,284 | $ 46,51,254 | $ 52,56,841 | $ 59,04,820 | $ 65,98,158 | $ 73,40,029 | $ 81,33,831 | $ 89,83,199 | ||
| Add: Depreciation | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | ||
| OCF | $ 80,62,000 | $ 85,56,340 | $ 90,85,284 | $ 96,51,254 | $ 1,02,56,841 | $ 1,09,04,820 | $ 1,15,98,158 | $ 1,23,40,029 | $ 1,31,33,831 | $ 1,39,83,199 | ||
| Capital expenditure | $ 5,00,00,000 | |||||||||||
| Annual after tax cash flow | $ -5,00,00,000 | $ 80,62,000 | $ 85,56,340 | $ 90,85,284 | $ 96,51,254 | $ 1,02,56,841 | $ 1,09,04,820 | $ 1,15,98,158 | $ 1,23,40,029 | $ 1,31,33,831 | $ 1,39,83,199 | |
| c] | WORST CASE [Growth rate = -10%]: | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Revenue | $ 1,35,00,000 | $1,21,50,000 | $ 1,09,35,000 | $ 98,41,500 | $ 88,57,350 | $ 79,71,615 | $ 71,74,454 | $ 64,57,008 | $ 58,11,307 | $ 52,30,177 | ||
| Cash expenses [60%] | $ 81,00,000 | $ 72,90,000 | $ 65,61,000 | $ 59,04,900 | $ 53,14,410 | $ 47,82,969 | $ 43,04,672 | $ 38,74,205 | $ 34,86,784 | $ 31,38,106 | ||
| Depreciation [50000000/10] | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | ||
| NOI | $ 4,00,000 | $ -1,40,000 | $ -6,26,000 | $ -10,63,400 | $ -14,57,060 | $ -18,11,354 | $ -21,30,219 | $ -24,17,197 | $ -26,75,477 | $ -29,07,929 | ||
| Tax at 20% | $ 80,000 | $ -28,000 | $ -1,25,200 | $ -2,12,680 | $ -2,91,412 | $ -3,62,271 | $ -4,26,044 | $ -4,83,439 | $ -5,35,095 | $ -5,81,586 | ||
| NOPAT | $ 3,20,000 | $ -1,12,000 | $ -5,00,800 | $ -8,50,720 | $ -11,65,648 | $ -14,49,083 | $ -17,04,175 | $ -19,33,757 | $ -21,40,382 | $ -23,26,343 | ||
| Add: Depreciation | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | $ 50,00,000 | ||
| OCF | $ 53,20,000 | $ 48,88,000 | $ 44,99,200 | $ 41,49,280 | $ 38,34,352 | $ 35,50,917 | $ 32,95,825 | $ 30,66,243 | $ 28,59,618 | $ 26,73,657 | ||
| Capital expenditure | $ 5,00,00,000 | |||||||||||
| Annual after tax cash flow | $ -5,00,00,000 | $ 53,20,000 | $ 48,88,000 | $ 44,99,200 | $ 41,49,280 | $ 38,34,352 | $ 35,50,917 | $ 32,95,825 | $ 30,66,243 | $ 28,59,618 | $ 26,73,657 |
jeff jeffy answered 1 week agoRelated Solutions
Your firm may purchase certain assets from a struggling competitor. The competitor is asking $50,000,000 for...
Your firm may purchase certain assets from a struggling
competitor. The competitor is asking $50,000,000 for the assets.
Last year, the assets produced revenues of $15,000,000. Revenues
earned in the next year (i.e., year 1) and in future years are
estimated using the information in the table below.
Your staff expects that the following assumptions will hold over
the operating period:
The assets will be viable for another 10 years but will be
worthless at the end of the 10...
Your firm may purchase certain assets from a struggling competitor. The competitor is asking $50,000,000 for...
Your firm may purchase certain assets from a struggling
competitor. The competitor is asking $50,000,000 for the assets.
Last year, the assets produced revenues of $15,000,000. Revenues
earned in the next year (i.e., year 1) and in future years are
estimated using the information in the table below.
Your staff expects that the following assumptions will hold over
the operating period:
The assets will be viable for another 10 years but will be
worthless at the end of the 10...
Your firm may purchase certain assets from a struggling competitor. The competitor is asking $50,000,000 for...
Your firm may purchase certain assets from a struggling
competitor. The competitor is asking $50,000,000 for the assets.
Last year, the assets produced revenues of $15,000,000. Revenues
earned in the next year (i.e., year 1) and in future years are
estimated using the information in the table below.
Your staff expects that the following assumptions will hold over
the operating period:
The assets will be viable for another 10 years but will be
worthless at the end of the 10...
Your firm is considering purchasing firm Z and they have asked for your help in valuing it. You are struggling a bit because of the uncertain prospects for this industry.
Your firm is considering purchasing firm Z and they have asked for your help in valuing it. You are struggling a bit because of the uncertain prospects for this industry. Firm Z most recently generated FCF of $30M last year, but you are uncertain of what might happen over the next few years. Specifically, your company’s sales team thinks that it is 40% likely that firms in the industry will grow by 6% this year and for 4 years after...
What are the advantages and disadvantages of a purchase of assets from the perspectives of the...
What are the advantages and disadvantages of a purchase of
assets from the perspectives of the buyer and the seller?
Your firm will either purchase or lease a new $500,000 packaging machine from the manufacturer. If...
Your firm will either
purchase or lease a new $500,000 packaging machine from the
manufacturer. If purchased, the machine will be depreciated
straight-line over five years. You can lease the machine using a
true tax lease for $125,000 per year for five years with the first
payment today. Assume the machine has no residual value, the
secured borrowing rate is 9%, and the tax rate is 35%. Should you
buy or lease?
Your firm has a contract to purchase 1000 laptops from a Taiwanese company. The payment is...
Your firm has a contract to purchase 1000 laptops from a
Taiwanese company. The payment is due on receipt of the shipment
and must be delivered in Taiwan on June 31, 2020. In March 2020,
when you are arranging the contract, the laptops are each priced at
20,000 NT$ (New Taiwan Dollar). The spot rate in March 2020 is $1
in exchange for 30 NT$.
a) [5 points] What is the U.S. dollar price of one unit of
laptop in...
Assume that your group of team members, drawn from multiple departments, and that it is struggling...
Assume that your group of team members, drawn from multiple
departments, and that it is struggling to deliver promised
deadlines within budget. Team tension grows, because people are
frustrated and fearful of failure. You notice that the negative
sentiments are risking outcomes. Conflict is growing, coordination
reducing, and their direct supervisory managers limit their
availability. What should you do?
250 words of detail - concise and structured business
writing
You are trying to allocate your assets into a risky portfolio and the purchase of a...
You are trying to allocate your assets into a risky portfolio
and the purchase of a risk free asset with a return of 2%. You use
the following data to estimate information about the risky
portfolio:
Year
Return
2014
-15%
2015
-5%
2016
30%
2017
-10%
2018
35%
If you have a risk-aversion factor of 2.5, what percentage of
your total portfolio should be in the risky portfolio?
Recall from your previous corporate finance studies. For a levered firm, firm’s assets are financed by...
Recall from your previous corporate finance studies. For a
levered firm, firm’s assets are financed by equity and debt. That
is, ?? = ?? + ??, where ??, ?? & ??
represents asset value, debt value and equity value at time ?.
Suppose the firm makes no dividend payment and has a zero-coupon
debt maturing at time ?. At maturity, if the value of the company
asset is greater than the maturity value of the debt (?? > ??),
the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- One economic question is deciding how to produce. That means businesses need to make decisions on...
- Is 2k-1 odd? I get that 2(some int k) + 1 is the property for odd...
- A 0.25 kg block slides down a ramp that is 0.6 m tall, 0.8 m long...
- WHAT IS THE BEST WAY TO MOTIVATE AN EMPLOYEE AND WHY?
- Which one between unemployment and inflation do you think is more inportant to stabilize if the...
- A3.2 Explain why it is important to actively support a team through all stages but particularly...
- should the United States adopt information-control regulations similar to Britain’s Official Secrets Act? Explain why or...
ADVERTISEMENT