Chapter 1, BOC Question 5 (ch01-M)
1/30/03
5. Finance is all about valuationhow do we estimate asset values, and what can we do to increase them? We develop and use Excel models throughout the book. We start this process in this chapter with simple models
Excel Locations
3/17/03
We explain and illustrate various Excel functions and operations in different BOC models, as the need for the functions arise. We provide here a listing of the various operations and indicate where they are found. Some operations a
A 1 2 3
B
C
D
E
F
G
Chapter 25. Mergers, LBOs, Divestitures, and Holding Companies
This spreadsheet illustrates a valuation for a proposed merger. The Excel functions used here were explained in detail in ear models, so to avoid clutter detailed explanati
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
B
C
D
E
F
G
H
I
Chapter 22, Other Topics in Working Capital Management
1 and 2. THE ECONOMIC ORDERING QUANTITY (EOQ) MODEL
3/19/03
The EOQ model provides a pedagogically useful explanation of invento
Worksheet for Chapter 17 BOC Questions. IPOs, Investment Banking, and Financial Restructuring
3/18/03
Introduction
This file contains four models: I. Pricing a new issue, II. Analyzing a rights offering, III. Analyzing a zero coupon bond, and IV. Analyzin
04/22/2011 07:19:49
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
B
C
D
E
F
G
Worksheet for Chapter 15 BOC Questions. Capital Structure Decisions: Part 2.
Modigliani and Miller Without Taxes
Proposition I. 1. The weighted average
A 1 2 3 4 5 6
B
C
D
E
F
G
H
I
Worksheet for Chapter 13 BOC Questions. Option Pricing and Real Options
3/17/03 Part 1 of this model analyzes financial (stock) options. Part 2, shown on a separate worksheet, analyzes real options.
Part 1. Financial Options
A 1
B
C
D
E
F
G
H
I 3/17/03
Worksheet for Chapter 12 BOC Questions. Cash Flow Estimation and Risk Analysis (ch12BOC-Model)
2
This spreadsheet illustrates the answers to the Chapter 12 BOC questions. The Excel functions used here were explained in detail i
A 1 2 3
B
C
D
E
F
G
H
I
BOC Model for Chapter 8, Financial Forecasting
3/1/03
This model goes through the steps required to make and then evaluate a financial forecast. No forecast will ever be exactly correct because the inputs cannot be predicted exactl
1 2 3 4 5 6 7
A B C D E F G H Worksheet for Chapter 7 BOC Questions We like to answer the Chapter 7 questions by going through the following model, which also helps students become more familiar with Excel. Note that the data used in this file are the sam
Worksheet for Chapter 6 BOC Questions
2/4/03
The Chapter 6 BOC questions can be answered verbally, but we like to go through the following model both to illustrate the points and to get students more familiar with Excel. Note that the data used in this fi
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
B
C
D
E
F
G
H
I
Worksheet for Chapter 5 BOC Questions
2/3/03
We like to go through an Excel exercise both to get students more famili
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
B
C
D
E
F
G
H
Worksheet for Chapter 4 BOC Questions
We use this model to illustrate some points about the bond valuation.
2/3/0
1. At the beginning of last year, you invested 4000 in 80 shares of an EU
based company. During the year, the company paid dividends of 5 per
share. At the end of the year, you sold the 80 shares for 59 a share.
Calculate your total HPY on these shares an