Chapter 26: Q36PGB (page 1473)

Howard Company operates a chain of sandwich shops. The company is considering two possible expansion plans. Plan A would open eight smaller shops at a cost of $8,500,000. Expected annual net cash inflows are $1,600,000 for 10 years, with zero residual value at the end of 10 years. Under Plan B, Howard Company would open three larger shops at a cost of $8,100,000. This plan is expected to generate net cash inflows of $1,000,000 per year for 10 years, which is the estimated useful life of the properties. Estimated residual value for Plan B is $990,000. Howard Company uses straight-line depreciation and requires an annual return of 6%.
Requirements
1. Compute the payback, the ARR, the NPV, and the profitability index of these two plans.
2. What are the strengths and weaknesses of these capital budgeting methods?
3. Which expansion plan should Howard Company choose? Why?
4. Estimate Plan A’s IRR. How does the IRR compare with the company’s required rate of return?

Short Answer

Expert verified

1. Capital budgeting methods:

	Plan A	Plan B
Payback	5.31 years	8.18 years
ARR	8.82%	3.56%
NPV	$3,276,000	($187,580)
Profitability index	1.39	0.97

2. Payback period and ARR are simple and easy but they do not consider the time value of money. NPV and profitability index considers the time value of money but sometimes ARR does not reflect accurate figures and also NPV cannot be used in certain situations.

3. The business entity must select Plan A.

4. IRR of plan A is 13.53%.

Step by step solution

Definition of Payback Period

A capital budgeting metric that determines the time period in which the investment will give back the cash invested or the investment/cash recovery period is known as the payback period.

Calculation of payback, ARR, NPV and profitability index

Calculation of payback period:

Plan	Initial investment	/	Expected net annual cash inflows	=	Payback period
A	$8,500,000	/	$1,600,000	=	5.31 years
B	$8,100,000	/	$990,000	=	8.18 years

Calculation of ARR:

Plan A:

$\begin{matrix} ARR = \frac{Average annual revenue}{Initial investment} \times 100 \\ = \frac{$ 750, 000}{$ 8, 500, 000} \times 100 \\ = 8.82 % \end{matrix}$

Working note:

Particular	Amount $
Total net cash flows during the life of the project	$16,000,000
Less: Total depreciation during the life of the asset	8,500,000
Total operating income during the operating life	7,500,000
Asset operating life in years	10
Average annual operating income ($7,500,000 / 10)	$750,000

Plan B:

role="math" localid="1656755103521" $\begin{matrix} ARR = \frac{Average annual revenue}{Initial investment} \times 100 \\ = \frac{$ 289, 000}{$ 8, 100, 000} \times 100 \\ = 3.56 % \end{matrix}$

Working note:

Particular	Amount $
Total net cash flows during the life of the project	10,000,000
Less: Total depreciation during the life of the asset ($8,100,000-$990,000)	7,110,000
Total operating income during the operating life	2,890,000
Asset operating life in years	10
Average annual operating income ($2,890,000 /10)	$289,000

Calculation of NPV:

Plan A:

Time	Particular	Net cash inflow	Ordinary annuity PV factor	PV factor	Present value
1-10 years	PV of annuity	$1,600,000	7.36	-	$11,776,000
10 years	Residual value	$0	-		0
Total PV of net cash flow					$11,776,000
0	Initial investment				(8,500,000)
Net present value of the Plan					$3,276,000

Plan B:

Time	Particular	Net cash inflow	Ordinary annuity PV factor	PV factor	Present value
1-10 years	PV of annuity	$1,000,000	7.36	-	$7,360,000
10 years	Residual value	$990,000	0.558		552,420
Total PV of net cash flow					$7,912,420
0	Initial investment				(8,100,000)
Net present value of the Plan					($187,580)

Calculation of profitability index:

Plan A:

$\begin{matrix} Profitability index = \frac{Total present value of net cashflows}{Initial investment} \\ = \frac{$ 11, 776, 000}{$ 8, 500, 000} \\ = 1.39 \end{matrix}$

Plan B:

$\begin{matrix} Profitability index = \frac{Total present value of net cashflows}{Initial investment} \\ = \frac{$ 7, 912, 420}{$ 8, 100, 000} \\ = 0.97 \end{matrix}$

Strength and weakness of capital budgeting

Method	Strength	Weakness
Payback	It is a simple method and determines the risk of the investments that will require a longer time to recover the cash.	It does not consider the time value of the money and cash flows occurring after the payback period.
ARR	It uses the figures of accrual accounting and measures the Plan's profitability over its useful life.	It also does not consider the time value of money.
NPV	It considers the time value of money and cash flow from the Plan over its useful life. It also determines the return that the company requires.	It is not helpful when different initial investments are required for various assets.
Profitability index	It also considers money’s time value and net cash flows during the Plan’s life. It also calculates the unique rate of return and does not require any additional steps.	It cannot be determined accurately without using the business calculator and software.

Appropriate expansion plan

Plan A will be appropriate because the net present value of this plan is positive and the profitability index of this plan is above 1.

IRR of plan A

$\begin{matrix} NPV = \sum_{t = 0}^{} \frac{C_{t}}{{(1 + IRR)}^{t}} \\ 0 = (\begin{array}{l} \frac{- $ 8, 500, 000}{{(1 + IRR)}^{0}} + \frac{$ 1, 600, 000}{{(1 + IRR)}^{1}} + \frac{$ 1, 600, 000}{{(1 + IRR)}^{2}} + \\ \frac{$ 1, 600, 000}{{(1 + IRR)}^{3}} + \frac{$ 1, 600, 000}{{(1 + IRR)}^{4}} + \frac{$ 1, 600, 000}{{(1 + IRR)}^{5}} + \\ \frac{$ 1, 600, 000}{{(1 + IRR)}^{7}} + \frac{$ 1, 600, 000}{{(1 + IRR)}^{6}} + \frac{$ 1, 600, 000}{{(1 + IRR)}^{7}} + \frac{$ 1, 600, 000}{{(1 + IRR)}^{8}} + \\ \frac{$ 1, 600, 000}{{(1 + IRR)}^{9}} + \frac{$ 1, 600, 000}{{(1 + IRR)}^{10}} \end{array}) \\ IRR = 13.53 % \end{matrix}$

IRR is 13.53% which is more than the required rate of return i.e., 6%. Therefore, the business entity must select Plan A.

Unlock Step-by-Step Solutions & Ace Your Exams!

Full Textbook Solutions
Get detailed explanations and key concepts
Unlimited Al creation
Al flashcards, explanations, exams and more...
Ads-free access
To over 500 millions flashcards
Money-back guarantee
We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Net Cash Inflows
	Project L		Project M		Project N
Year	Annual	Accumulated	Annual	Accumulated	Annual	Accumulated
1	\) 100,000	\( 100,000	\) 200,000	\( 200,000	\) 400,000	$ 400,000
2	100,000	200,000	250,000	450,000	400,000	800,000
3	100,000	300,000	350,000	800,000
4	100,000	400,000	400,000	1,200,000
5	100,000	500,000	500,000	1,700,000
6	100,000	600,000
7	100,000	700,000
8	100,000	800,000

Short Answer

Step by step solution

Definition of Payback Period

Calculation of payback, ARR, NPV and profitability index

Strength and weakness of capital budgeting

Appropriate expansion plan

IRR of plan A

One App. One Place for Learning.

Most popular questions from this chapter

Recommended explanations on Business Studies Textbooks

Managerial Economics

Managers

Human Resources

Operational Management

Business Development

Nature of Business

Study anywhere. Anytime. Across all devices.