Ross, Westerfield, and Jordan's Spreadsheet Master
Fundamentals of Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 4
In these spreadsheets, you will learn how to use the followin
IF
Data tables
Graphing
Iterative calculat
Read the minicase 'Planning for Growth at S&S Air' on pages 117-118 of your text; click HERE for the Excel template which
you will use to prepare this assignment.
1. Calculate the a) internal growth rate and b) sustainable growth rate for S&S Air; c) what
Ross, Westerfield, and Jordan's Spreadsheet Master
Fundamentals of Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 7
In these spreadsheets, you will learn how to use the followin
PRICE
YIELD
DURATION
MDURATION
COUPDAYSNC
CHAPTER 5
INTRODUCTION TO VALUATION: THE TIME
VALUE OF MONEY
Solutions to Questions and Problems
Basic
1.
The simple interest per year is:
$5,000 .08 = $400
So after 10 years you will have:
$400 10 = $4,000 in interest.
The total balance will be $5,000 +
Chapter 7 Mini Case 4:
Financing S&S Airs Expansion Plans with a Bond Issue
Mark Sexwale and Thandi Shilowa, the owners of S&S Air have decided to expand
their operations. They instructed their newly hired financial analyst, Chris Gumede to
enlist an unde
Chapter 4
Planning for Growth at S&S Air
Input area:
Sales
COGS
Other expenses
Depreciation
EBIT
Interest
Taxable income
Taxes (40%)
Net income
$30,499,420
22,224,580
3,867,500
1,366,680
$3,040,660
478,240
$2,562,420
1,024,968
$1,537,452
Dividends
Add to
Chapter 3
Ratios and Financial Planning at S&S Air
Input area:
Sales
COGS
Other expenses
Depreciation
EBIT
Interest
Taxable income
Taxes (40%)
Net income
$30,499,420
22,224,580
3,867,500
1,366,680
$3,040,660
478,240
$2,562,420
1,024,968
$1,537,452
Dividen
Ross, Westerfield, and Jordan's Spreadsheet Master
Fundamentals of Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 8
In these spreadsheets, you will learn how to use the followin
Formatting values as text
Concatenation
We
Read the minicase 'Planning for Growth at S&S Air' on pages 117-118 of your text; click HERE for the Excel template which
you will use to prepare this assignment.
1. Calculate the a) internal growth rate and b) sustainable growth rate for S&S Air; c) what
Chapter 10
Conch Republic Electronics, Part 1
Input Area:
Equipment
Salvage value
R&D
Marketing study
Sales(units)
Depreciation rate
Sales of old PDA
Lost sales
Price
VC
FC
Price of old PDA
Price reduction
of old PDA
VC of old PDA
Tax rate
NWC percentage
Ross, Westerfield, and Jordan's Spreadsheet Master
Fundamentals of Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 6 (Beta)
In these spreadsheets, you will learn how to use the followin
SUM
NPV
PV of an annuity
PMT
Annuit
CHAPTER 2
FINANCIAL STATEMENTS, TAXES AND CASH
FLOW
Solutions to Questions and Problems
NOTE: All end of chapter problems were solved using a spreadsheet. Many problems require multiple steps. Due to space
and readability constraints, when these intermedi
Lesson
Chapter 7 Assignment
#4,
Assignment
#2:
Read the minicase 'Financing S&S Air's Expansion Plans with a Bond Issue' on page 230 of your text; use Word
to submit the assignment below.
Prepare a memo describing the potential effect of each of the follo
CHAPTER 6
DISCOUNTED CASH FLOW VALUATION
Solutions to Questions and Problems
NOTE: All end of chapter problems were solved using a spreadsheet. Many problems require multiple steps. Due to space
and readability constraints, when these intermediate steps a
Chapter 9
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE:Somefunctionsusedinthesespreadsheetsmayrequirethat
the"AnalysisToolPak"or"SolverAddIn"beinstalledinExcel.
Toinstallthese,clickontheOfficebutto
Ross, Westerfield, and Jordan's Spreadsheet Master
Fundamentals of Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 9 (Beta)
In these spreadsheets, you will learn how to use the followin
N PV
XN PV
AN D
ABS
M AX
COU N T I
Chapter 10
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE:Somefunctionsusedinthesespreadsheetsmayrequirethat
the"AnalysisToolPak"or"SolverAddIn"beinstalledinExcel.
Toinstallthese,clickontheOfficebutt
Chapter 4
Planning for Growth at S&S Air
Input area:
Sales
COGS
Other expenses
Depreciation
EBIT
Interest
Taxable income
Taxes (40%)
Net income
$30,499,420
22,224,580
3,867,500
1,366,680
$3,040,660
478,240
$2,562,420
1,024,968
$1,537,452
Dividends
Add to
Fundamentals of Corporate Finance
4th South African Edition
Firer, Ross, Westerfield & Jordan
Case Solutions
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
Case #
1
2
3
4
5
6
7
8
9
10
ons
List of Mini-Cas
L esson #3, Assignment #2:
C hapter 5 Assignment
Solve the following problems; you may submit in a Word or Excel document, whichever you find
convenient.
As a lways, it is recommended that you show your work so that in the event your fina l
a nswer is inc
S&S Air, Inc.
Case questions
What does an extended DuPont analysis
(ROE) indicate about the performance of
the company?
4.
What problem does S&S Air, Inc. face in
this case?
What do the rates of growth (IGR and
SGR) indicate about the companys
performance
Chapter 8
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE:Somefunctionsusedinthesespreadsheetsmayrequirethat
the"AnalysisToolPak"or"SolverAddIn"beinstalledinExcel.
Toinstallthese,clickontheOfficebutto
Chapter 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 install these,
Chapter 6
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE:Somefunctionsusedinthesespreadsheetsmayrequirethat
the"AnalysisToolPak"or"SolverAddIn"beinstalledinExcel.
Toinstallthese,clickontheOfficebutto
CHAPTER 8
STOCK VALUATION
Answers to Concepts Review and Critical Thinking Questions
1.
The value of any investment depends on the present value of its cash flows; i.e., what investors will actually receive.
The cash flows from a share of stock are the di
CHAPTER 7
INTEREST RATES AND BOND VALUATION
Calculator Solutions
3.
Enter
10
N
8.75%
I/Y
PV
$918.89
Solve for
4.
Enter
9
N
Solve for
5.
Enter
13
N
$934
PV
I/Y
10.15%
7.5%
I/Y
$1,045
PV
Solve for
Coupon rate = $80.54 / $1,000 = 8.05%
6.
Enter
20
N
3.70%
I/