Question about Microsoft Excel for PC

# Compounding interest calculation

Hi,

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

Chintan Mehta

Posted by on

• chintanmehta Jul 22, 2008

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

×

• Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

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

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.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How to calculate interest on fixed deposit if tenor is 3 years?

principle X interest rate X term
deposit by interest rate by the length of the term

Jul 28, 2016 | investopedia.com

### How much is intereston 1 varable 2 fixed rate

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

May 09, 2016 | Computers & Internet

### How do you calculate and charge interest on outstanding accounts

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.

Jul 14, 2014 | Office Equipment & Supplies

### Compound interest

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

Nov 18, 2013 | Computers & Internet

### What is compounded interest in a personal savings account?

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

### I cannot get the textbook answer (online calculators are also the same as textbook answer) using my sharp calculator EL738: Monthly payment for \$184,500 at 6.75% interest semi annually, for 5 year term...

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.

Feb 22, 2011 | Sharp EL-738 Scientific Calculator

### Bank process in daily interest calculation

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

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

### Need a formulae for 'Interest calculation' for 'Over-draft loan'

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

### Compound interest

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

Feb 16, 2008 | Sharp EL-531VB Calculator

#### Related Topics:

210 people viewed this question

Level 3 Expert

Level 3 Expert

Level 3 Expert