I need the answers now to question below ca dq

Computer Science
Tutor: None Selected Time limit: 1 Day

If you were a financial planner, what are some Excel functions that you might use or need?

In your financial planning worksheet, when might you use conditional formatting?

Dec 23rd, 2014

NPV net present value

IRR Internal rate of Return

FV future Value

PMt Payment for loan

Yield yields on security 

and other financial functions

Average

Stdev

and other Statistical functions

Highlight those cells based on criteria by conditional formatting

For example if the A/R is more than a number of days  say 60

or if the inventory is more than a certain amount like $1 million

or net profit is negative or

gross profit is less than the interest to be paid.

Management by Exception is the rule for conditional formatting


Dec 23rd, 2014

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Dec 23rd, 2014
...
Dec 23rd, 2014
Dec 5th, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer