FIN 571 Course Great Wisdom / tutorialrank.com FIN 571 Course Great Wisdom / tutorialrank.com | Page 17
This lesson will help you refresh your skills using exponents. Many
financial equations rely on exponents to show compounding and
growth.
1. A business acquaintance promises to deliver a $20 bill to you one
year from today. How much should you be willing to pay today for
this promise?
2. What is the present value of $1,000 received three years from
today if interest rates are currently 6 percent?
3. What is the interest rate on a three-year investment with a future
value of $1000 and a present value of $863.84?
4. The product rule of exponents says that when multiplying two
powers that have the same base, you need to ________.
5. The fifth root of fifteen is equal to ________.
7. Basic Math
This section of the tutorial will cover writing and editing formulas,
using cell references, following the order of operations, and using
operators.
1. Which of the following Excel cell entries gives the sum of 20 +
150 + 85?
2. Which letter or symbol does Excel use to multiply numbers?
3. What is the correct order of operations for entering formulas into
Excel?
4. Which of the following sequences will give you the square root of
25 in Excel?
5. Suppose you need to add the values in range of cell from C2
through C8. Which of the following sequences will give you the
correct answer?