
Explore present value concepts and market conditions to value bonds, common stock, and preferred stock within corporate finance asset valuation.
Explain issuing bonds at par, recording cash and bonds payable, and how market rate differences create premium or discount when selling bonds, with no effect on net income.
Explore how bond contract rates compare to market rates, and how premium or discount pricing adjusts the bond's price from face value while interest is paid over time.
Learn how to issue a bond at a discount, calculate and record semiannual interest payments, and amortize the discount using a straight-line method, with journal entries and trial balance effects.
Explore how issuing a bond at a premium affects journal entries, carrying value, and interest expense as the premium amortizes to align with market vs contract rates.
Learn present value formulas for bonds, including the face amount and semiannual interest annuity, using market rate versus stated rate to value cash flows today.
Compute bond price by discounting the face value and the semiannual interest annuity using present value tables.
Learn to price bonds in Excel using present value formulas, separating the bond’s final face value from interest payments, with semiannual periods over two years.
Value perpetual preferred stock by its fixed dividends, paid before common stock and without a maturity date, using the present value of a perpetuity (dividend divided by discount rate).
Explore how common stock valuation uses present value of future dividends to estimate stock value. Analyze no growth, constant growth, and variable growth dividend scenarios with the discount rate.
Value bonds by discounting annual coupons and face amount under different yield rates, illustrating premium or discount relative to par with present value of annuity and present value of one.
Calculate bond value under different yield rates by discounting coupon payments and the par value, illustrating premium when market yield is below coupon and discount when it is above.
Calculate principal as a percentage of bond price using present value of the annuity and present value of the principal under a 15% market rate and 30-year maturity.
Explore how bond value changes with different maturity dates by comparing premium prices, using present value of annuities and the par value, with 17% coupon versus 7% market rate.
Calculate the bond purchase price at an 18% market rate using present value concepts, then compute sale price, gain, and ROI at 14%.
Compute the bond’s purchase price, sale price, and rate of return on the long-term sale as market rates shift from 12% to 16% over 19 years.
Explore calculating bond rate and price changes with present value methods, illustrating premium and discount when market rate differs from bond rate, using a 1000 par, 20-year bond.
Calculate bond price at issue and after ten years as market rate shifts, showing premium or discount, present value of annuity, and present value of par value.
Learn to back into a bond's market rate or yield from price using present value of the annuity and par, with Excel goal seek.
Compute a bond's yield from a given price with semiannual payments using present value of annuity and present value, via Excel goal seek and rate functions.
Calculate the semiannual bond value for a 1500 face amount with a 12% coupon over 12 years, using a 14% market rate to compute present value of annuity and principal.
Explore how bond value responds to semiannual payments and market-rate changes, by calculating the present value of the annuity and the face value to see premium or discount.
Learn to value a bond under different yield rates using Excel, by computing the present value of an annuity (coupons) and the present value of the par value at maturity.
calculate bond value under different yield rates in excel for a 1,000 par value, 18% coupon, and 20-year maturity, illustrating premium and discount with present value methods.
Compute the principal as a percentage of bond price by decomposing price into the present value of the par value and the interest annuity, using Excel and tables.
Explore how bond value changes as maturities vary from 35 to 12 to 8 years, using excel to compute annuity and present value for a 1000 par bond at 7%.
Calculate bond price and ROI by modeling a bond purchase at a market yield and a later sale, using Excel to compute present value, sale price, and ROIC.
Compute the bond purchase price, long-term sale price, and ROI using Excel, present value and annuity methods, illustrating coupon and market yield effects.
Calculate bond issuance rate to match the market and determine issuance price, then examine how market rate changes create premium or discount, using Excel for present value calculations.
Compute the bond yield from its price using Excel, employing goal seek and the rate function to back into the market rate for a 10-year, 8% coupon bond.
Learn to calculate a bond rate and price in excel, using par value 1000, 25-year maturity, and present value of annuity and par value under changing market rates.
Use Excel to find the bond market rate for a semiannual coupon by matching price 1130 to par 1500 with an 8% annual coupon, using Goal Seek or Rate Function.
Calculate bond value with semiannual payments in Excel, using a 12% coupon and 14% market rate over 12 years; derive present value of annuity and principal to price the bond.
Calculate bond value with semiannual payments in Excel, comparing face value when market rate equals 15% and premium when rate changes to 8% after five years.
Shows how to value preferred stock in an Excel worksheet by dividing the dividend by the yield, then explores scenario changes from 10% to 7%.
Compute the yield or rate of return on preferred stock in Excel using a 19.6 dividend and 205 price, yielding about 9.56%, and validate price via dividend over yield.
Compute the common stock price under no-growth assumptions using a stable dividend and an 18% required return, as demonstrated in the Excel worksheet.
Evaluate the value and price of common stock under stable growth by combining dividend cash flows and growth, using the required rate of return in Excel practice problems.
Project future eps using past eps trends and a constant 12% growth, then estimate dividends as 30% of earnings in Excel.
Learn to calculate the rate of return on common stock with a constant growth rate in Excel, using dividends and growth to estimate the required rate of return.
Explore common stock valuation using multiple methods, including dividend projections and present value of future price, with Excel worksheets to compare scenarios.
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.