State the purpose for each of the following six built-in spreadsheet functions.
(a) PV(i%, n, A, F)
(b) FV(i%, n, A, P)
(c) RATE(n, A, P, F)
(d ) IRR(first_cell:last_cell)
(e) PMT(i%, n, P, F)
( f ) NPER(i%, A, P, F)
What will be an ideal response?
(a) PV(i%,n,A,F) finds the present value P
(b) FV(i%,n,A,P) finds the future value F
(c) RATE(n,A,P,F) finds the compound interest rate i
(d) IRR(first_cell:last_cell) finds the compound interest rate i
(e) PMT(i%,n,P,F) finds the equal periodic payment A
(f) NPER(i%,A,P,F) finds the number of periods n
You might also like to view...
Which type of insulation is made of asbestos paper in alternate smooth and corrugated layers?
a. formed fibrous b. blanket c. foam d. corrugated
When using a transmission _____ on a car that is on a frame-contact lift, be careful not to raise the car off the lift pads as you raise the transmission.
What will be an ideal response?
The blower will run at full speed when __________ is applied to the motor
A) 12 volts B) Resisted volts C) 6 volts through a resistor D) None of these
When selecting a welding method and filler wire or electrode to repair a cracked frame rail, which of the following must be considered?
A. minimizing loss of temper B. avoiding crystallization C. matching the filler wire or electrode to the rail material D. all of the above