Calculating Loan Outstanding Balance Using Present Value Method

Overview of Loan Outstanding Balance Calculation

This lesson focuses on calculating the outstanding balance of a loan using the Present Value (PV) method. It highlights the difference between the Present Value and Future Value methods and emphasizes that this guide is specific to the PV approach.

Key Concepts

  • Loan Amount: The principal amount borrowed (e.g., 100,000 Rand).
  • Interest Rate: Annual interest rate converted to a monthly rate (16% annually = 0.016/12 monthly).
  • Loan Term: Total repayment period in months (5 years × 12 = 60 months).
  • Monthly Payment: The fixed amount paid monthly to repay the loan.

Step 1: Calculate the Monthly Payment

  • Use the Present Value formula for an annuity: [ PV = PMT \times \frac{1 - (1 + i)^{-n}}{i} ] where:

    • PV = loan amount (100,000 Rand)
    • PMT = monthly payment (unknown)
    • i = monthly interest rate (0.016/12)
    • n = total number of payments (60)
  • Rearrange the formula to solve for PMT.

  • Avoid rounding intermediate calculations to maintain accuracy.

  • Using a financial calculator or spreadsheet, the monthly payment is approximately 2,431.81 Rand.

Step 2: Calculate the Outstanding Balance After 2 Years

  • The outstanding balance is the present value of the remaining payments.

  • After 2 years (24 payments), the remaining term is 3 years (36 payments).

  • Use the Present Value formula again with:

    • PMT = 2,431.81 Rand
    • i = 0.016/12
    • n = 36 (remaining payments)
  • The outstanding balance is approximately 69,169.94 Rand.

Important Notes

  • The number of payments (n) in the outstanding balance formula refers to the remaining payments, not the payments already made.
  • The Present Value method calculates how much the borrower still owes at a given point in time.
  • Some students prefer the Future Value method, but this lesson focuses solely on the Present Value approach.

Summary

By applying the Present Value method, you can accurately determine both the monthly payment required to repay a loan and the outstanding balance after a certain period. This method is essential for understanding loan amortization and managing repayments effectively.

For further reading on related financial concepts, check out our guides on Understanding Bank Balance Sheets: A Comprehensive Guide to T-Accounts and Comprehensive Overview of Financial Management and Capital Budgeting Techniques. Additionally, if you're interested in the mathematical principles behind these calculations, you may find Understanding Averages, Ratios, and Proportions in Mathematics helpful.

Keep this summary

Save it to LunaNotes and it becomes a real note in your library — editable, searchable, and ready to turn into flashcards or a diagram. Free to start.

Save to LunaNotes

Or summarise for another video.

This summary and transcript were automatically generated using AI with the Free YouTube Transcript Summary Tool by LunaNotes.

Related summaries

Calculating Compound Interest and Depreciation Using Finance Solver

Calculating Compound Interest and Depreciation Using Finance Solver

Learn how to calculate the future value of an investment with compound interest and determine the annual depreciation rate of an asset using finance solver and formulas. This guide covers step-by-step methods for solving these financial problems accurately.

Calculating Retirement Savings and Monthly Contributions Using Finance Solver

Calculating Retirement Savings and Monthly Contributions Using Finance Solver

This guide explains how to calculate the lump sum needed at retirement and the monthly savings required to meet retirement goals using finance solver parameters. It covers key concepts like payment per period, compounding periods, and total payments over time with a practical example.

Understanding Bank Balance Sheets: A Comprehensive Guide to T-Accounts

Understanding Bank Balance Sheets: A Comprehensive Guide to T-Accounts

In this video, Mr. Willis demystifies bank balance sheets, also known as T-accounts, explaining how banks manage deposits, reserves, and loans. He provides clear examples and tips to help students master the concept of fractional reserve banking and understand the relationship between assets and liabilities.

Basis of Accounting Class 11: Cash vs Accrual Explained

Basis of Accounting Class 11: Cash vs Accrual Explained

Master the key concepts of Chapter 4, 'Basis of Accounting,' for Class 11 Accountancy. This video clearly explains the difference between Cash Basis and Accrual Basis of accounting with practical examples and exam-focused problem-solving, helping you understand when to recognize income and expenses.

Comprehensive Bank Loan Data Analyst Portfolio Project Tutorial

Comprehensive Bank Loan Data Analyst Portfolio Project Tutorial

Explore a detailed bank loan report project in the financial domain, covering data import from MSSQL Server, SQL query validation, and advanced Power BI dashboard creation with dynamic KPIs and interactive filters. Learn step-by-step how to build, validate, and visualize key business insights for real-time banking analytics and data analyst portfolio enhancement.

Found this summary useful?

Take it with you. One click puts it in your own LunaNotes library.

Save to LunaNotes

Start taking better notes today with LunaNotes