Hello. I could really use help answering these 2questions below for Financial Management Principles that I am struggling with. Any help answering the questions so I can understand for future reference would be a great help. Book reference if needed: Essentials of Corporate Finance, 11th edition, McGraw Hill, Author: Ross. These questions cover Chapter 9.

Image transcription text

A1 X v fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 9. The required answers are in rows 15 through 22. B C D E F G H J K L M N O P Q R S T U V W X 1 Consider the following information. Complete the income statement and then calculate the OCF. What is the depreciation tax shield? 3 Input area: UI P 6 Sales $704,600 Variable cost $527,300 8 Depreciation $82,100 9 Tax rate 22% 10 11 (Use cells A6 to B10 from the given information to complete this question.) 12 13 Output area: 14 15 Sales 16 Variable costs 17 Depreciation 18 EBT 19 Taxes 20 Net Income 21 OCF 22 Depreciation tax shield 

Image transcription text

A1 X v fx Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows 6 through 13. The required answers are in rows 21 through 37. C E G H K M N 0 P Q R S Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.18 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life. The project is estimated to generate $1.645 million in annual sales, with costs of $610,000. The tax rate is 21 percent and the required return is 12 percent. Suppose the project requires an initial investment in net working capital of $250,000, and the fixed asset will have a market value of $180,000 at the end of the project. What is the project's Year 0 net cash flow? Year 1? Year 2? Year 3? What is the NPV? Input area: Asset investment $2,180,000 Estimated annual sales $1,645,000 Costs $610,000 9 Tax rate 21% 10 Required return 12% 11 Project and asset live 12 Initial investment in NWC $250,000 13 Fixed asset value at end $180,000 14 15 (Use cells A6 to B13 from the given information to complete this question. You must use the built-in 16 Excel function to answer this question. Taxes on the salvage value should be negative for a tax 17 liability and positive for a tax credit.) 18 19 Output area: 20 21 Aftertax salvage value Sell equipment 23 Taxes 24 Aftertax salvage value 25 26 Year 0 Year 1 Year 2 Year 3 27 Sales 28 Costs 29 Depreciation 30 EBT 31 Taxes 32 Net income 33 Capital spending 34 Net working capital 35 OCF 36 Total cash flow NPV