How do I decide this total cost and how do I make a minimum estimate?

  • Context: MHB 
  • Thread starter Thread starter BTerry
  • Start date Start date
  • Tags Tags
    Estimate Minimum
Click For Summary
SUMMARY

The discussion focuses on calculating the total cost of a loan with a principal of $10,000, an interest rate of 10% compounded annually, over a period of five years. The formula derived for monthly payments (P) is P = (Ai(1+i)^n) / ((1+i)^n - 1), where A is the amount borrowed, i is the monthly interest rate, and n is the number of payments. The total cost is determined by subtracting the principal from the total amount paid back, represented as P*n - A. This method provides a clear approach to estimating loan repayment costs.

PREREQUISITES
  • Understanding of loan amortization concepts
  • Familiarity with compound interest calculations
  • Basic knowledge of recursive equations
  • Ability to manipulate algebraic expressions
NEXT STEPS
  • Research "Loan Amortization Schedules" for practical applications
  • Explore "Compound Interest Formulas" for different compounding periods
  • Learn about "Recursive Functions in Financial Calculations"
  • Study "Financial Modeling Techniques" for advanced loan analysis
USEFUL FOR

Finance professionals, loan officers, students studying finance, and anyone involved in personal or business loan calculations will benefit from this discussion.

BTerry
Messages
1
Reaction score
0
Principle: 10K
Interest: 10% compounded annually
Time: Over five years

What is the total cost of all of this factored in?

Could I get the formula so I can use it to apply to a real problem?
 
Physics news on Phys.org
Is this for a loan repayment? If so, consider the following, which can easily be changed to an annual payment:

Let $P$ = monthly payment, $A$ = amount borrowed, $i$ = monthly interest rate, and $n$ = the number of payments.

Also, let $D_n$ be the debt amount after payment $n$.

Consider the recursion:

(1) [math]D_{n}=(1+i)D_{n-1}-P[/math]

(2) [math]D_{n+1}=(1+i)D_{n}-P[/math]

Subtracting (1) from (2) yields the homogeneous recursion:

[math]D_{n+1}=(2+i)D_{n}-(1+i)D_{n-1}[/math]

whose associated auxiliary equation is:

[math]r^2-(2+i)r+(1+i)=0[/math]

[math](r-(1+i))(r-1)=0[/math]

Thus, the closed-form for our recursion is:

[math]D_n=k_1(1+i)^n+k_2[/math]

Using initial values, we may determine the coefficients $k_i$:

[math]D_0=k_1+k_2=A[/math]

[math]D_1=k_1(1+i)+k_2=(1+i)A-P[/math]

Solving this system, we find:

[math]k_1=\frac{Ai-P}{i},\,k_2=\frac{P}{i}[/math] and so we have:

[math]D_n=\left(\frac{Ai-P}{i} \right)(1+i)^n+\left(\frac{P}{i} \right)=\frac{(Ai-P)(1+i)^n+P}{i}[/math]

Now, equating this to zero, we can solve for $P$:

[math]\frac{(Ai-P)(1+i)^n+P}{i}=0[/math]

[math](Ai-P)(1+i)^n+P=0[/math]

[math](P-Ai)(1+i)^n=P[/math]

[math]P\left((1+i)^n-1 \right)=Ai(1+i)^n[/math]

[math]P=\frac{Ai(1+i)^n}{(1+i)^n-1}[/math]

[math]P=\frac{Ai}{1-(1+i)^{-n}}[/math]
 
After solving for P (as shown by Mark), the cost is simply: P*n - A

In other words: what you paid back less what you got.
 

Similar threads

  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 9 ·
Replies
9
Views
2K
  • · Replies 9 ·
Replies
9
Views
2K
  • · Replies 12 ·
Replies
12
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 4 ·
Replies
4
Views
6K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 1 ·
Replies
1
Views
1K