资讯

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.
How to calculate return on investment (ROI), the money an investment made relative to its cost, in Microsoft Excel.
How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.
This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.
If you are entering an investment amount, type it as a negative number, because it represents money you are currently spending. If this is the variable you wish to calculate, omit this step.