Question

In: Finance

Case Analysis 3: You are the General Manager at the Bicker, Slaughter, and Lynch Law Firm....

Case Analysis 3: You are the General Manager at the Bicker, Slaughter, and Lynch Law Firm. There is an opportunity to buy out a small law firm that was just started by a young MBA/JD, and you believe the firm can be grown and become a lucrative part of your Firm. With help from your finance leader, you have estimated the following benefit streams for this new division:

Before Tax Cash Flow From Operations

Year 1 $(149,000)

Year 2 $0

Year 3 $51,380

Year 4 $88,760

Year 5 $114,100

Year 6 $129,780

Year 7 $143,640

Year 8 $167,300

After Tax Net Income From Operations

Year 1 $(103,500)

Year 2 $(50,500)

Year 3 $36,700

Year 4 $63,400

Year 5 $81,500

Year 6 $92,700

Year 7 $102,600

Year 8 $119,500

After Tax Cash Flow From Operations

Year 1 $(85,600)

Year 2 $15,000

Year 3 $48,600

Year 4 $72,200

Year 5 $95,550

Year 6 $101,300

Year 7 $125,200

Year 8 $140,200

You estimate that the purchase price for this firm would be $200,000 and that additional net working capital would be needed in the amount of $60,000 in year 0, an additional $15,000 in year 2 and then $15,000 in year 5.

• BSL usually spend about $275,000 per year in advertising. If you make this acquisition, you would ask that advertising spending be increased by an incremental one-time amount of $45,000 in year 0 to publicize the firm’s expansion.

• Your finance leader has indicated that the firm has access to a credit line and could borrow the funds at a rate of 6%. He also mentions that when he runs project economics for capital budgeting (such as a new copier or a company car), he recommends a standard 10% rate discount, but the one other time they looked at an acquisition of a smaller firm, he used a 13% rate discount. Obviously you will want to select the most appropriate discount rate for this type of project.

• At the end of 8 years, the plan is to sell this division. The estimated terminal value (the sale and the return of working capital) is conservatively estimated to be $350,000 of after-tax cash flow help.

Using the data that you need (and ignoring the extraneous information), for this potential acquisition, calculate each of the following items: the Nominal Payback, the Discounted Payback, the Net Present Value, the IRR.

In an MS Word document, in paragraph form, respond to the following questions:

1) From a purely financial (numbers) perspective, would you recommend this purchase to management? Why?

2) What are some of the non-financial elements that need to be considered for this proposal?

3) Assumptions in project economics can have a huge impact on the result. Identify 3 financial elements/assumptions in your analysis that would make this project financially unattractive? In other words, what would have to be true for this to be a bad investment?

4) If you were the CEO, would you approve this proposal? Why or why not?

Solutions

Expert Solution

Step 1: Calculate Annual Net Cash Flows

The value of annual net cash flows is arrived as below:

Cash Flow Year 0 = Purchase Price + Working Capital + Incremental Advertising = 200,000 + 60,000 + 45,000 = $305,000

Cash Flow Year 1 = -$85,600

Cash Flow Year 2 = Annual After-Tax Flow Inflow for Year 2 - Working Capital = 15,000 - 15,000 = $0

Cash Flow Year 3 = $48,600

Cash Flow Year 4 = $72,200

Cash Flow Year 5 = Annual After-Tax Flow Inflow for Year 5 - Working Capital = 95,550 - 15,000 = $80,550

Cash Flow Year 6 = $101,300

Cash Flow Year 7 = $125,200

Cash Flow Year 8 = Annual After-Tax Flow Inflow for Year 8 + Terminal Value = 140,200 + 350,000 = $490,200

_____

Step 2: Calculate Nominal Payback Period

The nominal payback period is calculated as below:

Year Cash Flow Cumulative Cash Flow
0 -305,000 -305,000
1 -85,600 -390,600
2 0 -390,600
3 48,600 -342,000
4 72,200 -269,800
5 80,550 -189,250
6 101,300 -87,950
7 125,200 37,250
8 490,200 527,450

As can be seen from the above table that cumulative cash flows turn positive from negative between Year 6 and Year 7. Therefore, the payback period will fall between year 6 and year 7. The formula for payback period can be derived as below:

Payback Period = Years upto which Partial Recovery is Made + Balance Amount/Cash Flow of the Year in which Full Recovery is Made = 6 + 87,950/125,200 = 6.70 years

_____

Step 2: Calculate Discounted Payback Period

The discounted payback period is calculated as below:

Year Cash Flow (A) Discount Rate @13% (B) Discounted Cash Flows (A*B) Cumulative Discounted Cash Flows
0 -305,000 1.0000 -305,000 -305,000
1 -85,600 0.8850 -75,756 -380,756
2 0 0.7831 0 -380,756
3 48,600 0.6931 33,685 -34,7071
4 72,200 0.6133 44,280 -302,791
5 80,550 0.5428 43,723 -259,069
6 101,300 0.4803 48,654 -210,414
7 125,200 0.4251 53,223 -157,192
8 490,200 0.3762 184,413 27,222

As can be seen from the above table that cumulative discounted cash flows turn positive from negative between Year 7 and Year 8. Therefore, the payback period will fall between year 7 and year 8. The formula for discounted payback period can be derived as below:

Discounted Payback Period = Years upto which Partial Recovery is Made + Balance Amount/Cumulative Discounted Cash Flow of the Year in which Full Recovery is Made = 7 + 157,192/184,413 = 7.85 years

_____

Step 3: Calculate NPV

NPV is the difference between the discounted present value of cash outflows and cash inflows. The NPV is determined with the use of following table as below:

Year Cash Flow (A) Discount Rate @13% (B) Discounted Cash Flows (A*B)
0 -305,000 1.0000 -305,000
1 -85,600 0.8850 -75,756
2 0 0.7831 0
3 48,600 0.6931 33,685
4 72,200 0.6133 44,280
5 80,550 0.5428 43,723
6 101,300 0.4803 48,654
7 125,200 0.4251 53,223
8 490,200 0.3762 184,413
NPV $27,222

_____

Step 4: Calculate IRR

IRR is the minimum rate of return acceptable from a project. It can be calculated with the use of IRR function/formula of EXCEL/Financial Calculator. The basic for calculating IRR is provided as below:

NPV = 0 = Cash Flow Year 0 + Cash Flow Year 1/(1+IRR)^1 + Cash Flow Year 1/(1+IRR)^2 + Cash Flow Year 3/(1+IRR)^3 + Cash Flow Year 4/(1+IRR)^4 + Cash Flow Year 5/(1+IRR)^5 + Cash Flow Year 6/(1+IRR)^6 + Cash Flow Year 7/(1+IRR)^7 + Cash Flow Year 8/(1+IRR)^8

IRR is calculated with the use of EXCEL as below:

where IRR = IRR(B2:B10) = 14.25%

______

Part 1)

Yes, I would recommend this purchase to the management of the company. It is because it generates a positive NPV ($27,222) and IRR (14.25%) greater than the cost of capital (13%). Also, the total cost of investment gets recovered within the estimated life of the project.

______

Part 2)

The non-financial elements that need to be considered for this proposal are provided below:

1) The time duration of the project.

2) The changes in business risks and economic conditions.

3) Impact of making the purchase on employee/staff morale.

______

Part 3)

The three financial elements that would make the project financially unattractive are given as follows:

1) The NPV of the project is zero.

2) The internal rate of return is less than the cost of capital.

3) The investment is not recovered within the estimated life of the project.

______

Part 4)

Yes, I would approve the proposal. It is because the project will generate a positive NPV. NPV is considered as one of the best investment evaluation techniques while making a decision with respect to accepting/rejecting a project/investment.


Related Solutions

Case analysis report Please find an international business law case and write a case analysis. There...
Case analysis report Please find an international business law case and write a case analysis. There should be basic case information(such as case name, two parties, in which area, cast facts(the main disputes), issue(question), holding, rule or reasoning. Topic could be chosen from any Chapter from international economic and trade law. But topics related to contract/IPR/WTO/agency are easier to get. Requirements: a. Around 500-1000 words, better no more than two pages.
Case 1 – Cost-Volume-Profit Analysis Janet Jennings is the general manager for Mercashoe Store. She is...
Case 1 – Cost-Volume-Profit Analysis Janet Jennings is the general manager for Mercashoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $24,000 in fixed costs to the existing fixed costs. In addition, Janet is proposing a 5% price decrease ($40 to $38) that will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $24 per...
You are working at Bank of America Merrill Lynch as a Portfolio Manager. You are thinking...
You are working at Bank of America Merrill Lynch as a Portfolio Manager. You are thinking about rebalancing clients portfolio position and researching on various industries, i.e., housing construction, health care, energy, technology, financials, coal mining, and steel production. Choose one or two industry that you would expect to perform best in future. Write a brief summary and explain why you client would be convinced by your decision.
Case 1 Cost-Volume-Profit (CVP) analysis + marginal analysis You are the manager in Bright company that...
Case 1 Cost-Volume-Profit (CVP) analysis + marginal analysis You are the manager in Bright company that produces paper bags for food shops and supermarkets. You are provided with following information: Bright company is able to produce 60,000 packs of bags. Its current sale volume is 50,000 packs of bags per year. This has achieved its maximum sale force. Current selling price is $10 per pack of bags. Variable costs in total are $200,000; Fixed costs are $ 125,000. A newly...
Pretend you are a project manager employed by a General Contracting firm. Your company is currently...
Pretend you are a project manager employed by a General Contracting firm. Your company is currently serving as a Construction Manager at Risk for a project and is requiring all vendors, material suppliers and subcontractors to submit digital design files. Provide 4 strategies you may implement to facilitate interoperability issues. Provide detailed descriptions of each strategy
Option #2: Capital Budgeting Analysis Suppose you are the financial manager of a firm considering the...
Option #2: Capital Budgeting Analysis Suppose you are the financial manager of a firm considering the following five projects. Project A Project B Project C Project D Project E Initial Investment -$10,000 -$15,000 -$14,000 -$6,000 -$1,500 Year 1 $5,000 $5,000 $6,000 $4,000 $1,000 Year 2 $4,000 $5,000 $4,000 $2,000 $250 Year 3 $2,000 $5,000 $3,500 $2,000 $100 Year 4 $1,000 $5,000 $2,500 $2,000 $100 Year 5 $5,000 $2,000 $100 Year 6 $2,000 $100 Calculate the Payback Period for each project....
General Law vs Special Law
Differentiate between General Law and Special Law?or General Law vs Special Law
The law firm of Poe, Patterson and Henderson, a general partnership, represents 20 plaintiffs in a...
The law firm of Poe, Patterson and Henderson, a general partnership, represents 20 plaintiffs in a class-action product liability lawsuit, with trial scheduled to begin Monday of next week. It will be the biggest trial in the history of the firm, and the partners understand that success will depend, for the most part, on a collaborative effort on the part of all professionals at the firm, including partners, associate attorneys, paralegals, and secretarial staff. It is the Friday before the...
You are a shift manager at Home Depot. The General Manager tasks you with a huge...
You are a shift manager at Home Depot. The General Manager tasks you with a huge job. She wants you to create an action plan for the most dangerous department within the store. Specifically, she is looking for you to identify the part of the store where it is most likely that a customer may injure themselves. Please identify that area, explain the risk, and create a solution.
Barbara Lynch is the product manager for a line of skiwear produced by HeathCo Industries and...
Barbara Lynch is the product manager for a line of skiwear produced by HeathCo Industries and privately branded for sale under several different names, including Northern Slopes and Jacque Monri. A new part of Ms. Lynch's job is to provide a quarterly forecast of sales for the northern United States, a region composed of 27 states stretching from Maine to Washington. A 10-year sales history is shown: Period Sales Mar-07 72,962 Jun-07 81,921 Sep-07 97,729 Dec-07 142,161 Mar-08 145,592 Jun-08...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT