Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question
The image displays a spreadsheet related to calculating the cost of capital for a firm. The spreadsheet is titled "Cost of Capital Case 3" and has tabs for different worksheets: "Required Return," "Market Value Weights," "WACC," "Marginal WACC," and "Capital Budget Decision."

### Spreadsheet Breakdown

**Table: Market Value Weights** 

- **Columns:**
  - Source
  - Price
  - Units
  - Total Market Value
  - % of Total

- **Rows:**
  - Debt
    - Price: $704.53
  - Preferred Equity
    - Price: 100.00
    - Units: 1,000
  - Common Equity
    - Price: 70.00

### Notes:
There is a highlighted yellow section with instructions:

- **Book Values in Firm's Capital Structure:**
  - Long Term Debt: $400,000 ($1000.00 par), Percent: 40%
  - Preferred Equity: $100,000 (issue price $100.00), Percent: 10%
  - Common Equity: $500,000 (issue price $50.00), Percent: 50%
  
- **Instructions:**
  - Calculate the current market weights of the capital structure.
  - Given the after-tax cost of each form of capital calculated on tab 1, find the current total market values for each form of capital.
  - Complete the table with market value and market value % of total.
  - Given the after-tax cost, calculate the Weighted Average Cost of Capital (WACC).

This spreadsheet is structured to help students understand how to calculate the weights of different forms of capital based on market values and prepare them to compute the WACC for financial analysis.
expand button
Transcribed Image Text:The image displays a spreadsheet related to calculating the cost of capital for a firm. The spreadsheet is titled "Cost of Capital Case 3" and has tabs for different worksheets: "Required Return," "Market Value Weights," "WACC," "Marginal WACC," and "Capital Budget Decision." ### Spreadsheet Breakdown **Table: Market Value Weights** - **Columns:** - Source - Price - Units - Total Market Value - % of Total - **Rows:** - Debt - Price: $704.53 - Preferred Equity - Price: 100.00 - Units: 1,000 - Common Equity - Price: 70.00 ### Notes: There is a highlighted yellow section with instructions: - **Book Values in Firm's Capital Structure:** - Long Term Debt: $400,000 ($1000.00 par), Percent: 40% - Preferred Equity: $100,000 (issue price $100.00), Percent: 10% - Common Equity: $500,000 (issue price $50.00), Percent: 50% - **Instructions:** - Calculate the current market weights of the capital structure. - Given the after-tax cost of each form of capital calculated on tab 1, find the current total market values for each form of capital. - Complete the table with market value and market value % of total. - Given the after-tax cost, calculate the Weighted Average Cost of Capital (WACC). This spreadsheet is structured to help students understand how to calculate the weights of different forms of capital based on market values and prepare them to compute the WACC for financial analysis.
# Capital Structure Information

**Source and Price Details:**

- **Debt:**
  - Price: $704.53

- **Preferred:**
  - Price: $100.00

- **Common:**
  - Price: $70.00

**Additional Bond Data:**

- **Tax Rate:** 30%
- **Coupon Rate:** 10%
- **Face Value:** $1,000.00
- **Maturity:** 10 years
- **Yield to Maturity:** (not provided)

**Additional Preferred Data:**

- **Dividend:** $10.00
- **Required Return:** (to be filled in)

**Additional Common Data:**

- **Dividend (D0):** $3.66
- **Growth Rate:** 6%
- **Required Return:** (to be filled in)

**Instructions:**

Please fill in the yellow boxes given the information to the left. These represent the current costs of financing.

**Tabs at the Bottom:**

1. Required Return
2. Market Value Weights
3. WACC (Weighted Average Cost of Capital)
4. Marginal WACC
5. Capital Budget Decision

This document appears to be a spreadsheet used for calculating various financial metrics related to the cost of capital and budgeting decisions for a company, focusing on debt, preferred stock, and common equity.
expand button
Transcribed Image Text:# Capital Structure Information **Source and Price Details:** - **Debt:** - Price: $704.53 - **Preferred:** - Price: $100.00 - **Common:** - Price: $70.00 **Additional Bond Data:** - **Tax Rate:** 30% - **Coupon Rate:** 10% - **Face Value:** $1,000.00 - **Maturity:** 10 years - **Yield to Maturity:** (not provided) **Additional Preferred Data:** - **Dividend:** $10.00 - **Required Return:** (to be filled in) **Additional Common Data:** - **Dividend (D0):** $3.66 - **Growth Rate:** 6% - **Required Return:** (to be filled in) **Instructions:** Please fill in the yellow boxes given the information to the left. These represent the current costs of financing. **Tabs at the Bottom:** 1. Required Return 2. Market Value Weights 3. WACC (Weighted Average Cost of Capital) 4. Marginal WACC 5. Capital Budget Decision This document appears to be a spreadsheet used for calculating various financial metrics related to the cost of capital and budgeting decisions for a company, focusing on debt, preferred stock, and common equity.
Expert Solution
Check Mark
Step 1

Hello. Since your question has multiple sub-parts, we will solve the first three sub-parts for you. If you want the remaining sub-parts to be solved, then please resubmit the whole question and specify those sub-parts you want us to solve.

Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Text book image
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:9781260013962
Author:BREALEY
Publisher:RENT MCG
Text book image
Financial Management: Theory & Practice
Finance
ISBN:9781337909730
Author:Brigham
Publisher:Cengage
Text book image
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Text book image
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Text book image
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education