business valuation

 
Here are the minimal instructions/guidance for your final project for the semester.In “Valuation Reference Files” under “Course Documents” pay particular attention to the two Home Depot FilesNote: The NOA approach to Free Cash Flow to the Firm is used here that we talked about in the last lecture we had. I would like you to use what we have already discussed (i.e. use ‘NOPAT – change in Net PPE (i.e. capital expenditure spending – depreciation) – changes in Net Working Capital for operations’).
Perform the intrinsic valuation using the FCFF approach leading to the Market Value of Invested Capital to Enterprise Value (MVIC – Cash and Marketable Securities) to Equity Value (Enterprise Value – Long-term Term debt – PV of Operating Leases) to Value per Share (Equity Value  / Shares Outstanding)
Perform a Market Multiple analysis to compare to your intrinsic value. A minimum of two and a maximum of three multiples should be used.
NOTE: THERE MAY BE SOME CALCULATION ERRORS IN THE SPREADSHEETS THAT ARE USED FOR REFERENCE. I WANT YOU TO USE WHAT WE HAVE LEARNED. THE EARLY 2000s SPREADSHEETS ARE THERE FOR CONTENT AND GUIDANCE RATHER THAN COPYING ALL OF THE FORMULAS, ETC.Use the last day of the last fiscal year reporting as the Date of Value (Relying on Shares Outstanding from the 10k)
In addition to presentable spreadsheets, you are to also provide a written analysis in lieu of presenting. The analysis will include:An ExectiveSummary no longer than one-page. Less is more here but it must be able to stand alone and provide a busy top-level decision-maker with a complete briefing, what course of action to follow and a succinct description of why. Use whatever facts are necessary to show the significance and/or priority.
An Analysis that is 1-3pages listing the key assumptions you make in your analysis, your logic of your argument, and the use of each key assumption. Justify your assumption. Be specific but express your ideas clearly with support, evidence, explanation, and references if appropriate. The analysis portion should “build” to support your opinion/recommendation regarding the market value of Lowes on the last day of the Fiscal Year. Remember, only use information that was known and knowable at the time.
Include the exhibits to follow the Analysis.This should be a professional work product provided as a single document
In addition to submitting the “professional work product” please submit our valuation spreadsheets as well. Both will be graded.
Approximate price: $22
We value our customers and so we ensure that what we do is 100% original..

With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.