Please help me with this assignment. All done in excel.

3 NWC 20,000 3,905 10,000 2. Use the following information to complete a business valuation: Information for Business Valuation A. Inputs at the Time of Valuation (t = 0) Revenue $ $ GPPE $ B. Forecasts for the Finite Horizon (Years 1 to 5) Revenue Growth COGS/Revenue SG&A/Revenue NWC/Revenue Annual Depreciation $ Annual Increase in GPPE $ After-Tax Salvage Value $ C. Forecasts for the Infinite Horizon (Starting in Year 6) Annual Growth Rate* *This growth rate applies to Revenue, COGS, SG&A, NWC, Depreciation, and GPPE. D. Other Information Tax Rate Cost of Capital 6.00% 50.00% 15.00% 21.00% 1,000 250 4,000 5.50% 39.00% 10.95% 1) Follow the provided template to format your valuation report; that is, the information table is listed above the valuation table. 2) Use cell references to enter all input values necessary for the valuation analysis. 3) Add spin button (see below for an example) in input values for Revenue (t = 0) with an incremental change of $1,000 and for NWC (t = 0) with an incremental change of $200 to make these input values interactive. Example of Spin Button: 10,000 4) Use the Excel formula to complete all necessary calculations in the valuation table. Your estimate of the business value should appear in the cell highlighted in yellow. Make sure that your calculations change when you use the spin button to alter input values for Revenue and NWC. 5) Present your calculations in the analysis report as follows. a. A line item in the report is shown as _ where there is no applicable information or it is equal to 0. 4 b. A line item with no applicable information or a value of 0 must be included in all relevant calculations. 6) Enter your recommendation on the sales of the business in the bottom cell; that is, would you recommend your client to sell the business at a price of $67,000 offered by a potential buyer based on your analysis? 3 NWC 20,000 3,905 10,000 2. Use the following information to complete a business valuation: Information for Business Valuation A. Inputs at the Time of Valuation (t = 0) Revenue $ $ GPPE $ B. Forecasts for the Finite Horizon (Years 1 to 5) Revenue Growth COGS/Revenue SG&A/Revenue NWC/Revenue Annual Depreciation $ Annual Increase in GPPE $ After-Tax Salvage Value $ C. Forecasts for the Infinite Horizon (Starting in Year 6) Annual Growth Rate* *This growth rate applies to Revenue, COGS, SG&A, NWC, Depreciation, and GPPE. D. Other Information Tax Rate Cost of Capital 6.00% 50.00% 15.00% 21.00% 1,000 250 4,000 5.50% 39.00% 10.95% 1) Follow the provided template to format your valuation report; that is, the information table is listed above the valuation table. 2) Use cell references to enter all input values necessary for the valuation analysis. 3) Add spin button (see below for an example) in input values for Revenue (t = 0) with an incremental change of $1,000 and for NWC (t = 0) with an incremental change of $200 to make these input values interactive. Example of Spin Button: 10,000 4) Use the Excel formula to complete all necessary calculations in the valuation table. Your estimate of the business value should appear in the cell highlighted in yellow. Make sure that your calculations change when you use the spin button to alter input values for Revenue and NWC. 5) Present your calculations in the analysis report as follows. a. A line item in the report is shown as _ where there is no applicable information or it is equal to 0. 4 b. A line item with no applicable information or a value of 0 must be included in all relevant calculations. 6) Enter your recommendation on the sales of the business in the bottom cell; that is, would you recommend your client to sell the business at a price of $67,000 offered by a potential buyer based on your analysis