Calculating EAC-Excel Sign In HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW G6Calibri B 1 u. ?.-. Alignment Number Conditional Format as. Cell Formatting Table Styles Cells Editing Paste Clipboard Styles Font Al A five-year project has an initial fixed asset investment of $290,000, an initial NWC investment of $25,000, and an annual OCF of -$35,000. The fixed asset is fully depreciated over the life of the project and has no salvage value. If the required return is 11 percent, what is this project's equivalent annual cost, or EAC? nitial fixed asset investment $ 290,000 Initial NWC investment Annual OCF Required return Depreciation staight-line over life 25,900 (35,oo) 11% 10 12 Calculating EAC - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Paste B 1 u e. . Alignment Number Conditional Format as Cell Cells Editing -Formatting Table Styles Clipboard r Font Al 13 Complete the following analysis. Do not hard code values in your calculations You must use the built-in Excel functions to answer this question. 14 15 16 17 18 19 20 21 Cash flows Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 24 NPV EAC