Chapter 4
Problems 132
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 AddIn" be installed in Excel.
To
Chapter 04  LongTerm Financial Planning and Growth
CHAPTER 4
LONGTERM FINANCIAL PLANNING
AND GROWTH
Answers to Concepts Review and Critical Thinking Questions
1. The reason is that, ultimately, sales are the driving force behind a business. A firms ass
Chapter 5
Problems 120
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 AddIn" be installed in Excel.
To
Chapter 05  Introduction to Valuation: The Time Value of Money
CHAPTER 5
INTRODUCTION TO VALUATION: THE
TIME VALUE OF MONEY
Answers to Concepts Review and Critical Thinking Questions
1.
The four parts are the present value (PV), the future value (FV), th
Chapter 06
Discounted Cash Flow Valuation

CHAPTER 6
DISCOUNTED CASH FLOW VALUATION
Answers to Concepts Review and Critical Thinking Questions
1.
The four pieces are the present value (PV), the periodic cash flow (C), the discount rate (r), and the
numbe
Chapter 6
Problems 175
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 AddIn" be installed in Excel.
To
Chapter 9
Problems 128
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 AddIn" be installed in Excel.
To
Chapter 10
Problems 136
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 AddIn" be installed in Excel.
To