Cross Rates w/ Compounding Growth

Nov 04

In managerial accounting, we learn that sales is a function of price and volume, and that the growth of both sales and volume are not additive, but rather multiplicative (i.e., geometric).  The product of their growth rates is known as a cross rate, and can be derived by the following formula: Sales = Price × Volume, and Sales Growth =[ ( 1 + Price Growth Rate) × (1...

Read More

Further Insights Into The Gorden Dividend Discount Model (DDM)

Oct 20

Further Insights Into The Gorden Dividend Discount Model (DDM)

In a previous post, Gordon Dividend Discount Model (DDM) versus FCF Valuation Model, I explored the relationship between dividends being paid versus net income being retained, and how these both balance out within the DDM so that if more dividends are paid, less growth occurs, and if more net income is retained (i.e., less dividends are paid), more growth occurs. A...

Read More

A Closer Look at LINEST and Multiple Linear Regression

Apr 07

In a previous blog post, I walked through how Microsoft Excel calculates all of the variables for its LINEST function (i.e., multiple linear regression) except for the variable coefficients and their standard error, but promised to revisit LINEST.  This blog post directly addresses how to calculate manually the variable coefficients as well as their standard error....

Read More

The Proper Use of Beta (β)

Aug 03

The Proper Use of Beta (β)

In my previous post I highlighted the flaws associated with Beta (β), in this post I would like to explore the proper use of Beta. Studies have shown that managed portfolios only outperform the S&P500 Index about 1/3rd of the time in both bear and bull markets - this means that for 2/3rds of the time it is better to just invest your money in an index fund, and...

Read More

What is an Incremental Investment Dollar Worth?

Jan 15

What is an Incremental Investment Dollar Worth?

Whether you are an employee, a business owner, or a shareholder, you may have wondered what an incremental dollar of investment is worth to your company. First it depends upon the cost of funding (F%) for an incremental dollar of investment ($I), and second the return (R%) that you earn on that incremental dollar of investment.  The dollar value ($V) created by the...

Read More
Page 1 of 41234