Valuation of Fixed Income Securities and Equity with Excel
Master the art of bond valuation and stock 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.
What You Will 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
Who Should Attend!
- 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