Spreadsheets articles

Depending on the buyer’s preferences, there are periodic investments as well as fixed investments to choose from....

Given the periodic interest rate and expected yield, do you need to calculate the price of an investment or a...

All of us try and invest our money in some assets. So, we would definitely want to know how much value our future...

Let’s assume that we have a number of periodic constant-value payments to make against an investment. So naturally, we...

There are usually two kinds of assets – appreciating and depreciating assets. While investments such as stocks, bonds...

Given the expected yield that an investment and the interest rate, the MDURATION formula in Google Sheets calculates...

With the DISC formula in Google Sheets, we can calculate a security’s discount rate based on its price. This is one of...

Do you need to calculate the number of compounding periods that an investment required to reach a target value?...

With the NOMINAL interest rate formula in Google Sheets, we can calculate the annual nominal interest rate. We just...