Please show me how to complete these problems in Excel. Thank you!

3 Chapter 10 -- Capital Structure 4 5 Minicase 6 7 David Lyons, the CEO of Lyons Bio Technologies, is concerned about his firm's level of debt financing. 8 The company uses short-term debt to finance its temporary working capital needs, but it does not use 9 any permanent (long-term) debt. Other technology companies average about 30 percent debt, and 10 Mr. Lyons wonders why the difference occurs, and what its effects are on stock prices. To gain some 11 insights into the matter, he poses the following questions to you, his recently hired assistant. 12 13 a. Lyons has EBIT = $500,000 and its cost of equity is R(Reu) = 14%. Currently Lyons uses no debt 14 financing, but it has been told by an investment bank that it could borrow $500,000, $1,000,000, 15 $1,500,000, or $2,000,000 at a cost of R(Rd) = 8%. There are no taxes. Assume that the MM 16 without taxes assumptions hold. 17 - Complete the table below. 18 Graph the relationships between R(Rd), R(Re), and CCC and leverage as measured by DN. 19 20 D (000s) V E DAV E/V R(Rd) R(Re) CCC 21 $0 $3,571,428.57 22 $500 $3,571,428.57 23 $1,000 $3,571,428.57 24 $1,500 $3,571,428.57 25 $2,000 $3,571,428.57 26 EBIT Cost of equity $500,000 0.14 $0 26 27 b. Using the data given in part a., assume that Lyons is subject to a 30 percent corporate tax rate. 28 Repeat the part a. analysis under the MM with-tax model. 29 30 D V E D/ EN R(Rd) (Rd)*(1-T R(Re) 31 32 $500 33 $1,000 34 $1,500 35 $2,000 36 37