FIN 571 Course Great Wisdom / tutorialrank.com FIN 571 Course Great Wisdom / tutorialrank.com | Page 14

FIN 571 Week 1 Connect Problems (Math and Accounting
Review)
For more course tutorials visit
www.tutorialrank.com
Tutorial Purchased: 2 Times, Rating: A+

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
This lesson will help you refresh your knowledge on the basics of the
balance sheet. Brushing up on these concepts now will help you
tackle your finance coursework later.