Rating: 4 out of 5 stars
4/5
Ebook608 pages13 hours
Financial Modeling Using Excel and VBA
Rating: 0 out of 5 stars
()
About this ebook
Comprehensive instruction on developing real-world financial models
This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material.
Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).
This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material.
Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).
Related to Financial Modeling Using Excel and VBA
Titles in the series (100)
The Risk Management Process: Business Strategy and Tactics Strategic Corporate Tax Planning Rating: 0 out of 5 stars0 ratingsBusiness Exit Planning: Options, Value Enhancement, and Transaction Management for Business Owners Rating: 5 out of 5 stars5/5Middle Market M & A: Handbook for Investment Banking and Business Consulting Rating: 4 out of 5 stars4/5Mergers: What Can Go Wrong and How to Prevent It Rating: 0 out of 5 stars0 ratingsRisk Budgeting: Portfolio Problem Solving with Value-at-Risk Rating: 0 out of 5 stars0 ratingsThe Business of Options: Time-Tested Principles and Practices Rating: 0 out of 5 stars0 ratingsAsian Financial Statement Analysis: Detecting Financial Irregularities Rating: 0 out of 5 stars0 ratingsSalomon Smith Barney Guide to Mortgage-Backed and Asset-Backed Securities Rating: 0 out of 5 stars0 ratingsCredit Risk Measurement: New Approaches to Value at Risk and Other Paradigms Rating: 0 out of 5 stars0 ratingsThe Securitization Markets Handbook: Structures and Dynamics of Mortgage- and Asset-backed Securities Rating: 0 out of 5 stars0 ratingsThe Mechanics of Securitization: A Practical Guide to Structuring and Closing Asset-Backed Security Transactions Rating: 0 out of 5 stars0 ratingsFinancial Modeling Using Excel and VBA Rating: 0 out of 5 stars0 ratingsEquity Derivatives: Theory and Applications Rating: 3 out of 5 stars3/5Investor's Guide to Loss Recovery: Rights, Mediation, Arbitration, and other Strategies Rating: 0 out of 5 stars0 ratingsEnvironmental Finance: A Guide to Environmental Risk Assessment and Financial Products Rating: 1 out of 5 stars1/5Private Equity: History, Governance, and Operations Rating: 0 out of 5 stars0 ratingsQuantitative Methods in Derivatives Pricing: An Introduction to Computational Finance Rating: 2 out of 5 stars2/5Corporate Governance and Risk: A Systems Approach Rating: 0 out of 5 stars0 ratingsFinancial Simulation Modeling in Excel: A Step-by-Step Guide Rating: 3 out of 5 stars3/5Private Equity: Transforming Public Stock to Create Value Rating: 0 out of 5 stars0 ratingsEnergy and Power Risk Management: New Developments in Modeling, Pricing, and Hedging Rating: 1 out of 5 stars1/5Convertible Arbitrage: Insights and Techniques for Successful Hedging Rating: 4 out of 5 stars4/5Absolute Returns: The Risk and Opportunities of Hedge Fund Investing Rating: 4 out of 5 stars4/5Technology Valuation Solutions Rating: 0 out of 5 stars0 ratingsEvaluating Hedge Fund and CTA Performance: Data Envelopment Analysis Approach Rating: 0 out of 5 stars0 ratingsThe Exchange-Traded Funds Manual Rating: 0 out of 5 stars0 ratingsHow to Create and Manage a Hedge Fund: A Professional's Guide Rating: 4 out of 5 stars4/5Managing Global Financial and Foreign Exchange Rate Risk Rating: 0 out of 5 stars0 ratingsInvestment Leadership: Building a Winning Culture for Long-Term Success Rating: 0 out of 5 stars0 ratings
Related ebooks
Financial Simulation Modeling in Excel: A Step-by-Step Guide Rating: 3 out of 5 stars3/5Professional Financial Computing Using Excel and VBA Rating: 0 out of 5 stars0 ratingsModeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide Rating: 4 out of 5 stars4/5Financial Forecasting, Analysis, and Modelling: A Framework for Long-Term Forecasting Rating: 4 out of 5 stars4/5Next Generation Excel: Modeling in Excel for Analysts and MBAs Rating: 0 out of 5 stars0 ratingsIntermediate Structured Finance Modeling: Leveraging Excel, VBA, Access, and Powerpoint Rating: 0 out of 5 stars0 ratingsFinancial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level Rating: 4 out of 5 stars4/5Principles of Private Firm Valuation Rating: 3 out of 5 stars3/5Advanced Modelling in Finance using Excel and VBA Rating: 3 out of 5 stars3/5Investment Performance Measurement: Evaluating and Presenting Results Rating: 1 out of 5 stars1/5Performance Dashboards and Analysis for Value Creation Rating: 3 out of 5 stars3/5Financial Modeling with Crystal Ball and Excel Rating: 0 out of 5 stars0 ratingsUsing Excel for Business and Financial Modelling: A Practical Guide Rating: 0 out of 5 stars0 ratingsUsing Excel for Business Analysis: A Guide to Financial Modelling Fundamentals Rating: 0 out of 5 stars0 ratingsDerivatives: Markets, Valuation, and Risk Management Rating: 0 out of 5 stars0 ratingsMastering Corporate Finance Essentials: The Critical Quantitative Methods and Tools in Finance Rating: 0 out of 5 stars0 ratingsContinuing Financial Modelling: Working Those Optimal Figures For the (Financial) Modelling Industry Rating: 0 out of 5 stars0 ratingsThe Portable Financial Analyst: What Practitioners Need to Know Rating: 0 out of 5 stars0 ratingsThe Handbook of Municipal Bonds Rating: 0 out of 5 stars0 ratingsCash CDO Modelling in Excel: A Step by Step Approach Rating: 0 out of 5 stars0 ratingsThe New Science of Asset Allocation: Risk Management in a Multi-Asset World Rating: 0 out of 5 stars0 ratingsFinancial Modeling of the Equity Market: From CAPM to Cointegration Rating: 1 out of 5 stars1/5Global Investing: A Practical Guide to the World's Best Financial Opportunities Rating: 0 out of 5 stars0 ratingsAdvanced Bond Portfolio Management: Best Practices in Modeling and Strategies Rating: 0 out of 5 stars0 ratingsInvestment Risk and Uncertainty: Advanced Risk Awareness Techniques for the Intelligent Investor Rating: 0 out of 5 stars0 ratingsFinancial Applications using Excel Add-in Development in C / C++ Rating: 0 out of 5 stars0 ratingsActive Credit Portfolio Management in Practice Rating: 0 out of 5 stars0 ratingsFinancial Modeling in Excel For Dummies Rating: 4 out of 5 stars4/5Risk Budgeting: Portfolio Problem Solving with Value-at-Risk Rating: 0 out of 5 stars0 ratingsAnalysis of Financial Statements Rating: 3 out of 5 stars3/5
Finance & Money Management For You
The Tax and Legal Playbook: Game-Changing Solutions To Your Small Business Questions Rating: 3 out of 5 stars3/5The Richest Man in Babylon Rating: 4 out of 5 stars4/5The Psychology of Money: Timeless lessons on wealth, greed, and happiness Rating: 5 out of 5 stars5/5The Intelligent Investor, Rev. Ed: The Definitive Book on Value Investing Rating: 4 out of 5 stars4/5Capitalism and Freedom Rating: 4 out of 5 stars4/5Die With Zero: Getting All You Can from Your Money and Your Life Rating: 4 out of 5 stars4/5The 7 Habits of Highly Effective People: 15th Anniversary Infographics Edition Rating: 5 out of 5 stars5/5Principles: Life and Work Rating: 4 out of 5 stars4/5The Great Reset: And the War for the World Rating: 4 out of 5 stars4/5Set for Life: An All-Out Approach to Early Financial Freedom Rating: 4 out of 5 stars4/5Buy, Rehab, Rent, Refinance, Repeat: The BRRRR Rental Property Investment Strategy Made Simple Rating: 5 out of 5 stars5/5Good to Great: Why Some Companies Make the Leap...And Others Don't Rating: 4 out of 5 stars4/5The Great Awakening: Defeating the Globalists and Launching the Next Great Renaissance Rating: 4 out of 5 stars4/5Alchemy: The Dark Art and Curious Science of Creating Magic in Brands, Business, and Life Rating: 4 out of 5 stars4/5Financial Words You Should Know: Over 1,000 Essential Investment, Accounting, Real Estate, and Tax Words Rating: 4 out of 5 stars4/5Strategy Skills: Techniques to Sharpen the Mind of the Strategist Rating: 4 out of 5 stars4/5Just Keep Buying: Proven ways to save money and build your wealth Rating: 5 out of 5 stars5/5The Roadmap to Financial Freedom: A Millionaire's Guide to Building Automated Wealth Rating: 0 out of 5 stars0 ratingsThe Win-Win Wealth Strategy: 7 Investments the Government Will Pay You to Make Rating: 0 out of 5 stars0 ratingsFamily Trusts: A Guide for Beneficiaries, Trustees, Trust Protectors, and Trust Creators Rating: 5 out of 5 stars5/5Building Business Credit Rating: 5 out of 5 stars5/5Economics in One Lesson: The Shortest and Surest Way to Understand Basic Economics Rating: 4 out of 5 stars4/5
Related podcast episodes
CFO lessons learned in planning and forecasting - with Dan Fletcher, CFO Planful 0% found this document usefulWorldCom's Financial Statement Fraud 100% found this document usefulTIP568: Current Market Conditions, Alternative Assets, & AI w/ David Stein 0% found this document usefulTim Koller, "Valuation: Measuring and Managing the Value of Companies" (Wiley, 2020): How do you value something? 0% found this document usefulABP #106 - GAAP vs. IFRS for Inventory: The inventory accounting differences under GAAP and IFRS 0% found this document usefulThe Bullish vs. Bearish Cases Mid Shutdown: Investment Strategist Jason Trennert 0% found this document usefulThe Role of FP&A vis a vis Revenue Operations - with Paul Barnhurst, The FP&A Guy 0% found this document usefulTIP577: Valuation Masterclass w/ Aswath Damodaran 0% found this document useful#36 Matt Joass on Superforecasting 0% found this document usefulHow EfficientAide Provides Fractional VA Services to Help Clients “Buy Back Their Time and Eliminate Worry" 0% found this document useful244: CEO Day Retreat Results & How I am Implementing Major Pivots in My Business (and you can too!) - Part 2 0% found this document useful115: How To Actually Do an SEO Ranking Analysis – w/Micah Fisher-Kirshner 0% found this document useful#46 - Business Agility - Evan Leybourn 0% found this document usefulWhy Lean Portfolio Management? 0% found this document useful
Reviews for Financial Modeling Using Excel and VBA
Rating: 0 out of 5 stars
0 ratings
0 ratings0 reviews
Book preview
Financial Modeling Using Excel and VBA - Chandan Sengupta
Enjoying the preview?
Page 1 of 1