can you please solve using excel?

thank you

year of operation), the equipment is expected to be sold for $1,800,000 before taxes. The project will require an increase in net operating working capital of $730,000 at t = 0. The cost of the working capital will be fully recovered at t-3 (which is the project's last year of operation) Expected high protein energy smoothie sales are as follows: Year Sales 1 $2,100,000 28,000,000 3 3,150,000 . The project's annual operating costs (excluding depreciation) are expected to be 60% of sales. The company's tax rate is 25%. The company is extremely profitable; so l' any losses are incurred from the high protein energy smoothie project they can be used to partially omset taxes paid on the Company's other projects. (That is, assume that if there are any tax credits related to this project they can be used in the year they occur.) The project has a WACC - 10.0% What is the project's expected NPV and IRR? Round your answers to 2 decimal places. Do not round your intermediate calculations, NPV IRR Should the firm coept the project? The B SSC is considering another project the introduction of weight loss smoothie. The project would require a $0.2 million investment outlay today (-0). The after tax cash flows would depend on whether the weight loss smoothie is well received by consumers. There is a 40% chance that demand will be good, in which case the project wil produce after tax cash flows of $2.5 million at the end of each of the next 3 years. There is a 60% chance that demand will be poor, in which case the after tax cash flows will be $6.49 million for 3 years. The project is riskier than the firm's other projects, so it has a WACC of 11%. The firm will know the project is successful after receiving the cash niows the first year and after receiving the first year's cash flows it will have the option to abandon the project. If the firm decides to abandon the project the company will not receive any cash flows after t = 1, but it will be able to sell the assets related to the project for $2.5 million after taxes at 1. Assuming the company has an option to abandon the project, what is the expected NPV of the project today) Round your answer to 2 decimal places. Do not round your intermediate calculations. Use the values in millions of dollars to ascertain the answer millions of dollars www real options you consider the project with and without the option. The option value is calculated as the difference between the expected NPVs with and without the relevant option (If the value of the project without the option is negative and the NPV of the project with the option is positive, then the option value is simply the calculated NPV of the option. It is the value that is not accounted for in a traditional NPV analysis and a positive option value expands the firm's opportunities Quantitative ProblemSunshine Smoothies Company (SSC) manufactures and distributes smoothies. SSC is considering the development of a new line of high-protein energy smoothies. SSCs CFO has collected the following information regarding the proposed project, which is expected to last 3 years: The project can be operated at the company's Charleston plant, which is currently vacant The project will require that the company spend $4.5 million today (t = 0) to purchase additional equipment. This equipment is eligible for 100% bonus depreciation, so the equipment is fully depreciated at the time of its purchase. The company plans to use the equipment for all 3 years of the project. Att = 3 (which is the project's last year operation), the equipment is expected to be sold for $1,800,000 before taxes The project will require an increase in net operating working capital of $730,000 att = 0. The cost of the working capital will be fully recovered at t - 3 (which is the project's last year of operation). Expected high-protein energy smoothie sales are as follows: Year Sales 1 $2,100,000 28,000,000 33.150,000 The project's annual operating costs (excluding depreciation) are expected to be 60% of sales. The company's tax rate is 25% The company is extremely profitable; soit any losses are incurred from the high protein energy smoothie project they can be used to partially offset taxes paid on the company's other projects. (That is assume that if there are any tax credits related to this project they can be used in the year they occut) The project has a WACC - 10.04. What is the project's expected NPV and IRR? Round your answers to 2 decimal places. Do not round your intermediate calculations NPV $ TRR Should the firm accept the project? The B SSC is considering another project: the introduction of a weight loss smooth. The project would require a $3.2 million investment outlay today ( tj. The after-tax cath flows would depend on whether the weight loss smoothie is well received by consumers. There is a chance that demand will be good, in which case the project will produce aher-tax cash flows of $2.3 mon at the end of each of the next years. There is a 60% chance that demand will be poor, in which case the after-tax cash flows will be 36.49 million for 3 years. The project is rider an the firm's other projects, so it has a WACC of 11%. The firm wit know the project is successful after receiving the cash hows the first year, and after receiving the first year's cash rows it will have the option to abandon the project. If the firm decides to abandon the project the company will not alatianitamalaimaanatantin