Financial Functions

Microsoft Excel has a robust library of Financial Functions. Let's say that our little company, Charlotte's Website, needs a car. How would you calculate the car payments?

Here are the steps.


1. Before You Begin: Enter the Labels

Open a new, blank spreadsheet.

Select Cell A1 and type: Present Value

Select Cell A2 and type: Number of Payments

Select Cell A3 and type: Interest Rate

Select Cell A4 and type: Payment


If these are labels, and they are, they should be selected and formatted BOLD.


Keep going...


Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: FINANCIAL Functions