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

P=13,00,000

R=10%

N=5MONTHS

COMPOUNTED QUERTLY

Posted on Apr 09, 2009

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

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

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

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

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

Try this: =IF(B13+(B13*B$7/12-B$10)<0,0,B13+(B13*B$7/12-B$10))

Jul 07, 2015 | Microsoft Excel for PC

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

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.

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

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

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

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

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

Oct 13, 2007 | Microsoft Office Standard for PC

1,664 people viewed this question

Usually answered in minutes!

×