This article provides example scenarios and explains various approaches for calculating the time value of money using Microsoft Excel. The Excel tools discussed herein include the FV, FVSCHEDULE, PV, ...

How to Calculate Fluctuations in Excel. Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for ...

How to Calculate How Much You Can Borrow Using Excel. How much you can borrow is often determined by the bank based on internal qualifiers, such as credit score, debt-to-income ratio, interest ...

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present ...