Author

Valentine Schelstraete

Helping SaaS find their right buyer personas and generate organic traffic to build their user and customer base rapidly. Interested in all things product marketing, providing the best product/service to the right profile, and how to scale your tech business.

Latest posts

DAYS360 formula in Google Sheets

How to use the DAYS360 Google Sheets formula

Let’s say we need to know how far two different dates are separated from each other, based on the 360 day year. Probably for the purposes...
PPMT formula - Featured Image

How to use the PPMT formula in Google Sheets

Almost all of us at some point in our lives may opt for loans, against a prevailing interest rate. And we’d be interested to know the...
RECEIVED formula - Featured Image

How to use the RECEIVED formula in Google Sheets

Depending on the buyer’s preferences, there are periodic investments as well as fixed investments to choose from. Suppose that we...
PRICE formula - Featured Image

How to use the PRICE formula in Google Sheets

Given the periodic interest rate and expected yield, do you need to calculate the price of an investment or a security? The aptly...
PV formula - Featured Image

How to use the PV formula in Google Sheets

All of us try and invest our money in some assets. So, we would definitely want to know how much value our future investments stand for,...
RATE formula - Featured Image

How to use the RATE formula in Google Sheets

Let’s assume that we have a number of periodic constant-value payments to make against an investment. So naturally, we would be interested...
SLN formula - Featured Image

How to use the SLN formula in Google Sheets

There are usually two kinds of assets – appreciating and depreciating assets. While investments such as stocks, bonds etc. fall into the...
MDURATION formula - Featured Image

How to use the MDURATION formula in Google Sheets

Given the expected yield that an investment and the interest rate, the MDURATION formula in Google Sheets calculates the modified Macaulay...
How to use the DISC formula in Google Sheets featured image

How to use the DISC formula in Google Sheets

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

How to use the DURATION formula in Google Sheets

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