| 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 |
|
|
