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.
21,743,928 questions answered
Popular Conversations
Which statement best describes igneous intrusion?
Weegy: Igneous is formed by solidification of magma. User: what element has 81 protons in the nuclei of its atoms? ...
7/28/2015 7:38:30 PM| 4 Answers
The two primary "greenhouse" gases are?
Weegy: A greenhouse gas (sometimes abbreviated GHG) is a gas in an atmosphere that absorbs and emits radiation within ...
7/28/2015 9:33:07 PM| 3 Answers
The familiar constellation Sagittarius is near the Galactic Center of ...
Weegy: The familiar constellation Sagittarius is near the Galactic Center of the Milky Way. Sagittarius is what the ...
7/28/2015 2:39:19 AM| 2 Answers
What are longitudinal waves?
7/28/2015 10:03:14 AM| 2 Answers
When local authors read my short story, they are astounded. Their ...
Weegy: C. creating a good thesis statement User: From the Lands End Observatory I viewed the Grand Mesa with new ...
7/28/2015 11:56:27 AM| 2 Answers
Which of the following BEST reflects the ways in which a gerund can ...
Weegy: Noun BEST reflects the ways in which a gerund can be used. User: What is the difference between action ...
7/28/2015 12:40:19 PM| 2 Answers
Weegy Stuff
S
1
L
Points 803 [Total 1314]| Ratings 1| Comments 793| Invitations 0|Offline
S
P
C
L
P
L
1
P
P
1
P
1
P
L
Points 560 [Total 10094]| Ratings 3| Comments 510| Invitations 2|Offline
S
L
L
Points 330 [Total 8530]| Ratings 5| Comments 280| Invitations 0|Offline
S
Points 208 [Total 208]| Ratings 0| Comments 208| Invitations 0|Offline
S
Points 171 [Total 171]| Ratings 1| Comments 161| Invitations 0|Offline
S
1
L
L
Points 75 [Total 8455]| Ratings 0| Comments 75| Invitations 0|Offline
S
Points 65 [Total 65]| Ratings 0| Comments 65| Invitations 0|Offline
S
Points 50 [Total 50]| Ratings 3| Comments 20| Invitations 0|Offline
S
Points 40 [Total 40]| Ratings 2| Comments 20| Invitations 0|Offline
S
Points 13 [Total 108]| Ratings 1| Comments 3| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2015 Purple Inc.