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.
27,006,103 questions answered
Popular Conversations
4/9 = ? / 63
Weegy: 7 is the answer. 63 ? ( 9 ) = 7 User: Find a common denominator between the two fractions. 1/2 and 5/6 ...
2/20/2017 8:56:40 AM| 4 Answers
Reduce the following fraction to lowest terms: 3/8 User: Find the ...
Weegy: The greatest common factor of the numbers 28 and 42 is 4. User: Reduce the following fractions to lowest ...
2/20/2017 8:43:07 AM| 3 Answers
Simplify 5 + 2{x - 4[3x + 7(2 - x)]}. User: Find the ...
Weegy: 48a^3 bc^2 / (3abc) = 16a^2c User: Given: X = r + 2, Y = 2r - 9, and Z = r 2 + 17r + 30. Simplify [X · Y - ...
2/20/2017 2:07:55 PM| 3 Answers
What happens when factors of production (resources) fall?
Weegy: if the factors of production: land, capital and labor fail, then it is likely that production will halt because ...
2/20/2017 4:09:26 PM| 3 Answers
Saying positive things to yourself in order to develop a more ...
Weegy: Positive attitude is the power that drives you to success. Developing and manifesting a positive attitude makes ...
2/20/2017 8:54:48 AM| 2 Answers
2 7/8 ÷ 1/4 = User: 4/3 ÷ 1/2 =
2/20/2017 9:09:55 AM| 2 Answers
__________ is the chance a business owner will lose the time and ...
Weegy: RISK is the chance a business owner will lose the time and money invested in a business that proves to be ...
2/20/2017 10:48:17 AM| 2 Answers
People who make judgments in lower federal courts are called
Weegy: Federal : of, relating to, or being a form of government in which a union of states recognizes the sovereignty ...
2/20/2017 11:49:25 AM| 2 Answers
Find the GCF of 56 and 46.
Weegy: The GCF of 56 and 46 is: 2. User: Find the GCF of -10c 2 d and 15cd 2. Weegy: GCF of -10c^2d and 15cd^2 is ...
2/20/2017 2:30:31 PM| 2 Answers
What is an incident action plan
Weegy: Incident means: A usually minor event or condition that is subordinate to another; A definite and separate ...
2/20/2017 9:40:31 PM| 2 Answers
What was the Bay of Pigs? A. an American military base in Puerto ...
Weegy: The Bay of Pigs is a failed attempt by the U.S. to invade Cuba and overthrow the communist Castro regime. ...
2/21/2017 7:28:35 AM| 2 Answers
Weegy Stuff
S
P
P
L
Points 381 [Total 1150] Ratings 2 Comments 361 Invitations 0 Offline
S
P
P
L
P
P
Points 322 [Total 2296] Ratings 1 Comments 312 Invitations 0 Offline
S
P
P
L
P
Points 226 [Total 1440] Ratings 0 Comments 226 Invitations 0 Offline
S
Points 30 [Total 30] Ratings 3 Comments 0 Invitations 0 Offline
S
Points 12 [Total 112] Ratings 1 Comments 2 Invitations 0 Offline
S
Points 12 [Total 22] Ratings 1 Comments 2 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 5 [Total 5] Ratings 0 Comments 5 Invitations 0 Online
S
Points 3 [Total 3] Ratings 0 Comments 3 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.