How Does a Person Gain From an Investment?

July 8, 2024 No Comments

A: There are two main ways in which a person gains from an investment. The first is by capital gains, which is the difference between the purchase price and the sale price of an investment. The second is investment income, defined as the money paid

How does inflation affect fixed-income investments?

July 8, 2024 No Comments

A: Inflation is typically defined as a sustained increase in the price level of goods and services. There is no widespread consensus on the primary cause of inflation, but most economists agree that certain mechanisms in the economy, mainly commodity price increases and currency depreciation,

How does preferred stock differ from company issued bonds?

July 8, 2024 No Comments

A: Preferred stock is a special kind of equity ownership, while bonds are a common form of debt issue. Many consider preferred stock an investment that lands in between common shares and bonds. Despite many similarities, preferred stock is generally riskier than a bond and

How does quantitative easing in the U.S. affect the bond market?

July 8, 2024 No Comments

A: It is not entirely understood just how much, or even in what direction, the Federal Reserve’s quantitative easing, or QE, program affects the bond market. Simple market theory, based on increased demand from homogeneous buyers, should predict that the Fed’s purchase programs suppress bond

How does the money from the interest on my bond get to me?

July 8, 2024 No Comments

A: When you buy a regular coupon bond, you are entitled to a coupon, which is typically paid at regular intervals, and the face value of the bond (the amount you initially invested), which is typically paid upon maturity. Most coupons are paid on a

How is a corporate bond taxed?

July 8, 2024 No Comments

A: A corporate bond is taxed through the interest earned on the bond, through capital gains or losses earned in the early sale of the bond, and through an original issue discount. The aggregate taxes owed on each of these components adds up to equal

How can I create a yield curve in Excel?

July 8, 2024 No Comments

A: You can create a yield curve in Microsoft Excel if you are given the time to maturities of bonds and their respective yields to maturity. The yield curve depicts the term structures of interest rates for bonds and the term structures could be normal,

How do I calculate a discount rate over time, using Excel?

July 8, 2024 No Comments

A: The discount rate is the interest rate used when calculating the net present value (NPV) of something. NPV is a core component of corporate budgeting and is a comprehensive way to calculate whether a proposed project will add value or not. For this article, when we look at the discount

How do I calculate the expected return of my portfolio in Excel?

July 8, 2024 No Comments

A: The expected return of your portfolio can be calculated using Microsoft Excel if you know the expected return rates of all the investments in the portfolio. Using the total value of your portfolio, the value of each individual investment, and its respective return rate,

How do I calculate the Macaulay duration of a zero-coupon bond in Excel?

July 8, 2024 No Comments

A: The resulting Macaulay duration of a zero-coupon bond is equal to the time to maturity of the bond. A zero-coupon bond is a type of fixed-income security that does not pay interest on the principal amount. However, to compensate for the lack of coupon

All Rights Reserved