Chapter 17
Problems 1-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 Excel.
To
Chapter 3
Problems 1-30
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 4
Problems 1-33
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 8
Problems 1-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 Excel.
To
Chapter 6
Problems 1-78
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 1-35
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 9
Problems 1-28
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 10
Problems 1-36
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 1-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 Excel.
To
Chapter 13
Problems 1-28
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 12
Problems 1-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 Excel.
To
Cash Flows Types
1. Lump Sum: A single sum of money
PV
FVn
(1 i ) n
FVn PV (1 i) n
2. Annuity and perpertuity: Annuity is the periodic cash flows of the same amount for a given period.
C
C
i
PVA
N
i
(1i)N
C (1 i ) N C
FVA
N
i
i
3. Uneven cash flows: A s
Price history of three series
180
3000
160
2500
140
120
2000
100
80
1500
60
1000
40
20
500
0
-20
0
HD Prices 44.188492
MSFT
MSFT Prices 25.27927
SNP
HD
SNP Prices 1310.329956
SUMMARY OUTPUT
R-Square
Beta is
Regression Statistics
Multiple R
0.448844
R Squa
Chapter 2
Problems 1-26
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 5
Problems 1-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 Excel.
To
Chapter 14
Problems 1-26
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 1-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 Excel.
To
Chapter 15
Problems 1-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 Excel.
To
Chapter 18
Problems 1-18
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 19
Problems 1-12, Appendix 1-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 install
Chapter 20
Question 16
Input Area:
Sales
Cost per unit
Probablity of default
Initial charge to subscribe
Cost of each credit report
500
$490
4%
$450
$5.00
Output Area:
Cost of subscription
Savings from credit reports
$2,950.00
$9,800.00
Net savings
$6,850
Chapter 21
Problems 1-18
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 23
Problems 1-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
Case Solutions
Fundamentals of Corporate Finance
Ross, Westerfield, and Jordan
9th edition
CHAPTER 1
THE McGEE CAKE COMPANY
1.
The advantages to a LLC are: 1) Reduction of personal liability. A sole proprietor has unlimited
liability, which can include th
Chapter 27
Problems 1-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.
To
Chapter 25
Problems 1-30
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 24
Problems 1-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 Excel.
To
Microsoft Corporation (NMS: MSFT)
Standardized Annual Balance Sheet
Report Date
Scale
Cash & Equivalents
Short Term Investments
Cash & Equivs & ST Investments
Receivables (ST)
Inventories
Current Tax Assets
Other Current Assets
Total Current Assets
06/30/