Question about Microsoft Office Professional 2007 Full Version for PC

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/-**

Ad

P=13,00,000

R=10%

N=5MONTHS

COMPOUNTED QUERTLY

Posted on Apr 09, 2009

Ad

=+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

Ad

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

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

Banks and Non-Banking Financial Companies use the following formula to calculate EMI of a home loan. This is the formula for calculating compound interest. Applying the same formula for a home loan of Rs 90Lakhs, we get,

EMI = [P x R x (1+R)^N]/[(1+R)^N-1]

Where,

P= Amount borrowed- Here, it will be 90 lakhs

R= Rate of interest per month

N= Number of months in the home loan tenure

Going by the current lending rates followed by the financial institutions, we will consider R to be 9% per annum (to be converted to % per month) and for the loan tenure, we will take 20 years/240 months.

Substituting all values in the above formula, the home loan EMI comes out to be Rs 80,975 per month.

You can easily calculate the EMI for your home loan for any bank or NBFC using a free online Home Loan EMI calculator. You can also find this handy tool on the online portals of most banks and NBFCs. All you have to do is feed in the values in the respective fields and receive the answers.

EMI = [P x R x (1+R)^N]/[(1+R)^N-1]

Where,

P= Amount borrowed- Here, it will be 90 lakhs

R= Rate of interest per month

N= Number of months in the home loan tenure

Going by the current lending rates followed by the financial institutions, we will consider R to be 9% per annum (to be converted to % per month) and for the loan tenure, we will take 20 years/240 months.

Substituting all values in the above formula, the home loan EMI comes out to be Rs 80,975 per month.

You can easily calculate the EMI for your home loan for any bank or NBFC using a free online Home Loan EMI calculator. You can also find this handy tool on the online portals of most banks and NBFCs. All you have to do is feed in the values in the respective fields and receive the answers.

Oct 09, 2017 | The Office Equipment & Supplies

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

It becomes part of the new principal. The new principal is equal to the old principal + interest for the period.

As an example:

Principal $100

Interest Rate 10% compounded annually

Opening Closing

Balance Interest Balance

100 10 110

110 11 121

121 12.10 133.10

Good luck.

Paul

As an example:

Principal $100

Interest Rate 10% compounded annually

Opening Closing

Balance Interest Balance

100 10 110

110 11 121

121 12.10 133.10

Good luck.

Paul

Mar 22, 2015 | Office Equipment & Supplies

A=P(1+i)^n, where P is the Principal, i is the interest rate per period, and n is the number of periods.

A=10,000(1+0.075)^3, assuming the interest is compounded annually

For 30 years, we would replace the number of period 3 with a 30.

Good luck,

Paul

A=10,000(1+0.075)^3, assuming the interest is compounded annually

For 30 years, we would replace the number of period 3 with a 30.

Good luck,

Paul

Apr 05, 2014 | Texas Instruments TI 30XIIS Scientific...

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

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

Yes you can use it, here is the formula: Y= V(t+ (i/c))^(tc) V=amount put in, t=time, i=intrest rate, c= amount of times it is compounded.

(I know this because I have a TI-83 calculator)

(I know this because I have a TI-83 calculator)

Mar 27, 2009 | Texas Instruments TI-83+ Graphing...

after 3 years u wil get rs 43692..

Aug 29, 2008 | Office Equipment & Supplies

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

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

Jul 22, 2008 | Microsoft Excel for PC

If this is the same manual that you have already ... then apologies!

http://education.ti.com/educationportal/downloadcenter/SoftwareDetail.do?website=US&appId=6115&tabId=2

http://education.ti.com/educationportal/downloadcenter/SoftwareDetail.do?website=US&appId=6115&tabId=2

Apr 13, 2008 | Video Game Consoles & Games

1,713 people viewed this question

Usually answered in minutes!

×