please use excel and elaborate what you pluged into the the formula to get the answer. im still learning excel so its a little confusing. thank you in advance! Ill thumbs up if answer is shown and shown with what got pluged in:)

a)

b)

c)

d)

if you had to only choose three please focus on A, C & D but id really appreciate it if you did all 4 subparts:)

Rainy Day Corporation is considering a new project producing raincoats with recycled polyester material from plastic water and soda bottles. Rainy Day expects to sell 22,023 raincoats a year for a price of $70 and variable costs per raincoat of $31. What is the expected total dollar Revenue minus Variable costs for the raincoats? You are evaluating a project with expected revenues of $21,814 in year 1, variable costs of $10,000 year 1, fixed costs of $5,000 per year and bonus depreciation in year 1 of $3,997. Given a marginal tax rate of 21%, what is the Operating Cash Flow in year 1. Rainy Day needs an initial amount of Net Working Capital of $104,543 in time consisting of raw materials before selling any raincoats. In the first year (year 1), Rainy Day expects to need Net Working Capital of 16% of Revenues which are expected to be $2,435,271 in year 1. What is the forecasted change in Net Working Capital in year 12 (Note: Change in net working capital is positive if revenues are increasing.) Rainy Day is expecting to sell recycled bottle raincoats for five years. At the end of the project, in year 5. Rainy Day expects to sell its machinery for $101,417. Because the machine was purchased after 2018, Rainy Day took the bonus depreciation to save money on taxes so in year 5, the book value of the machinery will be 0. What is the expected cash flow from selling the equipment given Rainy Day has a a marginal tax rate of 23%