The forward price-to-earnings ratio (P/E) is a valuation metric that measures and compares a company's earnings using ...

How much you can borrow is often determined by the bank based on internal qualifiers, such as credit score, debt-to-income ratio, interest rate and the type of loan you need. These qualifiers will ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work. Image: ...

The market price of a stock doesn't necessarily reflect its intrinsic value. Several economic theories use different approaches toward valuing companies, but one of the simplest involves calculations ...

A price breakpoint is a discount you offer your customers based on the amount of units that they order. The breakpoint is the lower value of the range that entitles a customer to a discount. For ...

Successful investing requires the ability to distinguish long-term trends from the short-term noise that moves stock prices on a minute-to-minute basis. One way to tune out the random oscillations and ...

The right way to find the returns over the long term will be to represent the returns in terms of CAGR. Returns in a market-linked investment such as equity share or a mutual fund do not grow in the ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. David Kindness is a Certified Public Accountant ...