Excel金融应用

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

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

View Full Document Right Arrow Icon
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

Ask a homework question - tutors are online