Reference no: EM131820698
Develop, explain, and implement two different creative examples using first a financial function and second, one which uses “nested functions”; on excel another way of questions
Find the various collections of pre-set functions on the Formulas tab (such as financial, logic, other, etc), open each set , browse the function names and open some you think might be useful but at least one has to be the NPV function and one the IF function.
Read what the function does and open several of the “help on this function” links and read that file (including NPV).
In a worksheet, click on fx and find one of the functions you looked up and implement it (using any values you want).
Nesting functions: Puts one preset function inside another (see bottom page 472-473)
With reference to exercise 2 above, create a nested IF statement where the logical test is whether B1 is less than A1. If that is true, you want Excel to enter the Average of the two cells; if it is false you want it to enter the text word Wrong .
its from a book called business analysis the art of modeling with spreadsheets.
|
Create your own input numbers such as the annual rate
: Create your own input numbers such as the annual rate of return, initial investment amount, current salary, # of years until retirement, etc...
|
|
Propose the internal control activities or audit plan
: Propose the internal control activities or audit plan that might have detected the improper transactions. Be specific with your recommendation.
|
|
Reevaluating the jury system
: High-profile legal cases have many people reevaluating the jury system. Many believe that juries in criminal trials should be able to convict
|
|
Depreciation is computed for financial reporting purposes
: Depreciation is computed for financial reporting purposes by use of the straight-line method based on the useful lives
|
|
Implement two different creative examples
: Develop, explain, and implement two different creative examples using first a financial function and second, one which uses “nested functions”;
|
|
Compute the annual depreciation and carrying value
: Compute the annual depreciation and carrying value for the new crane for each of the 6 years under each of the following methods
|
|
Calculate net cash provided by operating activities
: Nikki's Neckwear Inc. used the indirect method to calculate net cash provided by operating activities. If the company started with net income of $222,000.
|
|
Evaluate each restaurant as an economic investment
: Simple Controllable Costs Shortline Espresso is a gourmet dessert restaurant in Seattle. Margie McMahon, the sole proprietor, expanded to a second location.
|
|
What amount should added to net income to arrive at net cash
: Using the indirect method to calculate net cash provided. What amount should be added to net income to arrive at net cash provided by operating activities?
|