Project I am working on has the following:

Base Rate, Opt Yr 1, Opt Yr 2, Opt Yr 3, Opt Yr 4.

I need each Opt Yr to calculate Base Rate + 5%, However, I have 40 rows to do this for. Can I create a formula outside the cells I am using that will automatically calculate each time I put a base rate in a cell instead of having to create a formula for each and every cell in every row? I know it is possible but I cannot remember how to do it and I was stumped when creating the formula. I believe I am missing something. Please help, project due soon!

Ad

Yes you can create the formula outside the cell or you can create it one time and copy it down to the other cells. That way it will populate once it is used.

The formula should be Base Rate * .05 to get the result then add the result back to the base rate.

Posted on Dec 18, 2008

Ad

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.

Good luck!

Posted on Jan 02, 2017

Ad

Every borrower can calculate your loan EMI with three methods -

**1. Formula Based:**you can calculate your loan EMI with the help of given formula-

E = P x r x (1+r)n / ((1+r)n - 1)

where,

E = Each month payable EMI

P = Principal loan amount

r = Rate of interest

n = Duration of the loan

**2. Excel Based:**

You can also calculate your loan EMI with the help of excel sheet. But before calculating loan EMI, you need to set the above formula in excel sheet.

**3.Online EMI calculator:**

You can calculate your loan EMI with the help of online business loan EMI calculator . EMI calculators can calculate your loan EMI very easily without any cost.

E = P x r x (1+r)n / ((1+r)n - 1)

where,

E = Each month payable EMI

P = Principal loan amount

r = Rate of interest

n = Duration of the loan

Feb 21, 2018 | The Computers & Internet

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

Hi Mohammed,

You would have to calculate the net cash flow for each year in a projection. Then simply deduct the net cash flow from Yr 1, Yr 2, Yr 3, etc. until you're left with only a partial year. Then you add the same of years (e.g. 4 years) to the quotient of the following:

remaining capex costs / net cash flow in the following year (e.g. Yr 5 if the first part was completed in 4 years).

You would have to calculate the net cash flow for each year in a projection. Then simply deduct the net cash flow from Yr 1, Yr 2, Yr 3, etc. until you're left with only a partial year. Then you add the same of years (e.g. 4 years) to the quotient of the following:

remaining capex costs / net cash flow in the following year (e.g. Yr 5 if the first part was completed in 4 years).

Apr 27, 2014 | Finance

Here is to get you started. To increase the size of the image do a CTRL Plus (+) in your browser.

You need to calculate the slant height of the pyramid for the formula of the lateral area. You should find a value of** (1/2)*SQRT(203) **or about 7.1239 cm

You need to calculate the altitude (height) of the pyramid from the apex (summit) to the center of the base triangle (center of inscribed circle, barycenter, orthocenter). The hypotenuse of such triangle is the slant height. One leg is the altitude (to be found),**the measure of the second leg is (1/3) the altitude** **of the equilateral triangle** that forms the base. You should find (1/3) m MH= (1/3)* **(11/2)*SQRT(3)**

1. Calculate the area of the base (use a formula for the equilateral triangle or the general formula for a triangle: you have its height MH ).

2. Lateral area = 3 times the area of triangle Triangle ECD (in yellow above).

3. Total area = area of base + lateral area.

4. Volume= (1/3)(Area of base)* (height of pyramid)

If you can see the details on the screen capture below, fine, Press CTRL + in your browser to increase the size.

You need to calculate the slant height of the pyramid for the formula of the lateral area. You should find a value of

You need to calculate the altitude (height) of the pyramid from the apex (summit) to the center of the base triangle (center of inscribed circle, barycenter, orthocenter). The hypotenuse of such triangle is the slant height. One leg is the altitude (to be found),

1. Calculate the area of the base (use a formula for the equilateral triangle or the general formula for a triangle: you have its height MH ).

2. Lateral area = 3 times the area of triangle Triangle ECD (in yellow above).

3. Total area = area of base + lateral area.

4. Volume= (1/3)(Area of base)* (height of pyramid)

If you can see the details on the screen capture below, fine, Press CTRL + in your browser to increase the size.

Mar 29, 2014 | Office Equipment & Supplies

All triangles have three sides.

There are two main formulas that do not call on trigonometric ratios.

**The classic one**:

*Heron's Formula *if you have the length of the three sides. Let those measures be **a, b,** and** c**.

There are two main formulas that do not call on trigonometric ratios.

- 1. You need the length of a base and it corresponding height (the length of the segment perpendicular to that base and passing through the vertex (summit) opposite to that base.
**Area=(1/2) * (measure of the base)*(measure of the height).**The base and height must be expressed in the same unit.

- Calculate the semi-perimeter p with
**p=(1/2)(a+b+c)** - Area=Square root of
**(p*(p-a)*(p-b)*(p-c))** **a, b, and c must be expressed in the same unit.**

May 21, 2011 | Casio FX82ES Scientific Calculator

Pressing 2 0 0 LN = will give you the natural logarithm of 200. If you need the common (base 10) logarithm, divide the result by the log of 10.

( 2 0 0 LN ) / ( 1 0 LN ) =

will give you the common log of 200.

( 2 0 0 LN ) / ( 1 0 LN ) =

will give you the common log of 200.

Jan 05, 2011 | Texas Instruments BA-II Plus Calculator

rind the exchange rate, perhaps at a site such as:

http://www.x-rates.com/

so, for example, 1 euro is apparently worth 1.4765 US$ at the moment.

if you have 13.82 US$ divide by 1.4765 to get 9.36 euro.

if you had 32.00 euro then multiply by 1.4765 to come up with 47.25 US$

http://www.x-rates.com/

so, for example, 1 euro is apparently worth 1.4765 US$ at the moment.

if you have 13.82 US$ divide by 1.4765 to get 9.36 euro.

if you had 32.00 euro then multiply by 1.4765 to come up with 47.25 US$

Oct 13, 2009 | Casio Office Equipment & Supplies

you need the change of base formula:

log base b of m is ln m / ln b

So- to find log base 2 of 8, simply find ln8/ln2

(from Wikipedia - the proof also follows if you want to go look it up)

While there are several useful identities, the most important for calculator use lets one find logarithms with bases other than those built into the calculator (usually log*e* and log10). To find a logarithm with base *b*, using any other base *k*:

log base b of m is ln m / ln b

So- to find log base 2 of 8, simply find ln8/ln2

(from Wikipedia - the proof also follows if you want to go look it up)

While there are several useful identities, the most important for calculator use lets one find logarithms with bases other than those built into the calculator (usually log

Oct 06, 2009 | Casio FX-300MS Calculator

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

Following formula we can use.

S=P(1+RT)

WHERE S =INVEST AMOUNT+PROFIT

P=INVEST AMOUNT

R= RATE OF RETURN

T=TIME IN YEARS

EX : (300+x) = x(1+(5.4/100)*1)

(300+x)*100 = 105.4x

x=30000/5.4

x=5555. 4

S=P(1+RT)

WHERE S =INVEST AMOUNT+PROFIT

P=INVEST AMOUNT

R= RATE OF RETURN

T=TIME IN YEARS

EX : (300+x) = x(1+(5.4/100)*1)

(300+x)*100 = 105.4x

x=30000/5.4

x=5555. 4

Jan 05, 2008 | The Learning Company Achieve! Math &...

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

116 people viewed this question

Usually answered in minutes!

I still think my formula is wrong.

=SUM(BaseRate*.05)(Opt Yr 1)

How do I get the formula outside the cell to populate for all 4 columns? I know there is a simple way of doing it but I am not getting it correct.

I get ######

how to calculate pf?

×