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 ?