Hi,

Can you help me with the calculation of Interest on compounding basis with the daily change in the rates

Chintan Mehta

Ad

Please see attached image.

The formula in C3 is =C2+((C2*(A3/100))/365). This is replicated down the spreadsheet.

Obviously you would have to put in the daily interest rate.

Hope this helps

Posted on Jul 22, 2008

Ad

Hi,

a 6ya Technician can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

principle X interest rate X term

deposit by interest rate by the length of the term

deposit by interest rate by the length of the term

Jul 28, 2016 | investopedia.com

interest is interest

fixed is calculated yearly on the principle and is paid 365 days time

variable changes and is calculated daily ( 1/365 part of the interest rate ) and added to the remaining principle monthly

so if you have a loan of $1000.00 on fixed interest of 10% , regardless of how much you have repaid in a 12 month period , it is 10% of the principle loaned

with a variable interest the interest rate could be 10% today, 15% in 2 months time or 6% later on

it is variable

to add to that it is calculated on a daily basis (1/365 of 10%) and added to the principle left after receiving a payment on the loan

so for a $1000.00 the interest is added to that principle at the end of the month if there is no loan repayment or is added to the principle balance after a payment

the difference is that a variable interest rate loan will allow you to save money if you pay off well before the period of the loan but will add almost 2 to 3 times the loan if you pay the absolute minimum for the period of the loan

a fixed rate is where you know exactly the total interest to be paid at the end of term

fixed is calculated yearly on the principle and is paid 365 days time

variable changes and is calculated daily ( 1/365 part of the interest rate ) and added to the remaining principle monthly

so if you have a loan of $1000.00 on fixed interest of 10% , regardless of how much you have repaid in a 12 month period , it is 10% of the principle loaned

with a variable interest the interest rate could be 10% today, 15% in 2 months time or 6% later on

it is variable

to add to that it is calculated on a daily basis (1/365 of 10%) and added to the principle left after receiving a payment on the loan

so for a $1000.00 the interest is added to that principle at the end of the month if there is no loan repayment or is added to the principle balance after a payment

the difference is that a variable interest rate loan will allow you to save money if you pay off well before the period of the loan but will add almost 2 to 3 times the loan if you pay the absolute minimum for the period of the loan

a fixed rate is where you know exactly the total interest to be paid at the end of term

May 09, 2016 | Computers & Internet

That question is much more complicated than you think - are you charging interest percentage daily? Weekly? Monthly? Anually? Once you have the period figured, you begin at some start point of your choosing. Exactly one "period" later, you multiply the basis (the outstanding balance) by the percentage rate (5%, for example, would mean you multiply by 0.05), then add that number to the basis - that's your new basis, your new outstanding balance.

But... if you charge an annual interest rate, and you compound daily or weekly or monthly, you have to take payments into account and adjust for them - it's fair to charge interest up to the moment of payment, but not beyond that moment; you can rightly only charge interest on the remaining unpaid balance beyond that date.

If you charge an annual interest rate but compound monthly, then every month you'd charge 1/12 of your annual interest rate. If weekly, 1/52. If daily, 1/365. The smaller the compounding period, the easier it is to calculate interest around payments, but the more paperwork is involved.

But... if you charge an annual interest rate, and you compound daily or weekly or monthly, you have to take payments into account and adjust for them - it's fair to charge interest up to the moment of payment, but not beyond that moment; you can rightly only charge interest on the remaining unpaid balance beyond that date.

If you charge an annual interest rate but compound monthly, then every month you'd charge 1/12 of your annual interest rate. If weekly, 1/52. If daily, 1/365. The smaller the compounding period, the easier it is to calculate interest around payments, but the more paperwork is involved.

Jul 14, 2014 | Office Equipment & Supplies

Assuming the 28k is put in as one lump sum each year and that the interest is compounded annually, then after 15 years I calculate $453,329

You can use the following online calculator to make adjustments, check my calculations, modify any factors, etc...

http://www.bankrate.com/calculators/savings/compound-savings-calculator-tool.aspx

You can use the following online calculator to make adjustments, check my calculations, modify any factors, etc...

http://www.bankrate.com/calculators/savings/compound-savings-calculator-tool.aspx

Nov 18, 2013 | Computers & Internet

Compounded Interest is when the bank pays
you interest on the interest. For example, if your savings account earns interest of 1%, then each day of
that 1% of the amount of money you have in your savings account is added to
your total amount of money.

*Daily compounding = Principal (1 + interest rate/365)365 =
(daily compounded amount)*

Aug 14, 2013 | Finance

Your result is for the 6.75% interest compounded monthly. The problem states that the interest is compounded semiannually. This makes a difference in the effective interest rate.

A 6.75% APR compounded semiannually gives an effective interest rate of about 6.864%:

Press 2 , 6 . 7 5 2nd >EFF

Converting this to APR gives about 6.657%:

Press 1 2 , 6 . 8 6 4 2nd >APR

If you use 6.657 for the interest rate instead of 6.75 you should get the correct result.

A 6.75% APR compounded semiannually gives an effective interest rate of about 6.864%:

Press 2 , 6 . 7 5 2nd >EFF

Converting this to APR gives about 6.657%:

Press 1 2 , 6 . 8 6 4 2nd >APR

If you use 6.657 for the interest rate instead of 6.75 you should get the correct result.

Feb 22, 2011 | Sharp EL-738 Scientific Calculator

I want how i can calculate daily profit /loss calculation on investment

Sep 07, 2009 | Microsoft Step by Step Visual Basic 6.0...

Try this formula=((A1)*(1+A2))-A3
Where:
A1 is the original Balance
A2 is the interest rate
A3 is the money paid for the preceding month

Apr 02, 2009 | Microsoft Excel for PC

=10000*(1+0.96)^12

=10000*(1+0.10)^18

=10000*(1+0.10)^24

=10000*(1+0.10)^18

=10000*(1+0.10)^24

Dec 02, 2008 | Microsoft Office Professional 2007 Full...

http://www.sharpusa.com/files/cal_man_EL531_509.pdf.

Feb 16, 2008 | Sharp EL-531VB Calculator

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

210 people viewed this question

Usually answered in minutes!

Please give me the solution for the same in Excel worksheet.

×