All
Search
Images
Videos
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
exceljet.net
Calculate loan interest in given year
To calculate the total interest for a loan in a given year, you can use the CUMIPMT function. In the example shown, the total interest paid in year 1 is calculated by using 1 for the start period and 12 for the end period. The formula in F5 is: =CUMIPMT(5%/12,60,30000,1,12,0) Note: values are hardcoded for readability only.
Oct 26, 2022
Excel Formula Basics
12:29
Excel Formulas and Functions Tutorial
YouTube
Kevin Stratvert
3.8M views
Jul 13, 2019
26:39
[FREE Excel Course] Lesson 9 - Excel Formula Basics
YouTube
TrumpExcel
236.1K views
May 8, 2019
26:26
How to use Formulas and Functions in Microsoft Excel
YouTube
Teacher's Tech
425.4K views
Apr 19, 2021
Top videos
Calculate interest for given period
exceljet.net
Nov 1, 2022
Calculate interest rate for loan
exceljet.net
Oct 26, 2022
Calculate simple interest
exceljet.net
Oct 19, 2016
Excel Functions Tutorial
2:31:06
20 Excel Formulas and Functions to Master in 2024 - Excel Formulas and Functions Training Tutorial
YouTube
Simon Sez IT
138.5K views
Jan 17, 2024
11:43
Excel Formulas and Functions - Tutorial for Beginners (2025)
YouTube
Kevin Stratvert
73.1K views
3 months ago
14:03
Excel for Beginners: Master Formulas, Functions & Cell References
YouTube
Teacher's Tech
1.3K views
3 weeks ago
Calculate interest for given period
Nov 1, 2022
exceljet.net
Calculate interest rate for loan
Oct 26, 2022
exceljet.net
Calculate simple interest
Oct 19, 2016
exceljet.net
Calculate compound interest
Oct 26, 2022
exceljet.net
Calculate original loan amount
Oct 26, 2022
exceljet.net
Calculate Interest Payments on a Loan with the IPMT Function
606.8K views
Mar 19, 2024
wikiHow
Jack Lloyd
Calculate payment for a loan
Oct 26, 2022
exceljet.net
Calculate payment periods for loan
Oct 26, 2022
exceljet.net
Calculate Loan Payments in Excel & Google Sheets
Feb 7, 2023
automateexcel.com
Estimate mortgage payment
Oct 26, 2022
exceljet.net
The Power of Compound Interest: Calculations and Examples
3 months ago
investopedia.com
4:55
How to Calculate Loan Payments Using Excel's PMT Function
2.9K views
Oct 6, 2015
YouTube
Dr. Daniel Soper
3:27
Excel Finance Trick #4: PMT function & Balloon payment
39.4K views
May 13, 2008
YouTube
excelisfun
2:54
How To Calculate Interest On A Loan
115.9K views
Jul 16, 2015
YouTube
Loan Things
1:58
Excel Calculate Interest Only Monthly Mortgage Payment
46.2K views
Apr 29, 2011
YouTube
welcome2videos4us
5:41
Finance Basics 1 - Simple Interest in Excel
138.5K views
Nov 21, 2009
YouTube
TeachExcel
10:08
Compound Interest - Using Excel
4.6K views
Apr 21, 2019
YouTube
Cindy Roberts
5:22
Loan Amortization Calculator (Installed Excel Template)
55.8K views
Apr 23, 2012
YouTube
Alex C
3:34
Excel: Use =MOD() to Calculate Quarterly Interest Payments
14.7K views
May 2, 2017
YouTube
A Simple Model
6:08
Compound Interest Calculator In Excel - Calculate Savings Using F
…
72.2K views
Jan 19, 2021
YouTube
The Excel Hub
12:38
Interest calculation Microsoft excel Advance Formula
100.3K views
Jan 19, 2019
YouTube
C TECH
1:53
How to Calculate Loan Payment per month using PMT function in Exce
…
27.2K views
Feb 20, 2017
YouTube
Find Easy Solution
2:38
What's the Monthly Payment? Find loan payment amount - Excel PM
…
470.4K views
Jun 22, 2013
YouTube
Contextures Inc.
4:47
How to use the TODAY function in Excel to calculate late payments
137.3K views
Jul 9, 2012
YouTube
Aldo Mencaraglia
2:06
Microsoft Excel - Using the Solver for loan amortization
1.6K views
Mar 1, 2018
YouTube
Sierratrainer Videos
10:47
How To Calculate Loan Payments Using The PMT Function In Excel
504.2K views
Jun 19, 2018
YouTube
The Organic Chemistry Tutor
1:52
Calculating Loan Payoff in Excel | Knowledgecity.com
37.7K views
Mar 14, 2018
YouTube
KnowledgeCity
3:08
How to Use Excel PMT Function | Calculate Monthly Loan Payment
…
28.4K views
May 6, 2020
YouTube
Excel, Word and PowerPoint Tutorials from Ho…
10:38
Spreadsheets for Finance: How to Calculate Loan Payments
43.6K views
Feb 11, 2014
YouTube
Tuts+ Computer Skills
See more videos
More like this
Feedback