FIN 571 TUTOR Career Path Begins/fin571tutor.com FIN 571 TUTOR Career Path Begins/fin571tutor.com | Page 7

45.What is the net present value of a project with an initial cost of $36,900
and cash inflows of $13,400, $21,600, and $10,000 for Years 1 to 3,
respectively? The discount rate is 13 percent.
----------------------------------------------------------------------------------------------------

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
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.
General Ledger for XYZ Company. The following is a portion of the general
ledger for XYZ Company as of December 31, 20X1, and the statement of
stockholders’ equity for XYZ Company for the year ended December 31,
20X1. Use this information to answer questions (1) through (5).
1. What is the total amount of current assets to be reported on XYZ
Company’s 12/31/X1 classified balance sheet?
2. What is the total amount of long-term assets to be reported on XYZ
Company’s 12/31/X1 classified balance sheet?
3. What is the total amount of current liabilities to be reported on XYZ
Company’s 12/31/X1 classified balance sheet?