Chapter 10, Problem 34QP

a)

Summary Introduction

To find: The net present value and determine what the answer states about the net present value. Also find the number of cartons that can be sold and still break evenin addition tothe cost level.

Introduction:

The price that a buyer is ready to pay for a security is the bid price.

Answer to Problem 34QP

The net present value is $465,254.29.

Explanation of Solution

Given information:

The D enterprise requires someone to supply it with 120,000 cartons of screw machines for one year to support the operations requirements for the subsequent 5 years. Person X has decided to make a bid on the contract. It will charge Person X $870,000 to install the necessary equipment to begin the production. Person X depreciates on a straight-line to zero over the project’s life. The equipment can be salvaged for $70,000.

The cost of fixed production of Person X is $325,000 for a year, and the variable production cost must be $10.30 for a carton. The essential investment that is required by Person X in the net working capital is $75,000. The tax rate is assumed to be 35% and the rate of return on the investment is 12%. The price per carton is $17.

Note: To calculate the bid price, it is essential to set the net present value equal to zero and the essential price is found using the operating cash flow. Thus, the bid price is representing the project’s financial break-even level.

Computation of the net present value:

Year	1	2	3	4	5
Sales	$2,040,000	$2,040,000	$2,040,000	$2,040,000	$2,040,000
Less: Variable costs	1,236,000	1,236,000	1,236,000	1,236,000	1,236,000
Fixed costs	325,000	325,000	325,000	325,000	325,000
Depreciation	174,000	174,000	174,000	174,000	174,000
EBIT	$   305,000	$   305,000	$   305,000	$   305,000	$   305,000
less: Taxes (35%)	106,750	106,750	106,750	106,750	106,750
Net Income	$   198,250	$   198,250	$   198,250	$   198,250	$   198,250
Add: Depreciation	174,000	174,000	174,000	174,000	174,000
Operating cash flow	$   372,250	$   372,250	$   372,250	$   372,250	$   372,250
Year	1	2	3	4	5
Operating cash flow	$   372,250	$   372,250	$   372,250	$   372,250	$   372,250
Change in NWC	-	-	-	-	75,000
Capital spending	-	-	-	-	45,500
Total CF	$   372,250	$   372,250	$   372,250	$   372,250	$   492,750

Computations for the above table:

Formula to calculate the sales:

$\text{Sales}=\text{Price per unit}\times \text{\$140,000}$

Computation of the sales:

$\begin{array}{c}\text{Sales}=\text{Price per unit}\times \text{\$140,000}\\ =17\times \text{\$120,000}\\ =\$2,040,000\end{array}$

Formula to calculate the cash outflow:

$\text{Cash outflow}=-\text{Capital spending}-\text{Changes in NWC}$

Computation of the cash outflow:

$\begin{array}{c}\text{Cash outflow}=-\text{Capital spending}-\text{Changes in NWC}\\ =-\$870,000-\$75,000\\ =-\$945,000\end{array}$

Formula to calculate the net present value:

$\text{NPV}=\text{Cash olutflow}+\text{Cash inflow}$

Computation of the net present value:

$\begin{array}{c}\text{NPV}=\text{Cash olutflow}+\text{Cash inflow}\\ =\{\begin{array}{l}-\$945,000+\text{Total cash flow}\left({\text{PVIFA}}_{\text{r , t}}\right)\\ +\left[\frac{\left(\text{Change in NWC}+\text{Capital spending}\right)}{{\left(1+\text{r}\right)}^{\text{t}}}\right]\end{array}\}\\ =-\$945,000+\$372,250\left(3.60478\right)+\left[\frac{\left(\$75,000+\$45,500\right)}{{\left(1.12\right)}^5}\right]\\ =\$465,254.29\end{array}$

Hence, the net present value is $465,254.29.

Explanation:

The net present value of the project is positive. If the real price is above the bid price, then it shows the results in zero net present value. As for the cartons, if the number of cartons sold increase, then the net present value will increase. Also, if the costs maximizes, the net present value will decline.

b)

Summary Introduction

To find: The cartons quantity that can be still supplied and still break even.

Introduction:

The price that a buyer is ready to pay for a security is the bid price.

Answer to Problem 34QP

The quantity of the cartons is 90,364.

Explanation of Solution

Given information:

The price per quantity is $17.

Computation of the operating cash flow using the formula of the net present value:

$\begin{array}{c}\text{NPV}=\text{0}=\{\begin{array}{l}\text{Cash outflow}+\text{OCF}\left({\text{PVIFA}}_{\text{12\%,5}}\right)+\\ \left[\frac{\left(\text{Change in NWC}+\text{Capital spending}\right)}{{\left(1+\text{r}\right)}^{\text{t}}}\right]\end{array}\}\\ =\{\begin{array}{l}-\$945,000+\text{OCF}\left(3.6048\right)\\ +\left[\frac{\left(\$75,000+\$45,500\right)}{{\left(1.12\right)}^5}\right]\end{array}\}\end{array}$

$\text{OCF}=\text{\$243,184}\text{.0773}$

Hence, the operating cash flow is $243,184.0773.

Formula to calculate the tax shield approach:

$\text{OCF = }\{\begin{array}{c}\left[\left(\text{P – v}\right)\text{Q – FC}\right]\left(\text{1 –Tax rate}\right)\\ \text{+Tax rate}\times \text{Depreciation}\end{array}\}$

Computation of the quantity using the formula of the operating cash flow:

$\begin{array}{c}\text{OCF =\$243,184}\text{.0773 }\{\begin{array}{c}\left[\left(\text{P – v}\right)\text{Q – FC}\right]\left(\text{1 –Tax rate}\right)\\ \text{+Tax rate}\times \text{Depreciation}\end{array}\}\\ \$\text{243,184}\text{.0773= }\{\begin{array}{c}\left[\left(\text{17 – 10}\text{.30}\right)\text{Q– \$325,000}\right]\\ \left(\text{1 – }\text{.35}\right)\text{ + }\text{.35}\left(\frac{\text{\$870,000}}{\text{5}}\right)\end{array}\}\\ \text{\$243,184}\text{.0773}=\{\left[\text{6}\text{.7Q}\text{– \$325,000}\right]\times \text{0}\text{.65 + 60,900}\}\\ \text{Q}=90,364\end{array}$

Hence, the quantity of the carton is 90,364.

c)

Summary Introduction

To find: The highest level of the fixed cost that can be afforded and still break even.

Introduction:

The price that a buyer is ready to pay for a security is the bid price.

Answer to Problem 34QP

The highest fixed cost is $523,562.68.

Explanation of Solution

Given information:

The price per quantity is $17, and the number of cartons is 120,000. The fixed price must be more than $325,000.

Computation of the operating cash flow using the formula of the net present value:

$\begin{array}{c}\text{NPV}=\text{0}=\{\begin{array}{l}\text{Cash outflow}+\text{OCF}\left({\text{PVIFA}}_{\text{12\%,5}}\right)+\\ \left[\frac{\left(\text{Change in NWC}+\text{Capital spending}\right)}{{\left(1+\text{r}\right)}^{\text{t}}}\right]\end{array}\}\\ =\{\begin{array}{l}-\$945,000+\text{OCF}\left(3.6048\right)\\ +\left[\frac{\left(\$75,000+\$45,500\right)}{{\left(1.12\right)}^5}\right]\end{array}\}\\ \text{OCF}=\text{\$243,184}\text{.0773}\end{array}$

Hence, the operating cash flow is $243,184.0773.

Formula to calculate the tax shield approach:

$\text{OCF = }\{\begin{array}{c}\left[\left(\text{P – v}\right)\text{Q – FC}\right]\left(\text{1 –Tax rate}\right)\\ \text{+Tax rate}\times \text{Depreciation}\end{array}\}$

Computation of the fixed cost using the tax shield approach:

$\begin{array}{c}\text{OCF =\$243,184}\text{.0773 }\{\begin{array}{c}\left[\left(\text{P – v}\right)\text{Q – FC}\right]\left(\text{1 –Tax rate}\right)\\ \text{+Tax rate}\times \text{Depreciation}\end{array}\}\\ \$\text{243,184}\text{.0773= }\{\begin{array}{c}\left[\left(\text{17 – 10}\text{.30}\right)\text{120,000}–\text{FC}\right]\\ \left(\text{1 – }\text{.35}\right)\text{ + }\text{.35}\left(\frac{\text{\$870,000}}{\text{5}}\right)\end{array}\}\\ \text{FC}=\$523,562.58\end{array}$

Hence, the highest level of fixed cost is $523,562.58.