Question about Microsoft Office Professional 2007 Full Version for PC

4 Answers

I want the excel compound interest formula

I want the excel compound intrest formula regarding this
TERM
INTEREST RATE P.A.
Rs.10,000/- will become (cumulative option)
1 YEAR
9.60%
Rs. 10,983/-
18 MONTHS
10.00%
Rs. 11,576/-
2 YEARS
10.00%
Rs. 12.155/-

Posted by on

4 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

P=13,00,000
R=10%
N=5MONTHS
COMPOUNTED QUERTLY

Posted on Apr 09, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

=+A3*(1+B3/2)^(C3*2)

this is the formula for comopound interest
heear A3= Amount Deposited
B3=Percentage
C3= No of year

this is for half yearly compound intrest....

Posted on Dec 03, 2008

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

Posted on Dec 03, 2008

  • Glove20 Dec 03, 2008

    Apologies, previous forumla was incorrect



    =10000*(1+0.096)^1
    =10000*(1+0.10)^1.5
    =10000*(1+0.10)^2

×

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

I am trying to figure out a formula for calculating "daily compounded interest" which the rate is adjusted quarterly.

I have set up a spreadsheet in excel, but I have to go into each cell and adj the formula..??

Any suggestions..??

Bern

Posted on Dec 24, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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 | Business & Productivity Software

2 Answers

Should I take out a student loan from a bank or a credit union?


Credit union. Credit unions offer low interest rates and a variety of outstanding borrower benefits but you should be a members. Unity One Credit Union in Texas (Unity One Student Loans) was my choice.

Apr 25, 2016 | Business & Productivity Software

1 Answer

Can I Regularly Draw Down A Business Loan With A Fixed Interest Rate?


A business loan with a variable rate would better suit this purpose. You can't add to the principal balance of a business loan with a set fee at some point of the fixed interest rate term. If multiple drawing is required while the rate is set for a time frame, break costs may be charged.

Apr 21, 2016 | Business & Productivity Software

1 Answer

Can I Modify My Payment Schedule On The Business Loan Having A Fixed Interest Rate?


You are able to switch to a principal and interest amortizing facility in order to a pursuit-in-advance facility in the finish of the fixed rate of interest term. When the payment type is transformed throughout the fixed rate of interest term, break costs might be incurred.

Jun 02, 2015 | The Business & Productivity Software

1 Answer

Excel 2007


The IRR function is provided by Excel so you can calculate an internal rate of return for a series of values. The IRR is the interest rate accrued on an investment consisting of payments and income that occur at the same regular periods. In the values provided to the function, you enter payments you make as negative values and income you receive as positive values.
For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest $50,000, and you expect to receive $10,000 in the first year, $17,500 in the second year, $25,000 in the third, and $30,000 in the fourth.
Since the $50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:
=IRR(D4:D8)
The function returns an IRR of 19.49%.
The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:
=IRR(D4:D8, -5%)
This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.

Jun 09, 2010 | Microsoft Office Professional 2007 Full...

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

1 Answer

Compounding interest calculation


Please see attached image.

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

Hope this helps

Jul 22, 2008 | Microsoft Excel for PC

1 Answer

Emi using excel


The function in Excel for calculating EMI is not EMI but PMT. It requires minimum three arguments. They are 1. Rate of interest (Rate), 2. Number of periods (Nper) and 3. Value of loan or present value (Pv) in that order, that is, PMT (Rate, Nper, Pv) If you want to find EMI for 1 lakh at 10% annual interest for 10 years you enter the following in one of the cells: = pmt(10%/12, 10*12, 100000)

Borrowed from http://www.hindu.com/pp/2004/02/28/stories/2004022800160500.htm

Oct 13, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

1,664 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...