...EXCEL MODELING AND ESTIMATION IN CORPORATE FINANCE Third Edition CRAIG W. HOLDEN Max Barney Faculty Fellow and Associate Professor Kelley School of Business Indiana University Copyright © 2008 by Prentice Hall, Inc., Upper Saddle River, New Jersey 07458 To Kathryn, Diana, and Jimmy. Contents iii CONTENTS Preface ..................................................................................... vii Third Edition Changes .................................................................................... vii What Is Unique About This Book ..................................................................... x 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 .......................................................................................
Words: 33587 - Pages: 135
...joy and pride. Craig CONTENTS Preface PART 1 TIME VALUE OF MONEY Chapter 1 Single Cash Flow 1.1 Present Value 1.2 Future Value Problems Chapter 2 Annuity 2.1 Present Value 2.2 Future Value 2.3 System of Four Annuity Variables Problems Chapter 3 Net Present Value 3.1 Constant Discount Rate 3.2 General Discount Rate Problems Chapter 4 Real and Inflation 4.1 Constant Discount Rate 4.2 General Discount Rate Problems Chapter 5 Loan Amortization 5.1 Basics 5.2 Sensitivity Analysis Problems PART 2 VALUATION Chapter 6 Bond Valuation 6.1 Basics 6.2 By Yield To Maturity 6.3 System Of Five Bond Variables 6.4 Dynamic Chart Problems Chapter 7 Stock Valuation 7.1 Two Stage 7.2 Dynamic Chart Problems Chapter 8 The Yield Curve 8.1 Obtaining It From Bond Listings 8.2 Using It To Price A Coupon Bond 8.3 Using It To Determine Forward Rates Problems Chapter 9 U.S. Yield Curve Dynamics 9.1 Dynamic Chart Problems PART 3 CAPITAL BUDGETING Chapter 10 Project NPV 10.1 Basics 10.2 Forecasting Cash Flows 10.3 Working Capital 10.4 Sensitivity Analysis Problems Chapter 11 Cost-Reducing Project 11.1 Basics 11.2 Sensitivity Analysis Problems Chapter 12 Break-Even Analysis 12.1 Based On Accounting Profit 12.2 Based On NPV Problems Chapter 13 Three Valuation Methods 13.1 Adjusted Present Value 13.2 Flows To Equity 13.3 Weighted Average Cost of Capital Problems PART 4 FINANCIAL PLANNING Chapter 14 Corporate Financial Planning 14.1 Actual 14...
Words: 49278 - Pages: 198
...Abstract Arbitrage is a key process in the practice of financial markets and in their theoretical depiction: it allows markets to be posited as efficient without all investors being assumed to be rational. This article explores the sociology of arbitrage by means of an examination of the arbitrageurs, Long-Term Capital Management (LTCM). LTCM’s 1998 crisis is analysed using both qualitative, interview-based data and quantitative examination of price movements. It is suggested that the roots of the crisis lay in an unstable pattern of imitation that had developed in the markets within which LTCM operated. As the resulting ‘superportfolio’ began to unravel, arbitrageurs other than LTCM fled the market, even as arbitrage opportunities became more attractive, causing huge price movements against LTCM. Three features of the sociology of arbitrage are discussed: its conduct by people often personally known to each other; the possibility and consequences of imitation; and the limits on the capacity of arbitrage to close price discrepancies. It is suggested that by 1998 imitative arbitrage formed a ‘global microstructure’ in the sense of Knorr Cetina and Bruegger. Keywords: arbitrage; economic sociology; imitation; Long-Term Capital Management (LTCM); globalization; risk. Introduction Of all the contested boundaries that define the discipline of sociology, none is more crucial than the divide between sociology and economics. Despite his synthesizing ambitions, Talcott...
Words: 16475 - Pages: 66
...Slow Diffusion of Information and Price Momentum in Stocks: Evidence from Options Markets Zhuo Chen∗ Andrea Lu† September 6, 2014 Abstract This paper investigates the source of price momentum in the equity market using information from options markets. The empirical results provide direct evidence of the gradual information diffusion model in Hong and Stein (1999). Consistent with their theory, we show that a successful identification of stocks’ information diffusion stage helps explain momentum profits. We are able to enhance momentum profits by longing winner stocks with higher growth (and shorting loser stocks with larger drop) in call options implied volatility. Our empirical strategy generates a risk-adjusted alpha of 1.8% per month for a hedged winner-minus-loser portfolio over the 1996–2011 period, during which the simple momentum strategy fails to perform. The results are stronger and clearer if we use call options compared with put options, which are consistent with managers’ tendency to reveal good news and hide bad news. Our results are robust to transaction costs, choice of options’ moneyness, elimination of implied volatility persistence, and choice of options’ time-to-maturity. Finally, our results are not driven by existing stock-level characteristics, such as size, trading volume, and analyst coverage. JEL Classification: G10, G11, G12, G13 Keywords: Momentum, Implied Volatility PBC School of Finance, Tsinghua University. Email: chenzh@pbcsf.tsinghua.edu.cn...
Words: 22536 - Pages: 91
...introduction to econometrics specifically written for finance students. It includes examples and case studies which finance students will recognise and relate to. This new edition builds on the successful data- and problem-driven approach of the first edition, giving students the skills to estimate and interpret models while developing an intuitive grasp of underlying theoretical concepts. Key features: ● Thoroughly revised and updated, including two new chapters on ● ● ● ● ● ● panel data and limited dependent variable models Problem-solving approach assumes no prior knowledge of econometrics emphasising intuition rather than formulae, giving students the skills and confidence to estimate and interpret models Detailed examples and case studies from finance show students how techniques are applied in real research Sample instructions and output from the popular computer package EViews enable students to implement models themselves and understand how to interpret results Gives advice on planning and executing a project in empirical finance, preparing students for using econometrics in practice Covers important modern topics such as time-series forecasting, volatility modelling, switching models and simulation methods Thoroughly class-tested in leading finance schools Chris Brooks is Professor of Finance at the ICMA Centre, University of Reading, UK, where he also obtained his PhD. He has published over sixty articles in leading academic and practitioner journals including the Journal of...
Words: 195008 - Pages: 781
...econometrics specifically written for finance students. It includes examples and case studies which finance students will recognise and relate to. This new edition builds on the successful data- and problem-driven approach of the first edition, giving students the skills to estimate and interpret models while developing an intuitive grasp of underlying theoretical concepts. Key features: ● Thoroughly revised and updated, including two new chapters on ● ● ● ● ● ● panel data and limited dependent variable models Problem-solving approach assumes no prior knowledge of econometrics emphasising intuition rather than formulae, giving students the skills and confidence to estimate and interpret models Detailed examples and case studies from finance show students how techniques are applied in real research Sample instructions and output from the popular computer package EViews enable students to implement models themselves and understand how to interpret results Gives advice on planning and executing a project in empirical finance, preparing students for using econometrics in practice Covers important modern topics such as time-series forecasting, volatility modelling, switching models and simulation methods Thoroughly class-tested in leading finance schools Chris Brooks is Professor of Finance at the ICMA Centre, University of Reading, UK, where he also obtained his PhD. He has published over sixty articles in leading academic and practitioner journals including ...
Words: 195008 - Pages: 781
...Retailing in the 21st Century Manfred Krafft ´ Murali K. Mantrala (Editors) Retailing in the 21st Century Current and Future Trends With 79 Figures and 32 Tables 12 Professor Dr. Manfred Krafft University of Muenster Institute of Marketing Am Stadtgraben 13±15 48143 Muenster Germany mkrafft@uni-muenster.de Professor Murali K. Mantrala, PhD University of Missouri ± Columbia College of Business 438 Cornell Hall Columbia, MO 65211 USA mantralam@missouri.edu ISBN-10 3-540-28399-4 Springer Berlin Heidelberg New York ISBN-13 978-3-540-28399-7 Springer Berlin Heidelberg New York Cataloging-in-Publication Data Library of Congress Control Number: 2005932316 This work is subject to copyright. All rights are reserved, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilm or in any other way, and storage in data banks. Duplication of this publication or parts thereof is permitted only under the provisions of the German Copyright Law of September 9, 1965, in its current version, and permission for use must always be obtained from Springer-Verlag. Violations are liable for prosecution under the German Copyright Law. Springer is a part of Springer Science+Business Media springeronline.com ° Springer Berlin ´ Heidelberg 2006 Printed in Germany The use of general descriptive names, registered names, trademarks, etc. in this publication does not...
Words: 158632 - Pages: 635
...in a database or retrieval system, without prior written permission of the publisher. This McGraw−Hill Primis text may include materials submitted to McGraw−Hill for publication by the instructor of this course. The instructor is solely responsible for the editorial content of such materials. 111 FINAGEN ISBN: 0−390−55204−6 Finance Contents Ross−Westerfield−Jaffe • Corporate Finance, Seventh Edition I. Overview 1 1 20 34 34 35 70 98 130 152 152 193 219 219 241 241 275 1. Introduction to Corporate Finance 2. Accounting Statements and Cash Flow II. Value and Capital Budgeting Introduction 4. Net Present Value 5. How to Value Bonds and Stocks 7. Net Present Value and Capital Budgeting 8. Risk Analysis, Real Options, and Capital Budgeting III: Risk 10. Return and Risk: The Capital−Asset−Pricing Model (CAPM) 12. Risk, Cost of Capital, and Capital Budgeting VII. Short−Term Finance 27. Cash Management VIII. Special Topics 29. Mergers and Acquisitions 31. International Corporate Finance Harvard Business School Entrepreneurship Cases JAFCO American Ventures, Inc.: Building a Venture Capital Firm 299 299 Case Harvard Business School Finance Cases Pioneer...
Words: 179333 - Pages: 718
...Scotland Abstract: This paper develops a model of the information intermediation role of analysts in the ‘market for information’ (MFI). It illustrates how the same type of ‘soft’ intangibles information changes as it progresses through analyst information intermediation processes. The latter concern: company disclosure; analyst acquisition and analysis of company information; analyst reporting processes; and market impacts. The common information concerns ‘soft’ or qualitative information about the company intellectual capital (IC) or intangibles in the company business model. Banks and bank analysts are used as examples. Knowledge, social and economic factors in the wider ‘market for information’ (MFI) are shown to be major influences on ‘soft information’ and how it changes in analyst information intermediation processes. Negative knowledge and social factors play a role in weakening and eventually destabilising economic processes in analyst and the MFI. They were important factors in creating knowledge and information problems in analysts and the MFI, both ongoing, and during the crisis of 2007-09. These factors are also part of a solution to the problems. The solutions include improved, transparent knowledge of business models of companies, analysts, and rest of MFI. They also include active use of social forces to create critical and reflexive performativity conditions in the MFI. The empirical analysis is discussed in a novel theoretical...
Words: 28563 - Pages: 115
...BU Basic M.B.A. International Master of Business Administration |Index | Accounting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Business Law . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Entrepreneurship. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100 Finance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Management. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160 Marketing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 180 Operations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220 Statistics. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 252 Strategic Management. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...
Words: 103642 - Pages: 415
...Quantitative Business Valuation Other Titles in the Irwin Library of Investment and Finance Convertible Securities by John P. Calamos Pricing and Managing Exotic and Hybrid Options by Vineer Bhansali Risk Management and Financial Derivatives by Satyajit Das Valuing Intangible Assets by Robert F. Reilly and Robert P. Schweihs Managing Financial Risk by Charles W. Smithson High-Yield Bonds by Theodore Barnhill, William Maxwell, and Mark Shenkman Valuing Small Business and Professional Practices, 3rd edition by Shannon Pratt, Robert F. Reilly, and Robert P. Schweihs Implementing Credit Derivatives by Israel Nelken The Handbook of Credit Derivatives by Jack Clark Francis, Joyce Frost, and J. Gregg Whittaker The Handbook of Advanced Business Valuation by Robert F. Reilly and Robert P. Schweihs Global Investment Risk Management by Ezra Zask Active Portfolio Management 2nd edition by Richard Grinold and Ronald Kahn The Hedge Fund Handbook by Stefano Lavinio Pricing, Hedging, and Trading Exotic Options by Israel Nelken Equity Management by Bruce Jacobs and Kenneth Levy Asset Allocation, 3rd edition by Roger Gibson Valuing a Business, 4th edition by Shannon P. Pratt, Robert F. Reilly, and Robert Schweihs The Relative Strength Index Advantage by Andrew Cardwell and John Hayden Quantitative Business Valuation A Mathematical Approach for Today’s Professional JAY B. ABRAMS, ASA, CPA, MBA McGRAW-HILL New York San Francisco Washington, D.C. Auckland Bogota ´ Caracas Lisbon London...
Words: 214584 - Pages: 859
...any means, or stored in a database or retrieval system, without prior written permission of the publisher. This McGraw−Hill Primis text may include materials submitted to McGraw−Hill for publication by the instructor of this course. The instructor is solely responsible for the editorial content of such materials. 111 FINAGEN ISBN: 0−390−55313−1 Finance Contents Ross−Westerfield−Jaffe • Corporate Finance, Seventh Edition I. Overview 1 1 20 34 34 69 97 129 151 151 192 192 214 214 248 1. Introduction to Corporate Finance 2. Accounting Statements and Cash Flow II. Value and Capital Budgeting 4. Net Present Value 5. How to Value Bonds and Stocks 7. Net Present Value and Capital Budgeting 8. Risk Analysis, Real Options, and Capital Budgeting III: Risk 10. Return and Risk: The Capital−Asset−Pricing Model (CAPM) VII. Short−Term Finance 27. Cash Management VIII. Special Topics 29. Mergers and Acquisitions 31. International Corporate Finance Baker−Lembke−King • Advanced Financial Accounting, Sixth Edition 19. Not−for−Profit Entities 272 272 Text...
Words: 226746 - Pages: 907
...NBER WORKING PAPER SERIES THE GRAVITY EQUATION IN INTERNATIONAL TRADE: AN EXPLANATION Thomas Chaney Working Paper 19285 http://www.nber.org/papers/w19285 NATIONAL BUREAU OF ECONOMIC RESEARCH 1050 Massachusetts Avenue Cambridge, MA 02138 August 2013 I want to thank Fernando Alvarez, Michal Fabinger, Xavier Gabaix, Sam Kortum, Bob Lucas, Jim Tybout, Jon Vogel and seminar participants in Berkeley, Bilkent, Bocconi, Boston University, Chicago, Erasmus, Hitotsubashi, LBS, Louvain-CORE, LSE, the NY Fed, Oxford, Princeton, Rochester, Sciences Po, Toulouse, UBC Vancouver, Yale and Zurich for helpful discussions, and NSF grant SES-1061622 for financial support. I am indebted to Jong Hyun Chung, Stefano Mosso and Adriaan Ten Kate for their research assistance. During the last year, I have received compensation for teaching activities from the Toulouse School of Economics, as well a research grant from the National Science Foundation (SES-1061622), in excess of $10,000. The views expressed herein are those of the author and do not necessarily reflect the views of the National Bureau of Economic Research. NBER working papers are circulated for discussion and comment purposes. They have not been peerreviewed or been subject to the review by the NBER Board of Directors that accompanies official NBER publications. © 2013 by Thomas Chaney. All rights reserved. Short sections of text, not to exceed two paragraphs, may be quoted without explicit permission provided that full credit...
Words: 18767 - Pages: 76
...Accounting, Organizations and Society 28 (2003) 127–168 www.elsevier.com/locate/aos Management control systems design within its organizational context: findings from contingency-based research and directions for the future Robert H. Chenhall Department of Accounting and Finance, Monash University, Clayton, Victoria 3168, Australia Abstract Contingency-based research has a long tradition in the study of management control systems (MCS). Researchers have attempted to explain the effectiveness of MCS by examining designs that best suit the nature of the environment, technology, size, structure, strategy and national culture. In recent years, contingency-based research has maintained its popularity with studies including these variables but redefining them in contemporary terms. This paper provides a critical review of findings from contingency-based studies over the past 20 years, deriving a series of propositions relating MCS to organizational context. The paper examines issues related to the purpose of MCS, the elements of MCS, the meaning and measurement of contextual variables, and issues concerning theory development. A final section considers the possibility that contingency-based ideas could encompass insights from a variety of theories to help understand MCS within its organizational context. # 2002 Elsevier Science Ltd. All rights reserved. 1. Introduction The three purposes of this paper are to provide a review of empirical, contingency-based research as it has developed...
Words: 26957 - Pages: 108
...9690010114 Yogendera sharma CONTRIBUTED PAPERS A41, Thursday, December 28, 4:00-5:30 P.M. Session: Case Studies - I Session Chair: Prashant Kulkarni Institute of Finance and International Ma 418 Global Marketing and Challenges for Future: Franchising in Banks K. Ravichandran, Gandhigram Rural University, drkravichandran@yahoo.co.in R. Muruganandham, Sudharsana Raamanujan, R, P. Nandakumar, M. Sasi Siddharth Thiagarajar College of Engineering, vr_muruganandham@hotmail.com, siddharth_mss@sify.com raamanujan@gmail.com, nandacivil@gmail.com The global economic scenario is undergoing a major innovative metamorphosis at a rate never experienced before. All organizations have their brands to face the global marketing challenges to secure a role of leader in this state of economic revolution. Our paper identifies the current marketing challenges and global economic threats for service industries. Besides our paper also explores the management strategies to overcome these challenges in the liberalized economy. The banking service is considered, where the franchising marketing strategies, introduction of new products and delightful customer service by new private sector banks and foreign banks pose a serious threat to the existence and survival of public sector banks profitwise. Hence our paper deeply discusses the benefits of e-banking with a view to minimize transaction cost cum operating expenses thereby increasing the overall net profit...
Words: 23823 - Pages: 96