Hello, can I get a step by step solution using excel? Thank you. This is a homework assignment in regards to understanding how to solve different problems.

Happy Times, Inc., wants to expand its party stores into the Southeast. In order to establish an immediate presence in the area, the company is considering the purchase of the privately held Joe's Party Supply. Happy Times currently has debt outstanding with a market value of $110 million and a YTM of 5 percent. The company's market capitalization is $330 million and the required return on equity is 10 percent. Joe's currently has debt outstanding with a market value of $29 million. The EBIT for Joe's next year is projected to be $12 million. EBIT is expected to grow at 9 percent per year for the next ve years before slowing to 2 percent in perpetuity. Net working capital, capital spending, and depreciation as a percentage of EBIT are expected to be 8 percent, 14 percent, and 7 percent, respectively. Joe's has 1.85 million shares outstanding and the tax rate for both companies is 30 percent. a. What is the maximum share price that Happy Times should be willing to pay for Joe's? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. After examining your analysis, the CFO of Happy Times is uncomfortable using the perpetual growth rate in cash flows. Instead, she feels that the terminal value should be estimated using the EV/EBITDA multiple. The appropriate EV/EBITDA multiple is 9. What is your new estimate of the maximum share price for the purchase? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 3216)