FIN 571 Week 1 Connect Problems ( Math and Accounting
Review )
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 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 ?