Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

## Loan Principal Amount Definition

Loan Principal refers to the outstanding loan amount that a borrower is required to pay to the lender (mostly banks, non-banking finance companies or other similar financial institutions) when the loan payment becomes due. It is to be noted that the outstanding loan amount does not include the interest that is being charged on the loan principal amount. However, the lender uses the outstanding loan principal to calculate the interest expense for the period.

In short, this principle is the amount that the borrower owes to the lender, not including interest, at any point in time during the life of the loan.

### Steps to Calculate Loan Principal Amount

In the case of EMI, the outstanding loan principal at any point in time can be simply calculated by using the following steps

**Step #1:** Firstly, the opening loan amount has to be determined.

**Step #2:** Next, the rate of interest to be charged on the loan during the period (say annually) has to be figured out.

**Step #3:** Now, the interest payment for the month can be calculated by multiplying the rate of interest with the opening loan amount and then dividing the result by 12 (since ** r** is the annualized interest rate) as shown below.

**Interest payment = Opening loan amount * Rate of interest /12**

**Step #4:** Now, EMI of the loan has to be determined based on the available information.

**Step #5:** Now, the principal repayment can be calculated by subtracting the interest payment in step 3 from the EMI in step 4 as shown below.

**Principal repayment = EMI – Interest payment**

**Step #6:** Finally, an outstanding principal at the end of the month can be a calculation by deducting the principal repayment from the opening loan amount as shown below.

4.9 (927 ratings)

**Outstanding principal = Opening loan amount – Principal repayment**

which can be further expanded as below,

**Outstanding principal = Opening loan amount – (EMI – Interest payment)**

**Outstanding principal = Opening loan amount + Interest payment – EMI**

### Examples of Loan Principal Amount

Let’s understand this concept with the help of an example

#### Example #1

**Let us take the example of company ABC Co. Ltd which is a gym facility located in the city of California. The company took a 2-year loan of $200,000 last month to fund its ongoing expansion plans. The CEO of the company asked the accountant to calculate the outstanding loan principal amount after the first monthly payment of $8,864.12 is made. The bank charges an interest rate of 6%. Determine the outstanding principal for the accountant after the first payment.**

As per the question,

Interest paid in the month = Loan amount * Rate of interest / 12

**= $1,000.00**

Principal repaid in the first month = EMI – Interest payment

**= $7,864.12**

Outstanding principal after first payment = Loan amount – Principal repaid

**= $192.135.88**

Therefore, after the first monthly payment, the outstanding loan principal amount is $192.135.88.

#### Example #2

**Let us take the example of company XYZ Ltd which has taken a one year loan of $1,000,000 for setting up a new tool manufacturing unit in the town. Now, an analyst intends to check the impact of the rate of interest on the outstanding principal after the first monthly payment. Help the analyst determine the principal based on the following information:**

As per the question,

The bank charges an interest rate of 5% and a monthly payment of $85,607.48

Interest paid in the month = Loan amount * Rate of interest / 12

** = $4,166.67**

Principal repaid in the first month = EMI – Interest payment

** = $81,440.81**

Outstanding loan principal calculation amount after first payment = Loan amount – Principal repaid

**= $918,559.19**

The bank charges an interest rate of 10% and a monthly payment of $87,915.89

Interest paid in the month = Loan amount * Rate of interest / 12

**= $8,333.33**

Principal repaid in the first month = EMI – Interest payment

**= $79,582.56**

Outstanding loan principal calculation after first payment = Loan amount – Principal repaid

** = $920,417.44**

Therefore, it can be seen that the outstanding loan principal amount increases with the rate of interest being charged.

### Relevance and Use

From the point of view of a borrower, it is very important to understand the underlying concept of principal because during the life of the loan the interest is charged based on the outstanding principal amount. In today’s financial setup, most of the bank loan repayment is characterized by EMI that includes both the interest payment and the principal repayment. As such, the borrower should be cognizant of the fact that the money that goes into the payment of EMI doesn’t actually reduce the principal entirely because a portion of it pays off the interest charged. The portion of principal repayment is low in the initial EMI payments; however, it increases gradually over the period of time until the maturity of the loan.

On the other hand, this is also important from the point of view of a banker since based on the outstanding loan principal amount a banker also has to manage its own liability. It means that a banker also needs to finance the outstanding principal amount by raising deposits from its customers. Besides, the interest income is calculated based on the principal and it is the major source of income for a bank. Therefore, it can be seen that the principal is significant information for both borrower and lender.

### Recommended Articles

This has been a guide to what is Loan Principal and its definition. Here we discuss the steps to calculate the Loan Principal amount along with practical examples. You can learn more about from the following articles –

- Loan vs Lease | Infographics
- Disadvantages of LIFO Liquidation
- Secured Loans – Explain
- Non-Performing Assets Meaning
- Loan Amortization Schedule in Excel
- What is Time Value of Money Formula?

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced