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.
25,616,369 questions answered
Popular Conversations
Cancer is a disease of ____________________
Weegy: Cancer is disease caused by an uncontrolled division of abnormal cells in a part of the body. User: ...
6/24/2016 3:16:51 AM| 3 Answers
The kingdom Animalia includes all of these except A. ...
Weegy: Sponge lacks nervous tissue. User: Many bivalves, like scallops, live in salt water. The scallop ...
6/24/2016 4:21:37 AM| 3 Answers
Is solar energy renewable?
Weegy: Solar energy is renewable energy.
6/24/2016 3:12:48 PM| 2 Answers
Crediting of sources can also protect you from being accused of ...
Weegy: True User: Plagiarism damages reputations and relationships. True False User: To be charged with plagiarism ...
6/24/2016 6:47:18 PM| 2 Answers
In which empire was St. Petersburg ...
6/24/2016 12:25:01 AM| 1 Answers
In which empire was St. Petersburg ...
6/24/2016 12:29:14 AM| 1 Answers
Which of the following is an example of an ...
Weegy: STOMACH is an organ of the digestive system. User: Which of the following is not a specialized tissue found ...
6/24/2016 1:21:36 AM| 1 Answers
Weegy Stuff
S
P
L
Points 836 [Total 1497] Ratings 2 Comments 816 Invitations 0 Offline
S
Points 337 [Total 698] Ratings 2 Comments 317 Invitations 0 Offline
S
L
P
P
P
Points 151 [Total 3694] Ratings 0 Comments 151 Invitations 0 Offline
S
Points 135 [Total 416] Ratings 0 Comments 135 Invitations 0 Offline
S
Points 127 [Total 179] Ratings 0 Comments 127 Invitations 0 Offline
S
P
1
Points 107 [Total 852] Ratings 3 Comments 57 Invitations 2 Offline
S
L
Points 68 [Total 4188] Ratings 0 Comments 68 Invitations 0 Offline
S
Points 40 [Total 50] Ratings 1 Comments 30 Invitations 0 Offline
S
Points 32 [Total 139] Ratings 0 Comments 32 Invitations 0 Offline
S
1
L
L
P
R
P
L
P
P
R
Points 29 [Total 12596] Ratings 0 Comments 29 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.