You have new items in your feed. Click to view.
Q: 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.
A: 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)) ]
Question
Rating

*
Get answers from Weegy and a team of really smart lives experts.
Popular Conversations
After the skin is cut and a capillary wall breaks, what's the first ...
Weegy: After the skin is cut and a capillary wall breaks, the first step in working to form a clot is - Platelets clump ...
Phototropism
Weegy: Geotropism is the growth response of a plant in response to gravity. User: Which type of plant was the last to ...
What does velocity mean
2. Which of the following is not an example of a nontraditional ...
Weegy: Law firm is not an example of a nontraditional health information technology setting. User: 3. Good coding ...
Given the formula E = IR what is the formula for R? A. ...
Weegy: Given the formula E = IR, the formula for R is R = E/I. User: Solve this equation: 80 = 3y + 2y + 4 + 1. ...
Strike-slip fault
Weegy: In a strike-slip fault, the rocks on either side of the fault slip past each other sideways. TRUE.
6 + (2 + 3) × 5?
Weegy: 2*6+4*5, 12 + 20 = 32 User: 2(5 × 3) + 2(5 × 8) + 2(3 × 8) Weegy: 3/8+2/5 = 15/40+16/40 = 31/40 User: ...
S
L
Points 226 [Total 237] Ratings 0 Comments 226 Invitations 0 Offline
S
R
L
R
P
R
Points 216 [Total 658] Ratings 0 Comments 26 Invitations 19 Offline
S
L
Points 141 [Total 141] Ratings 0 Comments 21 Invitations 12 Offline
S
1
L
L
P
R
P
L
P
P
R
P
R
P
R
P
Points 124 [Total 13209] Ratings 0 Comments 114 Invitations 1 Offline
S
Points 30 [Total 30] Ratings 0 Comments 0 Invitations 3 Offline
S
Points 14 [Total 14] Ratings 0 Comments 14 Invitations 0 Offline
S
Points 13 [Total 13] Ratings 0 Comments 3 Invitations 1 Offline
S
Points 13 [Total 13] Ratings 0 Comments 13 Invitations 0 Offline
S
Points 11 [Total 11] Ratings 1 Comments 1 Invitations 0 Offline
S
L
1
R
Points 11 [Total 1416] Ratings 0 Comments 1 Invitations 1 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.