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.
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.
> .2 %
Capital Budgeting Analysis 2
4.17
2,2 1
%)
9.618
$ 1659.618 Taxes $384.17 Year Cash flows 0 -9,220 -9,220 Year 1 $1,213.21 1 $1,213.21 5.88
2 $1,213.21 2 $1,213.21 3 $1,213.21 3 $1,213.21 4 $1,213.21 4 $1,213.21 5 $1,213.21 5 $1,213.21 6 $1,213.21 6 $1,213.21 7 $1,213.21 7 $1,213.21 8 $1,213.21 8 $1,213.21 9 $1,213.21 9 $1,213.21 10 $1,213.21 10 $1,213.21 11 $1,213.21 11 $1,213.21 12 $1,213.21 12 $1,213.21 Payback Period 12 $1,213.21 4610.05 384.17
2
Capital Budgeting Analysis
WACC
4
7
Life
1
Depreciation
$
3
8
Property, Plant and Equipment
9
0
Cash flows
Investment cost (PPE@
10
9,220.10
EBIT
1
6
5
Salvage value (5%@PPE)
4610.05
Depreciation Expense
384.17
EBIT (18 %@ project cost)
Income Before
Taxes
$1,275.45
Tax Rate
35%
$446.41
Net Income
$829.04
Add Back Depreciation
Cash flow from operations
$1,213.21
Net Present Value
Payback Period
Rate of Return
Year
Cash Inflow
PV Value
Balance
0
-9,220
($9,220.10)
Annual Cash Inflows
1 $1,213.21
$1,163.53
-8,007
2 $1,213.21
$1,
11
-6,794
3 $1,213.21
$1,070.18
-5,580
4 $1,213.21
$1,026.36
-4,367
5 $1,213.21
$984.33
-3,154
6 $1,213.21
$944.02
-1,941
7 $1,213.21
$905.36
-728
8 $1,213.21
$868.28
486
9 $1,213.21
$832.73
1,699
10 $1,213.21
$798.62
2,9
12
11 $1,213.21
$765.92
4,125
12 $1,213.21
$734.55
5,338
7.5997
Total Cash Inflows
$14,558.54
NPV
$1,989.66
7.5997 years
Total Years
Average Annual Cash Flows
Cost of Investment
9220.10
Residual value
Annual Depreciation Expenses
ARR
8.99
Order your essay today and save 25% with the discount code: STUDYSAVE
