Home Depot Executive Summary
2 Pages

Home Depot Executive Summary

Course: FINANCE 440, Spring 2012

School: Regis

Word Count: 302

Rating:

Document Preview

Running Header: Home Depot, Inc. Financial Analysis Home Depot, Inc. Financial Analysis Tim Gillespie Home Depot SWOT Regis University FIN 440 Professor: Doug Hartman October 5, 2009 Executive Summary The Home Depot is the largest home improvement chain in the United States, Canada, and Mexico. Currently the Home Depot operates over 1900 stores in all these areas, including a few stores in China as well. The...

Unformatted Document Excerpt
Coursehero >> Colorado >> Regis >> FINANCE 440

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Header: Running Home Depot, Inc. Financial Analysis Home Depot, Inc. Financial Analysis Tim Gillespie Home Depot SWOT Regis University FIN 440 Professor: Doug Hartman October 5, 2009 Executive Summary The Home Depot is the largest home improvement chain in the United States, Canada, and Mexico. Currently the Home Depot operates over 1900 stores in all these areas, including a few stores in China as well. The Home Depot has recently had to start closing some stores due to the economic conditions that exist and I will reference the reason for this in the following report. This is a financial analysis of Home Depot. In addition, it will compare Home Depot to one of its biggest competitors, Lowes. This report will cover the following key points: 1. The revenue trend for Home Depot compared to Lowes. This section will also cover key ratios, and other financial statements. The biggest point to notice in section this is how Home Depots revenue has gone down over $2 billion in the last 2 years. 2. Key ratios of Home Depot compared to the industry averages. 3. How Home Depots stock market performance has been during a portion of the economic recession. A key thing to notice is how Home Depot stock has stayed consistent even with an economic recession. 4. It will cover the economic conditions that favor Home Depot, the conditions that could create a challenge, and recommended financial decisions to help Home Depot. The purpose of this report is to inform readers of the financial conditions of Home Depot. It is also a comparison of how well Home Depot is doing compared to its largest competitor, Lowes. After reading this report, I hope that customers and anyone who views this will have a better understand of the economic conditions that face Home Depot, and how they compare to Lowes during the recession.

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Regis - FINANCE - 440
Problem 16-9ius (Capital; Structure analysis )The Rivoli Company has no debt outstanding and its financial position is given by thefollowing data:Assets (book = market)EBITCost of equity rsStock price P0Shares outstanding, n0Tax rate, T(federal-pl
Regis - FINANCE - 440
Business and Financial Risk MM ModelAir Tampa has just been incorporated, and its board of directors is currently grapplingwith the question of optimal capital structure. The company plans to offer commuter airservices between Tampa and smaller surroun
Regis - FINANCE - 440
Balance Sheet- Table 1The Oceanic CorporationCashAccounts ReceivableInventoryTotal Current Assets5,00010,00020,00035,000Accounts Payable8000Accurals5,000Notes Payable10,000Total Current assets 23,000Land & Buildings (net)Plant and Equipm
Regis - FINANCE - 440
Home Depot, Inc. Forecasting Project P a g e | 1Running Header: Home Depot, Inc. Forecasting ProjectHome Depot, Inc.Forecasting ProjectTim GillespieRegis UniversityFinancial AnalysisProfessor: Doug HartmanOctober 11, 2009Home Depot, Inc. Forecast
Regis - FINANCE - 440
Home Depot SWOT 1 | P a g eRunning Header: Home Depot SWOTThe Home Depot SWOT AnalysisTim GillespieHome Depot SWOTRegis UniversityFinancial PlanningProfessor: Doug HartmanSeptember 9, 2009Home Depot SWOT 2 | P a g eHome Depot SWOT AnalysisInter
Regis - FINANCE - 440
Tim GillespieFIN 440Week 1 HomeworkChapter 7-12A. What is the net operating profit after taxes (NOPAT) for 2009?NOPAT = EBIT(1-T)NOPAT = 150,000,000*(1-.4)NOPAT =$90,000,000.00B. What are the amounts of net operating working capital for both year
Regis - FINANCE - 440
Tim GillespieFin 440Homework Week 2Problem 9-7Sales 2009Net IncomeDividendsIncrease in SalesCashARInvTotal Current AssetsNet FixedTotal Assets35010.54.2$7040%20%3.52658APNPAccurals87.5Total Current Liab.MortgageComm StockReta
Regis - FINANCE - 440
Tim GillespieFIN 440Week 3 HomeworkChapter 21 Problems 6, 12 and 1421-6McDowell Industries sells on terms of 3/10, net 30. Total sales for the year are $912,500. Forty percent of thecustomers pay on the 10th day and take discounts, the other 60% pay
Regis - FINANCE - 440
Tim GillespieFIN 440Week 4 Homework22-7Kim Mitchell, the new credit manager of the Vinson Corporation, was alarmed to find that Vinson sells on credit terms of net 90 days while industry wide credit terms have recentlybeen lowered to net 30 days. On
Regis - FINANCE - 440
Tim GillespieWeek 5 HomeworkFin 440Prob 10-15DebtCommon EquityTotal Capital$30,000,000$30,000,000$60,000,000A. To maintain the present capital structure, how much of the new investment must be financed by the common equity?Debt : Equity =1 to
Regis - FINANCE - 440
Tim GillespieFin 440Sales ForecastYear1999200020012002200320042005200620072008Sales (millions)DifferenceGrowth Rate$38,434.00$45,738.00$7,304.0019%$53,553.00$7,815.0017%$58,247.00$4,694.009%$64,816.00$6,569.0011%$73,094.00$8
Regis - FINANCE - 440
Tim GillespieFIN 440Week 6 HomeworkProblem 13-5You have been asked by the president of your company to evaluate the proposed acquisition of a new spectrometer for the firms R&D department.The equipments basic price is $70,000, and it would cost anoth
Regis - FINANCE - 440
Tim GillespieFIN 440Week 7 HomeworkProblem 15-9The Rivoli Company has no debt outstanding and its financial position is given by the following data:Assets (book = market)EBITCost of equity rsStock price P0Shares outstanding, n0Tax rate, T(federa
Regis - FINANCE - 440
Tim GillespieFIN 440Demello Case #3#1Profitability Ratios1. Profit Margin on Sales2. Basic Earning Power (BEP) Ratio3. Return on Total Assets4. Return on Common EquityNet income available to common stockholders / SalesEBIT / Total AssetsNet inc
Regis - FINANCE - 440
Tim GillespieFIN 440Demello Case #42. If Oats R Us is operating its fixed assets at full capacity, what growth rate can it support without the need for any additional external financing?IGR = ROE x (1 Dividend Payout Ratio) x (Book Value of Equity)/(T
Regis - FINANCE - 440
Tim GillespieFIN 440Week 3 Demello Case #27Questions 3 and 6Cash Conv Cycle =3. How long are the firms operating and cash cycles? Using a suitable diagram show the breakdown of the firmsoperating cycle into its relevant components. What do your find
Regis - FINANCE - 410
Tim GillespieBusiness FinanceExecutive SummaryExecutive SummaryThe Home Depot is the largest home improvement chain in the United States, Canada,and Mexico. Currently the Home Depot operates over 1900 stores in all these areas, including afew stores
Regis - FINANCE - 410
No improvement for Home Depot, Lowe'sPosted Aug 26 2008, 01:57 PM by Todd HarrisonThe slumping housing market continues to take a bite out of home improvement - and theres noimmediate relief in sight.Consumers are pressed by high gasoline and food pri
Regis - FINANCE - 410
B. Reduces Payout RatioAssets to SalesChange in SalesLiabilities to SalesProfit MarginNew Sales LevelDividend Payout Ratio85.00% Assets * Increase$15,000,000.00 Liabilities * Increase25.00% Profit Marg * New Sales Total6.00%$115,000,000.00 Exte
Regis - FINANCE - 410
Medical ResearchCorporationMemoTo:Medical Research CorporationFrom: Tim GillespieCC:Kristin GwynDate:2/26/2012Re:Project Costs and ReturnsBased on the research that you asked me to do regarding project costs, I would recommendkeeping your bud
Regis - FINANCE - 410
Home Depot SWOT 1 | P a g eRunning Header: Home Depot SWOTThe Home Depot SWOT AnalysisTim GillespieHome Depot SWOTRegis UniversityCorporate FinanceProfessor: Kristin GwynMarch 28, 2009Home Depot SWOT 2 | P a g eHome Depot SWOT AnalysisInternal
Regis - FINANCE - 410
Tim GillespieFIN 400Chapter 3 Comprehensive ProblemProfitability Ratios1. Profit Margin2. Return on Assets (Investment)3. Return on EquityNet Income / Net Salesa. Net Income / Total Assetsb. Net Income / Sales x Sales / Total Assetsa. Net Income
Regis - FINANCE - 410
Tim GillespieFinancial Comparison Home DepotStatements on Different Tabs(Courtesy of MSN Money)Home Depot Income StatementPeriod End DatePeriod Length20092/1/200953 Weeks20082/3/200853 Weeks20071/28/200752 Weeks20061/29/200652 WeeksLowe
Regis - FINANCE - 410
Tim GillespieWeek 2 Chapter 4 Landis Corp.CashARInventoryTotal Current Assets2008 Sales$100,000,000.00Profit Margin after taxes6.00%Dividend Payout50.00%Landis CorporationBalance Sheet and Percent of Sales Table as of December 31 2008Assets
Regis - FINANCE - 410
Tim GillespieHome DepotProfitability Ratios1. Profit Margin2. Return on Assets (Investment)3. Return on EquityNet Income / Net Salesa. Net Income / Total Assetsb. Net Income / Sales x Sales / Total Assetsa. Net Income / Stockholders' Equityb. Re
Regis - FINANCE - 410
Tim GillespieWeek 3 Chapter 6 #8Three Year LoanYear1 to 3One Year LoanIf interest went up on one year loanOne Year LoanPrincipal Years$150,0001 $150,0002 $150,0003 $150,0001 $150,0002 $150,0003 $150,0003111Interest Rate Total Interest
Regis - FINANCE - 410
Tim GillespieWeek 4Chapter 10 Web ExerciseBank of America is a financial company that offers non-banking and banking services to consumers. Thecompany is a global company. They offer savings accounts, checking accounts, money market, certificates ofd
Regis - FINANCE - 410
Tim GillespieChapter 9 Problem 27$10,000 Now$2,000 For 8 yrs$24,000 8 yrs from nowYearsOption 1Option 2Option 3$10,000.00 Get Now$2,000.008$24,000.008Interest RatePresent Value$10,000.00 No formula, $10,000 cash now11%11%$10,292.25 PV =
Regis - FINANCE - 410
Tim GillespieWeek 4 Chapter 9Problems 2,4 and 9#2a.b.c.d.Annual Interest Rate Term in Years8.00%10.00%6.00%16.00%752550PaymentPVWhile working on this problem, I noticed right away that I would love to put 60 cents$9,000.00$5,251.41 in
Regis - FINANCE - 410
SymbolhdhdhdhdhdhdhdhdhdhdhdhdhdhdhdhdhdhdhdhdDateVolumeHighLow3/13/2009 22210714213/16/2009 1703440421.063/17/2009 2533153821.493/18/2009 3177326022.843/19/2009 2288184322.8353/20/2009 2236179522.733/23/2009 22872340
Regis - FINANCE - 410
Tim GillespieWeek 6Chapter 16 Web ExerciseSouthwest AirlinesDATELong-Term DebtTotal Stockholders' EquityRatio31-Dec-08$3,498,000.00$4,953,000.0070.62%31-Dec-07$2,050,000.00$6,941,000.0029.53%31-Dec-06$1,567,000.00$6,449,000.0024.30%DAT
Regis - FINANCE - 410
Tim GillespieBusiness FinanceWeek 6 Financial ProjectProfessor Kristin GwynHome Depot Financial AnalysisConditions that favor Home DepotWhile reviewing the ratios, and comparing it to the industry averages, it looked like therecould be many conditi
Regis - FINANCE - 410
Tim GillespieBusiness FinanceWeb Exercise1. How many round lot holders are required to be listed?400 U.S.Round lot holders1. How many total shareholders (use the first number)?2000 Shareholders1. What market value is required for public companies?
Regis - FINANCE - 410
Tim GillespieBusiness FinanceWeb Exercise1. How many round lot holders are required to be listed?400 U.S.Round lot holdersNYSE400NASDAQ4001. How many total shareholders (use the first number)?2000 Shareholders20004001. What market value is r
Regis - FINANCE - 410
Tim GillespieBusiness FinanceWeek 7 Chapter 174,500,000 outstanding shares$60.00 current market price per share rights on$18,000,000.00 Net Income455,000 New Shares Rights Offering$59.55 price per new share$55 plus 10 rightsneeded to buy one of n
Regis - FINANCE - 410
Home Depot, Inc. Financial Analysis P a g e | 1Running Header: Home Depot, Inc. Financial AnalysisHome Depot, Inc.Financial AnalysisTim GillespieHome Depot SWOTRegis UniversityCorporate FinanceProfessor: Kristin GwynMarch 28, 2009Home Depot, Inc
Regis - FINANCE - 410
Tim GillespieChapter 18 Problem 19D0 =A.D1 =Ke =g=$3.00Ke =g=10%5%Plan A3.5710%5%C.P0=BD1 =$71.40Plan B3.18Ke =g=10%6%P0=$79.50Plan B would create the higher value for the stock pricetoday. The reason for this is the growth r
Regis - FINANCE - 410
ProjectABCDExpected Return18%14%11.80%10.90%Common StockRetained Earnings$15,000,000Dividend D1Underwriting Costs60% of Financing$25Amount of Financing0-$25 million$25 - $45 millionOver $45 million$20,000,000 bonds sold to yield 11%a
Regis - FINANCE - 410
3 years priorOLDYear123456Depreciation Base % Depreciation Annual Depreciation$230,0000.200$46,000.00$230,0000.320$73,600.00$230,0000.192$44,160.00$230,0000.115$26,450.00$230,0000.115$26,450.00$230,0000.058$13,340.00$230,000.00
Waterloo - PYCSH - 101
Psychology NotesChapter One: Psychology: The Science of Behaviour*The Nature of Psychology:-psychology is the study of behaviours and the factors that influence it-behaviours are both observable actions and inner processes (thoughts, feelings, images,
Purdue - ANSC - 102
Animal Health and Well BeingDr. Mickey A. LatourPurdue UniversityAnimal Health and Well Being Losses caused by animal disease ~ 15% inthe U.S. This number can change greatly. Many of the diseases are dealt with throughthe use of antibiotics (compou
Purdue - ANSC - 102
Poultry ProductionPoultryChapter 35Dr.MickeyA.LatourPurdueUniversity,901WStateStreetWestLafayette,IN47907Poultry StructurePoultryLiveChicksBroilersLayersTurkeysDucksProcessingProcessingSupermarketRestaurantPoultry Industry (Format)Poult
Purdue - ANSC - 102
Dairy ManagementDairyDr. Mickey A. LatourDepartment of Animal SciencesPurdue University, 1151 Lilly Hall,PurdueWest Lafayette, Indiana 47907WestDairy StructureLive ProductionProcessingProcessing(ground)Replacement HeifersHeifersMilkingBull
Purdue - ANSC - 102
Reproductive PhysiologyReproductive PhysiologyDr. Mickey A. LatourPurdue University, Smith Hall,West Lafayette, IN 47907ReproductionReproduction The following topics will be discussed:- Male reproductionMale- Female reproduction- Embryonic Deve
Purdue - ANSC - 333
ANSC 333 9/21/11Cortex of the ovary:Dark blue around follicle basement membraneOutside basement membrane theca cellsInside basement membrane granulosa cellsTheca subdivides into theca interna and theca externaWhere blood vessels are found the theca
UBC - EOSC - 114
The Shaking Earth - EarthquakesINTRODUCTIONThe two extreme natural catastrophes of 2004-2008 originated as earthquakes: the Sumatra earthquake of December 26, 2004and the Sichuan earthquake of May 12, 2008. See the following web sites for more informat
Waterloo - CHEM - 123
CHEM 123 SAMPLE EXAM QUESTIONS1.How many spheres lie within one unit cell of a body-centred cubic lattice of identical, hard spheres?A.B.C.D.E.2.Aluminum (Al) crystallizes in a face-centred cubic structure. If the radius of the aluminum atom is1
Waterloo - CHEM - 123
Solution SetRick Marta 2011Solution SetRick Marta 2011Solution SetRick Marta 2011Solution SetRick Marta 2011Solution SetRick Marta 2011Solution SetRick Marta 2011Solution SetRick Marta 2011Solution SetRick Marta 2011Solution SetRick Marta
Waterloo - CHEM - 123
CHEM 1231.1Module 1: Phases, Phase Diagrams, Intermolecular Forces, and Solidspage 1 of 38STP vs SATPPhases and Phase diagramsSTP = standard temperatureoand pressure (0 C, 100 kPa)SATP = standard ambienttemperature and pressureo(25 C, 100 kPa)
Waterloo - CHEM - 123
CHEM 123Module 1: Phases, Phase Diagrams, Intermolecular Forces, and SolidsExample: Iodine chloride, ICl, and bromine, Br2, have exactly the same numberof electrons, and it is reasonable to assume these molecules are essentially theosame size. Yet th
Waterloo - CHEM - 123
CHEM 123: Practice Problems B1.page 1 of 30Simple cubic packing. The crystal lattic and unit cell for simple cubic packing are shown below.Aa) # spheres =(1 8sphere/corner) ( 8 corners )= 1 sphereb) The coordination number of each sphere is 6. T
Waterloo - CHEM - 123
Summary to dateThe stoichiometry of the balanced reaction determines the relativerates of disappearance of reactants and appearance of products.aA + bB cC + dD1 d A1 d B 1 d C 1 d D a dtb dtc dtd dtThe experimental rate law describes the depende
Waterloo - CHEM - 123
CHEM 123 Practice ProblemsWork (and learn) from your text book and stay ahead of your instructor throughout the term. This will help you get the mostout of the lectures. By working ahead, you can identify topics you find difficult before they come up in
Waterloo - CHEM - 123
University of Waterloo DEPARTMENT OF CHEMISTRY CHEM 123 Test #1 (Sample)Answers are given on the last page!This is test version 001. Fill in ovals 001 for the Card Number on your computer answer card.Name (Print in ink!): _First name SurnameStudent N
Waterloo - CHEM - 123
Chem 123 (Test #2) - SampleTerm Test #2CHEMISTRY 123Name: _Surname1.2.3.4.5.ID#: _Forename(s)Make sure your test contains 4 pages (15 questions). All questions are of equal value.You have 50 minutes to complete this test.Fill in oval 001 for
Waterloo - MATH - 128
Math 128ASSIGNMENT 1: Math 127 ReviewWinter 2012This assignment wont be marked. Instead, there will be a short quiz during the rst tutorial. Youll have 30 minutes to write it, though it shouldnt take that long. It is stronglyrecommended that you do th
Waterloo - MATH - 128
Math 128, Winter 2012Ch. 3 review exercises:Ch. 5 review exercises:Assignment 1 solutionsPage 1Math 128, Winter 2012Assignment 1 solutionsPage 21.* Note that solutions to the challenge problem will not be posted. However, your instructor orTA wil
Waterloo - MATH - 128
Math 128ASSIGNMENT 2: Integration TechniquesWinter 2012Due at 8:25 am on Wednesday, January 18th in the correct drop slot across from MC4066or in class depending on your instructors preference. Assignments put into the wrong dropslot will not be mark
Waterloo - MATH - 128
Math 128, Winter 2012Assignment 2 solutionsSolutions to Part A and B problems from the text:Section 7.1:Section 7.2:Section 7.3:Page 1Math 128, Winter 2012Section 7.4:Page 2Assignment 2 solutionsPage 2Math 128, Winter 2012Assignment 2 solutio
Waterloo - MATH - 128
Math 128ASSIGNMENT 3: Integration strategyWinter 2012Due at 8:25 am on Wednesday, January 25th in the correct drop slot across from MC4066or in class depending on your instructors preference. Assignments put into the wrong dropslot will not be marked
Waterloo - MATH - 128
Math 128ASSIGNMENT 4: Volume, arclength, areaWinter 2012Due at 8:25 am on Wednesday, February 1st in the correct drop slot across from MC4066or in class depending on your instructors preference. Assignments put into the wrong dropslot will not be mar