{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch3ClassNotes_Part3_sp10

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

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

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.

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

View Full Document
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
Ask a homework question - tutors are online