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 303 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,972,226 questions answered
Popular Conversations
How is the infinitive phrase used in the sentence? Morning is the ...
Weegy: To go to college is my greatest ambition. The infinitive phrase "to go to college" is used as noun as subject. ...
10/24/2014 11:04:05 AM| 5 Answers
Simplify. n 6 · n 5 · n 4 ÷ n 3 · n 2 ÷ n User: Find the ...
Weegy: What is your question? User: Simplify. y 5 ÷ y 3 · y 2 Weegy: y^5 ? y^3 ? y^2; y^8 ? y^2 = y^6 User: ...
10/24/2014 11:04:16 AM| 4 Answers
Brandon's huge collection of paper cranes come from his origami ...
Weegy: The correct sentence is: Brandon's huge collection of paper cranes comes from his origami hobby. User: ...
10/24/2014 7:48:30 AM| 3 Answers
William H. Crawford represented which ...
10/24/2014 7:25:41 AM| 2 Answers
Is the sentence compound, or is it simple with a compound verb? You ...
Weegy: Verb is a word (part of speech) that in syntax conveys an action (bring, read, walk, run, learn), an occurrence ...
10/24/2014 7:51:29 AM| 2 Answers
Weegy Stuff
S
L
1
1
1
1
L
1
L
Points 2722 [Total 15097]| Ratings 0| Comments 2722| Invitations 0|Offline
S
L
1
L
P
C
1
P
C
1
L
Points 1649 [Total 11130]| Ratings 4| Comments 1609| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 898 [Total 13127]| Ratings 0| Comments 898| Invitations 0|Offline
S
L
Points 615 [Total 2014]| Ratings 0| Comments 615| Invitations 0|Offline
S
1
L
L
Points 509 [Total 6303]| Ratings 3| Comments 479| Invitations 0|Offline
S
Points 482 [Total 482]| Ratings 0| Comments 452| Invitations 3|Offline
S
Points 454 [Total 455]| Ratings 6| Comments 394| Invitations 0|Offline
S
Points 277 [Total 277]| Ratings 1| Comments 267| Invitations 0|Offline
S
L
Points 48 [Total 1265]| Ratings 1| Comments 38| Invitations 0|Offline
S
P
C
L
P
L
1
Points 48 [Total 6282]| Ratings 0| Comments 48| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.