MODULE 8 Capital Budgeting

Download as pdf or txt
Download as pdf or txt
You are on page 1of 16

MANAGEMENT ADVISORY SERVICES

CAPITAL BUDGETING

CAPITAL INVESTMENT – involves significant commitment of funds to receive a satisfactory return – increase in revenue or reduction
in costs over an extended period of time. Example: purchase of equipment for expansion, replacement of old equipment.

GENERAL CHARACTERISTICS OF CAPITAL INVESTMENT DECISIONS


● AS TO COST usually involves large expenditure of resources, relative to business size
● AS TO COMMITMENT usually funds invested are tied up for a long period of time
● AS TO FLEXIBILITY usually more difficult to reverse than short-term decisions
● AS TO RISK usually involves so much risks and uncertainties due to operational and economic changes over an
extended period of time

CAPITAL BUDGETING – is the process by which management identifies, evaluates, and makes decision on capital investment
projects of an organization. It is the process of planning expenditures for assets, the return on which are expected to continue beyond
one-year period.

CAPITAL INVESTMENT FACTORS


Net Investments (for decision-making purposes)
● Costs less savings incidental to the acquisition of the capital investment projects
● Cash outflows less cash inflows incidental to the acquisition of the capital investment projects

Costs or cash outflows


1. Purchase price of the asset, net of related cash discount
2. Incidental project-related expenses such as freight, insurance, handling, installation, test-runs, etc.
CONSIDER ALSO THE FOLLOWING, if any:
● Additional working capital needed to support the operation of the project at the desired level.
● Market value of existing idle assets to be used in the operation of the proposed capital project.
● Training cost, net of related tax
Savings or cash inflows
1. Proceeds from sale of old asset disposed, net of related tax
CONSIDER ALSO THE FOLLOWING, if any:
● Trade-in value of old asset
● Avoidable cost of immediate repairs on the old asset to be replaced, net of related tax

Net Returns
● ACCRUAL BASIS: Accounting net income (after tax)
● CASH BASIS: Net cash inflows
✔ DIRECT METHOD (Cash inflows – Cash outflows)
✔ INDIRECT METHOD (Net income after tax + Noncash expenses)

CAPITAL INVESTMENT = CASH OUTFLOWS – CASH INFLOWS

Illustration: Net Investments for Decision-Making

Bicol Company plans to replace a unit of equipment that was acquired three (3) years ago and is now recorded at a book value of
P65,000. This equipment can be sold now for P75,000. Tax rate is 25%.

New equipment can be acquired from Baguio Company at a list price of P200,000. Baguio will grant a 2% cash discount if the
equipment is paid for within 30 days from acquisition date. Shipping, installation and testing charges to be paid are estimated at
P14,000.

Other assets with a book value of P12,000 that are to be retired as a result of the acquisition of the new machine can be salvaged and
sold for P10,000.

Additional working capital of P18,000 will be needed to support operations planned with the new equipment.

The annual cash flow after income tax from the operation of the new equipment has been estimated at P50,000. The equipment is
expected to have a useful life of 5 years with a salvage value of P4,000 at the end of 5 years.

Required: What is the initial cost of investments for decision-making purposes? 145,000

CASH OUTFLOWS:
Tax – Gain on sale of old equipment (75k-65k) x 25% 2,500
Purchase price, net (P200,000 x 98%) 196,000

1
Shipping, installation…. 14,000
Additional WC 18,000 230,500

CASH INFLOWS:
Proceeds from sale of old equipment 75,000
Proceeds from sale of other assets 10,000
Tax savings – loss on sale of O.A. (10k-12k) x 25% 500 85,500

Net investment 145,000

Illustration: Net Returns (Increase in Revenues)

The management of Star Cinema plans to install coffee vending machines costing P200,000 in its movie house. Annual sales
of coffee are estimated at 10,000 cups at a price of P15 per cup. Variable costs are estimated at P6 per cup, while incremental fixed
cash costs, excluding depreciation, at P20,000 per year. The machines are expected to have a service life of 5 years, with no salvage
value. Depreciation will be computed on a straight-line basis. The company’s income tax rate is 30%.

Required: Assuming that the vending machines are installed, determine:

a. The increase in annual net income 21,000


b. The annual cash inflows that will be generated by the project. 61,000

a)
Incremental CM (P15 – P6) x 10,000 P 90,000
Incremental fixed cash costs (20,000)
Incremental depreciation (P200,000/5) (40,000)
Incremental NIBT P 30,000
Incremental tax (30%) (9,000)
Incremental NIAT P 21,000

b)
Incremental CM (P15 – P6) x 10,000 P 90,000
Incremental fixed cash costs (20,000)
Incremental tax (30%) (9,000)
Incremental net cash flows P 61,000

Incremental NIAT P 21,000


Add back: Dep exp 40,000
Incremental net cash flows P 61,000
Tax savings – dep exp (P40,000 x 30%) P 12,000 (DEPRECIATION TAX-SHIELD)

Illustration: Net Returns (Cost Savings)

Moon Corporation is planning to buy cleaning equipment that can reduce service cost and other cash expenses by an average
of P70,000 per year. The new cleaning equipment will cost P100,000 and will be depreciated for 5 years on a straight-line basis. No
salvage value is expected at the end of the equipment’s life. Income tax is estimated at 32%.

Required: Determine the net cash inflows that will be generated by the project. 54,000

Cost savings, net (P70,000 x 68%) P 47,600


Depreciation tax-shield (P100,000/5) x 32% 6,400
Net cash inflows P 54,000

OR;

COST SAVINGS 70,000


DEPN (20,000)
INC. IN NIBT 50,000
TAX (16,000)
INC. IN NIAT 34,000
DEP 20,000
ACF 54,000

2
CAPITAL BUDGETING TECHNIQUES IN EVALUATING PROJECTS

● Non-discounted methods – methods that do not consider the time value of money
a. Payback period method c. Bail-out payback method
b. Payback reciprocal method d. Accounting rate of return method

● Discounted methods – methods that consider the time value of money


a. Net present value method c. Internal rate of return method
b. Profitability index method d. Present value payback method

P100,000 January 1, 2021


Vs. P100,000 January 1, 2024
WACC – 10%

YEAR 0 YEAR 1 YEAR 2 YEAR 3

PV P100,000

÷ 1.1 ÷ 1.1 ÷ 1.1

75,131.48

FV to PV = FV x PVF
= 100,000 x 0.7513 = 75,130

CASH FLOWS

YEAR 0 YEAR 1 YEAR 2 YEAR 3


0 100,000 100,000 100,000

ANNUAL CASH FLOWS:


YEAR 1: P100,000 X 0.9091 = P90,910
YEAR 2: P100,000 X 0.8264 = P82,640
YEAR 3: P100,000 X 0.7513 = P75,130
2.4868 P248,680

PV of ordinary annuity at 10% for 3 periods = 2.4868

I. NON-DISCOUNTED METHODS
= Payback Period Method =

Payback period = Net initial cost of investment / Annual net after-tax cash inflows

Cost of investment P 100,000


Annual cash flows 25,000
PBP = COI / ACF
= P100,000 / P25,000
= 4 years

Advantages:
1. Payback is simple to compute and easy to understand.
2. Payback gives information about the liquidity of the project.
3. It is a good surrogate for risk. A quick or short payback period indicates a less risky project.

Disadvantages:

3
1. Payback does not consider the time value of money.
2. It gives more emphasis on liquidity rather than on profitability of the project.
3. It does not consider the salvage value of the project.
4. It ignores cash flows that may occur after the payback period (short-sighted)

= Payback Reciprocal =

Payback reciprocal = Net cash inflows / Investment


= 1 / Payback period

Cost of investment P 100,000


Annual cash flows 25,000
PBP = COI / ACF
= P100,000 / P25,000
= 4 years

PBR = P25,000 / P100,000


= 25%

OR; 1/PBP
= 1/4
= 25%

= Accounting Rate of Return Method =

Accounting rate of return (ARR) = Average annual net income / Investment *


* may be based on original or average investment.

Advantages:
1. The ARR closely parallels accounting concepts of income measurement and investment return.
2. It facilitates re-evaluation of projects due to ready availability of data from the accounting records.

Disadvantages:
1. Like traditional payback methods, the ARR method does not consider the time value of money.
2. With the computation of income and book value based on the historical cost accounting data, the effect of inflation is ignored.

Other terms used to denote the ARR:


☺ Book value rate of return ☺ Approximate rate of return method
☺ Unadjusted rate of return ☺ Financial statement rate of return method
☺ Simple rate of return ☺ Average return on investment

Illustration: Payback Period & Accounting Rate of Return (With Even Cash Flows)

Green Company considers the replacement of some old equipment. The cost of the new equipment is P90,000, with a useful
life estimate of 8 years and a salvage value of P10,000. The annual pre-tax cash savings from the use of the new equipment is
P40,000. The old equipment has zero market value and is fully depreciated. The company uses a cost of capital of 25%.

Required: Assuming that the income tax rate is 40%, compute:


1. Payback period 3.214 years
2. Payback reciprocal 31.11%
3. Accounting rate of return on original investment 20%
4. Accounting rate of return on average investment 36%

1) PBP = Investment / ACF*


= P90,000 / P28,000
= 3.214 years

ACF before tax P 40,000


Dep exp (P90,000-P10,000) / 8 (10,000)
NIBT P 30,000
Tax (40%) (12,000)
NIAT P 18,000
Dep exp 10,000
ACF after tax P 28,000

4
2) PBR = 1/3.214
= 31.11%

3) ARR-orig. = NIAT / orig inv


= P18,000 / P90,000
= 20%

4) ARR-ave = NIAT / ave investment


= P18,000
(P90,000 + P10,000)/2

= 36%

Illustration: Payback Period & Accounting Rate of Return (With Uneven Cash Flows)

Pole Company has an investment opportunity costing P90,000 that is expected to yield the following cash flows over the next
five years: (assume a cut-off rate of 30%)
Year 1: P40,000 Year 2: P35,000 Year 3: P30,000 Year 4: P20,000 Year 5: P10,000

Required:
1. Payback period in months 30 months
2. Book rate of return 20%

1) P90,000
(40,000) CF1
(35,000) CF2
P15,000 – Unrecovered investment, beg. Of yr 3
/ 30,000
0.5

PBB = 2.5 years or 30 months

2) ARR-average = Average NIAT


Average BV

= 9,000
(P90,000/2)

= 20%

Average NIAT:
YEAR ACF DEP EXP NIAT

1 40,000 18,000 22,000

2 35,000 18,000 17,000

3 30,000 18,000 12,000

4 20,000 18,000 2,000

5 10,000 18,000 (8,000)

135,000 90,000 45,000

AVE NIAT = 45,000/5 = 9,000

= Bail-out Payback Period =

It is a modified payback period method wherein cash recoveries include the estimated salvage value at the end of each year of
the project life.

5
Illustration: Bail-out Payback Period

A project costing P180,000 will produce the following annual cash flows and salvage value:

Year Cash Flows Salvage Value


1 P 50,000 P 65,000
2 P 50,000 P 50,000
3 P 50,000 P 35,000
4 P 50,000 P 20,000

Required: Compute for the bail-out payback period. 2.9 years

P180,000
(50,000) CF1
(50,000) CF2
P 80,000
(35,000)
P 45,000
(50,000)
0.9 CF3

EXERCISES (TRUE OR FALSE; MULTIPLE-CHOICE)

1. A project’s salvage value, realizable at the end of life of the project, is considered in the computation of the net investments for
decision-making purposes. F

2. The payback period emphasizes the profitability of a capital project while the accounting rate of return, on the other hand,
emphasizes the project’s liquidity. F

3. Annual cash inflows from the capital projects are measured in terms of
a. Income before depreciation and taxes c. Income before depreciation but after taxes
b. Income after depreciation and taxes d. Income after depreciation but before taxes

4. When computing for the accounting rate of return (ARR), which of the following is used?
a. Income before depreciation and taxes c. Income before depreciation but after taxes
b. Income after depreciation and taxes d. Income after depreciation but before taxes

5. Calculating the payback period for a capital project requires knowing which of the following?
a. Useful life of the project c. The project's NPV
b. The company's minimum required rate of return d. The project's annual cash flow

6. The payback criterion for capital investment decisions


a. is conceptually superior to the IRR criterion c. gives priority to rapid recovery of cash.
b. takes into consideration the time value of money d. emphasizes the most profitable projects.

7. If there were no income taxes,


a. depreciation would be ignored in capital budgeting
b. the NPV method would not work
c. income would be discounted instead of cash flow
d. all potential investments would be desirable

8. Which statement describes the relevance of depreciation in calculating cash flows?


a. Depreciation is relevant only when income taxes exist.
b. Depreciation is always relevant.
c. Depreciation is never relevant.
d. Depreciation is relevant only with discounted cash flow methods.

9. Payback period is the length of time it will take a company to recoup its outlay for an investment. T

10. Payback emphasizes the return of the investment and ignores the return on the investment. T

11. As to a capital investment, net cash inflow is equal to the


a. cost savings resulting from the investment c. net increase in cash receipts over cash payments
b. sum of all future revenues from the investment d. net increase in cash payments over cash receipts

6
12. Which of the following would not involve a capital-budgeting analysis?
a. The acquisition of new equipment.
b. The addition of a new product line.
c. The adoption of a new cost driver for overhead application.
d. The construction of a new distribution facility.
e. Whether a pro football team should trade for and sign a star quarterback to a long-term contract.

13. A major difference between an investment in working capital and one in depreciable assets is that
a. An investment in working capital is never returned, while most depreciable assets have some residual value.
b. An investment in working capital is returned in full at the end of the project’s life, while an investment in depreciable assets
has no residual value.
c. An investment in working capital is not tax-deductible when made, not taxable when returned, while an investment in
depreciable assets does allow tax deductions.
d. Because an investment in working capital is usually returned in full at the end of the project’s life, it is ignored in computing
the amount of the investment required for the project.

14. The cash inflow from the return on an investment in working capital is
a. Adjusted for taxes due.
b. Discounted to present value.
c. Ignored if any depreciable assets also involved in the project have no expected residual value.
d. Not real.

15. As to a capital investment, net cash inflow is equal to the


a. cost savings resulting from the investment.
b. sum of all future revenues from the investment.
c. net increase in cash receipts over cash payments.
d. net increase in cash payments over cash receipts.

II. DISCOUNTED METHODS

The time value of money is an opportunity cost concept. A peso on hand today is worth more than a peso to be received
tomorrow because of interests a peso could earn by putting it in a savings account or placing it in an investment that earns income. The
time value of money is usually measured by using a discount rate that is implied to be the interest foregone by receiving funds at a later
time.

COSTS OF CAPITAL

The ‘costs of capital’ used in capital budgeting is the Weighted Average Costs of Capital (WACC). These are specific costs of using
long-term funds, obtained from the different sources: borrowed (debt) and invested (equity) capital.
SOURCES COSTS
Debt Interest rate (after tax)
Preferred Stock (PS) Dividend yield
Common Stock (CS) Dividend yield plus growth rate
Retained Earnings (RE) Dividend yield plus growth rate

DIVIDEND YIELD = DIVIDEND PER SHARE / PRICE PER SHARE

⮚ The after-tax cost of debt is computed based on: yield rate (1 – tax rate)
⮚ Dividend yield = dividend per share ÷ price per share
Costs of CS and RE = (Expected Cash DPS / MPPCS) + Dividend growth rate
Where: DPS = Dividend per share, MPPCS = Market price per common share
⮚ The dividend growth rate is assumed to be constant over time.
⮚ In computing cost of CS & PS, the market price should be net of flotation costs (e.g., underwriting fees).
⮚ In computing the cost of RE, flotation costs should be ignored.
⮚ Alternatively, the cost of equity capital may be computed based on Capital Asset Pricing Model (CAPM).

Other terms used to denote the weighted average cost of capital (WACC):
☺ Minimum required rate of return ☺ Desired rate of return
☺ Minimum acceptable rate of return ☺ Standard rate
☺ Cut-off rate ☺ Hurdle rate
☺ Target rate

Common shares:
Dividend per share – last year P5
Growth rate 10%
Expected DPS (P5 x 1.1) P5.5
7
MPPS P102
Flotation cost P2

COCE = [P5.5/(P102-P2)] + 10% = 15.5%

CORE = P5.5/P102 + 10% = 15.39%

Illustration: Weighted Average Cost of Capital (WACC)

The Bow Company wants to determine the weighted average cost of capital that it can use to evaluate capital investment
proposals. The company’s capital structure with corresponding market values follows:

8% Term Bonds P 600,000


5% Preferred Stock (P100 par) 200,000
Common stock (no par, 10,000 shares outstanding) 400,000
Retained earnings 800,000
Total P 2,000,000

Additional data:
● Current market price per share:
o Preferred stock: P50
o Common stock: P40

● Expected common dividend: P2 per share


● Dividend growth rate: 4%
● Corporate tax rate: 30%

Required:

1. Given an operating income of P500,000, how much is the earnings per share?
2. Determine the weighted average cost of capital.

EPS = NI available to OS = P306,400 = P30.64


O/S OS 10,000 shares

EBIT P 500,000
Int exp (P600,000 x 8%) (48,000)
NIBT P 452,000
Tax (30%) (135,600)
NIAT P 316,400
Pref Div (P200,000 x 5%) (10,000)
NI available to OS P 306,400

SOURCES SOLUTION Individual COC Weight (MV) WACC


DEBT 8% X (1-30%) 5.6% 30% 1.68%
PS P5 / P50 10% 10% 1.00%
CS (P2 / P40) + 4% 9% 60% 5.40%
RE
8.08%

8
Capital Asset Pricing Model – Illustrative Problems

Formula: K = Rf + B (Rm – Rf)


Market premium = (Rm – Rf)
Risk premium = B (Rm – Rf)

Where: K = Cost of equity


Rf = Risk-free rate
B = Beta coefficient
Rm = Market rate
EXERCISES: WACC – CAPM

1. According to CAPM estimates, what is the cost of equity for a firm with beta of 1.5 when the risk-free interest rate is 6% and
the expected return on the market portfolio is 15%? 19.5%

K = 6% + 1.5 (15% – 6%) = 19.5%

2. The expected return on Globe Oil stock is 18.95%. If the market premium is 8.2%, and the risk-free rate is 6.4%, what is the
beta of Globe Oil stock?

18.95% = 6.4% + B (8.2%)


12.55% = B (8.2%)
B = 1.53

3. An investor was expecting an 18% return on his portfolio with beta of 1.25 before the market risk premium increased from 8%
to 10%. Based on this change, what return will now be expected on the portfolio?

4. The expected rate of return of stock of Phoslate Company, given a beta of 1.25, risk-free rate of 7.5%, and a market risk
premium of 6%, is:

5. What is the risk-free rate given a beta of 0.8, a market risk premium of 6%, and an expected return of 9.8%?

= Net Present Value Method =

Net present value = Present value of cash inflows – Present value of cash outflows

PVCF XX – (ACF x PVF) + (SV x PVF)


Investment (XX)
NPV XX

⮚ Cash inflows include cash infused by the capital investment project on a regular basis (e.g., annul cash inflow) and cash
realizable at the end of the capital investment project. (e.g., salvage value, return of working capital requirements)
⮚ The net investment cost required at the inception of the project usually represents the present value of the cash outflows.

Advantages:
1. Emphasizes cash flows
2. Recognizes the time value of money
3. Assumes discount rate as reinvestment rate

Disadvantages:
1. It requires determination of the costs of the discount rate to be used.
2. The net present values of the different competing projects may not be comparable because of differences in magnitudes or
sizes of the projects.

Illustration: Net Present Value (With Uniform Cash Flows)

Can Company plans to buy a new machine costing P28,000. The new machine is expected to have a salvage value of P4,000 at the
end its life of 4 years. The annual cash inflows before income tax from this machine have been estimated at P11,000. The tax rate is
20%. The company desires a minimum return of 25% on invested capital.

Required: Determine the net present value. (Round-off factors to three decimal places)

PVCF:
9
ACF (P10,000 x 2.362) 23,620
SV (4,000 x 0.41)
Investment 28,000
NPV (4,380)

Pre-tax ACF P 11,000


Dep exp (P28,000-P4,000)/4 (6,000)
NIBT P 5,000
Tax (20%) (1,000)
NIAT P 4,000
Dep exp 6,000
Post-tax ACF P 10,000

P. Index = PVCF / Investment = P23,620 / P28,000 = 0.84


NPV Index = NPV / Investment = (4,380) / 28,000 = (0.16)

NPV > 0 (Project screening)


PI > 1 (Project ranking)

Project 1, NPV = 100,000; Cost = P500,000; PVCF= P600,000; PI = 1.2


Project 2, NPV = 1M; Cost = 100M; PVCF = 101M; PI = 1.01

= Profitability Index Method =

Profitability index = Present value of cash inflows / Present value of cash outflows
NPV index = NPV / Investment

The profitability index method is designed to provide a common basis of ranking alternatives that require different amounts of
investment.

Note: Profitability index method is also known as desirability index, present value index and benefit-cost ratio.

Illustration: Capital Rationing – Ranking Projects

Zone Corp. is considering five different investment opportunities. The company’s cost of capital is 12%. Data on these
opportunities under consideration are given below:

Project Investment PV – Cash Flow NPV IRR (%) P. Index


1 P35,000 P39,325 P4,325 16 1.12
2 20,000 22,930 2,930 15 1.15
3 25,000 27,453 2,543 14 1.10
4 10,000 10,854 854 18 1.09
5 9,000 8,749 (251) 11 0.97

Required:
1. Rank the projects in order of preference according to NPV, IRR and benefit/cost ratio.
NPV: 1,2,3,4,5
IRR: 4,1,2,3,5
PI: 2,1,3,4,5

2. If only a budget of P55,000 is available, which projects should be chosen?


P55,000
Proj. 2 20,000 = NPV 2,930
Proj. 1 35,000 = NPV 4,325 7,255

3. If only a budget of P45,000 is available, which projects should be chosen?


P 45,000
Proj. 2 20,000 = NPV 2,930
Proj. 3 25,000 = NPV 2,543 5,473

= Internal Rate of Return Method =


10
IRR is the rate of return that equates the present value of cash inflows to present value of cash outflows. It is also known as discounted
cash flow rate of return, time-adjusted rate of return or sophisticated rate of return.

Guidelines in determining IRR:

1. Determine the present value factor (PVF) for the internal rate of return (IRR) with the use of the following formula:

PVF for IRR = Net investment cost / Net cash inflows

2. Using the present value annuity table, find on line ‘n’ (economic life) the PVF obtained in No. 1. The corresponding rate is the
IRR. If the exact rate is not found on the PVF table, ‘interpolation’ process may be necessary.

Advantages:
1. Emphasizes cash flows
2. Recognizes the time value of money
3. Computes the true return of project

Disadvantages:
1. Assumes that IRR is the re-investment rate.
2. When project includes negative earnings during its life, different rates of return may result.

Illustration: NPV, PI & IRR (Even vs. Uneven Cash Flows)

Yahoo Corp. gathered the following data on two capital investment opportunities:

Project 1 Project 2
Cost of investment P195,200 P150,000
Cost of capital 10% 10%
Expected useful life 3 years 3 years
Net cash inflows P100,000 P100,000*

* This amount is to decline by P20,000 annually thereafter.

Required: Round-off factors to three decimal places in all cases.


1. Fill-in the blanks.
Project 1 Project 2
NPV 53,500 52,040
Profitability index 1.274 1.347
NPV Index 0.274 0.347

2. What is the project 1’s IRR?


a. 23% b. 27% c. 25% d. 24%

100,000 ? 1.952
PVCF 195,200 ACF x PVF
COI (195,200) Discount rate? (IRR)
NPV 0

@ COC of 10%, PVF = 2.487


@ 11%, PVF = 2.443
@ 22%, PVF = 2.042
@ 25%, PVF = 1.952

3. What is project 2’s time-adjusted rate of return?


a. Below 30% b. Between 30% & 31% c. Between 31% & 32% d. Above 32%

PROJECT 2:
PVCF 150,000 - (100,000 x ? ) + (80,000 x ?) + (60,000 x ?)
COI (150,000)
NPV 0

@ 30%, PVCF:
11
100,000 x 0.769 76,900
80,000 x 0.592 47,360
60,000 x 0.455 27,300 151,560
1,560 ÷
@ IRR, PVCF 150,000
1,920 = 0.8125
@ 31%, PVCF:
100,000 x 0.763 76,300
80,000 x 0.583 46,640
60,000 x 0.445 26,700 149,640

IRR = 30.8125%
100,000 x 0.764 76,400
80,000 x 0.584 46,720
60,000 x 0.447 26,820 149,940

PROJECT 2:
PVCF 202,040 - (100,000 x 0.909 ) + (80,000 x 0.826) + (60,000 x 0.751)
COI (150,000)
NPV 52,040

P.I. = PVCF / COI = 1.347

NPV Index = 0.347

PROJECT 1:
PVCF (100,000 x 2.487) 248,700
COI 195,200
NPV 53,500

P.I. = PVCF / COI = 1.274

NPV Index = P.I. – 1


= 0.274

OR; = NPV / COI


= 53,500 / 195,200
= 0.274

Present Value Payback – Illustrative Problem

Problema Co. is considering the purchase of new machinery. The estimated cost of the machine is P250,000. The machine is not
expected to have a residual value at the end of four years. The machine is expected to generate annual cash inflows for the next four
years as follows:
Year Annual Cash Inflow
1 P 150,000
2 100,000
3 50,000
4 50,000

Problema Co. requires a 12% return on this investment. The present values of 1, end of each period, discounted at 12% follow:
Year Present Value Factor
1 0.89286
2 0.79719
3 0.71178
4 0.63552

What is the present value payback? 3.024 years

Year Annual Cash Inflow PVF PVCF


1 P 150,000 0.89286 133,929
2 100,000 0.79719 79,719
3 50,000 0.71178 35,589
4 50,000 0.63552 31,776

12
PVPB period:
P250,000
(133,929)
(79,719)
(35,589)
763 / 31,776 = 0.024

Illustration: Relationships – Discounted Techniques

Fill in the blanks for each of the following independent cases. In all cases, the investment has a useful life of 10 years and no
salvage value. Round off factors to three decimal places.

Project Annual Cash Flow Investment Cost of Capital IRR NPV


1 P45,000 P188,640 14% 20% 64,305
2 P75,000 12% 18%
3 P300,000 16% P81,440
4 P450,000 12% 14% P115,000

PROJECT 1:
PVCF (45,000 x 5.621) 252,945
COI 188,640
NPV 64,305

COI/PVCF 188,640
÷ ACF 45,000
Required PVF 4.192

IRR:
@ 16%, PVF 5.159
@ 20%, PVF 4.193
@ 22%, PVF 3.923
@ 21%, PVF 4.054

Illustration: Discounted & Non-Discounted Techniques

Mall Company is considering buying a new machine, requiring an immediate P400,000 cash outlay. The new machine is expected to
increase annual net after-tax cash receipts by P160,000 in each of the next five years of its economic life. No salvage value is expected
at the end of 5 years. The company desires a minimum return of 14% on invested capital.

Required: Round-off factors to three decimal places in all cases.


1. Payback period 2.5 years 5. Net present value P149,280
2. Payback reciprocal 0.4 6. Profitability index 1.3732
3. ARR (based on original investment) 20% 7. Present Value Payback 3.3 yrs
4. ARR (based on average investment) 40% 8. Internal rate of return 28.65%

2.5
8) 160,000 X ???
PVCF 400,000 – ACF X PVF
COI 400,000
NPV 0

13
DISCOUNT RATE???
Required PVF = 2.5

@ 25% Discount rate, PVF = 2.689

@ 28%, PVF = 2.532


0.032
????? = 2.500 0.049

@ 29%, PVF = 2.483

0.032/0.049 = 0.65 + 28 = 28.653%

5)
PVCF:
ACF (P160,000 x 3.433) P 549,280
SV 0
Investment (400,000)
NPV P 149,280

6)
PI = PVCF ÷ Investment
= P549,280 ÷ P400,000
= 1.373

NPV Index = NPV ÷ Investment


= P149,280 ÷ P400,000
= 0.373

7)
P 400,000
PV-CF1 (P160,000 x 0.877) 140,320
PV-CF2 (P160,000 x 0.769) 123,040
PV-CF3 (P160,000 x 0.675) 108,000 P 28,640
PV-CF4 (P160,000 x 0.592) 94,720 0.30
PV-CF5 (P160,000 x 0.519) 83,040

1)
PBP = Investment / ACF
= P400,000 / P160,000
= 2.5 years

2)
PBR = ACF / Investment
= P160,000 / P400,000
= 40%

OR; = 1/PBP
= 1 ÷ 2.5
= 40%

3)
ARR – orig. = NIAT
Orig. inv.
= (P160,000 – P80,000)
P400,000
= 20%

4)

14
ARR-ave. = NIAT
(P400,000/2)

= P80,000
P200,000

= 40%

EXERCISES (MULTIPLE-CHOICE)

1. The technique that does not use cash flow for capital investment decisions.
a. Payback b. NPV c. ARR d. IRR

2. Which of the following groups of capital budgeting techniques uses the time value of money?
a. Book rate of return, payback and profitability index c. IRR, ARR and PI
b. IRR, payback and NPV d. IRR, NPV and PI

3. Cost of capital is 3%; economic life in years = 4 years; simple PV factor for year 4 is
a. 0.915 b. 0.888 c. 0.455 d. 0.350

4. Discount rate is 11%; economic life in years = 3 years; PV annuity factor for 3 years is
a.0.731 b. 1.713 c. 2.444 d. 3.102

5. As the discount rate increases,


a. Present value factors increase c. Present value factors remain constant
b. Present value factors decrease d. It is impossible to tell what happens to the factors

6. The PVF of any amount at year zero or zero percent is always equal to
a. Zero b. 0.50 c. 1.00 d. cannot be determined

7. The present value of P50,000 due in five years would be highest if discounted at a rate of
a. 0% b. 10% c. 15% d. 20%

8. An investment with a positive NPV also has


a. A positive PI b. A PI of one c. A PI less than one d. A PI greater than one

9. A company is considering the purchase of an investment that has a positive NPV based on a 12% discount rate of. What is the
IRR?
a. Zero b. 12% c. Greater than 12% d. Less than 12%

10. Which of the following combinations is possible?


Profitability index NPV IRR
a. >1 Positive = cost of capital
b. >1 Negative < cost of capital
c. <1 Negative < cost of capital
d. <1 Positive < cost of capital

11. The NPV method assumes that the project’s cash flows are reinvested at the
a. Internal rate of return b. Simple rate of return c. Cost of capital d. Payback period

12. The internal rate of return method assumes that the project’s cash flows are reinvested at the
a. Internal rate of return b. Simple rate of return c. Required rate of return d. Payback period

13. Which one of these methods is a project ranking method rather than project screening method?
a. NPV method b. Simple rate of return c. Profitability index d. Sophisticated rate of return

14. If the IRR on an investment is zero,


a. Its NPV is positive c. It is generally a wise investment
b. Its annual cash flows equal its required investment d. Its cash flows decrease over its life

15. If a company’s required rate of return is 12 percent and in using the profitability index method, a project’s index is greater than
1.0, this indicates that the project’s rate of return is
a. equal to 12 percent. c. less than 12 percent.
b. greater than 12 percent. d. dependent on the size of the investment.

15
16. In choosing from among mutually exclusive investments the manager should normally select the one with the highest
a. Net present value c. Profitability index.
b. Internal rate return d. Book rate of return.

16

You might also like