| 1 -Building Discount Formulas - Complete.xlsx | 407.8 KB | ||
| 1 -Building Discount Formulas - Teaching File.xlsx | 404.2 KB | ||
| 1 -Building Discount Formulas.mp4 | 20.6 MB | ||
| 1 -Building Discount Formulas.pptx | 1.3 GB | ||
| 1 -Building Loan Formulas - Completed.xlsx | 488.1 KB | ||
| 1 -Building Loan Formulas - Teaching File.xlsx | 463 KB | ||
| 1 -Building Loan Formulas.mp4 | 19.5 MB | ||
| 1 -Building Loan Formulas.pptx | 876.6 MB | ||
| 1 -Working with Investment Formulas - completed.xlsx | 978.3 KB | ||
| 1 -Working with Investment Formulas - teaching file.xlsx | 977.2 KB | ||
| 1 -Working with Investment Formulas.mp4 | 15.3 MB | ||
| 1 -Working with Investment Formulas.pptx | 208.5 MB | ||
| 10 -Building a Dynamic Loan Amortization Schedule.mp4 | 126.7 MB | ||
| 10 -Net Present Value with Nonperiodic Cash Flows.mp4 | 11.8 MB | ||
| 10 -Working Toward an Investment Goal; Calculating The Required Regular Deposit.mp4 | 11.2 MB | ||
| 11 -Calculating The Payback Period.mp4 | 28.3 MB | ||
| 11 -Calculating The Required Initial Deposit.mp4 | 10.9 MB | ||
| 11 -Calculating The Term of a Loan.mp4 | 75.7 MB | ||
| 12 -Calculating The Future Value with Varying Interest Rates.mp4 | 24.1 MB | ||
| 12 -Calculating The Interest Rate Required for a Loan.mp4 | 14.9 MB | ||
| 12 -Exact Undiscounted Payback Point.mp4 | 22 MB | ||
| 13 -Building an Investment Schedule.mp4 | 40.8 MB | ||
| 13 -Calculating How Much You Can Borrow.mp4 | 13.8 MB | ||
| 13 -Discounted Payback Period.mp4 | 54 MB | ||
| 14 -Building a Variable-Rate Mortgage Amortization Schedule.mp4 | 57 MB | ||
| 14 -Calculating The Internal Rate of Return.mp4 | 10.6 MB | ||
| 15 -Allowing for Mortgage Principal Paydowns.mp4 | 19.6 MB | ||
| 15 -Calculating IRR for Nonperiodic Cash Flows.mp4 | 9 MB | ||
| 16 -Calculating Multiple Internal Rates of Return.mp4 | 10.5 MB | ||
| 17 -Case Study; Publishing a Book.mp4 | 239.9 MB | ||
| 2 -Calculating The Present Value.mp4 | 37.2 MB | ||
| 2 -Understanding The Time Value of Money.mp4 | 25.8 MB | ||
| 2 -Working with Interest Rates.mp4 | 12.5 MB | ||
| 3 -Calculating The Present Value Using PV ().mp4 | 17.6 MB | ||
| 3 -Calculating a Loan Payment.mp4 | 23.8 MB | ||
| 3 -Nominal Versus Effective Interest.mp4 | 30.6 MB | ||
| 4 -Converting Between The Nominal Rate and The Effective Rate.mp4 | 10 MB | ||
| 4 -Income Investing vs. Purchasing a Rental Property.mp4 | 22.6 MB | ||
| 4 -Working With A Balloon Loan.mp4 | 20.6 MB | ||
| 5 -Buying vs. Leasing.mp4 | 24.1 MB | ||
| 5 -Calculating Interest Costs - Part I.mp4 | 26.1 MB | ||
| 5 -Calculating The Future Value of a Lump Sum.mp4 | 20 MB | ||
| 6 -Calculating The Principal & Interest.mp4 | 51.3 MB | ||
| 6 -Discounting Cash Flows.mp4 | 20.5 MB | ||
| 6 -The Future Value of a Series of Deposits.mp4 | 14 MB | ||
| 7 -Calculating Interest Costs - Part II.mp4 | 26.2 MB | ||
| 7 -Calculating the Net Present Value.mp4 | 44.1 MB | ||
| 7 -The Future Value of a Lump Sum Plus Deposits.mp4 | 10.5 MB | ||
| 8 -Calculating Cumulative Principal & Interest.mp4 | 78.5 MB | ||
| 8 -Calculating the Present Value Using NPV.mp4 | 16.6 MB | ||
| 8 -Working Toward an Investment Goal; Calculating The Required Interest Rate.mp4 | 17.2 MB | ||
| 9 -Building a Loan Amortization Schedule.mp4 | 59.7 MB | ||
| 9 -Net Present Value with Varying Cash Flows.mp4 | 14 MB | ||
| 9 -Working Toward an Investment Goal; Calculating The Required Number of Periods.mp4 | 11.8 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 56 total files | |||
Time Value of Money and Finance Functions in Excel
https://WebToolTip.com
Published 8/2025
Created by CreateMyExcel with Ben Scholl
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 45 Lectures ( 2h 16m ) | Size: 3.84 GB
Use Excel’s financial functions to analyze loans, investments, and long-term value.
What you'll learn
Learn to calculate loan payments using Excel financial functions.
Build loan amortization schedules with fixed and dynamic options.
Analyze interest costs, loan terms, and principal over time.
Understand the time value of money in real-world loan scenarios.
Calculate future value for investments using compound interest.
Compare nominal and effective interest rates in investment planning.
Determine required deposits or rates to meet investment goals.
Calculate present value and apply discounting for future cash flows.
Use Excel to evaluate leasing, investing, and buying decisions.
Analyze investment return using NPV, IRR, and payback methods.
Requirements
Microsoft Excel (Office 2021 or Microsoft 365) installed.
Basic knowledge of Excel (e.g., entering data, simple calculations).
Access to a computer with a stable internet connection.
No prior advanced Excel skills required; suitable for beginners.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.3 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 439.4 MB | freecoursewb | 1 month | 0 | 1 | |
| 841.8 MB | freecoursewb | 2 months | 39 | 4 | |
| 1.3 GB | freecoursewb | 2 months | 15 | 3 | |
| 354.3 MB | freecoursewb | 2 months | 20 | 8 |
All Comments