Many people are out buying homes this year as interest rates are at record lows. But figuring out what you can afford can sometimes be a bit challenging. You need to factor in how much of a downpayment you can afford, what your monthly payments wil ...
Last week, I covered how to calculate discounted cash flow. In this post, I'll build off that worksheet and show you how you can calculate the internal rate of return (IRR) in Excel. IRR tells you the return that you're making on an investment or pr ...
Do you need to calculate the present value of future cash flows or assess two options that will impact your cash flow over many years? Excel's a great place to do that and below I'll show you how you can easily set up a template to calculate discoun ...
$ per Day Week Month var slider = document.getElementById("myRange"); slider.oninput = function() { document.getElementById("money").innerHTML = "$" + slider.value; } function formatNumber(n ...
Several weeks ago, I discovered that Excel had a new function called STOCKHISTORY. It's able to pull stock prices and a great way to track stock prices and can help calculate returns. Excel does make it clear that it is not for trading purposes. Ho ...
50 Hours Minutes per Day Week Month var slider = document.getElementById("myRange"); slider.oninput = function() { document.getElementById("time").innerHTML = slider.value; } ...
Sensitivity analysis is a powerful way to make your template or Excel model update to reflect changes in variables. It makes it easy to run various what-if scenarios at once. In this post, I'll show you how you can conduct sensitivity analysis in ...
When doing any kind of data analysis, it's important to be able to pull in not just raw data but also to show percentages. From a period-over-period percent change to how much an item represents of a total, showing a percentage can give readers mult ...
VLOOKUP is a powerful function for extracting data from another sheet. And while most users will use it simply for pulling just one field, it can do a lot more than just that. Below, I'll show you how you can extract multiple columns from just a sin ...
For a while, one of the big advantages Google Sheets had over Excel was the ability to pull stock quotes easily. But that's no longer the case as there is a new function in Excel that allows you to pull in stock price history. Below, I'll cover how ...
