Please solve a-e with complete work in a excel format.

2. A Capital Budgeting Problem end of years, and then -10% per year until the end of year 10. The annual fixed expense is $ 40,000 per needs to maintain an inventory that is worth 15% of next year's sale. At the end of the project, no inventory Standard Food Company plans to establish a new production line for producing ice creams. The equipment projected to generate $ 200,000 worth of sale in the first year. The sale will grow at 10% per year until the equipment will be sold at a market value of $ 30,000. Assuming the tax rate is 40% and the cost of capital needs to be maintained and all existing inventory will be liquidated. Also, at the end of the project the is 9% for the company. Create a capital budgeting table to show the free (overall) cash flows for the new project. Please show all details for full credits (30 points) Hint must include operating cash flows, change of networking capital, initial investment, and salvage cash flow. a. b. Calculate the Project's NPV, IRR, Regular Payback Period, Discounted Payback period and Modified Internal Rate of Return, assuming a 9% reinvestment rate (15 points) c. The company faces two different scenarios: one is the scenario in part a and b with 1 year sales as 200,000; in another scenario, 1 year sales is 175,000. The probability of each scenario is listed below: Bad 40% Probability Sales at Year 1 Good 60% 200,000 175,000 Please solve the NPV for each scenario (7 points), and the expected NPV and standard deviation of NPV based on all scenarios. (8 points) d. Please calculate the sensitivity of NPV to revenue (4 points) and the sensitivity of NPV to cost of equipment (4 points). (Hint: you can put a 10% increase for the variable and calculate the new NPV). Report which variable would affect NPV to a greater degree (2 points). e. One year before the project starts, the company has an option to test the market. After the testing, the company would know whether the project's sales will be good or bad (as indicated in part c.). If the sale is going be bad, the company would not start the project. Without the test, the company would start the project no matter what and bear the risk of bad sales. Please calculate the value of the test option, given the test costs $10,000. Show all your work for full points (20 points)