PLEASE WRITE ALL ANSWERS IN EXCEL FORMAT . NO VALUES THANK U!

? X 31 Calculating NPV - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW * Calibri 11 - A = % D A - Paste B I U - PD - A Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - nts Clipboard Font Skipped A1 E F G H eBook Print Quad Enterprises is considering a new three-year expansion project that requires an initial 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 will be worthless. The project is estimated to generate $2,190,000 in annual sales, with costs of $815,000. The tax rate is 21 percent. If the required return is 12 percent, what is the project's NPV? eferences $ $ Asset investment Estimated annual sales Costs Tax rate Project and asset life Required return 2,900,000 2,190,000 815,000 21% 12% Complete the following analysis. Do not hard code values in your calculations. Sales D16 A B C D E F G H I J $ Asset investment Estimated annual sales Costs Tax rate Project and asset life Required return 2,900,000 2,190,000 815,000 21% nts Skipped 3 12% eBook Complete the following analysis. Do not hard code values in your calculations. Print Sales Costs Depreciation EBT eferences Taxes Net income OCF NPV Sheet1 ... 6 READY Attempt(s) 3/3 Step: Reference the input data cell above. $ -- + 100% Hint