Excel Chapter 5

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/4

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

5 Terms

1
New cards

Future value

+FV(rate,nper,pmt,pv)

2
New cards

In excel, just like in a graphing calc, present value is

Negative!
So for example, you would type “-B7”

3
New cards

Present value

=PV(rate,nper,pmt,fv)

4
New cards

Discount rate

=RATE(nper,pmt,pv,fv)

5
New cards

Number of periods

=NPER(rate,pmt,pv,fv)