INVESTMENT ANALYSIS AND PORTFOLIO MANAGEMENT
Live-Online Training: N 175,000
Classroom Training: N 215,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount
(Available also for Customised Training by Duration, Venue & Fee)
(PARTICIPANTS SHOULD BRING THEIR LAPTOPS)
Programme Description
This course is tailored in a step by step approach aimed at equipping candidates to understand how to analyse any investment and make proper investment decision. The program will cover various investment techniques including value functions and portfolio tools such as optimization techniques (Linear Programming).
Course Objectives
This programme will enable the participants to:
- Understand various techniques needed to appraise any investment
- Build various investment models
- Analyse loans and know if their cash flows will be able to repay the loans.
- Compute various debt securities
- Know the most profitable investment from several portfolios.
Course Contents
DAY ONE
Investment Analysis Appraisal Techniques
- (FV) Future Value of an Investment
- (PV) Present Value of an Investment
- (Nper) Number of period of an Investment
- (Fvshedule) Future value of an initial principal
- (IPMT) Interest payment in an annuity model
- (IRR) Internal rate of return for a series of cash flows
- (NPV) Net present value
- (PMT) Loan payment based on annuity
- (PPMT) Periodic principal payment of loan
DAY TWO
Payback Period Model
- (MIRR) Modified internal rate of return
- (XIRR) Internal rate of return for a schedule of cash flows
- (XNPV) Net present value for a schedule of cash flows
Securities
- Accrint) Accrued interest for a security that pays periodic interest
- (Accrintm) Returns the accrued interest for a security that pays interest at maturity
- (Disc) Returns the discount rate for a security.
- (Intrate) Returns the interest rate for a fully invested security.
- (Mduration) Returns the modified macauley duration with an assumed per value of N100
DAY THREE
Securities
- (Oddfprice) Returns the price per N100 face value of a security having an odd(short or long) first period.
- (Oddlprice) Returns the price per N100 face value of a security having an odd(short or long) last period.
- (Oddfyield) Returns the yield of a security that has an odd (short or long) first coupon period.
- (Oddlyield) Returns the yield of a security that has an odd (short or long) last coupon period.
- (Price) Returns the price per N100 face value of a security that pays periodic interest.
DAY FOUR
Securities
- (Price mat) Returns the price per N100 face value of a security that pays interest at maturity.tt
- (Received) Returns the amount received at maturity for a fully invested security
- Returns the bond equivalent yield for a treasury bill
- (Tbillprice) Returns the per N100 face value for a treasury bill
- (Yield) Returns the yield on a security that pays periodic interest.
- (Frequency) Computes the number of coupon payments per year
- (Yielddisc) Returns the annual yield for a discounted security
- (Yield mat) Returns the annual yield for a security that pays interest at maturity.
DAY FIVE
Portfolio Analysis
- Optimization
- Elements of Optimization Models
- Linear Programming
- Margin Maximization
- Building Sensitivity analysis and Scenarios into Models
- Strategy Session: Application of Policy Analysis and Formulation.