For this milestone, submit a draft of the Capital Budgeting Data section of the final project, along with your supporting explanations. Base your calculations on the data provided in this case study. Be sure to substantiate your claims. Submit your calculations on the designated tab of the Final Project Student Workbook and your supporting explanations as a Microsoft Word document. Prompt Using this case study, prepare a financial analysis report for Home Depot Inc. For your calculations, use the Final Project Student Workbook, which includes tabs specific to each milestone. Be sure to include in your analysis the background calculations and managerial analysis for each of the following topics: time value of money, stock and bond valuation, and capital budgeting. Also include a discussion of macroeconomic variables that might impact the company’s financial decision making and strategic objectives. Note that while these elements may seem separate and unrelated, together they will present a well-rounded view of the company’s finances with regard to the topics. Specifically, you must address the critical elements questions below. Capital Budgeting Data A. Suppose the company is considering a potential investment project to add to its portfolio. Calculate the following items: 1.The net present value (NPV) of the project 2.The internal rate of return (IRR) of the project B. What are the implications of these calculations? In other words, based on each of the calculations, and being mindful of the need to balance portfolio risk with return, would you recommend that the company pursue the investment? Why or why not? Be sure to substantiate your claims. C. What is the difference between NPV and IRR? Which one would you choose for evaluating a potential investment and why? Be sure to support your reasoning with evidence.