I need the answers now to question below ca dq

label Computer Science
account_circle Unassigned
schedule 1 Day
account_balance_wallet $5

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?

Oct 21st, 2017

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
...
Oct 21st, 2017
...
Oct 21st, 2017
Oct 22nd, 2017
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