Question about Microsoft Excel for PC

1 Answer

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.

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 4 Answers

Please see attached image.

The formula in C3 is =C2+((C2*(A3/100))/365). This is replicated down the spreadsheet.
compounding interest calculation - 2526d11.jpg Obviously you would have to put in the daily interest rate.

Hope this helps

Posted on Jul 22, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

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

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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

1 Answer

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

2 Answers

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

1 Answer

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

4 Answers

I want the excel compound interest formula


=10000*(1+0.96)^12
=10000*(1+0.10)^18
=10000*(1+0.10)^24

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

1 Answer

Compound interest


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

Feb 16, 2008 | Sharp EL-531VB Calculator

Not finding what you are looking for?
Microsoft Excel for PC Logo

186 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18346 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...