- Please Show Me How To Solve This In Excel 1 (27.57 KiB) Viewed 42 times
Please show me how to solve this in Excel.
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Please show me how to solve this in Excel.
Please show me how to solve this in Excel.
20. IDX Tech is looking to expand its investment in advanced security systems. The project will be financed with equity. You are trying to assess the value of the investment, and must estimate its cost of capital. You find the following data for a publicly traded firm in the same line of business Debt Outstanding (book value, AA-rated) Number of shares of common stock Stock price per share Book value of equity per share Beta of equity $397 million 81 million $17.44 $5.63 1.37 What is your estimate of the project's beta? What assumptions do you need to make?
20. IDX Tech is looking to expand its investment in advanced security systems. The project will be financed with equity. You are trying to assess the value of the investment, and must estimate its cost of capital. You find the following data for a publicly traded firm in the same line of business Debt Outstanding (book value, AA-rated) Number of shares of common stock Stock price per share Book value of equity per share Beta of equity $397 million 81 million $17.44 $5.63 1.37 What is your estimate of the project's beta? What assumptions do you need to make?