Interest calculated daily compounded monthly

  • Thread starter bradles
  • Start date
  • Tags
    Interest
In summary: I'm sure there must be a way to do it, but I'm just not sure how.Any ideas would be much appreciated!ThanksBradIn summary, the conversation discusses the process of calculating the time it would take to pay off a loan with daily compounded interest, while also making fortnightly repayments. The formula for calculating the interest is also mentioned, with the addition of a monthly interest rate. The participants are looking for an efficient way to calculate the time it would take to pay off a loan with these conditions.
  • #1
bradles
6
0
Does anyone know how I can work out a formula to calculate how long it will take to pay a loan back to zero if the interest is on a loan is calculated daily but compounded at the end of the month. To add another level of complexity, assume you are making fortnightly repayments.

P (Principal) = $500,000
E (Fortnightly Repayments) = $2,500
r (annual interest rate) = 8.59%
t (daily compound interest rate) = [tex]\frac {0.0859}{365}[/tex]

I started out with the following:

[tex] A_0 = P[/tex]

[tex] A_1_4 = P-E[/tex]

[tex] A_2_8 = P-2E[/tex]

[tex] A_3_0 = A_2_8 + 14(A_0 * t) + 14(A_1_4 * t) + 2(A_2_8 * t) [/tex]

[tex]= P - 2E + 14(Pt) + 14(Pt-Et) + 2(Pt-2Et)[/tex]

[tex]= P-2E+30Pt-18Et[/tex]



and continuing...

[tex]A_4_2 = A_3_0 - E = P-3E+30Pt-18Et[/tex]

[tex]A_5_6 = A_4_2 - E = P-4E+30Pt-18Et[/tex]

[tex]A_6_0 = A_5_6 + 12(A_3_0 * t) + 14(A_4_2 * t) + 4(A_5_6 * t)[/tex]


[tex]A_1_4[/tex] and [tex]A_2_8[/tex] is where I make repayments. [tex]A_3_0[/tex] is where the interest is finally compounded.

Am I heading in the right direction for this?

Can anyone enlighten me on the best way to go about solving this?
 
Mathematics news on Phys.org
  • #2
bradles said:
Does anyone know how I can work out a formula to calculate how long it will take to pay a loan back to zero if the interest is on a loan is calculated daily but compounded at the end of the month. To add another level of complexity, assume you are making fortnightly repayments.

P (Principal) = $500,000
E (Fortnightly Repayments) = $2,500
r (annual interest rate) = 8.59%
t (daily compound interest rate) = [tex]\frac {0.0859}{365}[/tex]
There is no reason to "calculate the interest daily" if you don't do anything with it! If the interest is being compounded monthly, then calculate it monthly: monthly interest is 0.0859/12= 0.00716.

I started out with the following:

[tex] A_0 = P[/tex]

[tex] A_1_4 = P-E[/tex]

[tex] A_2_8 = P-2E[/tex]

[tex] A_3_0 = A_2_8 + 14(A_0 * t) + 14(A_1_4 * t) + 2(A_2_8 * t) [/tex]

[tex]= P - 2E + 14(Pt) + 14(Pt-Et) + 2(Pt-2Et)[/tex]

[tex]= P-2E+30Pt-18Et[/tex]



and continuing...

[tex]A_4_2 = A_3_0 - E = P-3E+30Pt-18Et[/tex]

[tex]A_5_6 = A_4_2 - E = P-4E+30Pt-18Et[/tex]

[tex]A_6_0 = A_5_6 + 12(A_3_0 * t) + 14(A_4_2 * t) + 4(A_5_6 * t)[/tex]


[tex]A_1_4[/tex] and [tex]A_2_8[/tex] is where I make repayments. [tex]A_3_0[/tex] is where the interest is finally compounded.

Am I heading in the right direction for this?

Can anyone enlighten me on the best way to go about solving this?[/QUOTE]
I'm not sure I understand this. The interest is compounded monthly but how often are you paying on the loan?
 
  • #3
Let me explain. I will change from a straight 30 days being one month though...just to make things more complicated...sorry.

You start out with a loan of $500,000. Each day 8.59%/365 * $500,000 accrues in interest for 14 days until you make a payment of $2,500.

So the balance at day 14 is $500,000 - $2,500 = $497,500 (with $1647.39 in interest accrued so far).

For the next 14 days the loan accrues 8.59%/365 * $497,500 in interest. When you make a payment on day 28 the balance is $497,500 - $2,500 = $495,000 (with $1,639.16 interest accruing on the $497,500 for those 14 days).

Lets say that day also happened to be the compound date (the day the interest is actually charged and capitilised into the loan. The balance would be:

$495,000
+ $1,647.39 (interest accrued in the first 14 days)
+ $1,639.16 (interest accrued in the second 14 days)
------------------
$498,286.55

Then the cycle continues.

Banks here calculate interest daily and charge it to the loan on the 28th of each month. You can choose to make repayments monthly, fortnightly or weekly, however interest is still accrued daily and charged on the 28th of each month.

I was wondering if there is a way you could calculate things like what your repayments would need to be to pay off a loan of this type in "x" years. Or to work out how long it would take you to pay off a loan of "x" amount repaying "y" every fortnight. etc.

Hope that makes sense.

Brad
 
  • #4
Calculate the average daily balance. And use that as your principal for each month. Most credit card companies calculate interest this way.
 
  • #5
Now I see why you want to calculate the interest daily- the principle changes in the middle of the month.
But you can still do it "monthly". Since for half the month you owe $500000 and for half the month $497500 so for the entire month you owe an "average" of (500000+ 497500)/2= $498750. Calculating $498750*0.0859/12 will give you approximately what you have. "Approximately" because 28 days is not exactly one month.
 
  • #6
I'd like to try and develop a formula for it...but I'm not sure it's possible. I can simulate it on a spreadsheet but it requires a lot of data and it gets slow in the calculations.

I thought I could develop a formula to save all the number crunching.
 

FAQ: Interest calculated daily compounded monthly

What does "interest calculated daily compounded monthly" mean?

"Interest calculated daily compounded monthly" means that the interest on a loan or investment is calculated daily, but it is only added to the principal amount once a month. This means that the interest earned in a month is added to the principal amount and then the interest for the next month is calculated on the new total.

How is interest calculated daily compounded monthly?

The interest is calculated by dividing the annual interest rate by 365 (or 366 for leap years) to get the daily interest rate. This daily interest rate is then multiplied by the number of days in a month to get the total monthly interest. This monthly interest is then added to the principal amount, and the process repeats for the next month.

What are the benefits of daily compounding interest?

Daily compounding interest allows for faster growth of your investment because the interest is calculated and added to the principal more frequently. This means that the interest earned in a month will earn additional interest in the following months, compounding the growth of your investment.

Are there any disadvantages to daily compounding interest?

The main disadvantage of daily compounding interest is that it can be more difficult to calculate and understand compared to simpler interest calculation methods. It may also result in a slightly lower interest rate compared to interest calculated and compounded daily, but this difference is usually minimal.

How does daily compounding interest affect my overall interest earnings?

Daily compounding interest can have a significant impact on your overall interest earnings over time. It allows for a faster growth of your investment, resulting in higher earnings compared to simpler interest calculation methods. However, the actual impact will depend on the interest rate, the length of the investment, and the frequency of compounding.

Similar threads

Replies
1
Views
2K
Replies
2
Views
11K
Back
Top