please show work or formulas in excel

7. (10 points) AAA Corporation and BBB Corporation are identical in every way except their capital structures. AAA Corporation, an all-equity firm, has 40million shares of stock outstanding, currently worth $15 per share. BBB Corporation uses leverage in its capital structure. The market value of BBB's debt is $100 million and its cost of debt is 6.7 percent. Each firm is expected to have earnings before interest of $200 million in perpetuity. Assume that every investor can borrow at 6.7 percent per year. Corporate tax rate is 35%. 1). What is the value of AAA Corporation? 2). What is the value of BBB Corporation? 3). What is the market value of BBB Corporation's equity? 4). What would be the BBB's cost of equity (Rs)? 5). What would be BBB's weighted average cost of capital (WACC)