Reviewed by Thomas J. Catalano Fact checked by Vikki Velasquez The discount rate refers to the interest rate used when calculating the net present value (NPV) of an investment. It represents the ...

If you have assessed your finances and determined how much you can afford to pay each month, then you can calculate the maximum amount you can borrow, based on that monthly payment and a given ...

How to Calculate a Loan's Monthly Payment in Excel With Tax & PMI. Your monthly loan payment consists of more than just equity and interest payments. If you didn't put down at least 20 percent ...

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Reviewed by Ebony Howard Fact checked by Ryan Eichler Your effective tax rate can be calculated using Microsoft Excel through a few standard functions and an accurate breakdown of your income by ...

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.