can I please get help with question 2. and also the work shown in Excel if possible

only thing the first photo is missing from the picture is " share price " after 7% thats all the information i have for the question

Max Laboratories Inc. has been operating for over thirty years producing medications and food for pets and farm animals. Due to new growth opportunities they are interested in your expert opinion on a series of issues described below. The firm has a target capital structure of 40 percent debt and 60 percent common equity, which the CFO considers to be the optimal capital structure and plans to maintain it in the future. Next year the firm forecasts Earnings per share (EPS) of $15. Max Labs has One million common shares outstanding. The firm has a line of credit at the local bank at the following interest rates: Can borrow up to $6,000,000 at an 8% interest rate; the rate goes to 10% for amounts above $6,000,000. The firm's interest subsidy tax rate is 25 percent. The firm plans to retain 70% of the forecasted Net income; the remaining 30% of the estimated profits will be paid as dividends to common shareholders next year. Currently common shares sell for $110 and the expected earnings growth is 9%. The floatation costs to raise new common equity capital, equal 7% of 2. Ciloslate the wo Marginal cost of capital brcal points. Show the amount of total capital and how much would be raised from Common Equity and Debe at each point. A) Break point when the firm needs to borrow at the higher cost of debt but still does not need to issue new equity B) Break point when the firm needs to start issuing new equity (has exhausted the retained earnings). Notice that at this point the firm is already using the higher cost of debt. Max Laboratories Inc. has been operating for over thirty years producing medications and food for pets and farm animals. Due to new growth opportunities they are interested in your expert opinion on a series of issues described below. The firm has a target capital structure of 40 percent debt and 60 percent common equity, which the CFO considers to be the optimal capital structure and plans to maintain it in the future. Next year the firm forecasts Earnings per share (EPS) of $15. Max Labs has One million common shares outstanding. The firm has a line of credit at the local bank at the following interest rates: Can borrow up to $6,000,000 at an 8% interest rate; the rate goes to 10% for amounts above $6,000,000. The firm's interest subsidy tax rate is 25 percent. The firm plans to retain 70% of the forecasted Net income; the remaining 30% of the estimated profits will be paid as dividends to common shareholders next year. Currently common shares sell for $110 and the expected earnings growth is 9%. The floatation costs to raise new common equity capital, equal 7% of 2. Ciloslate the wo Marginal cost of capital brcal points. Show the amount of total capital and how much would be raised from Common Equity and Debe at each point. A) Break point when the firm needs to borrow at the higher cost of debt but still does not need to issue new equity B) Break point when the firm needs to start issuing new equity (has exhausted the retained earnings). Notice that at this point the firm is already using the higher cost of debt