FIN 571 TUTOR Education is Power/fin571tutor.com FIN 571 TUTOR Education is Power/fin571tutor.com | Page 20

FIN 571 Week 1 Connect Problems( Math and Accounting
Review)
at the end of Year 4 for an estimated net cash amount of $ 3,300. What is the net present value of this project if the required rate of return is 11.3 percent? 45. Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $ 2.73 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which it will be worthless. The project is estimated to generate $ 2,090,000 in 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).