Download files for Chapter 05 (Right-click link, then click SAVE to download):
Download Excel file: ACCTG455-Ch05.xlsx
Download notes: ACCTG455-Ch05.pdf Second pdf (note required): ACCTG455-Ch05-DeductiveProofAnnuityFormula.pdf
Videos to watch for chapter 05:
ACCTG 455: Excel Finance Class 26: Multiple Cash Flow Valuation, Future Value & Present Value (21 mins)
ACCTG 455: Excel Finance Class 27: Asset Valuation Using Discounted Cash Flow Analysis & PV Function (7 mins)
ACCTG 455: Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate (20 mins)
ACCTG 455: Excel Finance Class 29: Calculate Future Value Of An Annuity (FV Function) (18 mins)
ACCTG 455: Excel Finance Class 30: Future Value For Interest Paid Daily, But Deposits Made Monthly (6 mins)
ACCTG 455: Excel Finance Class 31: Calculate PMT for Future Value of Annuity (PMT Function) (8 mins)
ACCTG 455: Excel Finance Class 32: Calculate Present Value of Annuity (PV Function) (10 mins)
ACCTG 455: Excel Finance Class 33: Full Life Retirement Plan with PV Annuity & FV Annuity (10 mins)
ACCTG 455: Excel Finance Class 34: Present Value Of Annuity For Asset Valuation (3 mins)
ACCTG 455: Excel Finance Class 35: PMT for Present Value of Annuity PMT Function for Loan Payment (3 mins)
ACCTG 455: Excel Finance Class 36: PMT Function 7 Examples & Adjusted APR w/ Points & RATE function (15 mins)
ACCTG 455: Excel Finance Class 37: How Much Do I Get Each Month During Retirement? (3 mins)
ACCTG 455: Excel Finance Class 38: Calculate APR and EAR Given Cash Flows From Annuity (3 mins)
ACCTG 455: Excel Finance Class 39: How Long To Pay Off Credit Card With Minimum Payment (3 mins)
ACCTG 455: Excel Finance Class 40: Perpetuity (consol) Preferred Stock Valuation Formula (3 mins)
ACCTG 455: Excel Finance Class 41: Interest Only Loan Schedule. (2 mins)
ACCTG 455: Excel Finance Class 42: Consumer Amortized Loans (9 mins)
ACCTG 455 42.1: Excel Spilled Loan Amortization Table. #Short Excel Trick 40 (2 mins)
ACCTG 455: Excel Finance Class 43: Business Amortized Loans (3 mins)
ACCTG 455 43.1: Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41 (2 mins)
ACCTG 455: Excel Finance Class 44: Deep Discount Loans (6 mins)