Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network Access AI Bot ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

 Home > Courses > Access > Expert > X30 > X30 Outline < X29 Outline | X31 Outline >
 Access Expert 30 01. Functions & Interest (9:08) Access Financial Funtions Functions Covered Today: PV, FV RATE, NPER PMT, PPMT, IPMT Functions NOT Covered: NPV, DDB, IRR, MIRR SLN, SYD Simple v. Compound Interest Rates APR Annual Percentage Rate 02. Loan Calculator (18:08) Calculate Mortgage Payments PMT Function Amount of Loan Number of Periods Interest Rate Monthly Payment Total Amount Paid Total Interest Paid Rounding Issues Extra Payment at End of Loan 03. Investment Calculator (7:37) Calculate Future Value of Investment Amount of Investment APR Annual Percentage Rate Number of Years to Invest Extra Payments Future Value FV Function 04. Interest Rate Calculator (11:30) What was my rate of return ROI Intial Investment Amount Amount of Return Number of Years to Invest What was my Interest Rate RATE Function Why sometimes divide by 12 Annual vs. Monthly Compounding 05. Millionaire Calculator (9:30) How long until I'm a millionaire Initial Deposit Amount Monthly Payment Amount Goal Amount Interest Rate Calculate Number of Months Convert to Whole Years INT Function NPER FUnction 06. Initial Deposit Calculator (7:06) College fund calculator How much deposit to hit goal return Current Balance Amount Interest Rate Years to have account open Extra annual payments PV Function 07. House Value Calculator (5:55) Monthly payment you can afford Interest rate from bank How many years for your mortgage Calculate house you can afford PV Function 08. Loan Amortization (22:47) How Amortization Works Interest and Principal Portions Build LoanF Form Create AmortT Table for Periods Build AmortF Subform Link Child and Master Fields Calculate Interest Paid IPMT Function Calcaulte Principal Paid PPMT Function Rounding Issues IIF Function to Hide Errors