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

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 to Calculate NPV?


NPV stands for Net Present Value. Using this scientific calculator, you must utilize a formula to calculate net present value.

For example, if we want to find out what the net present value of $10,000 is using a 4% annual interest rate for 10 years. In other words, what amount do we have to invest today for 10 years assuming we get a 4% annual interest rate.

NPV=10,000(1+0.04)^-10

To do the exponent, use the ^ key.

Good luck.

Paul

Feb 26, 2016 | Texas Instruments Ti 30x Iis Scientific...

1 Answer

When interest is compounded why does the accrued amount not become the principal aount for the next period of time


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

Mar 22, 2015 | Office Equipment & Supplies

1 Answer

An original investment of 10,000 earns 7.50% interest compound continously, What will the investment be worth in 3 years? 30 years?


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

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

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

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

2 Answers

TI 83


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)

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

1 Answer

COMPOUND INTEREST CUMULATIVE AMOUNT


after 3 years u wil get rs 43692..

Aug 29, 2008 | Office Equipment & Supplies

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

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

1,702 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

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

Answer questions

Manuals & User Guides

Loading...