Ross, Westerfield, and Jordan's Spreadsheet Master
Fundamentals of Corporate Finance, 11th edition
by Brad Jordan and Joe Smolira
Version 11.0
Chapter 11
In these spreadsheets, you will learn how to use the following Excel functions:
Scenario Manager
One-
Ross, Westerfield, and Jordan's Spreadsheet Master
Fundamentals of Corporate Finance, 11th edition
by Brad Jordan and Joe Smolira
Version 11.0
Chapter 21
In these spreadsheets, you will learn how to use the following Excel functions:
Data Connections
Dash
TO:
FROM:
DATE:
RE:
Justin Wood
Heidi Peterson
March 5, 2015
Fun Toys Cash Budget
_
_
Per you request, the Treasury Department has completed a cash budget for next year. The
Marketing Department provided the sales budget for next year. Our current sales b
Chapter 5
Problems 1, 2, 3, 4, 5
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in E
Chapter 4
Problems 5, 6, 20, 22
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Ex
Chapter 2
Problems 2, 3, 4, 6, 7, 14, 15, 19
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be in
Chapter 26
Problems 2, 4, 5, 10
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Ex
Chapter 27
Problems 1, 3, 8
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
Chapter 25
Problems 3, 9, 18, 20
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in E
Chapter 24
Problems 7, 8, 11, 14, 22
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed
Chapter 16
Problems 6, 12
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
T
Chapter 23
Problem 1
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To ins
Chapter 21
Problems 2, 3, 5, 15
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Ex
Chapter 18
Problems 5, 6
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 17
Problems 5, 12
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
T
Chapter 14
Problems 4, 10
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
T
Chapter 15
Problems 1, 7
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-in" be installed in Excel.
To
Chapter 13
Problems 11, 20, 23, 24
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in
Chapter 11
Problems 5, 17
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
T
Chapter 12
Problems 7, 8
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To
Chapter 7
Problems 4, 6, 7, 21, 32
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in
CFIN3 Chapter 8 Homework Solutions
8-2
8-3
8-4
r = 5% + (12% - 5%)1.5 = 15.5%
r = 4% + (5%)2.0 = 14%
CVD = 8.0%/10.0% = 0.8
CVE = 24.0%/36% = 0.6667
Stock E has the lower coefficient of variation, so it has the lower relative risk.
8-6
a.
= (0.3)(15%) + (