Functions Continuation
Statistical Functions
1. AVERAGE(): It calculates the average of Example:=AVERAGE(A1:A10)
2. COUNT():Counts the number of non blank numeric cells in a list
Example=COUNT(12,13,15) returns 3
3. MAX()- Finds out the maximum value in a list of values Example. MAX (34,56,12) returns
56.
4. MIN()- Find out the minimum value in a list of values Example. MIN(34,56,12)returns 12..
Financial Functions
Financial Functions allows us to calculate loans, depreciation, cash flow.
1.RATE ()-- This function can be used to calculate the interest rate charged to pay off a loan.
Syntax :=RATE(nper, pmt, pv, fv, type, guess)
Where nper is the total number of payment periods, Pmt is the payment made each period, pv
is the present value of the total amount, fv is the future value at the end of the last payment,
type is the number 0 and 1 It indicates when payments are due. If type is omitted or 0 it means
that payment are made at the end of period, used, use 1 for type. Guess is your guess for what
the rate may be. If you do not use guess in the function, Excel assumes that guess to be 10%.
While using the RATE function, the first three arguments ie npr, pmt, fv are compulsory
For example:=RATE(48,-3000,100000)returns 2%
2.FV () - This function returns the future value of an investment based on periodic, constant
payments and a constant interest rate.
Syntax FV (rate, nper, pmt, pv, type)
Where rate is the periodic rate of interest.
For example, you want to save some money for purchasing a scooter after two years. You open
a special deposit account where you deposit Rs. 1000 at the beginning of every month. The
bank pays 12% annual rate that is compounded every month. (In other words, the monthly rate
of interest is 12%/12,i. e. 1% per month ). To find out how much money will be in account at the
end of 24 months, we can use FV function.
Rate 0.12/12
Nper 24
Pmt -1000
Pv 0
Type 1
Enter=FV(12%12,24,-1000,0,1)in a cell
Excel displays 27,243.20 as the result. i. e. you would have Rs. 27,243.20 in your account after
24 months.
Statistical Functions
1. AVERAGE(): It calculates the average of Example:=AVERAGE(A1:A10)
2. COUNT():Counts the number of non blank numeric cells in a list
Example=COUNT(12,13,15) returns 3
3. MAX()- Finds out the maximum value in a list of values Example. MAX (34,56,12) returns
56.
4. MIN()- Find out the minimum value in a list of values Example. MIN(34,56,12)returns 12..
Financial Functions
Financial Functions allows us to calculate loans, depreciation, cash flow.
1.RATE ()-- This function can be used to calculate the interest rate charged to pay off a loan.
Syntax :=RATE(nper, pmt, pv, fv, type, guess)
Where nper is the total number of payment periods, Pmt is the payment made each period, pv
is the present value of the total amount, fv is the future value at the end of the last payment,
type is the number 0 and 1 It indicates when payments are due. If type is omitted or 0 it means
that payment are made at the end of period, used, use 1 for type. Guess is your guess for what
the rate may be. If you do not use guess in the function, Excel assumes that guess to be 10%.
While using the RATE function, the first three arguments ie npr, pmt, fv are compulsory
For example:=RATE(48,-3000,100000)returns 2%
2.FV () - This function returns the future value of an investment based on periodic, constant
payments and a constant interest rate.
Syntax FV (rate, nper, pmt, pv, type)
Where rate is the periodic rate of interest.
For example, you want to save some money for purchasing a scooter after two years. You open
a special deposit account where you deposit Rs. 1000 at the beginning of every month. The
bank pays 12% annual rate that is compounded every month. (In other words, the monthly rate
of interest is 12%/12,i. e. 1% per month ). To find out how much money will be in account at the
end of 24 months, we can use FV function.
Rate 0.12/12
Nper 24
Pmt -1000
Pv 0
Type 1
Enter=FV(12%12,24,-1000,0,1)in a cell
Excel displays 27,243.20 as the result. i. e. you would have Rs. 27,243.20 in your account after
24 months.
