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 247 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.
17,182,540 questions answered
Popular Conversations
The political party notifies the people about certain issues, and in ...
Weegy: C. informer-stimulator function is the answer User: Which of the following if NOT a function served by ...
8/29/2014 11:19:03 PM| 3 Answers
The meaning of analysis is A. to dissect. B. absence of ...
Weegy: The meaning of analysis is : a separating into parts. User: A dog lying on its right side is in _______ ...
8/29/2014 11:32:49 PM| 3 Answers
What is passive listening
Weegy: ]
8/29/2014 9:51:30 AM| 2 Answers
The climate and terrain near the Black Sea in Georgia are well suited ...
Weegy: kindly include the choices. thanks!
8/29/2014 10:58:23 AM| 2 Answers
Factor -2bk 2 + 6bk - 2b
Weegy: 2b - 3 = 5. please rate this answer. User: (6x 2 - x - 40) ÷ (5 + 2x) Weegy: The simpified equation is (B) ...
8/29/2014 11:08:33 AM| 2 Answers
Weegy Stuff
S
R
L
1
1
P
C
1
P
1
1
L
P
C
P
C
1
P
C
L
P
C
1
P
C
P
C
Points 2754 [Total 24354]| Ratings 4| Comments 2714| Invitations 0|Offline
S
L
1
L
Points 2431 [Total 6407]| Ratings 8| Comments 2351| Invitations 0|Offline
S
L
C
P
C
1
L
L
Points 2265 [Total 15878]| Ratings 13| Comments 2135| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
P
C
Points 2076 [Total 17103]| Ratings 7| Comments 2006| Invitations 0|Offline
S
L
1
1
1
1
L
1
Points 1992 [Total 9699]| Ratings 2| Comments 1972| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
P
C
Points 900 [Total 18471]| Ratings 0| Comments 900| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 572 [Total 11233]| Ratings 1| Comments 562| Invitations 0|Offline
S
1
L
L
Points 558 [Total 5122]| Ratings 0| Comments 558| Invitations 0|Offline
S
Points 447 [Total 650]| Ratings 1| Comments 437| Invitations 0|Offline
S
Points 370 [Total 370]| Ratings 2| Comments 320| Invitations 3|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.