Question and answer
If you were a financial planner, what are some Excel functions that you might use or need? Please be specific, and explain thoroughly. You may need to use the Internet for answers, so remember to
include the URL of any site you used.
Some Excel functions that you might use or need if you're a financial planner: 1. [ The PMT Function Here is the formula in cell A6: =PMT(A1/12,A2,A3,A4,A5) If you don't use the "Percentage" format in cell A1 enter 0.05; If you use months as periods the rate must be divided by 12 (A1/12), if you use weeks then you divide by 52 (A1/52), if there are 4 payments per year you will divide the rate
by 4 (A1/4)and if the payment is annual you don't divide the rate argument (A1) ; The formula could also be =PMT(A1/12,A2,A3) the arguments in A4 and A5 being optional; If you want the payment to show as a positive value add a minus sign before the equal sign (=-PMT(A1/12,A2,A3,A4,A5)) 2. The RATE Function Here is the formula in cell A6: =RATE(A1,-A2,A3,A4,A5)*12 Notes on the formula: The payment argument is negative (-A2); If you use months as periods and you want an annual rate you multiply by 12, if you use a years as periods and you want an annual rate you don't multiply......; If you don't use the "Percentage" format in cell A6 the result of this example will be 0.05; The formula could also be =RATE(A1,-A2,A3)*12 the arguments in A4 and A5 being optional 3. The FV Function (Future value) Here is the formula in cell A6: =FV(A1/12,A2,A3,A4,A5) Notes on the formula: If you don't use the "Percentage" format in cell A1 enter 0.05; If you use months as periods the rate must be divided by 12 (A1/12), if you use weeks then you divide by 52 (A1/52), if there are 4 payments per year you will divide the rate by 4 (A1/4)and if the payment is annual you don't divide the rate argument (A1) ; The formula could also be =FV(A1/12,A2,A3) the arguments in A4 and A5 being optional; If you want the RESULT to show as a positive value add a minus sign before the equal sign (=-FV(A1/12,A2,A3,A4,A5)) ]
Expert answered|emdjay23|Points 3026|
Question
Asked 12/26/2013 10:46:34 AM
0 Answers/Comments
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
20,591,499 questions answered
Popular Conversations
Simplify 5x + 4x + 1. User: Simplify -3 xy3 + 7 xy3 + (- xy3 ) + (-3 ...
Weegy: Simplifying 6x2 + -17x + 5 = (3x + -1)(2x + -5) Reorder the terms: 5 + -17x + 6x2 = (3x + -1)(2x + -5) Reorder ...
4/26/2015 5:05:02 PM| 3 Answers
The Indo-European languages are believed to have originated ...
Weegy: Indo-European languages originated 7,800 to 9,800 years ago in Anatolia present day Turkey. [ The Indo-European ...
4/26/2015 10:36:09 AM| 2 Answers
A line passes through the points (-10,4) and (-1,2). What is the ...
Weegy: A line passes through the points and (-10, 4) and (-1, 2) The slope of the line that passes through the two ...
4/26/2015 4:05:37 PM| 2 Answers
Simplify 8(3 - 2x).
Weegy: 8(3 - 2x) = 8*3 - 8*2x = 24 - 16x User: Simplify 81.56 + n - 2.55. Weegy: 81.56 + n - 2.55 = 79.01 + n ...
4/26/2015 4:58:32 PM| 2 Answers
A real number is irrational. a. always c. never b. sometimes User: ...
Weegy: 2(4 - 2x + y) - 4(5 + x - y) = 8 - 4x + 2y - 20 - 4x + 4y; = -8x + 6y - 12 User: Every integer is a whole ...
4/26/2015 8:11:55 PM| 2 Answers
One of Teddy Roosevelt's favorite sayings was " softly and carry a ...
Weegy: Theodore Roosevelt's favorite saying is: Do what you can, with what you have, where you are.
4/26/2015 10:30:33 PM| 2 Answers
Which civilization built Machu ...
4/27/2015 8:47:37 AM| 2 Answers
Weegy Stuff
S
L
Points 712 [Total 2289]| Ratings 1| Comments 702| Invitations 0|Offline
S
L
Points 633 [Total 1200]| Ratings 2| Comments 613| Invitations 0|Offline
S
Points 460 [Total 460]| Ratings 1| Comments 450| Invitations 0|Offline
S
P
C
L
P
L
1
P
P
1
Points 441 [Total 8318]| Ratings 3| Comments 411| Invitations 0|Offline
S
Points 226 [Total 226]| Ratings 2| Comments 206| Invitations 0|Offline
S
Points 225 [Total 225]| Ratings 1| Comments 215| Invitations 0|Offline
S
1
L
L
Points 189 [Total 8183]| Ratings 0| Comments 189| Invitations 0|Offline
S
L
1
R
Points 128 [Total 1200]| Ratings 1| Comments 118| Invitations 0|Offline
S
L
Points 125 [Total 3728]| Ratings 0| Comments 125| Invitations 0|Offline
S
1
L
1
Points 43 [Total 3484]| Ratings 1| Comments 33| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2015 Purple Inc.