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.

A. There are many ways to calculate depreciation in Excel, and several of the depreciation methods already have a built-in function included in the software. The table below includes all the built-in ...

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

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

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

This ‘doubling of investment’ is an illusion as people fail to factor in the time value of money – the concept that a certain sum of money has greater value now than it will in the future ...

How to Calculate Inflation-Adjusted Prices To find out how inflation has affected the value of money over time, calculations can be done by hand or using spreadsheets.

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier. You may be investing through SIP or making lump sum investments ...

Do you know how much your mutual fund scheme has generated till now? Here is how to calculate CAGR in Excel One may use CAGR to calculate returns from mutual funds schemes by taking into account ...

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 .