PDF Excel Modeling in Fundamentals of Investments

Free download. Book file PDF easily for everyone and every device. You can download and read online Excel Modeling in Fundamentals of Investments file PDF Book only if you are registered here. And also you can download or read online all Book PDF file that related with Excel Modeling in Fundamentals of Investments book. Happy reading Excel Modeling in Fundamentals of Investments Bookeveryone. Download file Free Book PDF Excel Modeling in Fundamentals of Investments at Complete PDF Library. This Book have some digital formats such us :paperbook, ebook, kindle, epub, fb2 and another formats. Here is The CompletePDF Book Library. It's free to register here to get Book file PDF Excel Modeling in Fundamentals of Investments Pocket Guide.

The over-arching goals of this course are to build an understanding of the fundamentals of investment finance and provide an ability to implement key asset-pricing models and firm-valuation techniques in real-world situations. You can view a detailed summary of the ratings and reviews for this course in the Course Overview section.

For more information, please see the Resource page in this course and onlinemba. Course Overview -In this module, you will become familiar with the course, your instructor, your classmates, and our learning environment. The orientation also helps you obtain the technical skills required for the course. Module 1: Investments Toolkit and Portfolio Formation -In Module 1, we will build the fundamentals of portfolio formation.

After providing a brief refresher of basic investment concepts our toolkit , a summary of historical patterns of stock returns and government securities in the U. We end the module with a discussion of dominated assets and efficient portfolio formation, emphasizing real-world examples and practice in Excel solving for the optimal portfolio given certain constraints such as the amount of volatility we will accept in our portfolio.

We will understand that in a CAPM setting, only the market-wide risk of an asset is priced — securities with greater sensitivity to the market are required by investors to yield higher returns on average. Predictable patterns in stock returns, such as the size and value effects, will also be examined and the Fama-French 3-Factor Model will be introduced. Market efficiency will be discussed in this module, as well as its implications for the asset-management industry and observed patterns in stock returns. Module 4: Investment Finance and Corporate Finance: Firm Valuation -In Module 4, we will learn about the two key approaches to valuing a company or stock: market multiples and discounted cash flow.

We will learn how to value perpetuities and will discuss how caution should be exercised in terms of projecting both the growth in long-term cash flows and the riskiness of those cash flows — two key components of the perpetuity formula. Finally, to gain experience with the market multiples approach, we will estimate a value of Google at the time of its initial public offering IPO back in using market data on Yahoo! Course Conclusion -In this module, we say goodbye to the Investments course as key takeaways from the course are reviewed.

Course Overview

A tease is also provided to topics that will be covered in Professor Weisbenner's second course on Investments. What We've Learned 3m. Historical Returns in the U. Return and Risk: Intro to Portfolios 27m. Objectives and Source of Data for Examples 2m. Asset Allocation with Two Risky Assets 27m.

Product details

Real-World Example of a Dominated Asset 14m. What We've Learned 2m. Objectives 5m. What We've Learned 1m. Module 1 Review 6m. Like this course? Learn more with the iMBA! Reading 3 readings.


  1. Excel Modeling in the Fundamentals of Investments Book and CD-ROM by Craig W. Holden - olagynulehyb.gq?
  2. Introduction to Research in Education, 8th Edition.
  3. Contact ULI Education?
  4. Tensors and Their Applications.

Module 1 Overview 10m. Module 1 Readings 10m. Module 1 Spreadsheets 10m. Module 1 Quiz 24m. Video 21 videos. Objectives 2m. Two-Fund Separation Theorem and Applications 10m.

We build financial models, relationships, knowledge and confidence.

Examples of Reducing Portfolio Risk 20m. Objectives 48s. Development of the CAPM 18m. Objectives 50s. Module 2 Review 6m. Module 2 Overview 10m. Module 2 Readings 10m. Module 2 Spreadsheets 10m. Module 2 Quiz 24m. Video 18 videos. Objectives and Overview 6m. Testing the CAPM 11m. Defending the CAPM 14m. Interpretation of Market Anomalies 9m. Objectives 1m. Multi-Factor Models 16m.

Matching 9m.

Product details

What We've Learned 4m. Use Domestic or Global Factors? Market Efficiency 35m. Module 3 Review 11m. Module 3 Overview 10m. Module 3 Readings 10m. Module 3 Spreadsheets 10m. Module 3 Quiz 24m. Objectives and Overview 19m. Formula for Valuing a Perpetuity 12m. It can accompany any undergraduate investments textbook, including textbooks by Alexander, Bodie, Corrando, and Reilly. Annual Payments. APR vs.

Books by Craig W. Holden (Author of Excel Modeling in Investments (4th Edition))

By Yield to Maturity. System of Five Bond Variables. Dynamic Chart.

Price Sensitivity Using Duration. Price Sensitivity Including Convexity. Two Assets. Many Assets.

Full-Scale Real Data. Single Period. Risk Neutral. Continuous Dividend. Implied Volatility. Pearson offers special pricing when you package your text with other student resources. If you're interested in creating a cost-saving package for your students, contact your Pearson rep.