The net present value and the internal rate of return . Introduction: The variation between the present value of the cash outflows and the present value of the cash inflows are known as the net present value . In capital budgeting the net present value is utilized to analyze the profitability of a project or investment. The rate of return which equates the initial investment and the present value of net cash inflows are referred to as internal rate of return . This is also called as actual rate of return.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 10, Problem 32QP

Summary Introduction

To find: The net present value and the internal rate of return.

Introduction:

The variation between the present value of the cash outflows and the present value of the cash inflows are known as the net present value. In capital budgeting the net present value is utilized to analyze the profitability of a project or investment. The rate of return which equates the initial investment and the present value of net cash inflows are referred to as internal rate of return. This is also called as actual rate of return.

Expert Solution & Answer

Answer to Problem 32QP

The net present value is $4,725,575.74 and the internal rate of return is 27.52%.

Explanation of Solution

Given information:

Company A projects the unit sale for the new 7 octave voice emulation implant as follows:

The year 1 unit sales is 84,000
The year 2 unit sales is 98,000
The year 3 unit sales is 113,000
The year 4 unit sales is 106,000
The year 5 unit sales is 79,000

The production implant needs $1,500,000 in the net working capital to begin their production activities. The extra net working capital investment for every year is equivalent to the 15% of the sales that is projected has to rise for the following year. The total fixed cost is $3,400,000 for a year, the unit price is $395, and the variable production cost is $265. The installation cost of the equipment is $17,000,000.

The equipment is qualified in the 7 Year MACRS depreciation under the property class. In 5 years the equipment sale can be sold for 20% of its acquisition cost. The marginal tax bracket is 35 percent and has the required rate of return which is 18%.

MACRS depreciation table for year 7:

MACRS Depreciation table for seven year
Year	Seven year
1	14.29%
2	24.49%
3	17.49%
4	12.49%
5	8.93%
6	8.92%
7	8.93%
8	4.46%

Computation of the net present value:

Computation of the cash outflow:

$Cash outflow = (−Capital spending(Installed cost)+−Initial net working capital)=(−$17,000,000)+(−$1,500,000)=−$18,500,000$

Table showing the cash inflows:

Year	1	2	3	4	5
Ending book value	$14,570,700	$10,407,400	$7,434,100	$5,310,800	$3,792,700
Sales	$33,180,000	$38,710,000	$44,635,000	$41,870,000	$31,205,000
Less: Variable costs	-$22,260,000	-$25,970,000	-$29,945,000	-$28,090,000	-$20,935,000
Fixed costs	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000
Depreciation	-$2,429,300	-$4,163,300	-$2,973,300	-$2,123,300	-$1,518,100
EBIT	$5,090,700	$5,176,700	$8,316,700	$8,256,700	$5,351,900
Less: Taxes	-$1,781,745	-$1,811,845	-$2,910,845	-$2,889,845	-$1,873,165
Net income	$3,308,955	$3,364,855	$5,405,855	$5,366,855	$3,478,735
Add: Depreciation	$2,429,300	$4,163,300	$2,973,300	$2,123,300	$1,518,100
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835

Net cash inflows:
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835
Change in net working capital	–829,500	–888,750	$414,750	$1,599,750	$1,203,750
Capital spending	$0	$0	$0	$0	$3,537,445
Total cash inflows	$4,908,755	$6,639,405	$8,793,905	$9,089,905	$9,738,030

Computations for the above table:

Formula to calculate the ending book value:

$Ending book value = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]$

Computation of the ending book value for year 1:

$Ending book value for year 3 = [ Ending book value of an equipment for year 2−(Initial cost of an equipment×MACRS rate )]=$10,407,400−($17,000,000×17.49%)=$10,407,400−$2,973,300=$7,434,100$

$Ending book value for year 1 = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]=$17,000,000−($17,000,000×14.29%)=$17,000,000−$2,429,300=$14,570,700$

$Ending book value for year 2 = [ Ending book value of an equipment for year 1−(Initial cost of an equipment×MACRS rate )]=$14,570,700−($17,000,000×24.49%)=$14,570,700−$4,163,300=$10,407,400$

$Ending book value for year 4 = [ Ending book value of an equipment for year 3−(Initial cost of an equipment×MACRS rate )]=$7,434,100−($17,000,000×12.49%)=$7,434,100−$2,123,300=$5,310,800$

$Ending book value for year 5 = [ Ending book value of an equipment for year 4−(Initial cost of an equipment×MACRS rate )]=$5,310,800−($17,000,000×8.93%)=$5,310,800−$1,518,100=$3,792,700$

Formula to calculate the sales:

$Sales = Unit sales×Price per unit$

Computation of the sales:

$Sales for year 1 = Unit sales for year 1×Price per unit=$84,000×$395=$33,180,000$

$Sales for year 2 = Unit sales for year 2×Price per unit=$98,000×$395=$38,710,000$

$Sales for year 3 = Unit sales for year 3×Price per unit=$113,000×$395=$44,635,000$

$Sales for year 4 = Unit sales for year 4×Price per unit=$106,000×$395=$41,870,000$

$Sales for year 5 = Unit sales for year 5×Price per unit=$79,000×$395=$31,205,000$

Computation of the depreciation:

The depreciation amount is calculated by using the MACRS depreciation table for seven years.

Formula to calculate depreciation:

$Depreciaiton = (Installation cost of an equipment×MACRS rate for the specific year)$

Computation of the depreciation:

$Depreciaiton for year 1 = (Installation cost of an equipment×MACRS rate for year 1)=$17,000,000×14.29%=$2,429,300$

$Depreciaiton for year 2 = (Installation cost of an equipment×MACRS rate for year 2)=$17,000,000×24.29%=$4,163,300$

$Depreciaiton for year 3 = (Installation cost of an equipment×MACRS rate for year 3)=$17,000,000×17.49%=$2,973,300$

$Depreciaiton for year 4 = (Installation cost of an equipment×MACRS rate for year 4)=$17,000,000×12.49%=$2,123,300$

$Depreciaiton for year 5 = (Installation cost of an equipment×MACRS rate for year 5)=$17,000,000×8.93%=$1,518,100$

Formula to calculate the taxes:

$Taxes = EBIT for the specific year×Marginal tax rate$

Computation of the taxes:

$Taxes for year 1 = EBIT for year 1×Marginal tax rate=$5,090,700×35%=$1,781,745$

$Taxes for year 2 = EBIT for year 2×Marginal tax rate=$5,176,700×35%=$1,811,845$

$Taxes for year 3 = EBIT for year 3×Marginal tax rate=$8,316,700×35%=$2,910,845$

$Taxes for year 4 = EBIT for year 4×Marginal tax rate=$8,256,700×35%=$2,889,845$

$Taxes for year 5 = EBIT for year 5×Marginal tax rate=$5,351,900×35%=$1,873,165$

Formula to calculate the net working capital:

$Net working capital = Increases of 15%(Sales for the next year−Sales for the current year)$

Computation of the net working capital:

$NWC for year 1= Increases of 15%(Sales for year 2−Sales for year 1)=.15×($38,710,000−$33,180,000)=.15×$5,530,000=$829,500$

$NWC for year 2= Increases of 15%(Sales for year 3−Sales for year 2)=.15×($44,635,000−$38,710,000)=.15×$5,925,000=$888,750$

$NWC for year 3= Increases of 15%(Sales for year 4−Sales for year 3)=.15×($41,870,000−$44,645,000)=.15×$2,765,000=$414,750$

$NWC for year 4= Increases of 15%(Sales for year 5−Sales for year 4)=.15×($31,205,000−$41,870,000)=.15×$10,665,000=$1,599,750$

Computation of the net working capital for the year 5:

$NWC for year 5 = Recovery of all NWC= Initial NWC – [Change in NWC for year 1 + Change in NWC for Year 2 + Change in NWC for year 3 + Change in NWC for Year 4]$

$=$1,500,000−[−$829,500−$888,750+414,750+$1,599,750]=$1,500,000−$296,250=$1,203,750$

Computation of the ending book value:

$Ending book value = [Installation cost of an equipment−(Depreciation for year 1+Depreciation for year 2+Depreciation for year3+Depreciation for year4+Depreciation for year5)]=$17,000,000($2,429,300+$4,163,300+$2,973,300+$2,123,300+$1,518,100)=$17,000,000−$13,207,300=$3,792,700$

Formula to calculate the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]$

Computation of the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]=$3,400,000+($3,792,700−$3,400,000)×.35=$3,400,000+$137,445=$3,537,445$

Formula to calculate the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)$

Computation of the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)=−$18,500,000+($4,908,755(1.18)1+$6,639,405(1.18)2+$8,793,905(1.18)3+$9,089,905(1.18)4+$9,738,030(1.18)5)=$18,500,000+($4,159,961.86+$4,768,317.29+$5,352,242.07+$4,688,471.86+$4,256,582.66)$

$=$18,500,000+$23,225,575.74=$4,725,575.74$

Hence, the net present value is $4,725,575.74.

Computation of the internal rate of return:

The internal rate of return is calculated by the spreadsheet method.

Step 1:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 1

Type the formulae of the internal rate of return in H6 in the spreadsheet and consider the IRR value as H8

Step 2:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 2

Assume the IRR value as 0.10%

Step 3:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 3

In the spreadsheet go to data and select the what-if analysis.
In what-if analysis select goal seek
In set cell select H6 (the formulae)
The To value is considered as 0
The H8 cell is selected for the by changing cell.

Step 4:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 4

Following the previous step click OK in the goal seek. The goal seek status appears

Step 5:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 5

The IRR value appears to be 27.5164749401034%

Hence, the internal rate of return is 27.52%.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

About this Assignment For this Corporate Finance 301 assignment, you will submit a research paper that analyzes the types of organizational business structures. You will apply knowledge of business structure concepts as acquired in the course. The research paper should follow APA formatting style. Project Prompts The written research paper should be at least 1,000 to 1,200 words in length and should include four sections based on the business structures studied throughout the course. Define each business structure, compare the corporate finance strategies of the four business structures, discuss the advantages and disadvantages of each business structure, and how each varies in taxation. Research Paper Sections ⚫ Sole Proprietorship ⚫ Partnership • Corporation ⚫ Limited Liability Company (LLC)

PLEASE ANSWER THE COLUMN FULLY AND CORRECTLY PLEASE DO THE RIGHT CALCULATION DOUBLE CHECK AS WELL TO GIVE ME THE RIGHT ANSWER REQUIRED: Given the following information, what are the NZD/SGD currency against currency bid-ask quotations? Note: Do not round intermediate calculations. Round your answers to 4 decimal places. Bank Quotations American Terms European Terms Bid Ask Bid Ask New Zealand dollar 0.733 0.7340 1.3870 1.3884 Singapore dollar 0.6186 0.6191 1.6423 1.6436 answer Bid Ask New Zealand dollar ? ? Singapore dollar ? ?

About this Assignment For the Corporate Finance 301 assignment, you will submit a research paper that analyzes and discusses organizational financial risks. You will apply knowledge acquired in the course and use the concepts of multiple financial risks as the basis of research and analysis. The research paper should follow APA formatting style. Audience: upper-level business students. Project Prompt Write a 1,000-1,200-word analysis discussing financial risk concepts and assess the impact of the different financial risks on an organization. For this assignment, you will structure your assignment using four research paper sections associated with corporate risk management, as studied in the course. Base your research paper on the financial statements analyzed in Corporate Finance 301 assignment 2 and apply the knowledge acquired in the analysis. Define each financial risk, discuss the risk associated components, and evaluate the financial risks and how they affect the corporation's…

Answer 2

Question

Chapter 10, Problem 32QP

Summary Introduction

To find: The net present value and the internal rate of return.

Introduction:

The variation between the present value of the cash outflows and the present value of the cash inflows are known as the net present value. In capital budgeting the net present value is utilized to analyze the profitability of a project or investment. The rate of return which equates the initial investment and the present value of net cash inflows are referred to as internal rate of return. This is also called as actual rate of return.

Expert Solution & Answer

Answer to Problem 32QP

The net present value is $4,725,575.74 and the internal rate of return is 27.52%.

Explanation of Solution

Given information:

Company A projects the unit sale for the new 7 octave voice emulation implant as follows:

The year 1 unit sales is 84,000
The year 2 unit sales is 98,000
The year 3 unit sales is 113,000
The year 4 unit sales is 106,000
The year 5 unit sales is 79,000

The production implant needs $1,500,000 in the net working capital to begin their production activities. The extra net working capital investment for every year is equivalent to the 15% of the sales that is projected has to rise for the following year. The total fixed cost is $3,400,000 for a year, the unit price is $395, and the variable production cost is $265. The installation cost of the equipment is $17,000,000.

The equipment is qualified in the 7 Year MACRS depreciation under the property class. In 5 years the equipment sale can be sold for 20% of its acquisition cost. The marginal tax bracket is 35 percent and has the required rate of return which is 18%.

MACRS depreciation table for year 7:

MACRS Depreciation table for seven year
Year	Seven year
1	14.29%
2	24.49%
3	17.49%
4	12.49%
5	8.93%
6	8.92%
7	8.93%
8	4.46%

Computation of the net present value:

Computation of the cash outflow:

$Cash outflow = (−Capital spending(Installed cost)+−Initial net working capital)=(−$17,000,000)+(−$1,500,000)=−$18,500,000$

Table showing the cash inflows:

Year	1	2	3	4	5
Ending book value	$14,570,700	$10,407,400	$7,434,100	$5,310,800	$3,792,700
Sales	$33,180,000	$38,710,000	$44,635,000	$41,870,000	$31,205,000
Less: Variable costs	-$22,260,000	-$25,970,000	-$29,945,000	-$28,090,000	-$20,935,000
Fixed costs	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000
Depreciation	-$2,429,300	-$4,163,300	-$2,973,300	-$2,123,300	-$1,518,100
EBIT	$5,090,700	$5,176,700	$8,316,700	$8,256,700	$5,351,900
Less: Taxes	-$1,781,745	-$1,811,845	-$2,910,845	-$2,889,845	-$1,873,165
Net income	$3,308,955	$3,364,855	$5,405,855	$5,366,855	$3,478,735
Add: Depreciation	$2,429,300	$4,163,300	$2,973,300	$2,123,300	$1,518,100
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835

Net cash inflows:
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835
Change in net working capital	–829,500	–888,750	$414,750	$1,599,750	$1,203,750
Capital spending	$0	$0	$0	$0	$3,537,445
Total cash inflows	$4,908,755	$6,639,405	$8,793,905	$9,089,905	$9,738,030

Computations for the above table:

Formula to calculate the ending book value:

$Ending book value = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]$

Computation of the ending book value for year 1:

$Ending book value for year 3 = [ Ending book value of an equipment for year 2−(Initial cost of an equipment×MACRS rate )]=$10,407,400−($17,000,000×17.49%)=$10,407,400−$2,973,300=$7,434,100$

$Ending book value for year 1 = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]=$17,000,000−($17,000,000×14.29%)=$17,000,000−$2,429,300=$14,570,700$

$Ending book value for year 2 = [ Ending book value of an equipment for year 1−(Initial cost of an equipment×MACRS rate )]=$14,570,700−($17,000,000×24.49%)=$14,570,700−$4,163,300=$10,407,400$

$Ending book value for year 4 = [ Ending book value of an equipment for year 3−(Initial cost of an equipment×MACRS rate )]=$7,434,100−($17,000,000×12.49%)=$7,434,100−$2,123,300=$5,310,800$

$Ending book value for year 5 = [ Ending book value of an equipment for year 4−(Initial cost of an equipment×MACRS rate )]=$5,310,800−($17,000,000×8.93%)=$5,310,800−$1,518,100=$3,792,700$

Formula to calculate the sales:

$Sales = Unit sales×Price per unit$

Computation of the sales:

$Sales for year 1 = Unit sales for year 1×Price per unit=$84,000×$395=$33,180,000$

$Sales for year 2 = Unit sales for year 2×Price per unit=$98,000×$395=$38,710,000$

$Sales for year 3 = Unit sales for year 3×Price per unit=$113,000×$395=$44,635,000$

$Sales for year 4 = Unit sales for year 4×Price per unit=$106,000×$395=$41,870,000$

$Sales for year 5 = Unit sales for year 5×Price per unit=$79,000×$395=$31,205,000$

Computation of the depreciation:

The depreciation amount is calculated by using the MACRS depreciation table for seven years.

Formula to calculate depreciation:

$Depreciaiton = (Installation cost of an equipment×MACRS rate for the specific year)$

Computation of the depreciation:

$Depreciaiton for year 1 = (Installation cost of an equipment×MACRS rate for year 1)=$17,000,000×14.29%=$2,429,300$

$Depreciaiton for year 2 = (Installation cost of an equipment×MACRS rate for year 2)=$17,000,000×24.29%=$4,163,300$

$Depreciaiton for year 3 = (Installation cost of an equipment×MACRS rate for year 3)=$17,000,000×17.49%=$2,973,300$

$Depreciaiton for year 4 = (Installation cost of an equipment×MACRS rate for year 4)=$17,000,000×12.49%=$2,123,300$

$Depreciaiton for year 5 = (Installation cost of an equipment×MACRS rate for year 5)=$17,000,000×8.93%=$1,518,100$

Formula to calculate the taxes:

$Taxes = EBIT for the specific year×Marginal tax rate$

Computation of the taxes:

$Taxes for year 1 = EBIT for year 1×Marginal tax rate=$5,090,700×35%=$1,781,745$

$Taxes for year 2 = EBIT for year 2×Marginal tax rate=$5,176,700×35%=$1,811,845$

$Taxes for year 3 = EBIT for year 3×Marginal tax rate=$8,316,700×35%=$2,910,845$

$Taxes for year 4 = EBIT for year 4×Marginal tax rate=$8,256,700×35%=$2,889,845$

$Taxes for year 5 = EBIT for year 5×Marginal tax rate=$5,351,900×35%=$1,873,165$

Formula to calculate the net working capital:

$Net working capital = Increases of 15%(Sales for the next year−Sales for the current year)$

Computation of the net working capital:

$NWC for year 1= Increases of 15%(Sales for year 2−Sales for year 1)=.15×($38,710,000−$33,180,000)=.15×$5,530,000=$829,500$

$NWC for year 2= Increases of 15%(Sales for year 3−Sales for year 2)=.15×($44,635,000−$38,710,000)=.15×$5,925,000=$888,750$

$NWC for year 3= Increases of 15%(Sales for year 4−Sales for year 3)=.15×($41,870,000−$44,645,000)=.15×$2,765,000=$414,750$

$NWC for year 4= Increases of 15%(Sales for year 5−Sales for year 4)=.15×($31,205,000−$41,870,000)=.15×$10,665,000=$1,599,750$

Computation of the net working capital for the year 5:

$NWC for year 5 = Recovery of all NWC= Initial NWC – [Change in NWC for year 1 + Change in NWC for Year 2 + Change in NWC for year 3 + Change in NWC for Year 4]$

$=$1,500,000−[−$829,500−$888,750+414,750+$1,599,750]=$1,500,000−$296,250=$1,203,750$

Computation of the ending book value:

$Ending book value = [Installation cost of an equipment−(Depreciation for year 1+Depreciation for year 2+Depreciation for year3+Depreciation for year4+Depreciation for year5)]=$17,000,000($2,429,300+$4,163,300+$2,973,300+$2,123,300+$1,518,100)=$17,000,000−$13,207,300=$3,792,700$

Formula to calculate the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]$

Computation of the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]=$3,400,000+($3,792,700−$3,400,000)×.35=$3,400,000+$137,445=$3,537,445$

Formula to calculate the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)$

Computation of the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)=−$18,500,000+($4,908,755(1.18)1+$6,639,405(1.18)2+$8,793,905(1.18)3+$9,089,905(1.18)4+$9,738,030(1.18)5)=$18,500,000+($4,159,961.86+$4,768,317.29+$5,352,242.07+$4,688,471.86+$4,256,582.66)$

$=$18,500,000+$23,225,575.74=$4,725,575.74$

Hence, the net present value is $4,725,575.74.

Computation of the internal rate of return:

The internal rate of return is calculated by the spreadsheet method.

Step 1:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 1

Type the formulae of the internal rate of return in H6 in the spreadsheet and consider the IRR value as H8

Step 2:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 2

Assume the IRR value as 0.10%

Step 3:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 3

In the spreadsheet go to data and select the what-if analysis.
In what-if analysis select goal seek
In set cell select H6 (the formulae)
The To value is considered as 0
The H8 cell is selected for the by changing cell.

Step 4:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 4

Following the previous step click OK in the goal seek. The goal seek status appears

Step 5:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 5

The IRR value appears to be 27.5164749401034%

Hence, the internal rate of return is 27.52%.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Question

Chapter 10, Problem 32QP

Summary Introduction

To find: The net present value and the internal rate of return.

Introduction:

The variation between the present value of the cash outflows and the present value of the cash inflows are known as the net present value. In capital budgeting the net present value is utilized to analyze the profitability of a project or investment. The rate of return which equates the initial investment and the present value of net cash inflows are referred to as internal rate of return. This is also called as actual rate of return.

Expert Solution & Answer

Answer to Problem 32QP

The net present value is $4,725,575.74 and the internal rate of return is 27.52%.

Explanation of Solution

Given information:

Company A projects the unit sale for the new 7 octave voice emulation implant as follows:

The year 1 unit sales is 84,000
The year 2 unit sales is 98,000
The year 3 unit sales is 113,000
The year 4 unit sales is 106,000
The year 5 unit sales is 79,000

The production implant needs $1,500,000 in the net working capital to begin their production activities. The extra net working capital investment for every year is equivalent to the 15% of the sales that is projected has to rise for the following year. The total fixed cost is $3,400,000 for a year, the unit price is $395, and the variable production cost is $265. The installation cost of the equipment is $17,000,000.

The equipment is qualified in the 7 Year MACRS depreciation under the property class. In 5 years the equipment sale can be sold for 20% of its acquisition cost. The marginal tax bracket is 35 percent and has the required rate of return which is 18%.

MACRS depreciation table for year 7:

MACRS Depreciation table for seven year
Year	Seven year
1	14.29%
2	24.49%
3	17.49%
4	12.49%
5	8.93%
6	8.92%
7	8.93%
8	4.46%

Computation of the net present value:

Computation of the cash outflow:

$Cash outflow = (−Capital spending(Installed cost)+−Initial net working capital)=(−$17,000,000)+(−$1,500,000)=−$18,500,000$

Table showing the cash inflows:

Year	1	2	3	4	5
Ending book value	$14,570,700	$10,407,400	$7,434,100	$5,310,800	$3,792,700
Sales	$33,180,000	$38,710,000	$44,635,000	$41,870,000	$31,205,000
Less: Variable costs	-$22,260,000	-$25,970,000	-$29,945,000	-$28,090,000	-$20,935,000
Fixed costs	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000
Depreciation	-$2,429,300	-$4,163,300	-$2,973,300	-$2,123,300	-$1,518,100
EBIT	$5,090,700	$5,176,700	$8,316,700	$8,256,700	$5,351,900
Less: Taxes	-$1,781,745	-$1,811,845	-$2,910,845	-$2,889,845	-$1,873,165
Net income	$3,308,955	$3,364,855	$5,405,855	$5,366,855	$3,478,735
Add: Depreciation	$2,429,300	$4,163,300	$2,973,300	$2,123,300	$1,518,100
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835

Net cash inflows:
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835
Change in net working capital	–829,500	–888,750	$414,750	$1,599,750	$1,203,750
Capital spending	$0	$0	$0	$0	$3,537,445
Total cash inflows	$4,908,755	$6,639,405	$8,793,905	$9,089,905	$9,738,030

Computations for the above table:

Formula to calculate the ending book value:

$Ending book value = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]$

Computation of the ending book value for year 1:

$Ending book value for year 3 = [ Ending book value of an equipment for year 2−(Initial cost of an equipment×MACRS rate )]=$10,407,400−($17,000,000×17.49%)=$10,407,400−$2,973,300=$7,434,100$

$Ending book value for year 1 = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]=$17,000,000−($17,000,000×14.29%)=$17,000,000−$2,429,300=$14,570,700$

$Ending book value for year 2 = [ Ending book value of an equipment for year 1−(Initial cost of an equipment×MACRS rate )]=$14,570,700−($17,000,000×24.49%)=$14,570,700−$4,163,300=$10,407,400$

$Ending book value for year 4 = [ Ending book value of an equipment for year 3−(Initial cost of an equipment×MACRS rate )]=$7,434,100−($17,000,000×12.49%)=$7,434,100−$2,123,300=$5,310,800$

$Ending book value for year 5 = [ Ending book value of an equipment for year 4−(Initial cost of an equipment×MACRS rate )]=$5,310,800−($17,000,000×8.93%)=$5,310,800−$1,518,100=$3,792,700$

Formula to calculate the sales:

$Sales = Unit sales×Price per unit$

Computation of the sales:

$Sales for year 1 = Unit sales for year 1×Price per unit=$84,000×$395=$33,180,000$

$Sales for year 2 = Unit sales for year 2×Price per unit=$98,000×$395=$38,710,000$

$Sales for year 3 = Unit sales for year 3×Price per unit=$113,000×$395=$44,635,000$

$Sales for year 4 = Unit sales for year 4×Price per unit=$106,000×$395=$41,870,000$

$Sales for year 5 = Unit sales for year 5×Price per unit=$79,000×$395=$31,205,000$

Computation of the depreciation:

The depreciation amount is calculated by using the MACRS depreciation table for seven years.

Formula to calculate depreciation:

$Depreciaiton = (Installation cost of an equipment×MACRS rate for the specific year)$

Computation of the depreciation:

$Depreciaiton for year 1 = (Installation cost of an equipment×MACRS rate for year 1)=$17,000,000×14.29%=$2,429,300$

$Depreciaiton for year 2 = (Installation cost of an equipment×MACRS rate for year 2)=$17,000,000×24.29%=$4,163,300$

$Depreciaiton for year 3 = (Installation cost of an equipment×MACRS rate for year 3)=$17,000,000×17.49%=$2,973,300$

$Depreciaiton for year 4 = (Installation cost of an equipment×MACRS rate for year 4)=$17,000,000×12.49%=$2,123,300$

$Depreciaiton for year 5 = (Installation cost of an equipment×MACRS rate for year 5)=$17,000,000×8.93%=$1,518,100$

Formula to calculate the taxes:

$Taxes = EBIT for the specific year×Marginal tax rate$

Computation of the taxes:

$Taxes for year 1 = EBIT for year 1×Marginal tax rate=$5,090,700×35%=$1,781,745$

$Taxes for year 2 = EBIT for year 2×Marginal tax rate=$5,176,700×35%=$1,811,845$

$Taxes for year 3 = EBIT for year 3×Marginal tax rate=$8,316,700×35%=$2,910,845$

$Taxes for year 4 = EBIT for year 4×Marginal tax rate=$8,256,700×35%=$2,889,845$

$Taxes for year 5 = EBIT for year 5×Marginal tax rate=$5,351,900×35%=$1,873,165$

Formula to calculate the net working capital:

$Net working capital = Increases of 15%(Sales for the next year−Sales for the current year)$

Computation of the net working capital:

$NWC for year 1= Increases of 15%(Sales for year 2−Sales for year 1)=.15×($38,710,000−$33,180,000)=.15×$5,530,000=$829,500$

$NWC for year 2= Increases of 15%(Sales for year 3−Sales for year 2)=.15×($44,635,000−$38,710,000)=.15×$5,925,000=$888,750$

$NWC for year 3= Increases of 15%(Sales for year 4−Sales for year 3)=.15×($41,870,000−$44,645,000)=.15×$2,765,000=$414,750$

$NWC for year 4= Increases of 15%(Sales for year 5−Sales for year 4)=.15×($31,205,000−$41,870,000)=.15×$10,665,000=$1,599,750$

Computation of the net working capital for the year 5:

$NWC for year 5 = Recovery of all NWC= Initial NWC – [Change in NWC for year 1 + Change in NWC for Year 2 + Change in NWC for year 3 + Change in NWC for Year 4]$

$=$1,500,000−[−$829,500−$888,750+414,750+$1,599,750]=$1,500,000−$296,250=$1,203,750$

Computation of the ending book value:

$Ending book value = [Installation cost of an equipment−(Depreciation for year 1+Depreciation for year 2+Depreciation for year3+Depreciation for year4+Depreciation for year5)]=$17,000,000($2,429,300+$4,163,300+$2,973,300+$2,123,300+$1,518,100)=$17,000,000−$13,207,300=$3,792,700$

Formula to calculate the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]$

Computation of the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]=$3,400,000+($3,792,700−$3,400,000)×.35=$3,400,000+$137,445=$3,537,445$

Formula to calculate the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)$

Computation of the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)=−$18,500,000+($4,908,755(1.18)1+$6,639,405(1.18)2+$8,793,905(1.18)3+$9,089,905(1.18)4+$9,738,030(1.18)5)=$18,500,000+($4,159,961.86+$4,768,317.29+$5,352,242.07+$4,688,471.86+$4,256,582.66)$

$=$18,500,000+$23,225,575.74=$4,725,575.74$

Hence, the net present value is $4,725,575.74.

Computation of the internal rate of return:

The internal rate of return is calculated by the spreadsheet method.

Step 1:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 1

Type the formulae of the internal rate of return in H6 in the spreadsheet and consider the IRR value as H8

Step 2:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 2

Assume the IRR value as 0.10%

Step 3:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 3

In the spreadsheet go to data and select the what-if analysis.
In what-if analysis select goal seek
In set cell select H6 (the formulae)
The To value is considered as 0
The H8 cell is selected for the by changing cell.

Step 4:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 4

Following the previous step click OK in the goal seek. The goal seek status appears

Step 5:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 5

The IRR value appears to be 27.5164749401034%

Hence, the internal rate of return is 27.52%.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Question

Chapter 10, Problem 32QP

Summary Introduction

To find: The net present value and the internal rate of return.

Introduction:

The variation between the present value of the cash outflows and the present value of the cash inflows are known as the net present value. In capital budgeting the net present value is utilized to analyze the profitability of a project or investment. The rate of return which equates the initial investment and the present value of net cash inflows are referred to as internal rate of return. This is also called as actual rate of return.

Expert Solution & Answer

Answer to Problem 32QP

The net present value is $4,725,575.74 and the internal rate of return is 27.52%.

Explanation of Solution

Given information:

Company A projects the unit sale for the new 7 octave voice emulation implant as follows:

The year 1 unit sales is 84,000
The year 2 unit sales is 98,000
The year 3 unit sales is 113,000
The year 4 unit sales is 106,000
The year 5 unit sales is 79,000

The production implant needs $1,500,000 in the net working capital to begin their production activities. The extra net working capital investment for every year is equivalent to the 15% of the sales that is projected has to rise for the following year. The total fixed cost is $3,400,000 for a year, the unit price is $395, and the variable production cost is $265. The installation cost of the equipment is $17,000,000.

The equipment is qualified in the 7 Year MACRS depreciation under the property class. In 5 years the equipment sale can be sold for 20% of its acquisition cost. The marginal tax bracket is 35 percent and has the required rate of return which is 18%.

MACRS depreciation table for year 7:

MACRS Depreciation table for seven year
Year	Seven year
1	14.29%
2	24.49%
3	17.49%
4	12.49%
5	8.93%
6	8.92%
7	8.93%
8	4.46%

Computation of the net present value:

Computation of the cash outflow:

$Cash outflow = (−Capital spending(Installed cost)+−Initial net working capital)=(−$17,000,000)+(−$1,500,000)=−$18,500,000$

Table showing the cash inflows:

Year	1	2	3	4	5
Ending book value	$14,570,700	$10,407,400	$7,434,100	$5,310,800	$3,792,700
Sales	$33,180,000	$38,710,000	$44,635,000	$41,870,000	$31,205,000
Less: Variable costs	-$22,260,000	-$25,970,000	-$29,945,000	-$28,090,000	-$20,935,000
Fixed costs	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000
Depreciation	-$2,429,300	-$4,163,300	-$2,973,300	-$2,123,300	-$1,518,100
EBIT	$5,090,700	$5,176,700	$8,316,700	$8,256,700	$5,351,900
Less: Taxes	-$1,781,745	-$1,811,845	-$2,910,845	-$2,889,845	-$1,873,165
Net income	$3,308,955	$3,364,855	$5,405,855	$5,366,855	$3,478,735
Add: Depreciation	$2,429,300	$4,163,300	$2,973,300	$2,123,300	$1,518,100
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835

Net cash inflows:
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835
Change in net working capital	–829,500	–888,750	$414,750	$1,599,750	$1,203,750
Capital spending	$0	$0	$0	$0	$3,537,445
Total cash inflows	$4,908,755	$6,639,405	$8,793,905	$9,089,905	$9,738,030

Computations for the above table:

Formula to calculate the ending book value:

$Ending book value = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]$

Computation of the ending book value for year 1:

$Ending book value for year 3 = [ Ending book value of an equipment for year 2−(Initial cost of an equipment×MACRS rate )]=$10,407,400−($17,000,000×17.49%)=$10,407,400−$2,973,300=$7,434,100$

$Ending book value for year 1 = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]=$17,000,000−($17,000,000×14.29%)=$17,000,000−$2,429,300=$14,570,700$

$Ending book value for year 2 = [ Ending book value of an equipment for year 1−(Initial cost of an equipment×MACRS rate )]=$14,570,700−($17,000,000×24.49%)=$14,570,700−$4,163,300=$10,407,400$

$Ending book value for year 4 = [ Ending book value of an equipment for year 3−(Initial cost of an equipment×MACRS rate )]=$7,434,100−($17,000,000×12.49%)=$7,434,100−$2,123,300=$5,310,800$

$Ending book value for year 5 = [ Ending book value of an equipment for year 4−(Initial cost of an equipment×MACRS rate )]=$5,310,800−($17,000,000×8.93%)=$5,310,800−$1,518,100=$3,792,700$

Formula to calculate the sales:

$Sales = Unit sales×Price per unit$

Computation of the sales:

$Sales for year 1 = Unit sales for year 1×Price per unit=$84,000×$395=$33,180,000$

$Sales for year 2 = Unit sales for year 2×Price per unit=$98,000×$395=$38,710,000$

$Sales for year 3 = Unit sales for year 3×Price per unit=$113,000×$395=$44,635,000$

$Sales for year 4 = Unit sales for year 4×Price per unit=$106,000×$395=$41,870,000$

$Sales for year 5 = Unit sales for year 5×Price per unit=$79,000×$395=$31,205,000$

Computation of the depreciation:

The depreciation amount is calculated by using the MACRS depreciation table for seven years.

Formula to calculate depreciation:

$Depreciaiton = (Installation cost of an equipment×MACRS rate for the specific year)$

Computation of the depreciation:

$Depreciaiton for year 1 = (Installation cost of an equipment×MACRS rate for year 1)=$17,000,000×14.29%=$2,429,300$

$Depreciaiton for year 2 = (Installation cost of an equipment×MACRS rate for year 2)=$17,000,000×24.29%=$4,163,300$

$Depreciaiton for year 3 = (Installation cost of an equipment×MACRS rate for year 3)=$17,000,000×17.49%=$2,973,300$

$Depreciaiton for year 4 = (Installation cost of an equipment×MACRS rate for year 4)=$17,000,000×12.49%=$2,123,300$

$Depreciaiton for year 5 = (Installation cost of an equipment×MACRS rate for year 5)=$17,000,000×8.93%=$1,518,100$

Formula to calculate the taxes:

$Taxes = EBIT for the specific year×Marginal tax rate$

Computation of the taxes:

$Taxes for year 1 = EBIT for year 1×Marginal tax rate=$5,090,700×35%=$1,781,745$

$Taxes for year 2 = EBIT for year 2×Marginal tax rate=$5,176,700×35%=$1,811,845$

$Taxes for year 3 = EBIT for year 3×Marginal tax rate=$8,316,700×35%=$2,910,845$

$Taxes for year 4 = EBIT for year 4×Marginal tax rate=$8,256,700×35%=$2,889,845$

$Taxes for year 5 = EBIT for year 5×Marginal tax rate=$5,351,900×35%=$1,873,165$

Formula to calculate the net working capital:

$Net working capital = Increases of 15%(Sales for the next year−Sales for the current year)$

Computation of the net working capital:

$NWC for year 1= Increases of 15%(Sales for year 2−Sales for year 1)=.15×($38,710,000−$33,180,000)=.15×$5,530,000=$829,500$

$NWC for year 2= Increases of 15%(Sales for year 3−Sales for year 2)=.15×($44,635,000−$38,710,000)=.15×$5,925,000=$888,750$

$NWC for year 3= Increases of 15%(Sales for year 4−Sales for year 3)=.15×($41,870,000−$44,645,000)=.15×$2,765,000=$414,750$

$NWC for year 4= Increases of 15%(Sales for year 5−Sales for year 4)=.15×($31,205,000−$41,870,000)=.15×$10,665,000=$1,599,750$

Computation of the net working capital for the year 5:

$NWC for year 5 = Recovery of all NWC= Initial NWC – [Change in NWC for year 1 + Change in NWC for Year 2 + Change in NWC for year 3 + Change in NWC for Year 4]$

$=$1,500,000−[−$829,500−$888,750+414,750+$1,599,750]=$1,500,000−$296,250=$1,203,750$

Computation of the ending book value:

$Ending book value = [Installation cost of an equipment−(Depreciation for year 1+Depreciation for year 2+Depreciation for year3+Depreciation for year4+Depreciation for year5)]=$17,000,000($2,429,300+$4,163,300+$2,973,300+$2,123,300+$1,518,100)=$17,000,000−$13,207,300=$3,792,700$

Formula to calculate the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]$

Computation of the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]=$3,400,000+($3,792,700−$3,400,000)×.35=$3,400,000+$137,445=$3,537,445$

Formula to calculate the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)$

Computation of the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)=−$18,500,000+($4,908,755(1.18)1+$6,639,405(1.18)2+$8,793,905(1.18)3+$9,089,905(1.18)4+$9,738,030(1.18)5)=$18,500,000+($4,159,961.86+$4,768,317.29+$5,352,242.07+$4,688,471.86+$4,256,582.66)$

$=$18,500,000+$23,225,575.74=$4,725,575.74$

Hence, the net present value is $4,725,575.74.

Computation of the internal rate of return:

The internal rate of return is calculated by the spreadsheet method.

Step 1:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 1

Type the formulae of the internal rate of return in H6 in the spreadsheet and consider the IRR value as H8

Step 2:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 2

Assume the IRR value as 0.10%

Step 3:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 3

In the spreadsheet go to data and select the what-if analysis.
In what-if analysis select goal seek
In set cell select H6 (the formulae)
The To value is considered as 0
The H8 cell is selected for the by changing cell.

Step 4:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 4

Following the previous step click OK in the goal seek. The goal seek status appears

Step 5:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 5

The IRR value appears to be 27.5164749401034%

Hence, the internal rate of return is 27.52%.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Chapter 10, Problem 32QP

Summary Introduction

To find: The net present value and the internal rate of return.

Introduction:

The variation between the present value of the cash outflows and the present value of the cash inflows are known as the net present value. In capital budgeting the net present value is utilized to analyze the profitability of a project or investment. The rate of return which equates the initial investment and the present value of net cash inflows are referred to as internal rate of return. This is also called as actual rate of return.

Expert Solution & Answer

Answer to Problem 32QP

The net present value is $4,725,575.74 and the internal rate of return is 27.52%.

Explanation of Solution

Given information:

Company A projects the unit sale for the new 7 octave voice emulation implant as follows:

The year 1 unit sales is 84,000
The year 2 unit sales is 98,000
The year 3 unit sales is 113,000
The year 4 unit sales is 106,000
The year 5 unit sales is 79,000

The production implant needs $1,500,000 in the net working capital to begin their production activities. The extra net working capital investment for every year is equivalent to the 15% of the sales that is projected has to rise for the following year. The total fixed cost is $3,400,000 for a year, the unit price is $395, and the variable production cost is $265. The installation cost of the equipment is $17,000,000.

The equipment is qualified in the 7 Year MACRS depreciation under the property class. In 5 years the equipment sale can be sold for 20% of its acquisition cost. The marginal tax bracket is 35 percent and has the required rate of return which is 18%.

MACRS depreciation table for year 7:

MACRS Depreciation table for seven year
Year	Seven year
1	14.29%
2	24.49%
3	17.49%
4	12.49%
5	8.93%
6	8.92%
7	8.93%
8	4.46%

Computation of the net present value:

Computation of the cash outflow:

$Cash outflow = (−Capital spending(Installed cost)+−Initial net working capital)=(−$17,000,000)+(−$1,500,000)=−$18,500,000$

Table showing the cash inflows:

Year	1	2	3	4	5
Ending book value	$14,570,700	$10,407,400	$7,434,100	$5,310,800	$3,792,700
Sales	$33,180,000	$38,710,000	$44,635,000	$41,870,000	$31,205,000
Less: Variable costs	-$22,260,000	-$25,970,000	-$29,945,000	-$28,090,000	-$20,935,000
Fixed costs	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000
Depreciation	-$2,429,300	-$4,163,300	-$2,973,300	-$2,123,300	-$1,518,100
EBIT	$5,090,700	$5,176,700	$8,316,700	$8,256,700	$5,351,900
Less: Taxes	-$1,781,745	-$1,811,845	-$2,910,845	-$2,889,845	-$1,873,165
Net income	$3,308,955	$3,364,855	$5,405,855	$5,366,855	$3,478,735
Add: Depreciation	$2,429,300	$4,163,300	$2,973,300	$2,123,300	$1,518,100
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835

Net cash inflows:
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835
Change in net working capital	–829,500	–888,750	$414,750	$1,599,750	$1,203,750
Capital spending	$0	$0	$0	$0	$3,537,445
Total cash inflows	$4,908,755	$6,639,405	$8,793,905	$9,089,905	$9,738,030

Computations for the above table:

Formula to calculate the ending book value:

$Ending book value = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]$

Computation of the ending book value for year 1:

$Ending book value for year 3 = [ Ending book value of an equipment for year 2−(Initial cost of an equipment×MACRS rate )]=$10,407,400−($17,000,000×17.49%)=$10,407,400−$2,973,300=$7,434,100$

$Ending book value for year 1 = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]=$17,000,000−($17,000,000×14.29%)=$17,000,000−$2,429,300=$14,570,700$

$Ending book value for year 2 = [ Ending book value of an equipment for year 1−(Initial cost of an equipment×MACRS rate )]=$14,570,700−($17,000,000×24.49%)=$14,570,700−$4,163,300=$10,407,400$

$Ending book value for year 4 = [ Ending book value of an equipment for year 3−(Initial cost of an equipment×MACRS rate )]=$7,434,100−($17,000,000×12.49%)=$7,434,100−$2,123,300=$5,310,800$

$Ending book value for year 5 = [ Ending book value of an equipment for year 4−(Initial cost of an equipment×MACRS rate )]=$5,310,800−($17,000,000×8.93%)=$5,310,800−$1,518,100=$3,792,700$

Formula to calculate the sales:

$Sales = Unit sales×Price per unit$

Computation of the sales:

$Sales for year 1 = Unit sales for year 1×Price per unit=$84,000×$395=$33,180,000$

$Sales for year 2 = Unit sales for year 2×Price per unit=$98,000×$395=$38,710,000$

$Sales for year 3 = Unit sales for year 3×Price per unit=$113,000×$395=$44,635,000$

$Sales for year 4 = Unit sales for year 4×Price per unit=$106,000×$395=$41,870,000$

$Sales for year 5 = Unit sales for year 5×Price per unit=$79,000×$395=$31,205,000$

Computation of the depreciation:

The depreciation amount is calculated by using the MACRS depreciation table for seven years.

Formula to calculate depreciation:

$Depreciaiton = (Installation cost of an equipment×MACRS rate for the specific year)$

Computation of the depreciation:

$Depreciaiton for year 1 = (Installation cost of an equipment×MACRS rate for year 1)=$17,000,000×14.29%=$2,429,300$

$Depreciaiton for year 2 = (Installation cost of an equipment×MACRS rate for year 2)=$17,000,000×24.29%=$4,163,300$

$Depreciaiton for year 3 = (Installation cost of an equipment×MACRS rate for year 3)=$17,000,000×17.49%=$2,973,300$

$Depreciaiton for year 4 = (Installation cost of an equipment×MACRS rate for year 4)=$17,000,000×12.49%=$2,123,300$

$Depreciaiton for year 5 = (Installation cost of an equipment×MACRS rate for year 5)=$17,000,000×8.93%=$1,518,100$

Formula to calculate the taxes:

$Taxes = EBIT for the specific year×Marginal tax rate$

Computation of the taxes:

$Taxes for year 1 = EBIT for year 1×Marginal tax rate=$5,090,700×35%=$1,781,745$

$Taxes for year 2 = EBIT for year 2×Marginal tax rate=$5,176,700×35%=$1,811,845$

$Taxes for year 3 = EBIT for year 3×Marginal tax rate=$8,316,700×35%=$2,910,845$

$Taxes for year 4 = EBIT for year 4×Marginal tax rate=$8,256,700×35%=$2,889,845$

$Taxes for year 5 = EBIT for year 5×Marginal tax rate=$5,351,900×35%=$1,873,165$

Formula to calculate the net working capital:

$Net working capital = Increases of 15%(Sales for the next year−Sales for the current year)$

Computation of the net working capital:

$NWC for year 1= Increases of 15%(Sales for year 2−Sales for year 1)=.15×($38,710,000−$33,180,000)=.15×$5,530,000=$829,500$

$NWC for year 2= Increases of 15%(Sales for year 3−Sales for year 2)=.15×($44,635,000−$38,710,000)=.15×$5,925,000=$888,750$

$NWC for year 3= Increases of 15%(Sales for year 4−Sales for year 3)=.15×($41,870,000−$44,645,000)=.15×$2,765,000=$414,750$

$NWC for year 4= Increases of 15%(Sales for year 5−Sales for year 4)=.15×($31,205,000−$41,870,000)=.15×$10,665,000=$1,599,750$

Computation of the net working capital for the year 5:

$NWC for year 5 = Recovery of all NWC= Initial NWC – [Change in NWC for year 1 + Change in NWC for Year 2 + Change in NWC for year 3 + Change in NWC for Year 4]$

$=$1,500,000−[−$829,500−$888,750+414,750+$1,599,750]=$1,500,000−$296,250=$1,203,750$

Computation of the ending book value:

$Ending book value = [Installation cost of an equipment−(Depreciation for year 1+Depreciation for year 2+Depreciation for year3+Depreciation for year4+Depreciation for year5)]=$17,000,000($2,429,300+$4,163,300+$2,973,300+$2,123,300+$1,518,100)=$17,000,000−$13,207,300=$3,792,700$

Formula to calculate the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]$

Computation of the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]=$3,400,000+($3,792,700−$3,400,000)×.35=$3,400,000+$137,445=$3,537,445$

Formula to calculate the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)$

Computation of the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)=−$18,500,000+($4,908,755(1.18)1+$6,639,405(1.18)2+$8,793,905(1.18)3+$9,089,905(1.18)4+$9,738,030(1.18)5)=$18,500,000+($4,159,961.86+$4,768,317.29+$5,352,242.07+$4,688,471.86+$4,256,582.66)$

$=$18,500,000+$23,225,575.74=$4,725,575.74$

Hence, the net present value is $4,725,575.74.

Computation of the internal rate of return:

The internal rate of return is calculated by the spreadsheet method.

Step 1:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 1

Type the formulae of the internal rate of return in H6 in the spreadsheet and consider the IRR value as H8

Step 2:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 2

Assume the IRR value as 0.10%

Step 3:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 3

In the spreadsheet go to data and select the what-if analysis.
In what-if analysis select goal seek
In set cell select H6 (the formulae)
The To value is considered as 0
The H8 cell is selected for the by changing cell.

Step 4:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 4

Following the previous step click OK in the goal seek. The goal seek status appears

Step 5:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 5

The IRR value appears to be 27.5164749401034%

Hence, the internal rate of return is 27.52%.

Answer 6

Chapter 10, Problem 32QP

Summary Introduction

To find: The net present value and the internal rate of return.

Introduction:

The variation between the present value of the cash outflows and the present value of the cash inflows are known as the net present value. In capital budgeting the net present value is utilized to analyze the profitability of a project or investment. The rate of return which equates the initial investment and the present value of net cash inflows are referred to as internal rate of return. This is also called as actual rate of return.

Expert Solution & Answer

Answer to Problem 32QP

The net present value is $4,725,575.74 and the internal rate of return is 27.52%.

Explanation of Solution

Given information:

Company A projects the unit sale for the new 7 octave voice emulation implant as follows:

The year 1 unit sales is 84,000
The year 2 unit sales is 98,000
The year 3 unit sales is 113,000
The year 4 unit sales is 106,000
The year 5 unit sales is 79,000

The production implant needs $1,500,000 in the net working capital to begin their production activities. The extra net working capital investment for every year is equivalent to the 15% of the sales that is projected has to rise for the following year. The total fixed cost is $3,400,000 for a year, the unit price is $395, and the variable production cost is $265. The installation cost of the equipment is $17,000,000.

The equipment is qualified in the 7 Year MACRS depreciation under the property class. In 5 years the equipment sale can be sold for 20% of its acquisition cost. The marginal tax bracket is 35 percent and has the required rate of return which is 18%.

MACRS depreciation table for year 7:

MACRS Depreciation table for seven year
Year	Seven year
1	14.29%
2	24.49%
3	17.49%
4	12.49%
5	8.93%
6	8.92%
7	8.93%
8	4.46%

Computation of the net present value:

Computation of the cash outflow:

$Cash outflow = (−Capital spending(Installed cost)+−Initial net working capital)=(−$17,000,000)+(−$1,500,000)=−$18,500,000$

Table showing the cash inflows:

Year	1	2	3	4	5
Ending book value	$14,570,700	$10,407,400	$7,434,100	$5,310,800	$3,792,700
Sales	$33,180,000	$38,710,000	$44,635,000	$41,870,000	$31,205,000
Less: Variable costs	-$22,260,000	-$25,970,000	-$29,945,000	-$28,090,000	-$20,935,000
Fixed costs	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000
Depreciation	-$2,429,300	-$4,163,300	-$2,973,300	-$2,123,300	-$1,518,100
EBIT	$5,090,700	$5,176,700	$8,316,700	$8,256,700	$5,351,900
Less: Taxes	-$1,781,745	-$1,811,845	-$2,910,845	-$2,889,845	-$1,873,165
Net income	$3,308,955	$3,364,855	$5,405,855	$5,366,855	$3,478,735
Add: Depreciation	$2,429,300	$4,163,300	$2,973,300	$2,123,300	$1,518,100
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835

Net cash inflows:
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835
Change in net working capital	–829,500	–888,750	$414,750	$1,599,750	$1,203,750
Capital spending	$0	$0	$0	$0	$3,537,445
Total cash inflows	$4,908,755	$6,639,405	$8,793,905	$9,089,905	$9,738,030

Computations for the above table:

Formula to calculate the ending book value:

$Ending book value = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]$

Computation of the ending book value for year 1:

$Ending book value for year 3 = [ Ending book value of an equipment for year 2−(Initial cost of an equipment×MACRS rate )]=$10,407,400−($17,000,000×17.49%)=$10,407,400−$2,973,300=$7,434,100$

$Ending book value for year 1 = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]=$17,000,000−($17,000,000×14.29%)=$17,000,000−$2,429,300=$14,570,700$

$Ending book value for year 2 = [ Ending book value of an equipment for year 1−(Initial cost of an equipment×MACRS rate )]=$14,570,700−($17,000,000×24.49%)=$14,570,700−$4,163,300=$10,407,400$

$Ending book value for year 4 = [ Ending book value of an equipment for year 3−(Initial cost of an equipment×MACRS rate )]=$7,434,100−($17,000,000×12.49%)=$7,434,100−$2,123,300=$5,310,800$

$Ending book value for year 5 = [ Ending book value of an equipment for year 4−(Initial cost of an equipment×MACRS rate )]=$5,310,800−($17,000,000×8.93%)=$5,310,800−$1,518,100=$3,792,700$

Formula to calculate the sales:

$Sales = Unit sales×Price per unit$

Computation of the sales:

$Sales for year 1 = Unit sales for year 1×Price per unit=$84,000×$395=$33,180,000$

$Sales for year 2 = Unit sales for year 2×Price per unit=$98,000×$395=$38,710,000$

$Sales for year 3 = Unit sales for year 3×Price per unit=$113,000×$395=$44,635,000$

$Sales for year 4 = Unit sales for year 4×Price per unit=$106,000×$395=$41,870,000$

$Sales for year 5 = Unit sales for year 5×Price per unit=$79,000×$395=$31,205,000$

Computation of the depreciation:

The depreciation amount is calculated by using the MACRS depreciation table for seven years.

Formula to calculate depreciation:

$Depreciaiton = (Installation cost of an equipment×MACRS rate for the specific year)$

Computation of the depreciation:

$Depreciaiton for year 1 = (Installation cost of an equipment×MACRS rate for year 1)=$17,000,000×14.29%=$2,429,300$

$Depreciaiton for year 2 = (Installation cost of an equipment×MACRS rate for year 2)=$17,000,000×24.29%=$4,163,300$

$Depreciaiton for year 3 = (Installation cost of an equipment×MACRS rate for year 3)=$17,000,000×17.49%=$2,973,300$

$Depreciaiton for year 4 = (Installation cost of an equipment×MACRS rate for year 4)=$17,000,000×12.49%=$2,123,300$

$Depreciaiton for year 5 = (Installation cost of an equipment×MACRS rate for year 5)=$17,000,000×8.93%=$1,518,100$

Formula to calculate the taxes:

$Taxes = EBIT for the specific year×Marginal tax rate$

Computation of the taxes:

$Taxes for year 1 = EBIT for year 1×Marginal tax rate=$5,090,700×35%=$1,781,745$

$Taxes for year 2 = EBIT for year 2×Marginal tax rate=$5,176,700×35%=$1,811,845$

$Taxes for year 3 = EBIT for year 3×Marginal tax rate=$8,316,700×35%=$2,910,845$

$Taxes for year 4 = EBIT for year 4×Marginal tax rate=$8,256,700×35%=$2,889,845$

$Taxes for year 5 = EBIT for year 5×Marginal tax rate=$5,351,900×35%=$1,873,165$

Formula to calculate the net working capital:

$Net working capital = Increases of 15%(Sales for the next year−Sales for the current year)$

Computation of the net working capital:

$NWC for year 1= Increases of 15%(Sales for year 2−Sales for year 1)=.15×($38,710,000−$33,180,000)=.15×$5,530,000=$829,500$

$NWC for year 2= Increases of 15%(Sales for year 3−Sales for year 2)=.15×($44,635,000−$38,710,000)=.15×$5,925,000=$888,750$

$NWC for year 3= Increases of 15%(Sales for year 4−Sales for year 3)=.15×($41,870,000−$44,645,000)=.15×$2,765,000=$414,750$

$NWC for year 4= Increases of 15%(Sales for year 5−Sales for year 4)=.15×($31,205,000−$41,870,000)=.15×$10,665,000=$1,599,750$

Computation of the net working capital for the year 5:

$NWC for year 5 = Recovery of all NWC= Initial NWC – [Change in NWC for year 1 + Change in NWC for Year 2 + Change in NWC for year 3 + Change in NWC for Year 4]$

$=$1,500,000−[−$829,500−$888,750+414,750+$1,599,750]=$1,500,000−$296,250=$1,203,750$

Computation of the ending book value:

$Ending book value = [Installation cost of an equipment−(Depreciation for year 1+Depreciation for year 2+Depreciation for year3+Depreciation for year4+Depreciation for year5)]=$17,000,000($2,429,300+$4,163,300+$2,973,300+$2,123,300+$1,518,100)=$17,000,000−$13,207,300=$3,792,700$

Formula to calculate the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]$

Computation of the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]=$3,400,000+($3,792,700−$3,400,000)×.35=$3,400,000+$137,445=$3,537,445$

Formula to calculate the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)$

Computation of the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)=−$18,500,000+($4,908,755(1.18)1+$6,639,405(1.18)2+$8,793,905(1.18)3+$9,089,905(1.18)4+$9,738,030(1.18)5)=$18,500,000+($4,159,961.86+$4,768,317.29+$5,352,242.07+$4,688,471.86+$4,256,582.66)$

$=$18,500,000+$23,225,575.74=$4,725,575.74$

Hence, the net present value is $4,725,575.74.

Computation of the internal rate of return:

The internal rate of return is calculated by the spreadsheet method.

Step 1:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 1

Type the formulae of the internal rate of return in H6 in the spreadsheet and consider the IRR value as H8

Step 2:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 2

Assume the IRR value as 0.10%

Step 3:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 3

In the spreadsheet go to data and select the what-if analysis.
In what-if analysis select goal seek
In set cell select H6 (the formulae)
The To value is considered as 0
The H8 cell is selected for the by changing cell.

Step 4:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 4

Following the previous step click OK in the goal seek. The goal seek status appears

Step 5:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 5

The IRR value appears to be 27.5164749401034%

Hence, the internal rate of return is 27.52%.

Answer 7

Chapter 10, Problem 32QP

Summary Introduction

To find: The net present value and the internal rate of return.

Introduction:

The variation between the present value of the cash outflows and the present value of the cash inflows are known as the net present value. In capital budgeting the net present value is utilized to analyze the profitability of a project or investment. The rate of return which equates the initial investment and the present value of net cash inflows are referred to as internal rate of return. This is also called as actual rate of return.

Answer 8

Expert Solution & Answer

Answer to Problem 32QP

The net present value is $4,725,575.74 and the internal rate of return is 27.52%.

Answer 9

Expert Solution & Answer

Answer 10

Expert Solution & Answer

Answer 11

Explanation of Solution

Given information:

Company A projects the unit sale for the new 7 octave voice emulation implant as follows:

The year 1 unit sales is 84,000
The year 2 unit sales is 98,000
The year 3 unit sales is 113,000
The year 4 unit sales is 106,000
The year 5 unit sales is 79,000

The production implant needs $1,500,000 in the net working capital to begin their production activities. The extra net working capital investment for every year is equivalent to the 15% of the sales that is projected has to rise for the following year. The total fixed cost is $3,400,000 for a year, the unit price is $395, and the variable production cost is $265. The installation cost of the equipment is $17,000,000.

The equipment is qualified in the 7 Year MACRS depreciation under the property class. In 5 years the equipment sale can be sold for 20% of its acquisition cost. The marginal tax bracket is 35 percent and has the required rate of return which is 18%.

MACRS depreciation table for year 7:

MACRS Depreciation table for seven year
Year	Seven year
1	14.29%
2	24.49%
3	17.49%
4	12.49%
5	8.93%
6	8.92%
7	8.93%
8	4.46%

Computation of the net present value:

Computation of the cash outflow:

$Cash outflow = (−Capital spending(Installed cost)+−Initial net working capital)=(−$17,000,000)+(−$1,500,000)=−$18,500,000$

Table showing the cash inflows:

Year	1	2	3	4	5
Ending book value	$14,570,700	$10,407,400	$7,434,100	$5,310,800	$3,792,700
Sales	$33,180,000	$38,710,000	$44,635,000	$41,870,000	$31,205,000
Less: Variable costs	-$22,260,000	-$25,970,000	-$29,945,000	-$28,090,000	-$20,935,000
Fixed costs	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000	-$3,400,000
Depreciation	-$2,429,300	-$4,163,300	-$2,973,300	-$2,123,300	-$1,518,100
EBIT	$5,090,700	$5,176,700	$8,316,700	$8,256,700	$5,351,900
Less: Taxes	-$1,781,745	-$1,811,845	-$2,910,845	-$2,889,845	-$1,873,165
Net income	$3,308,955	$3,364,855	$5,405,855	$5,366,855	$3,478,735
Add: Depreciation	$2,429,300	$4,163,300	$2,973,300	$2,123,300	$1,518,100
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835

Net cash inflows:
Operating cash flow	$5,738,255	$7,528,155	$8,379,155	$7,490,155	$4,996,835
Change in net working capital	–829,500	–888,750	$414,750	$1,599,750	$1,203,750
Capital spending	$0	$0	$0	$0	$3,537,445
Total cash inflows	$4,908,755	$6,639,405	$8,793,905	$9,089,905	$9,738,030

Computations for the above table:

Formula to calculate the ending book value:

$Ending book value = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]$

Computation of the ending book value for year 1:

$Ending book value for year 3 = [ Ending book value of an equipment for year 2−(Initial cost of an equipment×MACRS rate )]=$10,407,400−($17,000,000×17.49%)=$10,407,400−$2,973,300=$7,434,100$

$Ending book value for year 1 = [ Installed cost of an equipment−(Installed cost of an equipment×MACRS rate )]=$17,000,000−($17,000,000×14.29%)=$17,000,000−$2,429,300=$14,570,700$

$Ending book value for year 2 = [ Ending book value of an equipment for year 1−(Initial cost of an equipment×MACRS rate )]=$14,570,700−($17,000,000×24.49%)=$14,570,700−$4,163,300=$10,407,400$

$Ending book value for year 4 = [ Ending book value of an equipment for year 3−(Initial cost of an equipment×MACRS rate )]=$7,434,100−($17,000,000×12.49%)=$7,434,100−$2,123,300=$5,310,800$

$Ending book value for year 5 = [ Ending book value of an equipment for year 4−(Initial cost of an equipment×MACRS rate )]=$5,310,800−($17,000,000×8.93%)=$5,310,800−$1,518,100=$3,792,700$

Formula to calculate the sales:

$Sales = Unit sales×Price per unit$

Computation of the sales:

$Sales for year 1 = Unit sales for year 1×Price per unit=$84,000×$395=$33,180,000$

$Sales for year 2 = Unit sales for year 2×Price per unit=$98,000×$395=$38,710,000$

$Sales for year 3 = Unit sales for year 3×Price per unit=$113,000×$395=$44,635,000$

$Sales for year 4 = Unit sales for year 4×Price per unit=$106,000×$395=$41,870,000$

$Sales for year 5 = Unit sales for year 5×Price per unit=$79,000×$395=$31,205,000$

Computation of the depreciation:

The depreciation amount is calculated by using the MACRS depreciation table for seven years.

Formula to calculate depreciation:

$Depreciaiton = (Installation cost of an equipment×MACRS rate for the specific year)$

Computation of the depreciation:

$Depreciaiton for year 1 = (Installation cost of an equipment×MACRS rate for year 1)=$17,000,000×14.29%=$2,429,300$

$Depreciaiton for year 2 = (Installation cost of an equipment×MACRS rate for year 2)=$17,000,000×24.29%=$4,163,300$

$Depreciaiton for year 3 = (Installation cost of an equipment×MACRS rate for year 3)=$17,000,000×17.49%=$2,973,300$

$Depreciaiton for year 4 = (Installation cost of an equipment×MACRS rate for year 4)=$17,000,000×12.49%=$2,123,300$

$Depreciaiton for year 5 = (Installation cost of an equipment×MACRS rate for year 5)=$17,000,000×8.93%=$1,518,100$

Formula to calculate the taxes:

$Taxes = EBIT for the specific year×Marginal tax rate$

Computation of the taxes:

$Taxes for year 1 = EBIT for year 1×Marginal tax rate=$5,090,700×35%=$1,781,745$

$Taxes for year 2 = EBIT for year 2×Marginal tax rate=$5,176,700×35%=$1,811,845$

$Taxes for year 3 = EBIT for year 3×Marginal tax rate=$8,316,700×35%=$2,910,845$

$Taxes for year 4 = EBIT for year 4×Marginal tax rate=$8,256,700×35%=$2,889,845$

$Taxes for year 5 = EBIT for year 5×Marginal tax rate=$5,351,900×35%=$1,873,165$

Formula to calculate the net working capital:

$Net working capital = Increases of 15%(Sales for the next year−Sales for the current year)$

Computation of the net working capital:

$NWC for year 1= Increases of 15%(Sales for year 2−Sales for year 1)=.15×($38,710,000−$33,180,000)=.15×$5,530,000=$829,500$

$NWC for year 2= Increases of 15%(Sales for year 3−Sales for year 2)=.15×($44,635,000−$38,710,000)=.15×$5,925,000=$888,750$

$NWC for year 3= Increases of 15%(Sales for year 4−Sales for year 3)=.15×($41,870,000−$44,645,000)=.15×$2,765,000=$414,750$

$NWC for year 4= Increases of 15%(Sales for year 5−Sales for year 4)=.15×($31,205,000−$41,870,000)=.15×$10,665,000=$1,599,750$

Computation of the net working capital for the year 5:

$NWC for year 5 = Recovery of all NWC= Initial NWC – [Change in NWC for year 1 + Change in NWC for Year 2 + Change in NWC for year 3 + Change in NWC for Year 4]$

$=$1,500,000−[−$829,500−$888,750+414,750+$1,599,750]=$1,500,000−$296,250=$1,203,750$

Computation of the ending book value:

$Ending book value = [Installation cost of an equipment−(Depreciation for year 1+Depreciation for year 2+Depreciation for year3+Depreciation for year4+Depreciation for year5)]=$17,000,000($2,429,300+$4,163,300+$2,973,300+$2,123,300+$1,518,100)=$17,000,000−$13,207,300=$3,792,700$

Formula to calculate the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]$

Computation of the after-tax salvage value:

$After-taxsalvage value = [Total fixed cost +(Ending book value−Total fixed cost)×Marginal tax rate]=$3,400,000+($3,792,700−$3,400,000)×.35=$3,400,000+$137,445=$3,537,445$

Formula to calculate the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)$

Computation of the net present value:

$NPV = Cash outflow +Cash inflow=−Total cash outflow +(Cash inflow for year 1(1+r)1+Cash inflow for year 2(1+r)2+Cash inflow for year 3(1+r)3+Cash inflow for year 4(1+r)4+Cash inflow for year 5(1+r)5)=−$18,500,000+($4,908,755(1.18)1+$6,639,405(1.18)2+$8,793,905(1.18)3+$9,089,905(1.18)4+$9,738,030(1.18)5)=$18,500,000+($4,159,961.86+$4,768,317.29+$5,352,242.07+$4,688,471.86+$4,256,582.66)$

$=$18,500,000+$23,225,575.74=$4,725,575.74$

Hence, the net present value is $4,725,575.74.

Computation of the internal rate of return:

The internal rate of return is calculated by the spreadsheet method.

Step 1:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 1

Type the formulae of the internal rate of return in H6 in the spreadsheet and consider the IRR value as H8

Step 2:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 2

Assume the IRR value as 0.10%

Step 3:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 3

In the spreadsheet go to data and select the what-if analysis.
In what-if analysis select goal seek
In set cell select H6 (the formulae)
The To value is considered as 0
The H8 cell is selected for the by changing cell.

Step 4:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 4

Following the previous step click OK in the goal seek. The goal seek status appears

Step 5:

Fundamentals of Corporate Finance, Chapter 10, Problem 32QP , additional homework tip 5

The IRR value appears to be 27.5164749401034%

Hence, the internal rate of return is 27.52%.

Answer 12

Ch. 10.1 - What are the relevant incremental cash flows for...Ch. 10.1 - What is the stand-alone principle?Ch. 10.2 - Prob. 10.2ACQ Ch. 10.2 - Prob. 10.2BCQ Ch. 10.2 - Explain why interest paid is not a relevant cash...Ch. 10.3 - What is the definition of project operating cash...Ch. 10.3 - For the shark attractant project, why did we add...Ch. 10.4 - Prob. 10.4ACQ Ch. 10.4 - How is depreciation calculated for fixed assets...Ch. 10.5 - Prob. 10.5ACQ

Answer to Problem 32QP

Explanation of Solution

Want to see more full solutions like this?

Chapter 10 Solutions