This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

To calculate your LTV ratio using Microsoft Excel for the example above, first right click on columns A, B, and C, select Column Width and change the value to 30 for each of the columns.

Reviewed by Charlene Rhinehart Fact checked by Vikki Velasquez Businesses depreciate long-term assets for both tax and accounting purposes. For tax purposes, businesses can deduct the cost of the ...

How to Calculate Depreciation Using Excel. Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function ...

"Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money. To calculate ROI you divide the earnings you made from an investment by the ...

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present ...

Learn how to calculate the intrinsic value of a stock using Warren Buffett's proven method! Intrinsic value is the foundation of successful investing, helping you determine whether a stock is ...

The article How to Calculate the Real Value of Money Using the CPI Formula originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Since an annuity’s present value depends on how much money you expect to receive in the future, you should keep the time value of money in mind when calculating the present value of your annuity.

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 ...