Excel金融应用

# Pd o w pd c u tr a c k c h f xc a n ge h f xc a n

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 50 10% FV 5 rate nper pmt pv type 5 .d o m w o m o .c lic k to bu EXCEL lic C c u-tr a c k w w .d o w w w C y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE y N bu to k • Excel 150 5 RATE 241.58 • Excel NPER 150 10% nper pmt pv rate pmt pv 241.58 fv fv type guess type .d o m w o m o .c lic k to bu EXCEL lic C c u-tr a c k w w .d o w w w C y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE y N bu to k (Annuity) • Excel 150 PV 10% rate nper pmt fv type 5 .d o m w o m o .c lic k to bu EXCEL lic C c u-tr a c k w w .d o w w w C y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE y N bu to k • 2 4 12 52 365 nominal rate periodic rate effective rate rper = • Excel nominal_rate • effect_rate rnom m EAR = (1 + rper ) m − 1 EFFECT nominal_rate npery effect_rate npery npery Excel NOMINAL .d o m w o m o .c lic k to bu EXCEL lic C c u-tr a c k w w .d o w w w C y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic w .d o m III o .c C m o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic 3 “ “ “ -” “ “ “ “ ” ” ” “ ” - - ” .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic 1 2 1 2 3 .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic Excel Excel Excel Excel X Y Z . .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic ” ”” , “ “ -” “ “ .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic Excel .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr...
View Full Document

## This document was uploaded on 03/29/2014.

Ask a homework question - tutors are online