Please help me solve this problem using Excel. Thank you!

A firm has the current liabilities and equity financing on its balance sheet shown below. The firm has taxable income that puts it in a 35% federal tax bracket, and the state in which it operates levies a 4.7% income tax. Compute the firm's weighted average cost of capital. The same firm is considering the following projects to improve its production process. If the firm has a capital budget of $1, 250,000, which projects should be accepted by the rate of return criteria? What is the firm's opportunity cost of capital? From your estimates of the WACC in part 1 and the opportunity cost of capital in part 2, what do you estimate the firm's true MARR to be