ANSWER IN EXCEL PLEASEANSWER IN EXCEL PLEASE

A project that provides annual cash flows of $15,400 for nine years costs $67,000 today. What is the NPV if the required return is 8 percent? What if it's 20 percent? At what discount rate would you be indifferent between accepting the project and rejecting it? $ 15,400 Annual cash flows # of years Costs Required Return Required Return 67,000 8% 20% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. NPV at 8 percent NPV at 20 percent IRR A proposed new investment has projected sales of $635,000. Variable costs are 44 percent of sales, and fixed costs are $193,000; depreciation is $54,000. Prepare a pro forma income statement assuming a tax rate of 21 percent. What is the projected net income? Projected sales Variable cost (% of sales) Fixed cost Depreciation Tax rate EA EA 635,000 44% 193,000 54,000 21% Complete the following analysis. Do not hard code values in your calculations. Sales Variable costs Fixed costs Depreciation EBT Taxes Net Income Consider the following income statement. Fill in the missing numbers and then calculate the OCF. What is the depreciation tax shield? Tax rate 22% Complete the following analysis. Do not hard code values in your calculations. $ 713,500 49,730 87,400 Sales Variable costs Depreciation EBT Taxes Net Income OCF Depreciation tax shield