Please show in Excel.

Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system in this year's capital budget. The projects are independent. The cash outlay for the truck is $17,100 and for the pulley system it is $22,430. After tax cash flows are as follows: The firm has $200,000 in debt with an interest rate of 6.5%$100,000 in preferred stock with an annual dividend rate of 9.5%, and $250,000 in equity with a cost of 17.0%. Edelman's tax rate is 25%. Calculate the WACC to be used for this project? Calculate the NPV, PI, IRR, PB, DPB for each project. Indicate the correct accept or reject decision for each project