Notice: Payments for answers will end 4/10/2017. Click for more info.
You have new items in your feed. Click to view.
Question and answer
Q: 2. If you were a financial planner, what are some Excel formulas that you might use or need? Please specify and explain (you may need to look this up on the Internet).
A: You would need to know formulas for: 1.Future value 2.Present value 3.Compound or simple interest 4.Amortization/Depreciation To make your own financial calculator in Excel, start a new file or sheet and label fields for Rate, Nper, PMT, PV, [ [ and Type, and add some sample values. Choose the cell where you want the result for FV to go. Click Insert, then Function (or fx on the task bar) to
open Insert Function window. In the left column, select "Financial". This will give you all the functions in financial calculation. ]
Expert answered|ANGEEELICA|Points 5026|
Question
Asked 9/6/2011 1:35:26 PM
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.
26,823,967 questions answered
Popular Conversations
S
P
L
P
P
P
P
Points 246 [Total 672] Ratings 0 Comments 246 Invitations 0 Offline
S
R
L
R
Points 232 [Total 370] Ratings 0 Comments 32 Invitations 20 Offline
S
1
L
L
P
R
P
L
P
P
R
P
R
P
R
Points 220 [Total 13023] Ratings 0 Comments 210 Invitations 1 Offline
S
L
Points 97 [Total 97] Ratings 1 Comments 57 Invitations 3 Offline
S
Points 71 [Total 71] Ratings 0 Comments 21 Invitations 5 Offline
S
Points 50 [Total 50] Ratings 0 Comments 0 Invitations 5 Offline
S
P
L
Points 35 [Total 126] Ratings 0 Comments 35 Invitations 0 Offline
S
Points 30 [Total 35] Ratings 3 Comments 0 Invitations 0 Offline
S
P
Points 24 [Total 68] Ratings 0 Comments 24 Invitations 0 Offline
S
Points 20 [Total 20] Ratings 1 Comments 0 Invitations 1 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.