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

annual sales, with costs of $785,000. The tax rate is 30 percent and the required
return is 13 percent.
What is the project’s NPV?
===========================================
====
FIN 571 Week 1 Connect Problems (Math and Accounting
Review)
FOR MORE CLASSES VISIT
www.fin571tutor.com
FIN 571 Week 1 Connect Problems (Math & Accounting Review)
1. Functions
Excel will make your life as a finance student much easier. This section will
show how to use various functions in Excel. Once you understand the how
and why of a particular financial equation, you can make
1. Which Excel cell entry will calculate the square root of 165?
2. Which statements about Excel’s FV function are correct?
3. Which fields are required to calculate net present value (NPV) in Excel?
4. Which Excel function is used to calculate the amount of each annuity
payment?
5. Which fields are required to calculate the rate of return (RATE) for a
present value calculation in Excel?
2. The Balance Sheet