I'm having a hard time comprehending the bulk of these formulas and putting them into Excel format.

Chapter 9: The Cost of Capital Corporate Finance: A Focused Approach Chapter Contents Chapter Review Mini Case During the last few years, Jana Industries has been too constrained by the high cost of capital to make many capital investments. Recently, though, capital costs have been declining, and the company has decided to look seriously at a major expansion program proposed by the marketing department. Assume that you are an assistant to Leigh Jones, the financial vice president. Your first task is to estimate Jana's cost of capital. Jones has provided you with the following data, which she believes may be relevant to your ta sk