Question and answer
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).
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
Ask a question
Not a good answer? Get an answer now. (Free)
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
Questions asked by the same visitor
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).
Question
All Categories|No Subcategories|Not Answered
Updated 9/9/2011 11:51:44 AM
1 Answer/Comment
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. ]
Added 9/9/2011 11:51:44 AM
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).
Weegy: SUM, AVERAGE, IF, HYPERLINK, COUNT, MAX, SIN, SUMIF, and STDEV. [ SUM- adds all the numbers in a range of cells. AVERAGE- Returns the average of its argument, which can be numbers or names, arrays, or references that contain numbers. IF- Checks whether a condition is met and returns one value if TRUE and another value if FALSE. HYPERLINK- Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or ... (More)
Question
Business and Money|No Subcategories|Expert Answered
Asked 9/6/2011 2:03:42 PM
0 Answers/Comments
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).
Weegy: 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 ... (More)
Question
All Categories|No Subcategories|Expert Answered
Asked 9/6/2011 1:55:15 PM
0 Answers/Comments
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).
Weegy: statistical formulas like sum, sumif, count, count if, array formulas as well (this will help you make your work more efficient). Also logical formulas and and IF to customize whatever criteria/ condition you set. (More)
Question
All Categories|No Subcategories|Expert Answered
Asked 9/6/2011 1:59:50 PM
0 Answers/Comments
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).
Weegy: Future Value of Annuity: Future Value of an Annuity Annuity = A level payment for a certain number of periods. (Normally payments take place at the end of the period, type 0) Given an annuity (pmt), [ a number of periods (n or nper) and a per period interest rate of 'k', what is the value at the end of the annuity period (FVA). =FV(rate,nper,pmt,PV,type) ] (More)
Question
All Categories|No Subcategories|Expert Answered
Asked 9/6/2011 2:06:47 PM
0 Answers/Comments
16,938,778 questions answered
Popular Conversations
A catharsis is a cleansing of emotions. True False
Weegy: Catharsis is defined as the purging of the emotions or relieving of emotional tensions, especially through ...
7/25/2014 10:33:32 AM| 2 Answers
14. Select the NIMS term that is defined as 'the architecture to ...
Weegy: Multiagency Coordination is defined as 'the architecture to support coordination for incident prioritization, ...
7/25/2014 12:13:02 AM| 1 Answers
I am going to meet my girlfriend’s father for the very first ...
Weegy: 1 Dress nicely. Her family will like someone who looks mature and put together. Don't wear jeans that hang to ...
7/25/2014 12:35:52 AM| 1 Answers
What is the BEST way to define nonfiction? A. genre of literature ...
Weegy: The BEST way to define nonfiction- genre of literature based on facts or reality. User: A record of a ...
7/25/2014 12:18:56 AM| 1 Answers
Weegy Stuff
S
R
L
1
1
P
C
1
P
1
1
L
P
C
P
C
1
P
C
L
P
C
1
P
C
Points 2040 [Total 21040]| Ratings 1| Comments 2030| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
Points 1917 [Total 17046]| Ratings 0| Comments 1917| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
Points 1700 [Total 14255]| Ratings 1| Comments 1690| Invitations 0|Offline
S
L
1
Points 1433 [Total 3616]| Ratings 2| Comments 1413| Invitations 0|Offline
S
L
1
1
1
1
L
1
Points 1194 [Total 7371]| Ratings 2| Comments 1174| Invitations 0|Offline
S
1
L
Points 1003 [Total 3139]| Ratings 6| Comments 943| Invitations 0|Online
S
1
L
1
L
P
P
L
Points 906 [Total 10514]| Ratings 0| Comments 906| Invitations 0|Offline
S
1
L
Points 787 [Total 4463]| Ratings 2| Comments 767| Invitations 0|Offline
S
P
C
L
P
L
1
Points 750 [Total 5804]| Ratings 4| Comments 710| Invitations 0|Offline
S
Points 263 [Total 411]| Ratings 2| Comments 243| Invitations 0|Offline
Home | Contact | Archive | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.