FIN 571 TUTOR Let's Do This /fin571tutor.com FIN 571 TUTOR Let's Do This /fin571tutor.com | Page 36

3. What is the amount of earnings before taxes (EBT) to be reported on
ABC Company’s 12/31/X1 income statement?
4. What is the amount of net income to be reported on ABC Company’s
12/31/X1 income statement?
5. Fractions and Decimals
This lesson will help you review fractions and decimals: calculating,
converting, and recognizing how to use them in a financial setting.
1. 54/32 converted to a mixed number is ________.
2. The product of one and four thirty-seconds and twenty thirty-seconds is
________.
3. One and eight thirty-seconds divided by twelve thirty-seconds is
________.
4. A U.S. Treasury bond is trading at 98 and 6/32. Convert this price to its
decimal form.
5. What is the percentage increase if the S&P 500 Index is currently
trading at 1,100 and rises 55 points?
6. Exponential Functions
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?
8. Organizing Data