You have new items in your feed. Click to view.
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.
0 questions answered
Popular Conversations
What is the frequency of a wave if 3 crests pass in 6 ...
Weegy: The frequency of a wave if 3 crests pass in 6 seconds is 0.5 Hz.
1/21/2017 12:32:19 AM| 2 Answers
The smallest unit of an element that has all of the properties of the ...
Weegy: The smallest unit of an element that has all of the properties of the element is an atom.
1/21/2017 12:26:51 AM| 1 Answers
Is defined as generating ideas by writing down everything that comes ...
Weegy: Brainstorming is defined as generating ideas by writing down everything that comes to mind on a subject. ...
1/21/2017 1:32:28 AM| 1 Answers
Who is the president of the united states?
1/21/2017 2:42:41 AM| 1 Answers
Who is the president of the united states?
1/21/2017 2:44:57 AM| 1 Answers
How many years did Barack Obama rule u.s.a
Weegy: Barack Obama is the 44th president of the United States and the first African-American president in American ...
1/21/2017 3:13:45 AM| 1 Answers
Five functions of government:
1/21/2017 3:33:07 AM| 1 Answers
Weegy Stuff
S
Points 481 [Total 481] Ratings 1 Comments 471 Invitations 0 Offline
S
P
Points 227 [Total 658] Ratings 3 Comments 197 Invitations 0 Online
S
Points 215 [Total 227] Ratings 0 Comments 215 Invitations 0 Offline
S
P
P
L
Points 171 [Total 1066] Ratings 2 Comments 151 Invitations 0 Offline
S
Points 88 [Total 90] Ratings 5 Comments 38 Invitations 0 Offline
S
Points 70 [Total 70] Ratings 7 Comments 0 Invitations 0 Offline
S
L
P
P
P
Points 68 [Total 4027] Ratings 0 Comments 68 Invitations 0 Offline
S
Points 24 [Total 96] Ratings 0 Comments 24 Invitations 0 Offline
S
Points 11 [Total 11] Ratings 0 Comments 11 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.