Evaluation of Techniques of Time Value of Money | Business Finance

BUSINESS FINANCE

Introduction
One of the most significant concepts of financial management is the valuation of the
securities using the techniques of time value of money. The following work is aimed at
evaluating the various techniques of time value of money such as present value, future value,
and the computation of the rates, in the context of the valuation of the bonds. The practical
application is demonstrated using the Excel functions like that of “Rate,” “PV,” and “FV.”
The valuation is divided into two categories for the callable and the non-callable bonds and
comparisons are demonstrated for the better understanding of the valuation in the real life
scenario.
Analysis
The following segment is descriptive of the analysis of the varied calculations
performed. It is to be noted that as the interest rate for the coupon payment is semi-annually,
the periodic rate is computed by dividing the rate into half, and multiplying the number of
years by 2. Thus in the Part 1, A) the actual number of periods, the amount of annual and
periodic coupon payments, the periods until calling of the bonds are computed.
In the Part 1, B) the “rate” function has been employed for the computation of the
periodic YTM. It is to be noted that the amount of coupon payment has been divided by 2, to
make it equivalent to the periodic YTM. Further, the annualized YTM has been computed by
taking the number of years, instead of periods and the annual coupon payment. It must be
noted that the periodic YTM turns out to be exact half of the annualized YTM.
The current yield as calculated in the Part 1, C) refers to the percentage of the annual
income as against the current price of the bond. Thus, the current yield has been computed
out to be 5.26%. As the coupon rate is lesser than the current yield and annualized YTM, it is
evident that the bond is selling at discount (Hopewell & Kaufman, 2017).
In the Part 1, D) it has been computed that the bonds are trading at a slight loss in the
form of the capital loss percentage of 0.15%. Thus, the market price is slightly lower than the
ideal prices as per the YTM. Part 1, E) further sheds light on the Yield to Call, that has been
computed on the basis of the number of years till the bonds can be called. As the yield to call