Financial Analysis: Capital Budgeting for Printer Replacement at CQU

Verified

Added on  2020/05/16

|23
|3336
|151
Report
AI Summary
This report provides a comprehensive analysis of capital budgeting techniques applied to the decision of replacing printers at CQU Printing. The report evaluates two printer options (Printer A and Printer B) using Net Present Value (NPV), Payback Period, and Internal Rate of Return (IRR) methods. It includes detailed calculations of initial investments, operating cash flows, and terminal cash flows for each printer. The analysis compares the financial performance of each printer based on the different capital budgeting techniques, and provides a graphical representation of the IRR profiles with NPVs. The report concludes that Printer B is the more favorable investment option, as it demonstrates more positive outcomes across the various financial metrics. The report also addresses decision-making under different scenarios, such as unlimited funds.
Document Page
Running Head: Appraisal of Capital Investments
Capital Budgeting Decisions
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Appraisal of Capital Investments 1
Executive summary:
In this report, various capital budgeting techniques have been discussed and applied to reach at a
conclusion regarding the decision of replacement of printers held as asset by CQU printing firm
which is engaged in the business of commercial printing. The firm is considering the
replacement the old printer with the new printer to improve the quality of printing and the
operational efficiency. However, there are two choices of printer available in the market and the
firm has to select the best suitable option on the basis of rankings given using various capital
budgeting techniques such as Net present value, Payback period, Internal rate of return etc. In
this report each of these capital investment proposals have been critically evaluated and it is
observed that the firm must go with the option of Printer B as it has more favorable results than
Printer A.
Document Page
Appraisal of Capital Investments 2
Table of Contents
Executive summary.....................................................................................................................................1
Introduction.................................................................................................................................................3
Part A..........................................................................................................................................................3
1. Initial investment.............................................................................................................................3
2. Operating cash flows.......................................................................................................................5
3. Terminal cash flows.........................................................................................................................7
Part B...........................................................................................................................................................8
Cash flow streams....................................................................................................................................8
Part C.........................................................................................................................................................10
1. Payback Period..............................................................................................................................10
2. Net Present Value..........................................................................................................................11
3. Internal Rate of return....................................................................................................................13
Part d.........................................................................................................................................................15
Graphical representation of IRR profiles with NPVs.............................................................................15
Part e......................................................................................................................................................17
i. Conflicts of results.....................................................................................................................17
ii. Decision making under the different situations..........................................................................17
Part f..........................................................................................................................................................18
Conclusion.................................................................................................................................................19
References.................................................................................................................................................20
Appendices................................................................................................................................................22
Document Page
Appraisal of Capital Investments 3
Introduction:
Capital budgeting is the most important part of financial management as it involves evaluation of
decisions regarding the capital investment in any business or project. As a large sum of capital
funds of the firm is investment in these decisions for generally longer terms and it is not easily
possible to reverse the decision once made, such decisions are required to be made after
assessing all the potential benefits and risks involved in the possible investment plans. To
evaluate each proposal of capital investment the project or business managers must use various
techniques of capital budgeting such as Net present value, Payback period or Internal rate of
return etc.
In the instant case of CQU Printers, the firm has to critically evaluate the replacement decision
and the year in which such decision must be implemented. Also, the firm has to select the most
appropriate investment option between Printer A or Printer B so as to increase its profitability
with the efficient utilization of resources available with it.
Part A
1. Initial investment:
Initial investment is the deployment of capital funds in the acquisition and installation of an asset
to the business or to undertake any project. It is made in the base year. In the given case, the firm
is selling the old printer and the value realized on its sale will be deducted from the cost of new
printer. Cost of new printer will include both the acquisition and installation cost (Correia &
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Appraisal of Capital Investments 4
Cramer, 2008). The initial investment required to be made in the replacement printers are
determined below.
Printer A
Cost of Printer
$
830,000.00
Add: Installation cost
$
40,000.00
Total Cost
$
870,000.00
Less: Inflow from sale of old printer
$
420,000.00
Net capital investment
$
450,000.00
Printer B
Cost of Printer B
$
640,000.00
Add: Installation cost
$
20,000.00
Total Cost
$
660,000.00
Less: Inflow from sale of old printer $
Document Page
Appraisal of Capital Investments 5
420,000.00
Net capital investment
$
240,000.00
2. Operating cash flows:
Operating cash flows associated with any asset or business covers both inflow as well as outflow
of cash from the normal operations of the business. In this case, the profits earned by the firm
with the use printers are taken as operating cash flows (Danielson & Scott, 2006). The operating
cash flows of replacement printers are calculated following the incremental approach where the
profits before depreciation and depreciation.
Refer Appendices
PRINTER A
Y
ea
r
Cash Flows
Of Printer A
Cash Flows
Of Old
Printer
Incremental
Cash Flows
Tax
@30%
Cash
Flows
After Tax
Depreci
ation
Total
Cash
Flows
0 ($90,400.00) 0
$ -
90,400.00
$ -
90,400.00
$ -
90,400.00
1
$
84,700.00
$
70,000.00
$
14,700.00
$
4,410.00
$
10,290.00
$
115,300.
00
$
125,590.0
0
2 $
104,700.00
$
70,000.00
$
34,700.00
$
10,410.0
$ $
115,300.
$
139,590.0
Document Page
Appraisal of Capital Investments 6
0 24,290.00 00 0
3
$
134,700.00
$
70,000.00
$
64,700.00
$
19,410.0
0
$
45,290.00
$
115,300.
00
$
160,590.0
0
4
$
164,700.00
$
70,000.00
$
94,700.00
$
28,410.0
0
$
66,290.00
$
115,300.
00
$
181,590.0
0
5
$
204,700.00
$
70,000.00
$
134,700.00
$
40,410.0
0
$
94,290.00
$
115,300.
00
$
209,590.0
0
PRINTER B
Ye
ar
Cash Flows
Of Printer B
Cash Flows
Of Old
Printer
Incremental
Cash Flows
Tax
@30%
Cash
Flows
After Tax
Deprecia
tion
Total
Cash
Flows
0 $0.00 0
$
-
$
-
$
-
1
$
84,600.00
$
70,000.00
$
14,600.00
$
4,380.00
$
10,220.00
$
75,400.00
$
85,620.00
2
$
84,600.00
$
70,000.00
$
14,600.00
$
4,380.00
$
10,220.00
$
75,400.00
$
85,620.00
3 $ $ $ $ $ $ $
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Appraisal of Capital Investments 7
84,600.00 70,000.00 14,600.00 4,380.00 10,220.00 75,400.00 85,620.00
4
$
84,600.00
$
70,000.00
$
14,600.00
$
4,380.00
$
10,220.00
$
75,400.00
$
85,620.00
5
$
84,600.00
$
70,000.00
$
14,600.00
$
4,380.00
$
10,220.00
$
75,400.00
$
85,620.00
Therefore total incremental operating cash flows of printer A are $725550 and that of printer B
are $ 428100.
3. Terminal cash flows:
The cash flows from activities other than operating and that occur in the last year of project
duration or useful life of the concerned asset, are the terminal cash flows of the project or
business. In the given case, the useful life of all the printers is 5 years and at the end of 5th year
the new printers are expected to be sold out by the firm. Therefore, the value realized on sale of
printers will be the terminal cash flows of the business. The capital gain taxation has been
ignored while calculating the terminal cash flows as per the requirement of the case.
Particular PRINTER A PRINTER B
Salvage value (at 5th yearend)
$
400,000.00 $ 330,000.00
Document Page
Appraisal of Capital Investments 8
Part B
Cash flow streams
Cash flow stream associated with each of the replacement printer will encompass the initial
investment net of amount realized on sale of old printer, net operating cash flows after tax and
depreciation and the terminal cash flows. All these cash flows are discounted at the rate given in
the question to determine the present value of the cash flows.
PRINTER A
Year Cash Flows Amount of Cash Flows
PVF @
14% Present Values
0
Initial
Investment
$ -
450,000.00 1.000 $ (450,000.000)
0
Changes in
cash balance
$ -
90,400.00 1.000 $ (90,400.000)
1
Incremental
CFATS
$
125,590.00 0.877 $ 110,166.667
2
Incremental
CFATS
$
139,590.00 0.769 $ 107,409.972
3
Incremental
CFATS
$
160,590.00 0.675 $ 108,393.676
4
Incremental
CFATS
$
181,590.00 0.592 $ 107,515.858
5 Incremental $ 0.519 $ 108,854.478
Document Page
Appraisal of Capital Investments 9
CFATS 209,590.00
5
Terminal
Cash Flows
$
356,500.00 0.519 $ 185,154.929
$ 187,095.580
PRINTER B
Year Cash Flows Amount of Cash Flows
PVF @
14% Present Values
0
Initial
Investment
$ -
240,000.00 1.000 $ (240,000.000)
1
Incremental
CFATS
$
85,620.00 0.877 $ 75,105.263
2
Incremental
CFATS
$
85,620.00 0.769 $ 65,881.810
3
Incremental
CFATS
$
85,620.00 0.675 $ 57,791.061
4
Incremental
CFATS
$
85,620.00 0.592 $ 50,693.913
5
Incremental
CFATS
$
85,620.00 0.519 $ 44,468.345
5
Terminal
Cash Flows
$
297,000.00 0.519 $ 154,252.493
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Appraisal of Capital Investments 10
$ 208,192.886
Part C:
1. Payback Period:
In capital budgeting, the time period required to recoup the invested funds in the project is called
as the payback period. This is the breakeven point at which the project earns as much of the
returns as required to cover the initial cost of project. At this point the project is neither at loss
nor at profit (Bennouna, Meredith & Marchant, 2010). Payback period of any project or asset is
an important capital budgeting technique to determine the project feasibility. As a general rule
projects with lower payback periods are preferable as they have the capacity of recovering the
cost of project quickly than the projects with longer payback periods.
In the given case, Printer B has a payback period of 2.80 years and Printer A has a payback
period of 3.63 years, hence Printer B must be selected by the firm as cash inflows of printer B
are capable of recovering the cost of printers in shorter duration than printer A.
PRINTER A
Year Cash flows
Cumulative Cash
flows
0 $ -540,400.00 -540400.000
1 $ 125,590.00 -414810.000
2 $ 139,590.00 -275220.000
Document Page
Appraisal of Capital Investments 11
3 $ 160,590.00 -114630.000
4 $ 181,590.00 66960.000
5 $ 209,590.00 276550.000
Paybac
k period 3.63 years
PRINTER B
Year Cash flows
0 $ -240,000.00 -240000.000
1 $ 85,620.00 -154380.000
2 $ 85,620.00 -68760.000
3 $ 85,620.00 16860.000
4 $ 85,620.00 102480.000
5 $ 85,620.00 188100.000
Paybac
k period 2.80 years
2. Net Present Value:
Net present value is a valuable tool used in capital budgeting to assess the project’s success. It is
the difference between the present value of cash inflows associated with the assets and the
present value of cash outflows (Dayananda, 2002). Present values of cash flows are calculated
taking into account the time value of money and therefore the cash flows of the project are
Document Page
Appraisal of Capital Investments 12
discounted using the discounting rate of return. The project which has positive NPV is profitable
to be invested in but when all the proposed investments have positive NPV, the project with
higher NPV is selected (Baker & English, 2011).
In the present case, NPVs of both the investment options i.e. Printer A and Printer B are
calculated using the discounting rate of 14%. The NPV of project A is greater than Project B’s
NPV and hence Printer A is preferred over Printer B as project A is more profitable in terms of
returns.
PRINTER A
Year Cash flows PVF PV of Cash Flows
0 $ -540,400.00 1 $ -540,400.00
1 $ 125,590.00 0.877
$
110,166.67
2 $ 139,590.00 0.769
$
107,409.97
3 $ 160,590.00 0.675
$
108,393.68
4 $ 181,590.00 0.592
$
107,515.86
5 $ 566,090.00 0.519
$
294,009.41
NPV $
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Appraisal of Capital Investments 13
187,095.58
PRINTER B
Year Cash flows PVF PV of Cash Flows
0 $ -240,000.00 1.000 $ -240,000.00
1 $ 85,620.00 0.877
$
75,105.26
2 $ 85,620.00 0.769
$
65,881.81
3 $ 85,620.00 0.675
$
57,791.06
4 $ 85,620.00 0.592
$
50,693.91
5 $ 382,620.00 0.519
$
198,720.84
NPV 208192.89
3. Internal Rate of return:
It is the important technique of capital budgeting as it is used to measure the profitability of the
investments. At this rate the NPV of the project is zero (Truong, Partington & Peat, 2008).
Higher internal rate of return of a project is desirable (Brijlal, 2008).
Document Page
Appraisal of Capital Investments 14
In this case the IRR of printer B is 37.93% and printer A is 24.40% and hence printer B must be
selected.
PRINTER A
Yea
r Cash flows
0 $ -540,400.00
1 $ 125,590.00
2 $ 139,590.00
3 $ 160,590.00
4 $ 181,590.00
5 $ 566,090.00
IRR 24.40%
PRINTER B
Yea
r Cash flows
0 $ -240,000.00
1
$
85,620.00
2
$
85,620.00
3 $
Document Page
Appraisal of Capital Investments 15
85,620.00
4
$
85,620.00
5 $ 382,620.00
IRR 37.931%
Part d
Graphical representation of IRR profiles with NPVs
Printer A
Data Table
NPV Rates
$187,095.58 14.00%
$69,201.07 20.00%
$36,188.35 22.00%
($1.00) 24.40%
($8,492.68) 25.00%
($35,419.16) 27.00%
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Appraisal of Capital Investments 16
14.00% 20.00% 22.00% 24.40% 25.00% 27.00%
($50,000.00)
$0.00
$50,000.00
$100,000.00
$150,000.00
$200,000.00
IRR (A)
IRR
Discouting Rates
NPV
Printer B
Data Table
NPV Rates
$ 208,192.89
14.00
%
$ 48,524.22
30.00
%
$ 16,308.11
35.00
%
$ 2.23
37.93
%
$ (10,526.74) 40.00
Document Page
Appraisal of Capital Investments 17
%
$ (33,081.58)
45.00
%
14.00% 30.00% 35.00% 37.93% 40.00% 45.00%
$(50,000.00)
$-
$50,000.00
$100,000.00
$150,000.00
$200,000.00
$250,000.00
IRR (B)
IRR (B)
Discounting Rates
NPV
Part e
i. Conflicts of results:
Since both the capital budgeting techniques i.e. NPV and IRR are providing the favorable
results for the investment in Printer B, there is no conflict of choice under both the
techniques. Under both the techniques Printer B is ranked above Printer A. Hence it can
be observed that printer B is more profitable than printer A.
ii. Decision making under the different situations:
Unlimited Funds:
Document Page
Appraisal of Capital Investments 18
Whenever firm has unlimited funds to utilize in the capital investments, the
decision become making quite simple and it can be based on the returns generated
by the investment proposals (Perold, 2005). If the firm has unlimited funds it can
invest in purchasing both the printers as it will enhance its productivity and
thereby it will contribute to generation of higher revenues from the business
(Peterson & Fabozzi, 2002). As the NPVs of both the printers are positive it can
be said that investment in both the printers will bring profitability for the
business.
Capital Rationing:
It is the situation in which the business is short of funds. When the funds
requirement is more than the availability of funds, the situation of capital
rationing arises. In such situations all the proposed capital investment plans e
ranked on certain basis whether it is based on the risk or returns attached to the
investment proposals (Bierman & Smidt, 2012). Then the project with least risk
and maximum possible return is selected for the investment purpose. In the
current situation, the company must choose to invest in Printer B as per the
outcomes of application of NPV and IRR techniques.
Part f
The consistency of cash flows reduces the risk of the concerned investment plan as there is no
uncertainty attached to the quantum of cash flows that the project is going to generate in the
future years (Ross, Westerfield & Jaffe, 2002). However, with the lower risk, the project is also
not able to offer higher returns to the managers. Whereas, in case of fluctuating returns, there is
higher risk involved with the project due to the uncertainties of quantum of cash inflows to be
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
Appraisal of Capital Investments 19
generated in future (Correia & Cramer, 2008). However, since there always remains the
probability of earning higher returns. In this case Printer B is offering uniform profits for all the
years hence it is less risky and at the same time it is offering less returns. On the other hand,
printer A is offering higher returns as there is higher risk involved. If the firm is not open to take
risk then it must not go with printer A rather it should invest in printer B as it will provide
uniformity of returns each year (Ehrhardt & Daves, 2000).
Conclusion:
On the overall basis it can concluded that capital investment decisions are significant part of
project planning as they involve huge funds and are generally irreversible and hence all the
proposed investment plans needs to be critically analyzed before reaching on any decision. In the
present case, it is observed that investment in Printer B is more beneficial.
Document Page
Appraisal of Capital Investments 20
References
Baker, H. K., & English, P. (2011). Capital budgeting valuation: Financial analysis for today's
investment projects (Vol. 13). John Wiley & Sons.
Bennouna, K., Meredith, G. G., & Marchant, T. (2010). Improved capital budgeting decision
making: evidence from Canada. Management decision, 48(2), 225-247.
Bierman Jr, H., & Smidt, S. (2012). The capital budgeting decision: economic analysis of
investment projects. Routledge.
Brijlal, P. (2008). The use of capital budgeting techniques in businesses: A perspective from the
Western Cape.
Correia, C., & Cramer, P. (2008). An analysis of cost of capital, capital structure and capital
budgeting practices: a survey of South African listed companies. Meditari accountancy
research, 16(2), 31-52.
Danielson, M. G., & Scott, J. A. (2006). The capital budgeting decisions of small
businesses. Journal of Applied Finance, 16(2), 45.
Dayananda, D. (2002). Capital budgeting: financial appraisal of investment projects. Cambridge
University Press.
Ehrhardt, M. C., & Daves, P. R. (2000). Capital budgeting: The valuation of unusual, irregular,
or extraordinary cash flows. Financial practice and education, 10, 106-114.
Document Page
Appraisal of Capital Investments 21
Perold, A. F. (2005). Capital allocation in financial firms. Journal of Applied Corporate
Finance, 17(3), 110-118.
Peterson, P. P., & Fabozzi, F. J. (2002). Capital budgeting: theory and practice (Vol. 10). John
Wiley & Sons.
Ross, S. A., Westerfield, R. W., & Jaffe, J. F. (2002). Corporate Finance.
Truong, G., Partington, G., & Peat, M. (2008). Cost-of-capital estimation and capital-budgeting
practice in Australia. Australian journal of management, 33(1), 95-121.
tabler-icon-diamond-filled.svg

Secure Best Marks with AI Grader

Need help grading? Try our AI Grader for instant feedback on your assignments.
Document Page
Appraisal of Capital Investments 22
Appendices
Workings =
1)
Depreciation as per straight line method is calculated using the following formula:
Cost of Printers- Book value
Useful life
Old Printer = 400000-150000
5
= 50000
Printer A
= 870000-43500
5
=165300
Printer B
=660000-33000
5
=125400
chevron_up_icon
1 out of 23
circle_padding
hide_on_mobile
zoom_out_icon
[object Object]