ANSWERS MUST BE IN EXCEL

Excel Calculating uring cash flow - Excel FORMULAS DATA REVIEW VIEW HOME INSERT PAGE LAYOUT 1 Cell A Alignment Number Paste Conditional Format as Cell Formatting Table Styles Styles Font clipboard A1 1 X D H C 3 Quad Enterprises is considering a new free-year expansion project that requires an nitial fixed asset investment of $2.9 million. The fixed asset will be depreciated straight line to zero over its three-year tax life, after which time it wilbe wortless. The project is estimated to generate $2.190,000 in annual sales, with costs of $815,000. If the tax rate is 21 percent, what is the OCF for this project? 7 B Asset investment Estimated annual sales Costs Tax rate Project and asset life 2,900,000 2,190.000 815,000 2196 3 Complete the following analysis. Do not hard code values in your calculation 15 16 17 18 Sales Costs Depreciation EBT Taxes Net income 21 22 OCF Sheet1 READY Attempt(s)