Premium Essay

Capital Budgeting At Home Depot

Submitted By
Words 1787
Pages 8
IV. Capital Budgeting
A. Suppose the company is considering a potential investment project to add to its portfolio. Calculate the following items: Before Home Depot calculates the net present value (NPV), internal rate of return (IRR), terminal value (TV), and modified internal rate of return (MIRR), the company must calculate its FCFs. The calculation begins by subtracting the operating costs and the 20% depreciation expenses from the cash flows derived from sales revenues. Next, the income tax (35%) is subtracted from the resulting operating income to arrive at the company’s after-tax earnings before income tax (EBIT). The final step is for Home Depot to add back the depreciation to the EBIT to arrive at the company’s FCFs. For example, …show more content…
Excel enables Home Depot to calculate MIRR in two ways: (1) the rate function and (2) the MIRR function. The rate function focuses on the number of periods (N), the PV, and the TV. Therefore, the function is Rate (5, -65000000, 115036070.66) and the MIRR is 12.094%. The MIRR function can also be utilized, which focuses on the FCF amounts, the initial outlay, the finance rate, and the re-invest rate. Since there is no re-invest rate, Home Depot’s WACC is utilized twice. Therefore, the function reads MIRR (-65000000, 17225000, 30550000, 23725000, 4225000, 0.08, 0.08) and the result is 12.094%. Home Depot can utilize PV= $115,036,070.66 / (1 + 0.12094)^5 to verify its calculations, which equals its initial outlay of $65,000,000 (Modified Internal Rate of Return (MIRR) 2013) (Ehrhardt & Brigham …show more content…
Before embarking on an investment opportunity, the investor needs to realize that the level of risk impacts the level of return. For example, a lower risk investment will result in a lower return, while a higher risk investment will result in a higher return. In addition, investors need to be mindful of an investment period’s length and the necessity of quick access. Therefore, all factors need considering when balancing an investment portfolio’s risks and returns. Home Depot is deciding on whether to accept or reject an investment opportunity with an initial overlay of $65,000,000. They are utilizing five years worth of FCF and a WACC of 8% to complete calculations that enable them to decide (Balancing risk and return n.d.) (Ehrhardt & Brigham 2017) (Investment risk and return

Similar Documents

Premium Essay

Value Publishing

...case follows the performance-review and financial-statement-forecasting decisions of a Value Line analyst for the retail-building-supply industry in October 2002. The case contrasts the strong operating performance of Home Depot with the strong stock-market performance of Lowe's. Students examine a financial-ratio analysis for Home Depot that acts as a template for generating a comparable ratio analysis for Lowe's. The student ratio analysis is designed to build intuition with respect to interpreting individual ratios as well as ratio interrelationships (e.g., the DuPont framework). The historical-performance comparison suggests that investors are skeptical of the ability of Home Depot to maintain its performance trajectory, yet they project sustained improvements for Lowe's. Students are invited to scrutinize the analyst's five-year income-statement and asset-side balance-sheet forecast for Home Depot. The case expressly focuses on the asset side of the balance sheet as a preview for other cases using free-cash-flow forecasting. The Home Depot forecast exercise exposes students to the mechanics of financial-statement modeling and sensitivity analysis, which they can use in building their own forecast for Lowe's. Finally, the strong-growth assumptions for Home Depot relative to the modest-growth forecast for the industry suggest that the company can be expected to capture massive and perhaps unreasonable market share in the near term. The exercise provides a striking example of...

Words: 328 - Pages: 2

Premium Essay

Financial Statements

...examine the importance and show what business decisions can be made from each statement. In addition, we will look at these financial statements for Home Depot and see what their financial statement say about the company’s financial state. Consolidated Statement of Earnings The Consolidated Statement of Earnings, the income statement, reveals the profit or loss of a company as well as other crucial numbers that investors and creditors will look for. For the Home Depot, their income statement shows that from 2007 to 2009, profit was earned each year. However, profit decreased each year. The decrease in profit is directly related to the decrease of net sales. Home Depot’s expenses decreases along with sales and therefore, they were still able to show a profit. Their net sales decreased significantly from 2008 to 2009, while their cost of sales did not change significantly. The income statement is important because it shows the profitability of a company during the time interval specified in its heading. The period the statement covers is chosen by the business. Normally the period is based on the company’s fiscal year, however may change. The income statement shows revenues, expenses, gains, and, losses Items not included in an income statement are cash receipts and cash disbursements. For the Home Depot, their profitability over the years will look favorably to investors and...

Words: 999 - Pages: 4

Premium Essay

Lowes

...Accounting/Financial Analysis Of Lowe's Inc. Lowe’s is the world’s second largest home improvement retailer and operated 952 stores in forty five states at their fiscal year ending January 30, 2004. The company is currently in the midst of the most aggressive expansion in its history with 130 new stores opened in 2003 and another 140 slated for this year. Lowe’s saw 2003 sales reach approximately $30.8 billion, due largely to their focus on the retail customers and home-improvement projects. Fifty eight years ago Lowe’s began as North Wilkesboro Hardware Company, a neighborhood hardware store fittingly named after the small town it was located in. Owned by partners H. Carl Buchan and James Lowe, this concept was more than a living, it was a vision of creating a chain of hardware stores. The concept was easy and straight forward. Lowe’s concentrated on selling only hardware, appliances and hard-to-find building materials while eliminating wholesalers and dealing directly with manufacturers to establish a reputation of offering the lowest prices. The company went public in 1961 and began trading on the New York Stock Exchange in 1979 (NYSE:LOW). In 1982, Lowe’s had its first billion-dollar sales year, earning a record profit of $25 million, establishing them as an industry force. Lowe’s has posted extremely strong numbers in the past few years and the company has grown rapidly, swelling it’s store base from 500 to over 950. Sales have increased an average of 20% per year...

Words: 4255 - Pages: 18

Premium Essay

Finance Ch 12

...CHAPTER 12 – Practice Problems CASH FLOW ESTIMATION AND RISK ANALYSIS (12-1) Cash flow estimation F I K Answer: b EASY 1. Although it is extremely difficult to make accurate forecasts of the revenues that a project will generate, projects' initial outlays and subsequent costs can be forecasted with great accuracy. This is especially true for large product development projects. a. True b. False (12-1) Relevant cash flows F I K Answer: b EASY 2. Since the focus of capital budgeting is on cash flows rather than on net income, changes in noncash balance sheet accounts such as inventory are not included in a capital budgeting analysis. a. True b. False (12-1) Relevant cash flows F I K Answer: a EASY 3. If an investment project would make use of land which the firm currently owns, the project should be charged with the opportunity cost of the land. a. True b. False (12-2) Depreciation cash flows F I K Answer: a EASY 4. The primary advantage to using accelerated rather than straight-line depreciation is that with accelerated depreciation the present value of the tax savings provided by depreciation will be higher, other things held constant. a. True b. False (12-1) Opportunity costs F I Answer: a MEDIUM 5. Opportunity costs include those cash inflows that could be generated from assets the firm already owns if those assets are not used for the project being evaluated. a. True ...

Words: 1797 - Pages: 8

Free Essay

Indian Literarture

...incorporated under Companies Act,1956. The Corporation had set up 22 field units for carrying arrack operations at capital outlay of Rs. 32.65 crores, various district locations with a total which includes buildings and civil works. The various fixed assets like Plant and Machinery other than buildings valued at Rs. 24.70 crores were transferred to the Corporation in the form of Debt and Equity in the ratio of 2:1. The authorised share capital of the Corporation is Rs.10 Crores and the paid up share capital as on date is Rs.833.37 lakhs. The erstwhile Arrack Bottling units are converted into IML Depots for the wholesale trading activities of IML & BEER. 2.0. OPERATIONS: 2.1. ARRACK PACKING OPERATIONS: (from 1-1-87 to 30-9-93) The Corporation commenced its commercial operations on 1-1-1987 and successfully handled the arrack packing operations from 1.1.1987 to 30.9.93 i.e. till the imposition of ban on arrack by the Government. 2.2. WHOLESALE TRADE OF IML & BEER: (from 1-1-94 to 12-1-95) In pursuance of the Act 15 of 1993 the Corporation took over the wholesale trade of IML and Beer in the State of Andhra Pradesh w.e.f. 1.1.1994 and successfully handled the same till the imposition of Total Prohibition w.e.f. 13.1.1995. The trading activities were carried out 2 through erstwhile arrack bottling unit by converting into IML Wholesale Depots except in...

Words: 6218 - Pages: 25

Free Essay

Planning

...HYBRID COURSE MATERIALS ASSIGNMENTS Acme Mexico City and Application of World-Class Operations and Information Systems Management Techniques and Production Planning and Strategy for Toyota North America (Version 06/01/15) Background Information for Acme Mexico City Acme Home Improvements, Inc. was founded in 1982 in Raleigh, North Carolina, USA. By mid 2015, the company had 125 stores along the US East Coast from Florida to Maine. Its annual sales are currently ~$5,400,000,000 with $280,000,000 net income. The average store is about 100,000 square feet with an additional 10,000 square feet of outside garden center. The stores typically carry 40,000 different products from 5,000 vendors worldwide. Major US competitors include Ace, Home Depot, Lowe's, and TruValue. All four operate already in Mexico. 1 In the interests of seeking greater profits and buffering against downturns in the US market, Acme has determined to follow these and other competitors to Canada and Mexico. In the latter, it has established, in accordance with Mexican law, a joint venture with local interests, known as Acme Home Improvements de México, SA de CV ("Acme de México" or "Acme Mexico City"). (SA de CV = Sociedad Anónima de Capital Variable, a Mexican corporate form.) There are five major product groups within each Acme store: plumbing and electrical supplies, building materials, hardware and tools, seasonal and garden/yard items, and paint, flooring and wall coverings. Each store has a store manager...

Words: 3105 - Pages: 13

Premium Essay

Finance Book

...Licensed to: iChapters User Eugene F. Brigham UNIVERSITY OF FLORIDA Joel F. Houston UNIVERSITY OF FLORIDA Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it. Eugene F. Brigham UNIVERSITY OF FLORIDA Joel F. Houston UNIVERSITY OF FLORIDA Copyright 2011 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it. Licensed to: iChapters User This is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. The publisher reserves the right to remove content from this title at any time...

Words: 16711 - Pages: 67

Free Essay

Circuit City

...yarney...

Words: 2416 - Pages: 10

Premium Essay

Finance

...subject lines. Multiple Choice: True/False (12-1) Cash flow estimation 1 F I K Answer: b EASY . Because of improvements in forecasting techniques, estimating the cash flows associated with a project has become the easiest step in the capital budgeting process. a. True b. False (12-1) Cash flow estimation 2 F I K Answer: a EASY . Estimating project cash flows is generally the most important, but also the most difficult, step in the capital budgeting process. Methodology, such as the use of NPV versus IRR, is important, but less so than obtaining a reasonably accurate estimate of projects' cash flows. a. True b. False (12-1) Cash flow estimation 3 F I K Answer: b EASY . Although it is extremely difficult to make accurate forecasts of the revenues that a project will generate, projects' initial outlays and subsequent costs can be forecasted with great accuracy. This is especially true for large product development projects. a. True b. False (12-1) Relevant cash flows 4 F I K Answer: b EASY . Since the focus of capital budgeting is on cash flows rather than on net income, changes in noncash balance sheet accounts such as inventory are not included in a capital budgeting analysis. a. True b. False (12-1) Relevant cash flows F I K Answer: a EASY Chapter 12: Cash Flow and Risk True/False Page 231 5 . If an investment project would make use of land which the firm currently owns, the project...

Words: 13260 - Pages: 54

Premium Essay

Boom Panes

...Diff: E . Which of the following statements is most correct? a. The rate of depreciation will often affect operating cash flows, even though depreciation is not a cash expense. b. Corporations should fully account for sunk costs when making investment decisions. c. Corporations should fully account for opportunity costs when making investment decisions. d. Statements a and c are correct. e. All of the statements above are correct. Relevant cash flows Answer: c Diff: E . A company is considering a new project. The company’s CFO plans to calculate the project’s NPV by discounting the relevant cash flows (which include the initial up-front costs, the operating cash flows, and the terminal cash flows) at the company’s cost of capital (WACC). Which of the following factors should the CFO include when estimating the relevant cash flows? a. Any sunk costs associated with the project. b. Any interest expenses associated with the project. c. Any opportunity costs associated with the project. d. Statements b and c are correct. e. All of the statements above are correct. Relevant cash flows Answer: d Diff: E . When evaluating potential projects, which of the following factors should be incorporated as part of a project’s estimated cash flows? a. Any sunk costs that were incurred in the past prior to considering the proposed project. b. Any opportunity costs that are incurred if the project is undertaken. c. Any externalities (both positive and negative) that...

Words: 21266 - Pages: 86

Premium Essay

Damodaran

...Aswath Damodaran INVESTMENT VALUATION: SECOND EDITION Chapter 1: Introduction to Valuation Chapter 2: Approaches to Valuation Chapter 3: Understanding Financial Statements Chapter 4: The Basics of Risk Chapter 5: Option Pricing Theory and Models Chapter 6: Market Efficiency: Theory and Models Chapter 7: Riskless Rates and Risk Premiums Chapter 8: Estimating Risk Parameters and Costs of Financing Chapter 9: Measuring Earnings Chapter 10: From Earnings to Cash Flows Chapter 11: Estimating Growth Chapter 12: Closure in Valuation: Estimating Terminal Value Chapter 13: Dividend Discount Models Chapter 14: Free Cashflow to Equity Models Chapter 15: Firm Valuation: Cost of Capital and APV Approaches Chapter 16: Estimating Equity Value Per Share Chapter 17: Fundamental Principles of Relative Valuation Chapter 18: Earnings Multiples Chapter 19: Book Value Multiples Chapter 20: Revenue and Sector-Specific Multiples 3 16 37 81 121 152 211 246 311 341 373 425 450 487 533 593 637 659 718 760 Chapter 21: Valuing Financial Service Firms Chapter 22: Valuing Firms with Negative Earnings Chapter 23: Valuing Young and Start-up Firms Chapter 24: Valuing Private Firms Chapter 25: Acquisitions and Takeovers Chapter 26: Valuing Real Estate Chapter 27: Valuing Other Assets Chapter 28: The Option to Delay and Valuation Implications Chapter 29: The Option to Expand and Abandon: Valuation Implications Chapter 30: Valuing Equity in Distressed Firms Chapter 31: Value Enhancement: A Discounted Cashflow...

Words: 118369 - Pages: 474

Premium Essay

Scenario Analysis

...1 PROBABILISTIC APPROACHES: SCENARIO ANALYSIS, DECISION TREES AND SIMULATIONS In the last chapter, we examined ways in which we can adjust the value of a risky asset for its risk. Notwithstanding their popularity, all of the approaches share a common theme. The riskiness of an asset is encapsulated in one number – a higher discount rate, lower cash flows or a discount to the value – and the computation almost always requires us to make assumptions (often unrealistic) about the nature of risk. In this chapter, we consider a different and potentially more informative way of assessing and presenting the risk in an investment. Rather than compute an expected value for an asset that that tries to reflect the different possible outcomes, we could provide information on what the value of the asset will be under each outcome or at least a subset of outcomes. We will begin this section by looking at the simplest version which is an analysis of an asset’s value under three scenarios – a best case, most likely case and worse case – and then extend the discussion to look at scenario analysis more generally. We will move on to examine the use of decision trees, a more complete approach to dealing with discrete risk. We will close the chapter by evaluating Monte Carlo simulations, the most complete approach of assessing risk across the spectrum. Scenario Analysis The expected cash flows that we use to value risky assets can be estimated in one or two ways. They can represent a probability-weighted...

Words: 17404 - Pages: 70

Premium Essay

International Accounting Standards

...Internship Report On Management Accounting Practice At Beximco Pharmaceuticals Ltd: A Review Of Costing Function ‘Management Accounting Practice At Beximco Pharmaceuticals Ltd: A Review Of Costing Function’ by Syeda Afrina Sarwar ID: 07304063 BRAC Business School BRAC University, Bangladesh August 2011 ‘Management Accounting Practice At Beximco Pharmaceuticals Ltd: A Review Of Costing Function’ Submitted By: Syeda Afrina Sarwar ID: 07304063 BRAC Business School Submitted To: ------------------------------------------------Ms. Rahnuma Ahmed Lecturer BRAC Business School BRAC University, Bangladesh August 2011 Letter of Transmittal August 10, 2011 Ms. Rahnuma Ahmed Lecturer BRAC BUSINESS SCHOOL BRAC University 66, Mohakhali Dhaka-1212 Subject: Submission of Internship Report Dear Madam, I am submitting an internship report titled for ‘Management Accounting Practice At Beximco Pharmaceuticals Ltd: A Review of Costing Function’ as a part of the requirement of the course. Your guideline has been followed in every aspect of preparing this report. I have really enjoyed working on this project and I hope that my work would meet the level of your expectation. Any query on this report is appreciated. Thank You. Sincerely, Syeda Afrina Sarwar ID:07304063 Acknowledgement It’s difficult for me to thank all of those marvelous people who have contributed something of them to this report. There are of course some very special people who cannot go...

Words: 15094 - Pages: 61

Premium Essay

Paper

...Internship Report On Management Accounting Practice At Beximco Pharmaceuticals Ltd: A Review Of Costing Function ‘Management Accounting Practice At Beximco Pharmaceuticals Ltd: A Review Of Costing Function’ by Syeda Afrina Sarwar ID: 07304063 BRAC Business School BRAC University, Bangladesh August 2011 ‘Management Accounting Practice At Beximco Pharmaceuticals Ltd: A Review Of Costing Function’ Submitted By: Syeda Afrina Sarwar ID: 07304063 BRAC Business School Submitted To: ------------------------------------------------Ms. Rahnuma Ahmed Lecturer BRAC Business School BRAC University, Bangladesh August 2011 Letter of Transmittal August 10, 2011 Ms. Rahnuma Ahmed Lecturer BRAC BUSINESS SCHOOL BRAC University 66, Mohakhali Dhaka-1212 Subject: Submission of Internship Report Dear Madam, I am submitting an internship report titled for ‘Management Accounting Practice At Beximco Pharmaceuticals Ltd: A Review of Costing Function’ as a part of the requirement of the course. Your guideline has been followed in every aspect of preparing this report. I have really enjoyed working on this project and I hope that my work would meet the level of your expectation. Any query on this report is appreciated. Thank You. Sincerely, Syeda Afrina Sarwar ID:07304063 Acknowledgement It’s difficult for me to thank all of those marvelous people who have contributed something of them to this report. There are of course some very special people who cannot go...

Words: 15094 - Pages: 61

Premium Essay

Finance

...text may include materials submitted to McGraw−Hill for publication by the instructor of this course. The instructor is solely responsible for the editorial content of such materials. 111 FINAGEN ISBN: 0−390−55204−6 Finance Contents Ross−Westerfield−Jaffe • Corporate Finance, Seventh Edition I. Overview 1 1 20 34 34 35 70 98 130 152 152 193 219 219 241 241 275 1. Introduction to Corporate Finance 2. Accounting Statements and Cash Flow II. Value and Capital Budgeting Introduction 4. Net Present Value 5. How to Value Bonds and Stocks 7. Net Present Value and Capital Budgeting 8. Risk Analysis, Real Options, and Capital Budgeting III: Risk 10. Return and Risk: The Capital−Asset−Pricing Model (CAPM) 12. Risk, Cost of Capital, and Capital Budgeting VII. Short−Term Finance 27. Cash Management VIII. Special Topics 29. Mergers and Acquisitions 31. International Corporate Finance Harvard Business School Entrepreneurship Cases JAFCO American Ventures, Inc.: Building a Venture Capital Firm 299 299 Case Harvard Business School Finance Cases Pioneer...

Words: 179333 - Pages: 718