Your calculations for the amount of property, plant, and equipment and the annual depreciation for the project ? Your calculations t
I have attached a copies of my draft to go off of. I will be needing a
narrated PowerPoint presentation that will highlight the following items.
· Your calculations for the amount of property, plant, and equipment and the annual depreciation for the project
· Your calculations that convert the project's EBIT to free cash flow for the 12 years of the project.
· The following capital budgeting results for the project
o Net present value
o Internal rate of return
o Discounted payback period.
· Your discussion of the results that you calculated above, including a recommendation for acceptance or rejection of the project
Once again, you may embed your Excel spreadsheets into your document. Be sure to follow APA standards for this project.
The back information.
You have recently assumed the role of CFO at your company. The company's CEO is looking to expand its operations by investing in new property, plant, and equipment. You are asked to do some capital budgeting analysis that will determine whether the company should invest in these new plant assets.
Signature Assignment Parameters
Select a company, download the most recent copy of the company's 10-K report, and submit your company choice to your professor for approval.
The parameters for deliverable are as follows.
· The firm is looking to expand its operations by 10% of the firm's net property, plant, and equipment. (Calculate this amount by taking 10% of the property, plant, and equipment figure that appears on the firm's balance sheet.)
· The estimated life of this new property, plant, and equipment will be 12 years. The salvage value of the equipment will be 5% of the property, plant and equipment's cost.
· The annual EBIT for this new project will be 18% of the project's cost.
· The company will use the straight-line method to depreciate this equipment. Also assume that there will be no increases in net working capital each year. Use 35% as the tax rate in this project.
· The hurdle rate for this project will be the WACC that you are able to find on a financial website, such as Gurufocus.com. If you are unable to find the WACC for a company, contact your instructor. He or she will assign you a WACC rate.
Running head: CAPITAL BUDGETING 1
CAPITAL BUDGETING
4
Capital Budgeting
Introduction
Walmart is the largest retail company that is founded by Sam Walton in the mid of 1962. According to the annual report of 2021, the total employees that work in Walmart are 2.3 million. Walmart enables people all over the globe to save finances as well as lead happy lives by allowing them to shop online as well as in retail stores. The company seeks to constantly enhance customer satisfaction that works seamlessly with the firm retail stores as well as eCommerce in an omnichannel providing that saves patrons time via innovation (Report, 2021). Every week, the organization provides over two hundred and forty million patrons who visit roughly eleven thousand, and four hundred stores as well as multiple eCommerce sites in twenty-six states under fifty-four banners. In this report, we will do a capital-budgeting analysis and determine whether Walmart should invest its money in purchasing new assets. The three methods that will employ in capital budgeting evaluation are net-present value, payback period and the rate of return.
Net-Present-Value
Any investment entails a preliminary cash-outflow to charge for it, accompanied by a combination of funds-inflows in the manifestation of income or a decrease in current cash flows due to incurred expenses. The conventional approach to assessing capital propositions is net-present-value because it is premised on a singular factor – cash-flows – which could be utilized to evaluate any proposal coming from any place in a corporation (Knoke, Gosling, & Paul, 2020). Walmart wants to invest its money in purchasing a new asset for the company. When the NPV of any project is negative then it means a project or investment is not beneficial for the company and the company does not need to invest its capital in the particular project. On the other side, if the NPV of any project is one or greater than one then that means the company should invest its capital in that particular project because that shows the company can earn profit from that investment (Arshad, 2012). The total investment required for purchasing an asset is 10 percent of property, plant & equipment, which is equal to 9,220 million dollars. However, the cash-flows are 1,213.21 million dollars. The result of NPV is 1989.66 million dollars, which means Walmart should invest its capital in purchasing the asset because it is beneficial for the company, and after the sometimes company will make a profit from its investment.
Accounting-Rate-of-Return
ARR refers to the anticipated proportion of return/investment on an asset or investment in comparison to the preliminary invested cost. It is generally utilized to create investment choices. Accounting-Rate-of-Return is among the greatest methods for calculating the probable profit margins of a capital invested, creating it a useful tool for deciding which investment, asset, or long-term plan to spend in (Warren & Jack, 2018). For instance, if a firm wants to choose whether it should invest in a particular project, the calculation of ARR allows the company to decide whether investing in a particular project or asset is beneficial for the company or not. For calculating the ARR, to begin with, we subtracted the value of depreciation expense by the cash flow, then we divide it by the investment cost of the asset. The value of accounting-rate-of-return is 8.99 percent. That means, for every dollar that Walmart invests in purchasing the new asset, it will get 8.99 dollars in return, which is quite beneficial for the company.
Payback Period
The payback-period refers to the amount-of-time a project need to regain the investment cost. In simple terms, it refers to the time required for an investment to reach its breakeven point. Corporations as well as people actually invest primarily to be paid back, hence this is the key reason that the payback has become so critical (Mahlia, Razak, & Nursahida, 2011). In essentially, the narrower the payback period of an investment, the much more appealing this becomes. Deciding the payback time is helpful for anyone (corporations or individual investors alike) as well as can be accomplished by dividing the original investment of the project by the average-net-cash-flows. It is calculated by dividing the initial investment of the project by cash flows (Wan, Xia, & Zhu, 2020). The initial investment is 9220.10 million dollars and the cash flow is 1213.20 million dollars, the value that we get after the analysis is 7.5997 years. That means, if Walmart invests its capital on purchasing the new assets then they invest will take more than seven years to reach its point of breakeven. In other words, after approximately seven years and seven months, the company will get profit from the investment-cost. Payback-period outcome indicates that Walmart should invest its capital in purchasing the new assets because, after seven years and seven months, it will start earning a profit on the new assets.
Conclusion
To sum up, Walmart is a retail company that is operating its stores in several countries. The purpose of the analysis is to determine whether it is beneficial for Walmart to invest its capital in purchasing new assets for the company. Three methods that are utilized for the capital-budgeting evaluation are payback-period, NPV as well as ARR. The NPV of Walmart for investing in the new asset is 1989.66 million dollars which are positive, secondly, the payback period of the project is seven years and seven months. However, the accounting-rate-of-return of the investment is 8.99 percent. As company’s NPV value is positive and ARR is higher than 7 percent that means Walmart will get profit from this investment. In other words, Walmart should invest its capital in purchasing the new plant-assets because new assets will help the company in generating more return as well as profit.
References Arshad, A. (2012). Net present value is better than internal rate of return. Interdisciplinary journal of contemporary research in business , 211-219. Knoke, T., Gosling, E., & Paul, C. (2020). Use and misuse of the net present value in environmental studies. Ecological Economics. Mahlia, T. M., Razak, H., & Nursahida, M. (2011). Life cycle cost analysis and payback period of lighting retrofit at the University of Malaya. Renewable and Sustainable Energy Reviews, 1125-1132. Report, A. (2021). Walmart Inc. Form 10-K, 6-82. Wan, J., Xia, Z.-h., & Zhu, X.-p. (2020). Investment Payback Period Calculating Model for Airport Bridge Facility. Mathematical Problems in Engineering. Warren, L., & Jack, L. (2018). The capital budgeting process and the energy trilemma-A strategic conduct analysis. The British Accounting Review, 481-496.
,
Capital Budgeting Analysis
WACC | 4.27% | Capital Budgeting Analysis | |||||||||
Life | 12 | ||||||||||
Depreciation | $384.17 | ||||||||||
Property, Plant and Equipment | 92,201 | Cash flows | |||||||||
Investment cost ([email protected]%) | 9,220.10 | EBIT | 1659.618 | ||||||||
Salvage value (5%@PPE) | 4610.05 | Depreciation Expense | $384.17 | ||||||||
EBIT (18 %@ project cost) | 1659.618 | Income Before Taxes | $1,275.45 | ||||||||
Tax Rate | 35% | Taxes | $446.41 | ||||||||
Net Income | $829.04 | ||||||||||
Add Back Depreciation | $384.17 | ||||||||||
Cash flow from operations | $1,213.21 | ||||||||||
Net Present Value | Payback Period | Rate of Return | |||||||||
Year | Cash Inflow | PV Value | Year | Cash flows | Balance | ||||||
0 | -9,220 | ($9,220.10) | 0 | -9,220 | -9,220 | Year | Annual Cash Inflows | ||||
1 | $1,213.21 | $1,163.53 | 1 | $1,213.21 | -8,007 | 1 | $1,213.21 | ||||
2 | $1,213.21 | $1,115.88 | 2 | $1,213.21 | -6,794 | 2 | $1,213.21 | ||||
3 | $1,213.21 | $1,070.18 | 3 | $1,213.21 | -5,580 | 3 | $1,213.21 | ||||
4 | $1,213.21 | $1,026.36 | 4 | $1,213.21 | -4,367 | 4 | $1,213.21 | ||||
5 | $1,213.21 | $984.33 | 5 | $1,213.21 | -3,154 | 5 | $1,213.21 | ||||
6 | $1,213.21 | $944.02 | 6 | $1,213.21 | -1,941 | 6 | $1,213.21 | ||||
7 | $1,213.21 | $905.36 | 7 | $1,213.21 | -728 | 7 | $1,213.21 | ||||
8 | $1,213.21 | $868.28 | 8 | $1,213.21 | 486 | 8 | $1,213.21 | ||||
9 | $1,213.21 | $832.73 | 9 | $1,213.21 | 1,699 | 9 | $1,213.21 | ||||
10 | $1,213.21 | $798.62 | 10 | $1,213.21 | 2,912 | 10 | $1,213.21 | ||||
11 | $1,213.21 | $765.92 | 11 | $1,213.21 | 4,125 | 11 | $1,213.21 | ||||
12 | $1,213.21 | $734.55 | 12 | $1,213.21 | 5,338 | 12 | $1,213.21 | ||||
7.5997 | Total Cash Inflows | $14,558.54 | |||||||||
NPV | $1,989.66 | Payback Period | 7.5997 years | Total Years | 12 | ||||||
Average Annual Cash Flows | $1,213.21 | ||||||||||
Cost of Investment | 9220.10 | ||||||||||
Residual value | 4610.05 | ||||||||||
Annual Depreciation Expenses | 384.17 | ||||||||||
ARR | 8.99 |
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.