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 332 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.
18,417,076 questions answered
Popular Conversations
If and has sides that are 5 times greater than those of , what is ...
Weegy: Solution: C = 2pi(r) 15.7 = 2(3.14)r 15.7 = 6.28r 2.5 = r A = pi(r^2) = 3.14(2.5)^2 = 3.14(6.25) = 19.625 ...
11/22/2014 2:32:51 PM| 3 Answers
. What is the value of 4 cubed? A. 24 B. 43 C. 64 ...
Weegy: The answer is C. 125,000,000 User: What is the value of 324? A. 1,048,576 B. 18 C. 128 D. ...
11/22/2014 4:52:09 PM| 3 Answers
It rained yesterday and is supposed to be sunny today. This is an ...
Weegy: It is an example of B) climate. User: In Hawaii, you can almost always expect 80°F temperatures and daily ...
11/23/2014 3:21:11 AM| 3 Answers
Who is the prime minister of India?
Weegy: Manmohan Singh is the 13th and current Prime Minister of India. User: National flower of India?
11/22/2014 1:28:06 AM| 2 Answers
One of the major advantages of VANs is cost. True or False
Weegy: What is false? Do you have a question for Weegy? User: True or False One of the major advantages of VANs is ...
11/22/2014 2:06:05 AM| 2 Answers
293.55 is 51.5% of what number?
11/22/2014 3:36:30 AM| 2 Answers
When purchasing merchandise for resale for cash, record the ...
Weegy: User: When purchasing merchandise for resale for cash, record the transaction in the Answer: Business documents ...
11/22/2014 6:52:09 AM| 2 Answers
The _____ is the smallest interval in Western music. half ...
Weegy: In Western music, intervals are most commonly differences between notes of a diatonic scale. User: Which types ...
11/22/2014 9:44:17 AM| 2 Answers
Which of the following best describes the advantage of having data ...
Weegy: a. The number of digits that can be included within the data best describes the advantage of having data ...
11/22/2014 11:03:31 AM| 2 Answers
Weegy Stuff
S
L
1
L
P
C
1
P
C
1
L
P
C
1
Points 2381 [Total 14092]| Ratings 10| Comments 2281| Invitations 0|Offline
S
L
Points 1294 [Total 3580]| Ratings 0| Comments 1294| Invitations 0|Offline
S
1
L
1
L
P
P
L
P
Points 718 [Total 14092]| Ratings 0| Comments 718| Invitations 0|Offline
S
L
Points 707 [Total 1228]| Ratings 6| Comments 647| Invitations 0|Offline
S
Points 504 [Total 536]| Ratings 1| Comments 494| Invitations 0|Offline
S
1
L
L
Points 222 [Total 6616]| Ratings 0| Comments 222| Invitations 0|Online
S
L
Points 150 [Total 1446]| Ratings 3| Comments 120| Invitations 0|Offline
S
Points 50 [Total 50]| Ratings 0| Comments 0| Invitations 5|Offline
S
Points 46 [Total 46]| Ratings 3| Comments 6| Invitations 1|Offline
S
Points 40 [Total 40]| Ratings 4| Comments 0| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.