FRINK Linked Data Fragments server

Matches in SemOpenAlex for { <https://semopenalex.org/work/W1497459439> ?p ?o ?g. }

• W1497459439 abstract "Preface Fifth Edition Changes Ready-To-Build Spreadsheets What Is Unique About This Book Conventions Used In This Book Craig's Challenge Excel(r) 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" @default.
• W1497459439 created "2016-06-24" @default.
• W1497459439 creator A5064607226 @default.
• W1497459439 date "2004-02-01" @default.
• W1497459439 modified "2023-09-26" @default.
• W1497459439 title "Excel Modeling in Corporate Finance" @default.
• W1497459439 hasPublicationYear "2004" @default.
• W1497459439 type Work @default.
• W1497459439 sameAs 1497459439 @default.
• W1497459439 citedByCount "1" @default.
• W1497459439 crossrefType "book" @default.
• W1497459439 hasAuthorship W1497459439A5064607226 @default.
• W1497459439 hasConcept C10138342 @default.
• W1497459439 hasConcept C106159729 @default.
• W1497459439 hasConcept C114886758 @default.
• W1497459439 hasConcept C116168712 @default.
• W1497459439 hasConcept C143801662 @default.
• W1497459439 hasConcept C162118730 @default.
• W1497459439 hasConcept C162324750 @default.
• W1497459439 hasConcept C163428354 @default.
• W1497459439 hasConcept C166819830 @default.
• W1497459439 hasConcept C181236170 @default.
• W1497459439 hasConcept C186027771 @default.
• W1497459439 hasConcept C2780334105 @default.
• W1497459439 hasConcept C2781014177 @default.
• W1497459439 hasConcept C47096860 @default.
• W1497459439 hasConcept C6177178 @default.
• W1497459439 hasConcept C6927289 @default.
• W1497459439 hasConcept C80515813 @default.
• W1497459439 hasConceptScore W1497459439C10138342 @default.
• W1497459439 hasConceptScore W1497459439C106159729 @default.
• W1497459439 hasConceptScore W1497459439C114886758 @default.
• W1497459439 hasConceptScore W1497459439C116168712 @default.
• W1497459439 hasConceptScore W1497459439C143801662 @default.
• W1497459439 hasConceptScore W1497459439C162118730 @default.
• W1497459439 hasConceptScore W1497459439C162324750 @default.
• W1497459439 hasConceptScore W1497459439C163428354 @default.
• W1497459439 hasConceptScore W1497459439C166819830 @default.
• W1497459439 hasConceptScore W1497459439C181236170 @default.
• W1497459439 hasConceptScore W1497459439C186027771 @default.
• W1497459439 hasConceptScore W1497459439C2780334105 @default.
• W1497459439 hasConceptScore W1497459439C2781014177 @default.
• W1497459439 hasConceptScore W1497459439C47096860 @default.
• W1497459439 hasConceptScore W1497459439C6177178 @default.
• W1497459439 hasConceptScore W1497459439C6927289 @default.
• W1497459439 hasConceptScore W1497459439C80515813 @default.
• W1497459439 hasLocation W14974594391 @default.
• W1497459439 hasOpenAccess W1497459439 @default.
• W1497459439 hasPrimaryLocation W14974594391 @default.
• W1497459439 hasRelatedWork W104536370 @default.
• W1497459439 hasRelatedWork W144738277 @default.
• W1497459439 hasRelatedWork W1540367240 @default.
• W1497459439 hasRelatedWork W1707576845 @default.
• W1497459439 hasRelatedWork W1837300706 @default.
• W1497459439 hasRelatedWork W2026002193 @default.
• W1497459439 hasRelatedWork W2046141847 @default.
• W1497459439 hasRelatedWork W2112246152 @default.
• W1497459439 hasRelatedWork W2114525406 @default.
• W1497459439 hasRelatedWork W2138753954 @default.
• W1497459439 hasRelatedWork W2167821110 @default.
• W1497459439 hasRelatedWork W2252432132 @default.
• W1497459439 hasRelatedWork W2273345520 @default.
• W1497459439 hasRelatedWork W2339153058 @default.
• W1497459439 hasRelatedWork W2374409961 @default.
• W1497459439 hasRelatedWork W2626607572 @default.
• W1497459439 hasRelatedWork W592603834 @default.
• W1497459439 hasRelatedWork W629480291 @default.
• W1497459439 hasRelatedWork W653712082 @default.
• W1497459439 hasRelatedWork W179098003 @default.
• W1497459439 isParatext "false" @default.
• W1497459439 isRetracted "false" @default.
• W1497459439 magId "1497459439" @default.
• W1497459439 workType "book" @default.