Q1. Prepare a NPV table based on the information given and using the table BFBS Cost Analysis format
Answer.
Given:
New Machine Cost = $40,000
Working Capital = $3,000
Project Life = 10 years
Annual Net Cash Flow = $15,000 each year (Ordinary Annuity)
Discount Rate = 10 %
Tax Rate = 40 %
Salvage Value = $6,000
Depreciation = Straight line over 10 years.
Yearly depreciation calculation
Cost = $ 40,000
Salvage value = $6,000
Cost – Salvage value = $40,000  $6,000 = $34,000
10 – year straight line depreciation = $34,000 / 10 = $3,400 per year.
Assumptions:
 Annual net cash flow = Sales revenue – (Cost of goods sold + Salaries, Shipment, etc.).
 Cash inflows are even
 Depreciation value is not added to expenses
 Earning before income taxes (EBIT) is calculated without depreciation
 Effect of depreciation is added to the NPV calculation as an additional earning, and is shown in the BFBS cost analysis table
BFBS Cost Analysis

Years

Amount

Tax Effect 40%

AfterTax Cash Flows

10% Factor

Net Present Value

Cost of asset

Now

($40,000)


($40,000)

1.0000

($40,000)

Working capital needed

Now

($3,000)


($3,000)

1.0000

($3,000)

Net annual cash inflows

1 to 10

$15,000

0.6

$9,000

6.14457

$55,301

Depreciation tax shield

1 to 10

$3,400

0.4

$1,360

6.14457

$8,357

Salvage value

10

$6,000

0.6

$3,600

0.38554

$1,388

Working capital released

10

3000


3000

0.38554

$1,157

Net present value






$23,202

Table 1. NPV calculation per BFBS format
Q2. Analyze the data in the NPV table
Answer.
Net Present Value (NPV) calculates the present value of an investment using the discounted sum of all cash in flows and out flows to and from the project. It also considers salvage value and released working capital, if any. The principal parts of NPV are investment, cost of the capital or discount rate, and cash inflows throughout the project life (Managerial Accounting).
To initiate the project, BFBS needs to invest $40,000 to purchase a new machine, and $3,000 working capital to maintain the machine. These are cash out flows. In the NPV calculation, they are negative.
The project life is 10 years. Throughout the project life, it generates cash from the operation. In this case, it generates $15,000 each year. However, out of $15,000, the company pays 40 % taxes. Thus, 60 % goes to the company as cash inflow. In NPV this value, it is positive.
Mentioned above assumptions stated that depreciation was not added to the expenses in net cash flow evaluation. Depreciation through the tax shield affects taxes, and it indirectly affect after tax cash flows (Wiley). Depreciation, in this case, gives 40 % tax shield, which is a cash inflow. In the NPV calculation, in this case, is a positive value.
NPV considers time value factor of the future cash flows. Net Present Value (NPV) is calculated based on the following formula (Net Present Value).
NPV =  C_{0} + {C_{1}/(1+r)} + {C_{2}/(1+r)^{2}} + {C_{3} / (1+ r)^{3}} + …… +{C_{t} / (1+r)^{t}}; where,
C_{0} = Initial investment;
C_{1} = Net annual cash flow for year 1;
C_{2} = Net annual cash flow for year 2;
C_{3} = Net annual cash flow for year 3,
C_{t }= Net annual cash flow for year t.
r = Discount rate
t = Time
In the above formula, 1 / (1+r)^{t} considers the time value factor of money. The ratio, 1 / (1+r)^{t} is called PV factor. It depends on “r”, the discount rate. PV factors for 10 years with the discount rate of 10 % are shown below in the tabular form.

10.00%


PV Factors

Year 1

0.90909

Year 2

0.82645

Year 3

0.75131

Year 4

0.68301

Year 5

0.62092

Year 6

0.56447

Year 7

0.51316

Year 8

0.46651

Year 9

0.42410

Year 10

0.38554

The present value of the future money is calculated by multiplying it with PV factors. The sum of all PV factors at 10 % discount rate for 10 years is 6.14457. Net cash inflow and depreciation used this factor to evaluate the present value of the future moneys.
Salvage value is an income for the company. The company pays 40 % tax of this income and generates 60 % cash inflow. In NPV calculation, it is a positive value. Its present value is calculated by multiplying PV factor of the 10th year, which is 0.38554.
Released working capital is not an income. That is why; the company does not pay taxes. On the other hand, its value after 10 years is not same as of its current value. That is why; released working capital is multiplied by PV factor of the 10th year, which is 0.38554.
For the BFBS project, NVP is the sum of all cash flows shown in Table 1. The NPV of the project is $23,202.
Q3. Discuss the decision that should be made concerning the investment in the new machine.
Answer:
NPV is a capital budgeting evaluation method. Industry recommendation is to accept the project if the NPV value is positive (Managerial Accounting). In this case, the NPV value is $23,202. The BFBS Company can accept the project.