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,157,664 questions answered
Popular Conversations
Tissues arranged together make up _____, which, when functioning ...
Weegy: Tissues arranged together make up ORGANS, which, when functioning together in groups, make up SYSTEMS. User: ...
3/27/2015 1:09:34 PM| 7 Answers
Perform the indicated operation. 3 + (-4) 1 -1 7 -7
Weegy: 3 + (-4) = 3 - 4 = -1 User: Evaluate BD for A = 5, B = -2, C = 4 and D = -6. -12 -8 8 12 Weegy: If A = 5, B ...
3/28/2015 4:37:41 AM| 7 Answers
Why do anabolic steroids differ from other illegal drugs? A. They ...
Weegy: Why do anabolic steroids differ from other illegal drugs? C. They are only dangerous for men. User: Which of ...
3/28/2015 6:04:09 PM| 3 Answers
The Ramayana is a text from ...
Weegy: The Ramayana is a text from India. User: The following question references Chapter 4 of The Three Musketeers ...
3/27/2015 5:43:33 AM| 2 Answers
The Preamble is the __________. A. introduction to the ...
Weegy: The Preamble is the introduction to the Constitution. User: Federal is defined as __________. A. the ...
3/27/2015 6:43:00 AM| 2 Answers
What was the first armed conflict of the Cold War? A. the Korean ...
Weegy: The Korean war was the first armed conflict of the Cold War. User: What was the outcome of the Vietnam ...
3/27/2015 11:35:25 AM| 2 Answers
Weegy Stuff
S
L
P
L
P
P
P
Points 1270 [Total 9156]| Ratings 0| Comments 1270| Invitations 0|Offline
S
1
L
Points 622 [Total 1533]| Ratings 6| Comments 562| Invitations 0|Offline
S
P
C
L
P
L
1
P
Points 481 [Total 7788]| Ratings 8| Comments 401| Invitations 0|Online
S
1
L
L
Points 450 [Total 7951]| Ratings 0| Comments 450| Invitations 0|Offline
S
Points 401 [Total 906]| Ratings 10| Comments 291| Invitations 1|Offline
S
L
Points 353 [Total 1475]| Ratings 2| Comments 333| Invitations 0|Offline
S
Points 199 [Total 567]| Ratings 3| Comments 169| Invitations 0|Offline
S
Points 66 [Total 66]| Ratings 0| Comments 66| Invitations 0|Offline
S
Points 42 [Total 158]| Ratings 4| Comments 2| Invitations 0|Offline
S
Points 35 [Total 126]| Ratings 0| Comments 35| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2015 Purple Inc.