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? 4. What is the ending balance in retained earnings to be reported on XYZ Company’ s 12 / 31 / X1 classified balance sheet? 5. What is the total amount of stockholders’ equity to be reported on XYZ Company’ s 12 / 31 / X1 classified balance sheet? 3. Calculating Interest This lesson will help fill in the basics on how to calculate interest when tackling financial problems. 1. What is the amount of interest earned after two years on a $ 100 deposit paying 4 percent simple interest annually? 2. What is the amount of compound interest earned after three years on a $ 100 deposit paying 8 percent interest annually?