Sheetgo Blog
Your go-to resource for all things spreadsheet related
Given the periodic interest rate and expected yield, do you need to calculate the price of an investment or a security? The aptly...
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,...
Let’s assume that we have a number of periodic constant-value payments to make against an investment. So naturally, we would be interested...
There are usually two kinds of assets – appreciating and depreciating assets. While investments such as stocks, bonds etc. fall into the...
Given the expected yield that an investment and the interest rate, the MDURATION formula in Google Sheets calculates the modified Macaulay...
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...
Do you need to calculate the number of compounding periods that an investment required to reach a target value? The DURATION formula in...
With the NOMINAL interest rate formula in Google Sheets, we can calculate the annual nominal interest rate. We just need to have an...
Do you have a series of irregularly spaced cash flows of an investment? And you want to calculate the internal rate of return or...
Ever wanted to have proper Google sheets data visualization, creating dashboard views and generate appealing reports? Visible is a SaaS...
Europe's General Data Protection Regulation (GDPR) is a new law governing data protection and privacy for citizens of the European Union....
How to get structured data for reporting Your company has decided to standardize spreadsheets and reporting on Google Sheets. That’s...
English 
Español 
Português do Brasil 
Français