Udemy - Time Value of Money and Finance Functions in Excel
- Category Other
- Type Tutorials
- Language English
- Total size 3.8 GB
- Uploaded By freecoursewb
- Downloads 389
- Last checked 1 day ago
- Date uploaded 6 months ago
- Seeders 7
- Leechers 4
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.
Files:
[ WebToolTip.com ] Udemy - Time Value of Money and Finance Functions in Excel- Get Bonus Downloads Here.url (0.2 KB) ~Get Your Files Here ! 1 - Building Loan Formulas
- 1 -Building Loan Formulas - Completed.xlsx (488.1 KB)
- 1 -Building Loan Formulas - Teaching File.xlsx (463.0 KB)
- 1 -Building Loan Formulas.mp4 (19.5 MB)
- 1 -Building Loan Formulas.pptx (876.6 MB)
- 10 -Building a Dynamic Loan Amortization Schedule.mp4 (126.7 MB)
- 11 -Calculating The Term of a Loan.mp4 (75.7 MB)
- 12 -Calculating The Interest Rate Required for a Loan.mp4 (14.9 MB)
- 13 -Calculating How Much You Can Borrow.mp4 (13.8 MB)
- 14 -Building a Variable-Rate Mortgage Amortization Schedule.mp4 (57.0 MB)
- 15 -Allowing for Mortgage Principal Paydowns.mp4 (19.6 MB)
- 2 -Understanding The Time Value of Money.mp4 (25.8 MB)
- 3 -Calculating a Loan Payment.mp4 (23.8 MB)
- 4 -Working With A Balloon Loan.mp4 (20.6 MB)
- 5 -Calculating Interest Costs - Part I.mp4 (26.1 MB)
- 6 -Calculating The Principal & Interest.mp4 (51.3 MB)
- 7 -Calculating Interest Costs - Part II.mp4 (26.2 MB)
- 8 -Calculating Cumulative Principal & Interest.mp4 (78.5 MB)
- 9 -Building a Loan Amortization Schedule.mp4 (59.7 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 -Working Toward an Investment Goal; Calculating The Required Regular Deposit.mp4 (11.2 MB)
- 11 -Calculating The Required Initial Deposit.mp4 (10.9 MB)
- 12 -Calculating The Future Value with Varying Interest Rates.mp4 (24.1 MB)
- 13 -Building an Investment Schedule.mp4 (40.8 MB)
- 2 -Working with Interest Rates.mp4 (12.5 MB)
- 3 -Nominal Versus Effective Interest.mp4 (30.6 MB)
- 4 -Converting Between The Nominal Rate and The Effective Rate.mp4 (10.0 MB)
- 5 -Calculating The Future Value of a Lump Sum.mp4 (20.0 MB)
- 6 -The Future Value of a Series of Deposits.mp4 (14.0 MB)
- 7 -The Future Value of a Lump Sum Plus Deposits.mp4 (10.5 MB)
- 8 -Working Toward an Investment Goal; Calculating The Required Interest Rate.mp4 (17.2 MB)
- 9 -Working Toward an Investment Goal; Calculating The Required Number of Periods.mp4 (11.8 MB)
- 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)
- 10 -Net Present Value with Nonperiodic Cash Flows.mp4 (11.8 MB)
- 11 -Calculating The Payback Period.mp4 (28.3 MB)
- 12 -Exact Undiscounted Payback Point.mp4 (22.0 MB)
- 13 -Discounted Payback Period.mp4 (54.0 MB)
- 14 -Calculating The Internal Rate of Return.mp4 (10.6 MB)
- 15 -Calculating IRR for Nonperiodic Cash Flows.mp4 (9.0 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)
- 3 -Calculating The Present Value Using PV ().mp4 (17.6 MB)
- 4 -Income Investing vs. Purchasing a Rental Property.mp4 (22.6 MB)
- 5 -Buying vs. Leasing.mp4 (24.1 MB)
- 6 -Discounting Cash Flows.mp4 (20.5 MB)
- 7 -Calculating the Net Present Value.mp4 (44.1 MB)
- 8 -Calculating the Present Value Using NPV.mp4 (16.6 MB)
- 9 -Net Present Value with Varying Cash Flows.mp4 (14.0 MB)
- Bonus Resources.txt (0.1 KB)
There are currently no comments. Feel free to leave one :)
Code:
- udp://tracker.torrent.eu.org:451/announce
- udp://tracker.tiny-vps.com:6969/announce
- http://tracker.foreverpirates.co:80/announce
- udp://tracker.cyberia.is:6969/announce
- udp://exodus.desync.com:6969/announce
- udp://explodie.org:6969/announce
- udp://tracker.opentrackr.org:1337/announce
- udp://9.rarbg.to:2780/announce
- udp://tracker.internetwarriors.net:1337/announce
- udp://ipv4.tracker.harry.lu:80/announce
- udp://open.stealth.si:80/announce
- udp://9.rarbg.to:2900/announce
- udp://9.rarbg.me:2720/announce
- udp://opentor.org:2710/announce