Valuation of Fixed Income Securities and Equity with Excel
What you'll learn
- Valuation of Fixed Income Securities
- Know the fixed income securities and market participants
- Understand the difference between coupon bonds and zero coupon bonds
- Understand risks involved in bond investing
- Calculate the effective rate of zero coupon bond
- Understand the fundamental features of bonds
- Calculate bond prices, yields, yield to maturity, yield to call
- Calculate bond yield, YTM,YTC and price using Excel
- Valuation of Equity also called Stock Valuation
- Stock Valuation Models
- Conduct valuations based on the discounted cash flow method
- Conduct a relative valuation for a company
Requirements
- Interest in valuation of fixed income securities and equity valuation
Description
This course will help you pursue career as Fixed Income Researcher, Fixed Income Analyst, Credit Research Analyst, Investment Advisor, Wealth Management, HNI Sales in companies like iMarkserv, QuantMagnum, Morgan Stanley, Genpact, Bajaj Capital, Axis Securities, Rathi, eClerx, Clearwater Analytics and many more. Master the art of analyzing fixed income securities and their yields and Equity valuation with dividend discount models.
This course equips you with the tools required to understand construction, pricing and the risks of bonds and fixed income securities. It also explains the fundamentals of fixed income securities, examines the valuation of fixed-income securities, calculating yields and management of risk.
This course explains you how to determine intrinsic value of stock using both absolute valuation models and relative valuation models. You will gain in depth theoretical and practical knowledge of equity valuation.
This course shows you how to calculate bond price, bond yields, and intrinsic value of stock, dividend discount models using Microsoft Excel.
Who this course is for:
- Finance and accounting students
- Person seeking career in fixed income securities
- Person seeking career in equity valuation
- Looking for career in investment banking, valuations, mutual fund trusts, investments, and portfolio management services
Course content
- Preview02:00
- 02:27An Introduction to Bonds
- Preview01:55
- 04:00Key features of bonds. Characteristics of Bonds
- 03:27Illustration of Bond certificate.
- 04:57Risks in Bond Investing
Instructor
![Rama Krishna Yelamanchili](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 47 Reviews
- 225 Students
- 10 Courses
Currently I am working as Professor of Finance in one of the India's leading business school accredited by AACSB, a constituent of NAAC A+ Grade Private University located in Hyderabad, Telangana, India. I teach courses like Security Analysis and Portfolio Management, Investments, Financial Management, Corporate Finance, Accounting, and Financial Statement Analysis.