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 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 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 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 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 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 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 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

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

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

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

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%) + (

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

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 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 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 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 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 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 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

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-