| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/00 Introduction/0001 Welcome.mov |
5.1 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/00 Introduction/0002 Using the exercise files.mov |
663 KB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/00 Introduction/0003 Disclaimer.mov |
499 KB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/01 Analyzing Loans, Payments, and Interest/0102 PPMT and IPMT Calculating principal and interest per loan payment.mov |
6.8 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/01 Analyzing Loans, Payments, and Interest/0103 CUMPRINC and CUMIPMT Calculating cumulative principal and interest paid between periods.mov |
5.8 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/01 Analyzing Loans, Payments, and Interest/0101 PMT Calculating a loan payment.mov |
5.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/01 Analyzing Loans, Payments, and Interest/0106 ACCRINT and ACCRINTM Calculating accrued interest for investments.mov |
5.3 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/01 Analyzing Loans, Payments, and Interest/0107 RATE Discovering the interest rate of an annuity.mov |
4.8 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/01 Analyzing Loans, Payments, and Interest/0105 EFFECT and NOMINAL Finding nominal and effective interest rates.mov |
4.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/01 Analyzing Loans, Payments, and Interest/0108 NPER Calculating the number of periods in an investment.mov |
4.3 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/01 Analyzing Loans, Payments, and Interest/0104 ISPMT Calculating interest paid during a specific period.mov |
2.8 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/02 Calculating Depreciation/0205 VDB Calculating declining balance depreciation for a partial period.mov |
4.1 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/02 Calculating Depreciation/0203 DDB Calculating depreciation using the double-declining balance method.mov |
4.1 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/02 Calculating Depreciation/0202 DB Calculating depreciation using the declining balance method.mov |
3.9 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/02 Calculating Depreciation/0207 AMORLINC Calculating depreciation for each accounting period.mov |
3.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/02 Calculating Depreciation/0206 AMORDEGRC Calculating depreciation using a depreciation coefficient.mov |
3.2 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/02 Calculating Depreciation/0204 SYD Calculating depreciation for a specified period.mov |
2.8 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/02 Calculating Depreciation/0201 SLN Calculating depreciation using the straight-line method.mov |
2.3 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0303 PV Calculating the present value of an investment.mov |
4.6 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0304 NPV Calculating the net present value of an investment.mov |
4.2 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0309 DISC Calculating the discount rate of a security.mov |
3.9 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0301 FV Calculating the future value of an investment.mov |
3.4 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0305 XNPV Calculating net present value given irregular inputs.mov |
3.4 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0306 IRR Calculating internal rate of return.mov |
3.2 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0302 FVSCHEDULE Calculating the future value of an investment with variable returns.mov |
2.9 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0308 MIRR Calculating internal rate of return for mixed cash flows.mov |
2.7 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/03 Determining Values and Rates of Return/0307 XIRR Calculating internal rate of return for irregular cash flows.mov |
2.3 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/04 Calculating Bond Coupon Dates and Security Durations/0408 MDURATION Calculating the duration of a security using the modified Macauley method.mov |
4.2 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/04 Calculating Bond Coupon Dates and Security Durations/0407 DURATION Calculating the annual duration of a security.mov |
4.2 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/04 Calculating Bond Coupon Dates and Security Durations/0401 COUPDAYBS Calculating total days between coupon beginning and settlement.mov |
3.9 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/04 Calculating Bond Coupon Dates and Security Durations/0406 COUPPCD Calculating the date of a coupon due immediately before settlement.mov |
3.8 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/04 Calculating Bond Coupon Dates and Security Durations/0403 COUPDAYSNC Calculating days from the settlement date to the next coupon date.mov |
3.7 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/04 Calculating Bond Coupon Dates and Security Durations/0405 COUPNUM Calculating the number of coupons between settlement and maturity.mov |
3.6 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/04 Calculating Bond Coupon Dates and Security Durations/0402 COUPDAYS Calculating days in the settlement date's coupon period.mov |
3.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/04 Calculating Bond Coupon Dates and Security Durations/0404 COUPNCD Calculating the next coupon date after the settlement date.mov |
3.4 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0504 PRICE Calculating the price of a security that pays periodic interest.mov |
4.2 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0510 YIELD Calculating the yield of a security that pays periodic interest.mov |
3.7 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0505 PRICEDISC Calculating the price of a discounted security.mov |
3.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0502 INTRATE Calculating the interest rate of a fully invested security.mov |
3.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0503 RECEIVED Calculating the value at maturity of a fully invested security.mov |
3.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0501 DOLLARDE and DOLLARFR Converting between fractional prices and decimal prices.mov |
3.2 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0512 YIELDMAT Calculating the annual yield of a security that pays interest at maturity.mov |
2.9 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0511 YIELDDISC Calculating the annual yield for a discounted security.mov |
2.7 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0506 PRICEMAT Calculating the price of a security that pays interest at maturity.mov |
2.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0507 TBILLEQ Calculating the bond-equivalent yield for a Treasury bill.mov |
2.4 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0509 TBILLYIELD Calculating the yield of a Treasury bill.mov |
2.1 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/05 Calculating Security Prices and Yields/0508 TBILLPRICE Calculating the price for a Treasury bill.mov |
1.9 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/06 Calculating Prices and Yields of Securities with Odd Periods/0601 ODDFPRICE Calculating the price of a security with an odd first period.mov |
4.2 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/06 Calculating Prices and Yields of Securities with Odd Periods/0602 ODDFYIELD Calculating the yield of a security with an odd first period.mov |
3.9 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/06 Calculating Prices and Yields of Securities with Odd Periods/0604 ODDLYIELD Calculating the yield of a security with an odd last period .mov |
3.7 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/06 Calculating Prices and Yields of Securities with Odd Periods/0603 ODDLPRICE Calculating the price of a security with an odd last period.mov |
3.5 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/07 Conclusion/0701 Additional resources.mov |
1.3 MB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/Exercise Files/Ex_Files_Ex10_Fin_ID.zip |
310 KB |
| Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR/quasar.nfo |
3 KB |
Magnet link
