Ross, Westerfield, and Jaffe's Spreadsheet Master
Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 16
In these spreadsheets, you will learn how to use the following Excel functions:
Scroll bars
Pie charts
The following con
Ross, Westerfield, and Jaffe's Spreadsheet Master
Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 13
In these spreadsheets, you will learn how to use the following Excel functions:
Hyperlink
The following conventions are
1.
On March 1, you contract to take delivery of 1 ounce of gold for $495. The agreement is good
for any day up to April 1. Throughout March, the price of gold hit a low of $425 and hit a high of
$535. The price settled on March 31 at $505, and on April 1s
1. Michael's Motor Scooters has 1,000 shares outstanding each with a par value of $0.05. If
they are sold to shareholders at $5 each, what would the capital surplus be?
$5,000
$4,950
$4,400
$4,500
$4,750
2. A stock had returns of 6%, 13%, -11%, and 17% ov
Chapter 29
Problems 3, 5, 7, 10, 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 i
Chapter 25
Problems 6, 9
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 22
Problems 4, 6, 10, 12, 23
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
Ross, Westerfield, and Jaffe's Spreadsheet Master
Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 22
In these spreadsheets, you will learn how to use the following Excel functions:
EXP
LN
NORMSDIST
ActiveX Control
The fol
Chapter 21
Problems 4, 7, 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
Chapter 10
Problems 4, 6, 10, 18 ,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 installed
Chapter 13
Problems 2, 5, 7, 11, 14
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 i
Chapter 15
Problems 6, 9
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 16
Problems 2, 6, 12, 16
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 17
Problems 1, 2, 3, 6, 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
Chapter 18
Problems 1, 2, 3, 6, 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
Chapter 19
Problems 2, 4, 6, 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 20
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
Ross, Westerfield, and Jaffe's Excel Master
Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 10
In these spreadsheets, you will learn how to use the following Excel functions:
Column charts
COUNTIF
Sorting data
Filtering d