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 360 days ago|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.
18,799,819 questions answered
Popular Conversations
definition of absurdity
12/20/2014 12:13:09 AM| 1 Answers
If your supervisor criticizes the way you handled a certain ...
Weegy: A. clarify how your way of handling it was best. User: You can perform your job well only if you A. ...
12/20/2014 12:00:56 AM| 1 Answers
Personal pronouns take different forms depending on whether they’re ...
Weegy: When we want to show that something belongs to somebody or something, we usually add 's to a singular noun and ...
12/20/2014 12:24:16 AM| 1 Answers
Subjects in sentences refer either to nouns or to A. adverbs. ...
Weegy: An adjective can come before or after a noun or pronoun in a sentence.
12/20/2014 12:23:55 AM| 1 Answers
Weegy Stuff
S
L
P
Points 1135 [Total 4979]| Ratings 0| Comments 1135| Invitations 0|Offline
S
L
Points 741 [Total 1432]| Ratings 1| Comments 731| Invitations 0|Offline
S
1
L
1
L
P
P
L
P
Points 691 [Total 14876]| Ratings 1| Comments 681| Invitations 0|Offline
S
Points 681 [Total 681]| Ratings 1| Comments 671| Invitations 0|Offline
S
P
C
L
P
L
1
Points 118 [Total 6437]| Ratings 1| Comments 108| Invitations 0|Offline
S
L
Points 80 [Total 1540]| Ratings 1| Comments 70| Invitations 0|Online
S
1
L
L
Points 33 [Total 6700]| Ratings 0| Comments 33| Invitations 0|Offline
S
Points 30 [Total 30]| Ratings 0| Comments 0| Invitations 3|Offline
S
Points 23 [Total 29]| Ratings 0| Comments 23| Invitations 0|Offline
S
Points 22 [Total 22]| Ratings 0| Comments 2| Invitations 2|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.