Assume that you work for the publicly traded company you selected. (I chose Costco Wholesale Corporation (COST)) The first step for completing this project is to extract the data for your chosen company. You can get the data from YahooFinace for example. Your boss (the CFO) has asked you to analyze a potential capital budgeting project. To impress her, your calculations obviously need to be correct as well as professionally presented. However, it is also important that you use Excel efficiently so any future changes require minimal work (i.e. be sure to use formulas in Excel). You will be comparing a project using traditional MACRS depreciation to using 100% bonus depreciation in year 1. You will need to estimate the initial outlay, annual cash flows, and terminal cash flow for your project under the two approaches. You should then calculate the NPV and IRR and make a recommendation as to which approach is better for your company. Here is the information you have about the potential project: Cash flow informationyou will use this information to estimate the projects cash flows -This is a four-year project. Only the items listed below change. Other income statement and balance sheet items remain constant. -the financial statements from Bloomberg contain several years of data plus projections. The starting point will be the Fiscal Year 2019. -Revenue on the income statement will increase by 10%from FY 2019. Inflation will cause revenue to increase by 3%in Years 2,3, and 4. -Cost of Revenue on the income statement will increase by 8%from FY 2019. (Please note that if your company does not have Cost of Revenueyou should use Operating Expenses.)Inflation will cause the costs to increase by 3% in Years 2,3 and 4. -Gross Fixed Assets or Property, Plant, & Equipment (gross) on the balance sheet will increase by 30%. This will be a cash outlay in Year 0in other words, this is the purchase price of the asset. -Method 1: Assume that the increase in Gross Fixed Assetsrepresentsassets that are depreciable on a MACRS 5-year life. -Method 2: Assume that the increase in Gross Fixed Assets represents assets that are eligible for bonus depreciation in Year 1. In other words, 100% of the asset cost can be depreciated in Year 1. -Networking capital (NWC) will increase by 15% of the increase in Gross Fixed Assets in Year 0. Then, NWC will increase by an additional 10% in Year 1, 8% in Year 2, and 5% in Year 3. Assume the investment in NWC will be recovered in Year 4(i.e., the level of NWC for Year 4should be 0) -The tax rate is 21%. If calculated taxes are negative, you should assume the full value of the tax credit is recognized that year. In other words, negative taxes are fine. -The asset will be sold at the end of Year 4for 30% of the initial purchase price. The appropriate discount rate is the estimated WACCfor the company since this will be an average-risk project. You can use financial websites to get an estimate for the WACC. You need to mention the source you use. Use Excel to create a professional-looking spreadsheet with appropriate cash flows, depreciation table, NPV, and IRR. Indicate your recommendation about whether the project is acceptable under either MACRS depreciation and/or bonus depreciation. You should also indicate which approach is better. Your Excel spreadsheet must be uploaded via Canvas. Be sure to also include the Balance Sheet, and Income Statement, (you might want to include them as separate Worksheets in your Excel document). You can upload multiple files if necessary. Show all of your work, step by step, and label all of your numbers. Make sure that all of your calculations are formula-driven and that they use amounts listed and labeled in your Excel spreadsheet.