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 249 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,190,993 questions answered
Popular Conversations
Indicate whether the statement is true or false. The reason a penny ...
Weegy: TRUE - The reason a penny thrown straight up inside an airplane will come back to your hand is that you, the air ...
8/31/2014 3:31:31 PM| 4 Answers
A line passes through the points (-10, -4) and (-1,2). What is the ...
Weegy: A line passes through the points (-10, -4) and (-1,2). The y-intercept of the line is 8/3. The equation of the ...
8/31/2014 11:50:10 AM| 3 Answers
India is a subcontinent and consists of all of the following except. ...
Weegy: Indian subcontinent has all the features , valleys in himalayan mountains , deccan plateaus , thar desert , and ...
8/31/2014 11:02:13 AM| 2 Answers
Market economy. User: Command economy.
8/31/2014 8:31:19 PM| 2 Answers
Consider this quote: "In each of these historical instances . . . ...
Weegy: D. it stands for the omission of only a single word. User: Which of the following statements correctly ...
9/1/2014 8:30:28 AM| 2 Answers
Every set of three points is coplanar.
9/1/2014 7:59:14 PM| 2 Answers
Weegy Stuff
S
L
1
L
Points 136 [Total 6669]| Ratings 0| Comments 136| Invitations 0|Offline
S
L
C
P
C
1
L
L
Points 109 [Total 16048]| Ratings 0| Comments 109| Invitations 0|Offline
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 96 [Total 24496]| Ratings 0| Comments 96| Invitations 0|Offline
S
L
1
1
1
1
L
1
Points 63 [Total 9843]| Ratings 0| Comments 63| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
P
C
Points 46 [Total 17218]| Ratings 0| Comments 46| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
P
C
Points 39 [Total 18570]| Ratings 0| Comments 39| Invitations 0|Offline
S
Points 20 [Total 20]| Ratings 0| Comments 0| Invitations 2|Offline
S
1
L
1
L
P
P
L
Points 19 [Total 11265]| Ratings 0| Comments 19| Invitations 0|Offline
S
Points 17 [Total 687]| Ratings 0| Comments 17| Invitations 0|Offline
S
P
C
L
P
L
1
Points 15 [Total 6072]| Ratings 1| Comments 5| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.