software analysts
Because the CEO wants to increase salaries for all hourly employees and
software analysts, there needs to be a count of the employees in each
category.
Part 2: Use the funding you calculated in Part 1A and the
appropriate compound interest formulas you learned in business algebra to
calculate the investment amounts for options 1 and 2. Show your calculations in
any empty area on the worksheet created in Part 1.
Hints:
Excel Functions:
PV – Returns the present value of a future amount
PMT – Calculates the payment necessary to accumulate a future amount
Compound Interest Formulas:
A = P(1 + i)^{n}
FV = PMT × 
(1 + i)^{n} – 

Liteman, Cal
Law, Grace1