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
net present value
Internal rate of Return
Payment for loan
yields on security
other financial functions
other Statistical functions
those cells based on criteria by conditional formatting
example if the A/R is more than a number of days say 60
if the inventory is more than a certain amount like $1 million
net profit is negative or
profit is less than the interest to be paid.
by Exception is the rule for conditional formatting
Content will be erased after question is completed.
Enter the email address associated with your account, and we will email you a link to reset your password.
Forgot your password?