Application of Capital Budgeting for MAGIC TIMBER AND STEEL PTY LTD.edited (1)

docx

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

Report
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