Microsoft (MS) Excel has several financial functions that can come quite handy for you as an investor. Many of these are simple to understand and use. On the Excel screen, these functions can be ...

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

Use Excel in your rate card formulas to calculate discounts, dimensions and unit costs of your advertising rate document. Instead of manually calculating each of these components, use Excel ...

Excel Financial functions are used to assist Financial Analysts and Investment Brokers to make calculations and create graphs. Here are the useful ones!

Here are the 17 most useful accounting functions in Microsoft Excel to make financial data monitoring and reporting easier and faster.

We looked at different Excel functions that help in estimating the future value of investments, both for constant and varied interest rates, computing loan EMIs, and estimating the time frame to reach ...

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.

Earlier, we had seen how the RATE function can be used to calculate the return on investments, whether lump-sum or periodic. This can come in handy in the calculation of SIP returns, too.

Ever wondered how such YTM is calculated? Theoretically, YTM of a bond is that rate that equates the present value of the stream of interest income to its face value.