Course curriculum

    1. 1003 Financial Asset Valuation

    2. 1005 Bond Issued at Par

    3. 1010 Bonds Market Rate vs Contract Rate

    4. 1015 Issue bond at a discount%2C calculate%2C and record interest payment

    5. 1020 Bond Issued at Premium

    6. 1025 Bonds Present Value Formulas

    7. 1030 Bond Price Present Value Tables

    8. 1035 Bond Price Excel Formula

    9. 1040 Preferred Stock Valuation

    10. 1045 Common Stock Valuation

    1. 1011 Bond Value Different Yield Rates Prob 1 (1)

    2. 1012 Bond Value Different Yield Rates Prob 2 (1)

    3. 1014 Principal as a % of bond price (1)

    4. 1015 Bond Value Different Maturity Dates

    5. 1018 Bond Sale Percentage Profit (ROI)

    6. 1020 Bond Sale Percentage Profit (ROI) Long Term Sale

    7. 1023 Calculate Bond Rate & Change in Rate

    8. 1025 Calculate Bond Rate & Change in Rate Prob. 2

    9. 1028 Find Bond Market Rate or Yield

    10. 1030 Find Bond market Rate or yield Semiannual

    11. 1031 Bond Value Semiannual Payments

    12. 1032 Bond Value Semiannual Rate Change

    1. 1011 Bond Value Different Yield Rates Prob 1

    2. 1012 Bond Value Different Yield Rates Prob 2

    3. 1014 Principal as a % of bond price

    4. 1015 Bond Value Different Maturity Dates

    5. 1018 Bond Sale Percentage Profit (ROI)

    6. 1020 Bond Sale Percentage Profit (ROI) Long Term Sale

    7. 1023 Calculate Bond Rate & Change in Rate

    8. 1025 Find Bond Market Rate or Yield

    9. 1028 Calculate Bond Rate & Change in Rate Prob. 2

    10. 1030 Find Bond Market Rate or Yield Semiannual

    11. 1031 Bond Value Semiannual Payments

    12. 1032 Bond Value Semiannual Rate Change

    13. 1034 Preferred Stock Value

    14. 1036 Preferred Stock Yield or Rate of Return

    15. 1037 Common Stock Price No Growth Assumed

    16. 1038 Common Stock Value Calculate Stable Growth

    17. 1041 Estimated Earnings Per Share & Dividends

    18. 1042 Common Stock Rate of Return Constant Growth Rate

    19. 1044 Common Stock Value Multiple Methods

About this course

  • $15.00
  • 41 lessons
  • 11 hours of video content

Description

This course will cover the valuation of financial assets including bonds, common stock, and preferred stock.

We will include many example problems, both in the format of presentations and Excel worksheet problems. The Excel worksheet presentations will include a downloadable Excel workbook with at least two tabs, one with the answer, the second with a preformatted worksheet that can be completed in a step-by-step process along with the instructional videos.

The general concept used to value financial assets is to take the present value of future cash flows from the financial asset. Therefore, we will need to use present value concepts and calculations.

The cash flow related to bonds will generally consist of a series of interest payments and a principal payment at maturity of the bond. We can use annuity calculations to determine the present value of the interest payments and present value of one calculation to determine the present value of principal at maturity.

Preferred stock has characteristics similar to bonds in that the payments are often standardized. However, we do not have a maturity date as we do with bonds.

Common stock can be more complex as we consider the future cash flow of dividends in an attempt to value the securities. The common stock dividends are more likely to change over time and we do not have a maturity date as we do with bonds.