Application of Capital Budgeting for MAGIC TIMBER AND STEEL PTY LTD.edited (1)
docx
keyboard_arrow_up
School
University of Nairobi *
*We aren’t endorsed by this school
Course
100
Subject
Finance
Date
Nov 24, 2024
Type
docx
Pages
13
Uploaded by ConstableTeam19431
1
Application of Capital Budgeting for Magic Timber and Steel Pty. Ltd
Student’s Name
Institutional Affiliation
Instructor
Course
Date
2
Executive Summary
This report thoroughly analyzes Magic Timber and Steel's investment decision on whether to retain the existing finishing machine (Matrix750) or acquire the new Delta one. The report recommends using Net Present Value (NPV) analysis, sensitivity analyses, and qualitative insights. Calculations of net present value (NPV) using a 10% discount rate and a 30% tax rate highlight the financial ramifications of both approaches. Our findings, supported by sensitivity analysis, show that keeping the Matrix 750 machine results in higher NPV values. Qualitative aspects like market trends and strategic alignment influence our thorough proposal. Therefore, we advise Magic Timber and Steel to keep the current Matrix machine in working order. This move guarantees higher financial returns and aligns with the Company's overarching objectives, assuring wise capital allocation.
Introduction
Capital budgeting plays a pivotal role in businesses' strategic decision-making, enabling businesses to allocate funds effectively and invest in projects wisely. This procedure entails assessing the financial viability of new investments and coordinating them with organizational objectives. Net Present worth (NPV) analysis, which considers the time worth of money and evaluates the profitability of initiatives, is one extensively used strategy (Knoke et al., 2020). The
case study "Magic Timber and Steel: Investment Evaluation with Net Present Value" is examined
in this report. The choice Magic Timber and Steel must make is whether to buy a new Delta finishing machine or keep using the current Matrix machine as the focus of the study. This report
intends to assist the Company in making the best investment decision by completing an extensive
NPV analysis, sensitivity analyses, and qualitative considerations.
3
Problem Statement
The main problem facing the Magic Timber and Steel Company is to choose between purchasing the new Delta finishing machine and preserving the current Matrix machine. Picking an option that is financially, strategically solid, and compatible with the firm's objectives is the main problem.
Methodology
This report provides an organized approach to aid the decision-making process for Magic Timber and Steel. The main strategy uses Net Present Value (NPV) analysis, a well-known method for assessing investment projects. NPV accounts for the influx and outflow of cash throughout an investment by considering the time value of money. A 10% discount rate accounts for the time value of money, while a 30% tax rate accounts for the effect of taxes on cash flows (Farrar, 2020). This methodology supports decision-making by comparing NPV values between choices. Sensitivity analysis strengthens the evaluation by assessing how changes in important factors affect results, resulting in a solid and well-informed recommendation.
Cash Flow Analysis
Matrix 750
Year 1
Salvage Value: $35,000
Maintenance Costs: -$28,000 (initial maintenance cost)
Depreciation: -$6,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4
Total for Year 1 = $1,000
Year 2
Maintenance Costs: -$7,000
Depreciation: -$6,000
Total for Year 2 =
-$13,000
Year 3
Maintenance Costs: -$7,000
Scheduled Service: -$4,000
Depreciation: -$6,000
Total for Year 3 = -$17,000
Year 4
Maintenance Costs: -$7,000
Depreciation: -$6,000
Total for Year 4 = -$13,000
Year 5
Salvage Value: $5,000
Maintenance Costs: -$7,000
5
Depreciation: -$6,000
Machine Sales: $5,000
Total for Year 5 = -$3,000
Total Cash Flows (Matrix) for 5 Years: $1,000 - $13,000 - $17,000 - $13,000 - $3,000 = -
$45,000
Delta Machine
Year 1
Machine Investment: -$145,000
Labour Savings: $3,150
Electricity Savings: $2,812.50
Maintenance Costs: -$2,000
Depreciation: -$14,500
Total for Year 1
=-$155,537.50
Year 2
Machine Investment: $0
Labour Savings: $3,400
Electricity Savings: $2,887.50
6
Maintenance Costs: -$3,000
Depreciation: -$14,500
Total for Year 2
= -$11,212.50
Year 3
Machine Investment: $0
Labour Savings: $3,650
Electricity Savings: $2,962.50
Maintenance Costs: -$4,000
Depreciation: -$14,500
Total for Year 3
= -$11,887.50
Year 4
Machine Investment: $0
Labour Savings: $3,900
Electricity Savings: $3,037.50
Maintenance Costs: -$5,000
Depreciation: -$14,500
Total for Year 4
= -$12,562.50
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7
Year 5
Machine Investment: $0
Labour Savings: $4,150
Electricity Savings: $3,112.50
Salvage Value: $80,000
Maintenance Costs: -$6,000
Depreciation: -$14,500
Total for Year 5
= $66,762.50
Total Cash Flows (Delta) for 5 Years:
-$155,537.50 - $11,212.50 - $11,887.50 - $12,562.50 + 66,762.50 = - $124,437.50
Non-Cash Flow Analysis
Matrix 750 Option
Depreciation for the Matrix machine is $6,000 per year for the Matrix machine. While it doesn't directly affect cash flows, it significantly reduces taxable income, leading to potential tax savings.
Delta Option
Depreciation for the Delta machine is computed at 10% of the $145,000 initial cost, resulting in $14,500 annually. The Matrix-like depreciation conceals taxable income, resulting in tax advantages.
8
The study produces a more thorough knowledge of the financial implications of the investment by including non-cash flows. It contributes to the overall assessment of the investment alternatives and emphasizes the importance of depreciation in reducing tax liabilities.
Tax Impact Relevant Cash Flows
Both choices have complex tax implications necessary for a precise assessment. Each investment's net cash inflows are greatly influenced by the interaction of cash flows, depreciation, and the applicable tax rate (Knoke et al., 2020). Tax savings from depreciation deductions help the project be profitable and have a positive net present value (NPV) overall.
Cash Flows for NPV
Using the 10% discount rate and 30% tax rate, let's calculate the NPV for each year (1-5) and sum them up to get the NPV values for both options. Matrix 750 Option
Year 1
Cash Flow: $1,000
NPV: $1,000 / (1 + 0.1) ^1 = $909.09
Year 2
Cash Flow: -$13,000
NPV: -$13,000 / (1 + 0.1) ^2 = -$10,743.80
Year 3
9
Cash Flow: -$17,000
NPV: -$17,000 / (1 + 0.1) ^3 = -$12,772.35
Year 4
Cash Flow: -$13,000
NPV: -$13,000 / (1 + 0.1) ^4 = -$8,877.71
Year 5
Cash Flow: -$3,000
NPV: -$3,000 / (1 + 0.1) ^5 = -$1,861.15
Total NPV for Matrix Option: $909.09-$10,743.80-$12,772.35-$8,877.71-$1,861.15=-
$33,345.92
Delta Option
Year 1
Cash Flow: -$155,537.50
NPV: -$155,537.50 / (1 + 0.1) ^1 = -$141,397.73
Year 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
10
Cash Flow: -$11,212.50
NPV
: -$11,212.50 / (1 + 0.1) ^2 = -$9,266.53
Year 3
Cash Flow: -$11,887.50
NPV
: -$11,887.50 / (1 + 0.1) ^3 = -$8,931.25
Year 4
Cash Flow: -$12,562.50
NPV
: -$12,562.50 / (1 + 0.1) ^4 = -$8,580.36
Year 5
Cash Flow: $66,762.50
NPV
: $66,762.50 / (1 + 0.1) ^5 = $41,454.26
Total NPV for Delta Option: -$141,397.73-$9,266.53-$8,931.25-$8,580.36+$41,454.26=-
$126,721.61.
Comparison and Recommendation
A higher NPV indicates a more favorable investment. Therefore, it is evident from the calculations that the Matrix option is a more financially attractive with an NVP score of -
$33,345.92 compared to the Delta option, which has a score of -$126,721.61. Therefore, considering the financial analysis and the calculated NPV values, my recommendation to John Davidson would be to retain and maintain the existing Matrix machine rather than invest in the
11
Delta machine. This decision would result in a more positive net present value over the five years.
Conclusion
In conclusion, this analysis report of Magic Timber and Steel's investment problem has laid a firm foundation for decision-making for the Company. This paper has carefully assessed the financial and strategic implications of the Matrix and Delta choices using sensitivity analysis,
NPV analysis, and qualitative factors. The sound recommendation to keep the current Matrix machine highlighted its greater NPV and compatibility with the organization's goals. This choice foresees probable market difficulties and ensures careful capital allocation. Magic Timber & Steel is now well-positioned to navigate its investment environment with assurance and foresight
because of this report's synthesis of quantitative and qualitative variables, leading to a well-
founded action plan.
12
References
Farrar, S. (2020). Optimization models in capital budgeting. Tax and Optimal Capital Budgeting
Decisions
, pp. 93–107. https://doi.org/10.1201/9780429435812-5
Knoke, T., Gosling, E., & Paul, C. (2020). Use and misuse of the net present value in environmental studies. Ecological Economics
, p. 174
, 106664. https://doi.org/10.1016/j.ecolecon.2020.106664
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
13
Appendix
Related Documents
Related Questions
Part 3: Capital Budgeting and Project Evaluation
Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product. It will require the company to buy a new equipment that will generate the same revenue for the company each year. The table below shows the initial and annual costs for each option.
3.1. Capital Budgeting Decision Making: Perform capital budgeting technique based on Equivalent Annual Cost (EAC) to advise the Company Management which option should be chosen if the relevant discount rate is 9%?
Costs
Option A
Option B
Initial Investment
1,400,000
1,500,000
Year 1
35,000
25,000
Year 2
35,000
25,000
Year 3
35,000
25,000
Year 4
35,000
25,000
Year 5
25,000
3.2. Risk Analysis and Project evaluation:
Assume that the company finally chose Option B. It expects to sell 600,000 units of the new product for an average price of $15 per unit. The…
arrow_forward
Net Present Value (NPV)
In this assignment, you are required to prepare a
PowerPoint presentation reviewing 3 projects. You
will calculate the NPV, IRR, and payback period for
each project. Utilizing the capital budgeting
calculations, you will need to select the best
investment for the company. These calculations will
be based on the following scenario:
AIU Industries has 3 potential projects to consider,
all with an initial cost of $1,250,000. The company
prefers to reject any project with a 4-year cut-off
period for recapturing initial cash outflow. Given the
cost of capital rates and the future cash flow for
each project, determine which project the company
should accept.
Project AProject Project U
Cash Flow
Year 1
250,000 450,000 250,000
Year 2
250,000 450,000 400,000
Year 3
250,000
450,000 600,000
Year 4
250,000
450,000 800,000
Year 5
400,000
400,000 200,000
Year 6
400,000
400,000 800,000
Year 7
400,000 400,000 600,000
Year 8
400,000
400,000 200,000
Cost of Capital
4%
6%
8%
arrow_forward
Subject: accounting
arrow_forward
Calculations to determine which – if any – additional investment opportunities should be undertaken.
1. If the projects are divisible
2. If the projects are not divisible
.
arrow_forward
use excel
arrow_forward
Average rate of return method, net present value method, and analysis for a service company
The capital investment committee of Iguana Inc. is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows:
Year
Robotic AssemblerOperating Income
Robotic AssemblerNet Cash Flow
WarehouseOperating Income
WarehouseNet Cash Flow
1
$47,500
$152,000
$100,000
$243,000
2
47,500
152,000
76,000
205,000
3
47,500
152,000
38,000
144,000
4
47,500
152,000
17,000
99,000
5
47,500
152,000
6,500
69,000
Total
$237,500
$760,000
$237,500
$760,000
Each project requires an investment of $500,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 15% for purposes of the net present value analysis.
Year
6%
10%
12%
15%
20%
1
0.943
0.909
0.893
0.870
0.833
2
0.890
0.826
0.797
0.756
0.694
3
0.840
0.751
0.712
0.658
0.579
4
0.792
0.683
0.636
0.572
0.482
5
0.747…
arrow_forward
Average rate of return method, net present value method, and analysis for a service company
The capital investment committee of Iguana Inc. is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows:
Year
Robotic AssemblerOperating Income
Robotic AssemblerNet Cash Flow
WarehouseOperating Income
WarehouseNet Cash Flow
1
$34,200
$105,000
$72,000
$168,000
2
34,200
105,000
55,000
142,000
3
34,200
105,000
27,000
100,000
4
34,200
105,000
12,000
68,000
5
34,200
105,000
5,000
47,000
Total
$171,000
$525,000
$171,000
$525,000
Each project requires an investment of $360,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis.
Year
6%
10%
12%
15%
20%
1
0.943
0.909
0.893
0.870
0.833
2
0.890
0.826
0.797
0.756
0.694
3
0.840
0.751
0.712
0.658
0.579
4
0.792
0.683
0.636
0.572
0.482
5
0.747
0.621…
arrow_forward
Problem #2 - Chapter 13 – Preference Ranking for Investment Projects
The management of Revco Products is exploring four different investment opportunities, Information on the four projects under study
follows:
Project C
(450,000)
522,970
72,970
Project B
(360,000)
433,400
73,400
Project A
Description
Investment Required ($)
Present value of Cash Inflows ($)
Net Present Value ($)
Life of the Project (in years)
Project D
(270,000)
336,140
66,140
(480,000)
567,270
87,270
6
3
12
6
Internal Rate of Return (%)
18%
19%
14%
16%
Because the company's required rate of return is 10%, a 10% discount rate has been used in the present value computations above.
Limited funds are available for the investment, so the company cannot accept all the available projects.
1) Compute the project profitability index for each investment project.
2) Rank the four projects according to preference in terms of the following metrics:
Net Present Value
b. Project Profitability Index
Internal Rate of Return
a.
c.
3)…
arrow_forward
Using accounting rate of return to make capital investment decisions
Carter Company is considering three investment opportunities with the following accounting rates of return:
Use the decision rule for ARR to rank the projects from most desirable to least desirable. Carter Company’s required rate of return is 8%.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Related Questions
- Part 3: Capital Budgeting and Project Evaluation Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product. It will require the company to buy a new equipment that will generate the same revenue for the company each year. The table below shows the initial and annual costs for each option. 3.1. Capital Budgeting Decision Making: Perform capital budgeting technique based on Equivalent Annual Cost (EAC) to advise the Company Management which option should be chosen if the relevant discount rate is 9%? Costs Option A Option B Initial Investment 1,400,000 1,500,000 Year 1 35,000 25,000 Year 2 35,000 25,000 Year 3 35,000 25,000 Year 4 35,000 25,000 Year 5 25,000 3.2. Risk Analysis and Project evaluation: Assume that the company finally chose Option B. It expects to sell 600,000 units of the new product for an average price of $15 per unit. The…arrow_forwardNet Present Value (NPV) In this assignment, you are required to prepare a PowerPoint presentation reviewing 3 projects. You will calculate the NPV, IRR, and payback period for each project. Utilizing the capital budgeting calculations, you will need to select the best investment for the company. These calculations will be based on the following scenario: AIU Industries has 3 potential projects to consider, all with an initial cost of $1,250,000. The company prefers to reject any project with a 4-year cut-off period for recapturing initial cash outflow. Given the cost of capital rates and the future cash flow for each project, determine which project the company should accept. Project AProject Project U Cash Flow Year 1 250,000 450,000 250,000 Year 2 250,000 450,000 400,000 Year 3 250,000 450,000 600,000 Year 4 250,000 450,000 800,000 Year 5 400,000 400,000 200,000 Year 6 400,000 400,000 800,000 Year 7 400,000 400,000 600,000 Year 8 400,000 400,000 200,000 Cost of Capital 4% 6% 8%arrow_forwardSubject: accountingarrow_forward
- Calculations to determine which – if any – additional investment opportunities should be undertaken. 1. If the projects are divisible 2. If the projects are not divisible .arrow_forwarduse excelarrow_forwardAverage rate of return method, net present value method, and analysis for a service company The capital investment committee of Iguana Inc. is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows: Year Robotic AssemblerOperating Income Robotic AssemblerNet Cash Flow WarehouseOperating Income WarehouseNet Cash Flow 1 $47,500 $152,000 $100,000 $243,000 2 47,500 152,000 76,000 205,000 3 47,500 152,000 38,000 144,000 4 47,500 152,000 17,000 99,000 5 47,500 152,000 6,500 69,000 Total $237,500 $760,000 $237,500 $760,000 Each project requires an investment of $500,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 15% for purposes of the net present value analysis. Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747…arrow_forward
- Average rate of return method, net present value method, and analysis for a service company The capital investment committee of Iguana Inc. is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows: Year Robotic AssemblerOperating Income Robotic AssemblerNet Cash Flow WarehouseOperating Income WarehouseNet Cash Flow 1 $34,200 $105,000 $72,000 $168,000 2 34,200 105,000 55,000 142,000 3 34,200 105,000 27,000 100,000 4 34,200 105,000 12,000 68,000 5 34,200 105,000 5,000 47,000 Total $171,000 $525,000 $171,000 $525,000 Each project requires an investment of $360,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis. Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621…arrow_forwardProblem #2 - Chapter 13 – Preference Ranking for Investment Projects The management of Revco Products is exploring four different investment opportunities, Information on the four projects under study follows: Project C (450,000) 522,970 72,970 Project B (360,000) 433,400 73,400 Project A Description Investment Required ($) Present value of Cash Inflows ($) Net Present Value ($) Life of the Project (in years) Project D (270,000) 336,140 66,140 (480,000) 567,270 87,270 6 3 12 6 Internal Rate of Return (%) 18% 19% 14% 16% Because the company's required rate of return is 10%, a 10% discount rate has been used in the present value computations above. Limited funds are available for the investment, so the company cannot accept all the available projects. 1) Compute the project profitability index for each investment project. 2) Rank the four projects according to preference in terms of the following metrics: Net Present Value b. Project Profitability Index Internal Rate of Return a. c. 3)…arrow_forwardUsing accounting rate of return to make capital investment decisions Carter Company is considering three investment opportunities with the following accounting rates of return: Use the decision rule for ARR to rank the projects from most desirable to least desirable. Carter Company’s required rate of return is 8%.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning