{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch3ClassNotes_Part3_sp10

Ch3ClassNotes_Part3_sp10 - C hapter 3 Excel Functions Pa rt...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Functions, Part 3 (of 4) Chapter Skills for Part 3 Practice using financial functions to return various data variables used in the calculation of time value of money. Understand each argument of financial functions used in time value of money calculations. Build an amortization table using financial functions: o PMT, IPMT, PPMT Become aware of other financial functions that support time value of money calculation: o PV, FV, NPV, NPER, RATE Use data validation to prevent user entry errors. Chapter Vocabulary for Chapter 3, Part 3 time value of money amortization amortization table Financial category of functions Chapter Demonstration 13: 1. Download and save to your machine the Excel file, LoanCalculator_ch3-3.xlsx that is posted on Blackboard. 2. Select the LoanData worksheet . Sample data is already provided in cells in range B2:B6. You may change this data as you wish. 3. Apply data validation to cell B5. Use a drop-down list to limit the user choice to the years listed in column F. a.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

Ch3ClassNotes_Part3_sp10 - C hapter 3 Excel Functions Pa rt...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon bookmark
Ask a homework question - tutors are online