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



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
Mar 29th, 2017
Mark as Final Answer
Unmark as Final Answer
Final Answer

Secure Information

Content will be erased after question is completed.

Final Answer