Excel modeling and estimation in corporate finance:
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Upper Saddle River, NJ
Pearson Education Internat.
2009
|
| Edition: | 3. ed., Internat. ed. |
| Series: | Prentice-Hall series in finance
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XVI, 198 S. Ill., graph. Darst. 1 CD-ROM |
| ISBN: | 9780136089063 0136089062 0136025633 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV035494664 | ||
| 003 | DE-604 | ||
| 005 | 20100120 | ||
| 007 | t | ||
| 008 | 090518s2009 ad|| |||| 00||| eng d | ||
| 020 | |a 9780136089063 |c pbk |9 978-0-13-608906-3 | ||
| 020 | |a 0136089062 |9 0-13-608906-2 | ||
| 020 | |a 0136025633 |c CDROM |9 0-13-602563-3 | ||
| 020 | |a 9780136089063 |c CDROM |9 978-0-13-608906-3 | ||
| 035 | |a (OCoLC)476416628 | ||
| 035 | |a (DE-599)BVBBV035494664 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-N2 |a DE-355 | ||
| 084 | |a QP 700 |0 (DE-625)141926: |2 rvk | ||
| 100 | 1 | |a Holden, Craig W. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Excel modeling and estimation in corporate finance |c Craig W. Holden |
| 250 | |a 3. ed., Internat. ed. | ||
| 264 | 1 | |a Upper Saddle River, NJ |b Pearson Education Internat. |c 2009 | |
| 300 | |a XVI, 198 S. |b Ill., graph. Darst. |e 1 CD-ROM | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Prentice-Hall series in finance | |
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 4 | |a Mathematisches Modell | |
| 650 | 4 | |a Corporations |x Finance |x Computer programs | |
| 650 | 4 | |a Corporations |x Finance |x Mathematical models | |
| 650 | 4 | |a Electronic spreadsheets | |
| 650 | 0 | 7 | |a Finanzierung |0 (DE-588)4017182-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Unternehmen |0 (DE-588)4061963-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Modellierung |0 (DE-588)4170297-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Unternehmen |0 (DE-588)4061963-1 |D s |
| 689 | 0 | 1 | |a Finanzierung |0 (DE-588)4017182-6 |D s |
| 689 | 0 | 2 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | 3 | |a Modellierung |0 (DE-588)4170297-9 |D s |
| 689 | 0 | |C b |5 DE-604 | |
| 856 | 4 | 2 | |m Digitalisierung UB Regensburg |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017550997&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-017550997 | ||
Record in the Search Index
| _version_ | 1804139110613385216 |
|---|---|
| adam_text | Contents
iii
CONTENTS
Preface
.....................................................................................
vii
Third Edition Changes
....................................................................................
vii
What Is Unique About This Book
.....................................................................
χ
Conventions Used In This Book
.......................................................................xi
Craig s Challenge
...........................................................................................xiii
The Excel Modeling and Estimation Series
..................................................xiii
Suggestions for Faculty Members
..................................................................xiv
Acknowledgements
...........................................................................................xv
About The Author
.................................................................xvi
PART
1
TIME VALUE OF MONEY
.....1
Chapter
1
Single Cash Flow
....................................................1
1.1
Present Value
...............................................................................................1
1.2
Future Value
................................................................................................2
Problems
..............................................................................................................3
Chapter
2
Annuity
...................................................................4
2.1
Present Value
...............................................................................................4
2.2
Future Value
................................................................................................5
2.3
System of Four Annuity Variables
.............................................................6
Problems
..............................................................................................................8
Chapter
3
NPV Using Constant Discounting
........................9
3.1
Nominal Rate
...............................................................................................9
3.2
Real Rate
....................................................................................................10
Problems
__..___................................................................................................11
Chapter
4
NPV Using General Discounting
........................12
4.1
Nominal Rate
.............................................................................................12
4.2
Real Rate
....................................................................................................14
Problems
............................................................................................................16
Chapter
5
Loan Amortization
................__..........................17
5.1
Basics
..........................................................................................................17
5.2
Sensitivity Analysis
....................................................................................18
Problems
............................................................................................................20
PART
2
VALUATION..
.........................21
Chapter
6
Bond Valuation
....................................................21
6.1
Annual Payments
........................................................................................21
6.2
EAR and APR
.............................................................................................22
63
By Yield To Maturity
................................................................................23
6.4
Dynamic Chart
............................................................................__.____24
6.5
System of Five Bond Variables
.................................................................25
Problems
............................................................................................................26
iv Contents
Chapter
7
Estimating the Cost of Capital
...........................28
7.1
Static CAPM Using Fama-MacBeth Method
..........................................28
7.2
APT or
Intertemporal
САРМ
Using Fama-McBeth Method
................33
Problems
............................................................................................................40
Chapter
8
Stock Valuation
....................................................42
8.1
Dividend Discount Model
..........................................................................42
Problems
............................................................................................................43
Chapter
9
Firm and Project Valuation
................................44
9.1
Cash Flows for Five Equivalent Methods
................................................44
9.2
Adjusted Present Value
.............................................................................47
9.3
Free Cash Flow To Equity
........................................................................48
9.4
Free Cash Flow to the Firm
......................................................................50
9.5
Dividend Discount Model
..........................................................................52
9.6
Residual Income
.........................................................................................53
9.7
Five Equivalent Methods
..........................................................................54
Problems
............................................................................................................63
Appendix: Where did those Two-Stage Formulas for the Cost of Equity
Capital and the Cost of Firm Capital come from?
........................................64
Chapter
10
The Yield Curve
.................................................70
10.1
Obtaining It From Treasury Bills and Strips
........................................70
10.2
Using It To Price A Coupon Bond
..........................................................71
10.3
Using It To Determine Forward Rates
..................................................73
Problems
............................................................................................................74
Chapter
11
US Yield Curve Dynamics
................................75
11.1
Dynamic Chart.
........................................................................................75
Problems
............................................................................................................81
PART
3
CAPITAL BUDGETING
........83
Chapter
12
Project NPV.....
...................................................83
12.1
Basics
........................................................................................................83
12.2
Forecasting Cash Flows
...........................................................................86
12.3
Working Capital
.......................................................................................87
12.4
Sensitivity Analysis
..................................................................................89
Problems
............................................................................................................92
Chapter
13
Cost-Reducing Project
......................................93
13.1
Basics
........................................................................................................93
13.2
Sensitivity Analysis
..................................................................................96
Problems
............................................................................................................96
Chapter
14
Break-Even Analysis
.........................................98
14.1
Based On Accounting Profit
...................................................................98
14.2
Based On NPV
.......................................................................................101
Problems
..........................................................................................................105
Contents
v
PART
4
FINANCIAL PLANNING
....106
Chapter
15
Corporate Financial Planning.....
..................106
15.1
Actual
......................................................................................................106
15.2
Forecast
..................................................................................................109
15.3
Cash Flow
...............................................................................................113
15.4
Ratios
......................................................................................................115
15.5
Sensitivity
...............................................................................................117
15.6
Full-Scale Estimation
............................................................................118
Problems
..........................................................................................................124
Chapter
16
Du Pont
System Of Ratio Analysis
................127
16.1
Basics
......................................................................................................127
Problems
..........................................................................................................128
Chapter
17
Life-Cycle Financial Planning
.......................129
17.1
Basics
......................................................................................................129
17.2
Full-Scale Estimation
............................................................................131
Problems
..........................................................................................................139
PART
5
OPTIONS AND CORPORATE
FINANCE
...............................................140
Chapter
18
Binomial Option Pricing
................................140
18.1
Estimating Volatility
.............................................................................140
18.2
Single Period
..........................................................................................141
18.3
Multi-Period
...........................................................................................143
18.4
RiskNeutral
...........................................................................................149
18.5
American With Discrete Dividends
......................................................152
18.6
Full-Scale
................................................................................................156
Problems
..........................................................................................................164
Chapter
19
Real Options
....................................................166
19.1
NPV Correctly vs. NPV Ignoring Option
............................................166
Problems
..........................................................................................................169
Chapter
20
Black Scholes Option Pricing
........................170
20.1
Basics
......................................................................................................170
20.2
Continuous Dividend
.............................................................................171
20.3
Dynamic Chart.
......................................................................................172
20.4
Implied Volatility
...................................................................................175
Problems
..........................................................................................................177
Chapter
21
Debt And Equity Valuation
...........................179
21.1
Two Methods
..........................................................................................179
21.2
Impact of Risk
........................................................................................181
Problems
..........................................................................................................182
Chapter
22
International Parity
........................................183
22.1
System of Four Parity Conditions
........................................................183
22.2
Estimating Future Exchange Rates
......................................................185
Problems
..........................................................................................................187
vi
Contents
PART
6
EXCEL SKILLS
....................188
Chapter
23
Useful Excel Tricks
.........................................188
23.1
Quickly Delete The Instructions and Arrows
......................................188
23.2
Freeze Panes
...........................................................................................188
23.3
Spin Buttons and the Developer Tab
...................................................189
23.4
Option Buttons and Group Boxes
........................................................190
23.5
Scroll Bar
................................................................................................192
23.6
Install Solver or the Analysis ToolPak
.................................................193
23.7
Format Painter
.......................................................................................193
23.8
Conditional Formatting
........................................................................194
23.9
Fill Handle
..............................................................................................195
23.10
2-D Scatter Chart
................................................................................195
23.11 3-D
Surface Chart
................................................................................197
Contents on CD
Ш
Readme.txt
и
Excel Mod
Est
in Corp Fin 3.pdf
Ш
Ch
01
Single Cash
Flow.xlsx
Ш
Ch
02
Annuity .xlsx
Ш
Ch
03
NPV Constant Discntxlsx
Ш
Ch
04
NPV General Discntxlsx
ѕШ
Ch
05
Loan Amortization.xlsx
Ш
Ch
06
Bond Valuation.xlsx
Ш
Ch
07
Cost of Capital.xlsx
Ü
Ch
08
Stock Valuation.xlsx
Ш
Ch
09
Firm and Project Val.xlsx
Ш
Ch
10
The Yield Curve.xlsx
Ш
Ch
11
US Yield Curve Dynam.xlsx
Ш
Ch
12
Project NPV.xlsx
И
Ch
13
Cost Reducing Proj.xlsx
si Ch
14
Break Even Analysis.xlsx
Ш
Ch
15
Corp Financial Plan.xlsx
Щ
Ch
16
DuPont Ratio Anal.xlsx
Ш
Ch
17
Life-Cycle Fin Plan.xlsx
® Ch
18
Binomial Option Pric.xlsx
Ш
Ch
19
Real Options.xlsx
Ш
Ch
20
Black Scholes Opt Pr.xlsx
® Ch21 Debt and Equity Val.xlsx
eI Ch
22
International Parity.xlsx
Q
Files in Excel
97-2003
Format
|
| any_adam_object | 1 |
| author | Holden, Craig W. |
| author_facet | Holden, Craig W. |
| author_role | aut |
| author_sort | Holden, Craig W. |
| author_variant | c w h cw cwh |
| building | Verbundindex |
| bvnumber | BV035494664 |
| classification_rvk | QP 700 |
| ctrlnum | (OCoLC)476416628 (DE-599)BVBBV035494664 |
| discipline | Wirtschaftswissenschaften |
| edition | 3. ed., Internat. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02028nam a2200505 c 4500</leader><controlfield tag="001">BV035494664</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20100120 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">090518s2009 ad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780136089063</subfield><subfield code="c">pbk</subfield><subfield code="9">978-0-13-608906-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0136089062</subfield><subfield code="9">0-13-608906-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0136025633</subfield><subfield code="c">CDROM</subfield><subfield code="9">0-13-602563-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780136089063</subfield><subfield code="c">CDROM</subfield><subfield code="9">978-0-13-608906-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)476416628</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV035494664</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-N2</subfield><subfield code="a">DE-355</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 700</subfield><subfield code="0">(DE-625)141926:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Holden, Craig W.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Excel modeling and estimation in corporate finance</subfield><subfield code="c">Craig W. Holden</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">3. ed., Internat. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Upper Saddle River, NJ</subfield><subfield code="b">Pearson Education Internat.</subfield><subfield code="c">2009</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVI, 198 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield><subfield code="e">1 CD-ROM</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Prentice-Hall series in finance</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Mathematisches Modell</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations</subfield><subfield code="x">Finance</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations</subfield><subfield code="x">Finance</subfield><subfield code="x">Mathematical models</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Electronic spreadsheets</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Finanzierung</subfield><subfield code="0">(DE-588)4017182-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Unternehmen</subfield><subfield code="0">(DE-588)4061963-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Modellierung</subfield><subfield code="0">(DE-588)4170297-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Unternehmen</subfield><subfield code="0">(DE-588)4061963-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Finanzierung</subfield><subfield code="0">(DE-588)4017182-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="3"><subfield code="a">Modellierung</subfield><subfield code="0">(DE-588)4170297-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="C">b</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Regensburg</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017550997&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-017550997</subfield></datafield></record></collection> |
| id | DE-604.BV035494664 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T21:38:52Z |
| institution | BVB |
| isbn | 9780136089063 0136089062 0136025633 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-017550997 |
| oclc_num | 476416628 |
| open_access_boolean | |
| owner | DE-N2 DE-355 DE-BY-UBR |
| owner_facet | DE-N2 DE-355 DE-BY-UBR |
| physical | XVI, 198 S. Ill., graph. Darst. 1 CD-ROM |
| publishDate | 2009 |
| publishDateSearch | 2009 |
| publishDateSort | 2009 |
| publisher | Pearson Education Internat. |
| record_format | marc |
| series2 | Prentice-Hall series in finance |
| spelling | Holden, Craig W. Verfasser aut Excel modeling and estimation in corporate finance Craig W. Holden 3. ed., Internat. ed. Upper Saddle River, NJ Pearson Education Internat. 2009 XVI, 198 S. Ill., graph. Darst. 1 CD-ROM txt rdacontent n rdamedia nc rdacarrier Prentice-Hall series in finance Microsoft Excel (Computer file) Mathematisches Modell Corporations Finance Computer programs Corporations Finance Mathematical models Electronic spreadsheets Finanzierung (DE-588)4017182-6 gnd rswk-swf Unternehmen (DE-588)4061963-1 gnd rswk-swf Modellierung (DE-588)4170297-9 gnd rswk-swf EXCEL (DE-588)4138932-3 gnd rswk-swf Unternehmen (DE-588)4061963-1 s Finanzierung (DE-588)4017182-6 s EXCEL (DE-588)4138932-3 s Modellierung (DE-588)4170297-9 s b DE-604 Digitalisierung UB Regensburg application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017550997&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Holden, Craig W. Excel modeling and estimation in corporate finance Microsoft Excel (Computer file) Mathematisches Modell Corporations Finance Computer programs Corporations Finance Mathematical models Electronic spreadsheets Finanzierung (DE-588)4017182-6 gnd Unternehmen (DE-588)4061963-1 gnd Modellierung (DE-588)4170297-9 gnd EXCEL (DE-588)4138932-3 gnd |
| subject_GND | (DE-588)4017182-6 (DE-588)4061963-1 (DE-588)4170297-9 (DE-588)4138932-3 |
| title | Excel modeling and estimation in corporate finance |
| title_auth | Excel modeling and estimation in corporate finance |
| title_exact_search | Excel modeling and estimation in corporate finance |
| title_full | Excel modeling and estimation in corporate finance Craig W. Holden |
| title_fullStr | Excel modeling and estimation in corporate finance Craig W. Holden |
| title_full_unstemmed | Excel modeling and estimation in corporate finance Craig W. Holden |
| title_short | Excel modeling and estimation in corporate finance |
| title_sort | excel modeling and estimation in corporate finance |
| topic | Microsoft Excel (Computer file) Mathematisches Modell Corporations Finance Computer programs Corporations Finance Mathematical models Electronic spreadsheets Finanzierung (DE-588)4017182-6 gnd Unternehmen (DE-588)4061963-1 gnd Modellierung (DE-588)4170297-9 gnd EXCEL (DE-588)4138932-3 gnd |
| topic_facet | Microsoft Excel (Computer file) Mathematisches Modell Corporations Finance Computer programs Corporations Finance Mathematical models Electronic spreadsheets Finanzierung Unternehmen Modellierung EXCEL |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017550997&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT holdencraigw excelmodelingandestimationincorporatefinance |