Excel Modeling in Corporate Finance
Home > Business and Economics > Finance and accounting > Finance and the finance industry > Corporate finance > Excel Modeling in Corporate Finance
Excel Modeling in Corporate Finance

Excel Modeling in Corporate Finance

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

For courses in corporate finance or financial management at the undergraduate and graduate level.   Excel Modeling in Corporate Finance approaches building and estimating models with Microsoft® Excel®. Students are shown the steps involved in building models, rather than already-completed spreadsheets.

Table of Contents:
Preface Fifth Edition Changes Ready-To-Build Spreadsheets What Is Unique About This Book Conventions Used In This Book Craig's Challenge Excel® Modeling Books Suggestions for Faculty Members Acknowledgements About The Author 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 NPV Using Constant Discounting 3.1 Nominal Rate 3.2 Real Rate Problems Chapter 4 NPV Using General Discounting 4.1 Nominal Rate 4.2 Real Rate Problems Chapter 5 Loan Amortization 5.1 Basics 5.2 Sensitivity Analysis Problems Chapter 6 Lease Vs. Buy 6.1 Car 6.2 Corporate Problems PART 2 VALUATION Chapter 7 Bond Valuation 7.1 Annual Payments 7.2 EAR, APR, and Foreign Currencies 7.3 Duration and Convexity 7.4 Price Sensitivity 7.5 System of Five Bond Variables Problems Chapter 8 Estimating the Cost of Capital 8.1 Static CAPM Using Fama-MacBeth Method 8.2 APT or Intertemporal CAPM Using Fama-McBeth Method Problems Chapter 9 Stock Valuation 9.1 Dividend Discount Model Problems Chapter 10 Firm and Project Valuation 10.1 Cash Flows for Five Equivalent Methods 10.2 Adjusted Present Value 10.3 Free Cash Flow To Equity 10.4 Free Cash Flow to the Firm 10.5 Dividend Discount Model 10.6 Residual Income 10.7 Five Equivalent Methods Problems Appendix: Reconciling the Residual Income Method with Other Approaches to Valuing Firms or Projects Chapter 11 The Yield Curve 11.1 Obtaining It From Treasury Bills and Strips 11.2 Using It To Price A Coupon Bond 11.3 Using It To Determine Forward Rates Problems Chapter 12 US Yield Curve Dynamics 12.1 Dynamic Chart Problems PART 3 CAPITAL STRUCTURE Chapter 13 Capital Structure 13.1 Modigliani-Miller With No Taxes. 13.2 Modigliani-Miller With Corporate Taxes 13.3 Trade-off Model: Tax Shield vs. Distress Cost Problems PART 4 CAPITAL BUDGETING Chapter 14 Project NPV 14.1 Basics 14.2 Forecasting Cash Flows 14.3 Working Capital 14.4 Sensitivity Analysis Problems Chapter 15 Cost-Reducing Project 15.1 Basics 15.2 Sensitivity Analysis Problems Chapter 16 Break-Even Analysis 16.1 Based On Accounting Profit 16.2 Based On NPV Problems PART 5 FINANCIAL PLANNING Chapter 17 Corporate Financial Planning 17.1 Actual 17.2 Forecast 17.3 Cash Flow 17.4 Ratios 17.5 Sensitivity 17.6 Full-Scale Estimation Problems Chapter 18 Du Pont System Of Ratio Analysis 18.1 Basics Problems Chapter 19 Life-Cycle Financial Planning 19.1 Taxable Vs. Traditional Vs. Roth Savings 19.2 Basic Life-Cycle Planning 19.3 Full-Scale Life-Cycle Planning Problems PART 6 INTERNATIONAL CORPORATE FINANCE Chapter 20 International Parity 20.1 System of Four Parity Conditions 20.2 Estimating Future Exchange Rates Problems PART 7 OPTIONS AND CORPORATE FINANCE Chapter 21 Binomial Option Pricing 21.1 Estimating Volatility 21.2 Single Period 21.3 Multi-Period 21.4 Risk Neutral 21.5 Average of N and N-1 21.6 Convergence to Normal 21.7 American With Discrete Dividends 21.8 Full-Scale Problems Chapter 22 Real Options 22.1 Option To Abandon 22.2 Option to Expand 22.3 Option to Contract 22.4 Option To Choose 22.5 Compound Option Problems Chapter 23 Black-Scholes Option Pricing 23.1 Basics 23.2 Continuous Dividend 23.3 Implied Volatility Problems Chapter 24 Debt And Equity Valuation 24.1 Two Methods 24.2 Impact of Risk Problems PART 8 EXCEL SKILLS Chapter 25 Useful Excel Tricks 25.1 Quickly Delete The Instructions and Arrows 25.2 Freeze Panes 25.3 Spin Buttons and the Developer Tab 25.4 Option Buttons and Group Boxes 25.5 Scroll Bar 25.6 Install Solver or the Analysis ToolPak 25.7 Format Painter 25.8 Conditional Formatting 25.9 Fill Handle 25.10 2-D Scatter Chart 25.11 3-D Surface Chart DOWNLOADABLE CONTENTS Excel Modeling in Corporate Finance Fourth Edition.pdf Ready-To-Build spreadsheets available in both XLSX and XLS file formats: Ch 01 Single Cash Flow - Ready-To-Build.xlsx Ch 02 Annuity - Ready-To-Build.xlsx Ch 03 NPV Using Constant Discounting - Ready-To-Build.xlsx Ch 04 NPV Using General Discounting - Ready-To-Build.xlsx Ch 05 Loan Amortization - Ready-To-Build.xlsx Ch 06 Lease Vs Buy - Ready-To-Build.xlsx Ch 07 Bond Valuation - Ready-To-Build.xlsx Ch 08 Estimating the Cost of Capital - Ready-To-Build.xlsx Ch 09 Stock Valuation - Ready-To-Build.xlsx Ch 10 Firm and Project Valuation - Ready-To-Build.xlsx Ch 11 The Yield Curve - Ready-To-Build.xlsx Ch 12 US Yield Curve Dynamics - Ready-To-Build.xlsx Ch 13 Capital Structure - Ready-To-Build.xlsx Ch 14 Project NPV - Ready-To-Build.xlsx Ch 15 Cost-Reducing Project - Ready-To-Build.xlsx Ch 16 Break-Even Analysis - Ready-To-Build.xlsx Ch 17 Corporate Financial Planning - Ready-To-Build.xlsx Ch 18 Du Pont System of Ratio Analysis - Ready-To-Build.xlsx Ch 19 Life-Cycle Financial Planning - Ready-To-Build.xlsx Ch 20 International Parity - Ready-To-Build.xlsx Ch 21 Binomial Option Pricing - Ready-To-Build.xlsx Ch 22 Real Options - Ready-To-Build.xlsx Ch 23 Black-Scholes Option Pricing - Ready-To-Build.xlsx Ch 24 Debt and Equity Valuation - Ready-To-Build.xlsx


Best Sellers


Product Details
  • ISBN-13: 9780205987252
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Pearson
  • Height: 10 mm
  • No of Pages: 240
  • Spine Width: 10 mm
  • Width: 10 mm
  • ISBN-10: 0205987257
  • Publisher Date: 05 Aug 2014
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Weight: 548 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Excel Modeling in Corporate Finance
Pearson Education (US) -
Excel Modeling in Corporate Finance
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Excel Modeling in Corporate Finance

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!