Go with the cash flow: Calculate NPV and IRR in Excel
There are two financial methods that you can use to help you answer all of these questions: net present value (NPV) and internal rate of return (IRR). Both NPV and IRR are referred to as discounted cash flow methods because they factor the time value of money into your capital investment project evaluation.
Introduction to What-If Analysis - Microsoft Support
By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results. For example, you can do What-If Analysis to build two budgets that each assumes a certain level of revenue.
Underline cell contents, entire cells, or rows on a worksheet ...
Underline cell contents, entire cells, or rows on a worksheet. There are several ways to add underlining to data on a worksheet. You can underline all or selected text in cells, apply a bottom border to cells or rows, or draw a line to underline cells.
Date systems in Excel - Microsoft Support
Excel supports two date systems, the 1900 date system and the 1904 date system. Each date system uses a unique starting date from which all other workbook dates are calculated. All newer versions of Excel calculate dates based on the 1900 date system, while older versions used the …
Excel Functions Translator - Microsoft Support
Enables users to easily translate full formulas to their native language. Supports all of Excel's localized languages and functions, with 80 languages, and 800 functions. Provides an efficient way to search for any part of a function's name in both languages selected.