00 Introduction |
1 |
0001 Welcome |
|
2.69 MB |
|
|
2 |
0002 Using the exercise files |
|
425.55 KB |
|
|
3 |
0003 Disclaimer |
|
308.10 KB |
|
|
01 Analyzing Loans, Payments, and Interest |
4 |
0101 PMT Calculating a loan payment |
|
2.98 MB |
|
|
5 |
0102 PPMT and IPMT Calculating principal and interest per loan payment |
|
3.71 MB |
|
|
6 |
0103 CUMPRINC and CUMIPMT Calculating cumulative principal and interest paid between periods |
|
3.53 MB |
|
|
7 |
0104 ISPMT Calculating interest paid during a specific period |
|
1.63 MB |
|
|
8 |
0105 EFFECT and NOMINAL Finding nominal and effective interest rates |
|
2.74 MB |
|
|
9 |
0106 ACCRINT and ACCRINTM Calculating accrued interest for investments |
|
3.29 MB |
|
|
10 |
0107 RATE Discovering the interest rate of an annuity |
|
2.44 MB |
|
|
11 |
0108 NPER Calculating the number of periods in an investment |
|
2.68 MB |
|
|
02 Calculating Depreciation |
12 |
0201 SLN Calculating depreciation using the straight-line method |
|
1.41 MB |
|
|
13 |
0202 DB Calculating depreciation using the declining balance method |
|
2.44 MB |
|
|
14 |
0203 DDB Calculating depreciation using the double-declining balance method |
|
2.57 MB |
|
|
15 |
0204 SYD Calculating depreciation for a specified period |
|
1.65 MB |
|
|
16 |
0205 VDB Calculating declining balance depreciation for a partial period |
|
2.58 MB |
|
|
17 |
0206 AMORDEGRC Calculating depreciation using a depreciation coefficient |
|
1.93 MB |
|
|
18 |
0207 AMORLINC Calculating depreciation for each accounting period |
|
2.18 MB |
|
|
03 Determining Values and Rates of Return |
19 |
0301 FV Calculating the future value of an investment |
|
2.13 MB |
|
|
20 |
0302 FVSCHEDULE Calculating the future value of an investment with variable returns |
|
1.77 MB |
|
|
21 |
0303 PV Calculating the present value of an investment |
|
2.85 MB |
|
|
22 |
0304 NPV Calculating the net present value of an investment |
|
2.57 MB |
|
|
23 |
0305 XNPV Calculating net present value given irregular inputs |
|
2.06 MB |
|
|
24 |
0306 IRR Calculating internal rate of return |
|
2.01 MB |
|
|
25 |
0307 XIRR Calculating internal rate of return for irregular cash flows |
|
1.43 MB |
|
|
26 |
0308 MIRR Calculating internal rate of return for mixed cash flows |
|
1.71 MB |
|
|
27 |
0309 DISC Calculating the discount rate of a security |
|
2.40 MB |
|
|
04 Calculating Bond Coupon Dates and Security Durations |
28 |
0401 COUPDAYBS Calculating total days between coupon beginning and settlement |
|
2.38 MB |
|
|
29 |
0402 COUPDAYS Calculating days in the settlement date's coupon period |
|
2.22 MB |
|
|
30 |
0403 COUPDAYSNC Calculating days from the settlement date to the next coupon date |
|
2.32 MB |
|
|
31 |
0404 COUPNCD Calculating the next coupon date after the settlement date |
|
2.11 MB |
|
|
32 |
0405 COUPNUM Calculating the number of coupons between settlement and maturity |
|
2.28 MB |
|
|
33 |
0406 COUPPCD Calculating the date of a coupon due immediately before settlement |
|
2.40 MB |
|
|
34 |
0407 DURATION Calculating the annual duration of a security |
|
2.58 MB |
|
|
35 |
0408 MDURATION Calculating the duration of a security using the modified Macauley method |
|
2.58 MB |
|
|
05 Calculating Security Prices and Yields |
36 |
0501 DOLLARDE and DOLLARFR Converting between fractional prices and decimal prices |
|
2.03 MB |
|
|
37 |
0502 INTRATE Calculating the interest rate of a fully invested security |
|
2.18 MB |
|
|
38 |
0503 RECEIVED Calculating the value at maturity of a fully invested security |
|
2.12 MB |
|
|
39 |
0504 PRICE Calculating the price of a security that pays periodic interest |
|
2.56 MB |
|
|
40 |
0505 PRICEDISC Calculating the price of a discounted security |
|
2.17 MB |
|
|
41 |
0506 PRICEMAT Calculating the price of a security that pays interest at maturity |
|
1.55 MB |
|
|
42 |
0507 TBILLEQ Calculating the bond-equivalent yield for a Treasury bill |
|
1.43 MB |
|
|
43 |
0508 TBILLPRICE Calculating the price for a Treasury bill |
|
1.17 MB |
|
|
44 |
0509 TBILLYIELD Calculating the yield of a Treasury bill |
|
1.30 MB |
|
|
45 |
0510 YIELD Calculating the yield of a security that pays periodic interest |
|
2.26 MB |
|
|
46 |
0511 YIELDDISC Calculating the annual yield for a discounted security |
|
1.64 MB |
|
|
47 |
0512 YIELDMAT Calculating the annual yield of a security that pays interest at maturity |
|
1.76 MB |
|
|
06 Calculating Prices and Yields of Securities with Odd Periods |
48 |
0601 ODDFPRICE Calculating the price of a security with an odd first period |
|
2.54 MB |
|
|
49 |
0602 ODDFYIELD Calculating the yield of a security with an odd first period |
|
2.38 MB |
|
|
50 |
0603 ODDLPRICE Calculating the price of a security with an odd last period |
|
2.12 MB |
|
|
51 |
0604 ODDLYIELD Calculating the yield of a security with an odd last period |
|
2.26 MB |
|
|
07 Conclusion |
52 |
0701 Additional resources |
|
781.18 KB |
|
|
08 ZZZ - فایلهای تمرینی |
53 |
Ex_Files_Ex10_Fin_ID |
|
310.48 KB |
|
|