. Compute the OCF for this project Calculating Project OCF- Excel Sign In HOME INSERT PAGE LAYOUT FORMULASDATA REVIEWVIEW Arial 12A A . o. . Alignment Number Conditional Format as StCell. Cels Editing B 1 u . Paste Cipboard D15 Formatting" Table Shyles Font A B Keiper, Inc., 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. If the tax rate is 35 percent, what is the OCF for this project? Asset investment 6 Estimated annual sales Costs Tax rate S 2,900,000 2,190,000 815,000 35% 9"Depreciation straight-line to zero over tax life 12 13 Complete the following analysis. Do not hard code values in your calculations 15 16 Costs 17 Depreciation EBT Taxes 18 Paste f B r u- -.- . Alignment Number Conditional Format as Cell Formatting" Table Styles . Cells Editing Clipboard D15 A B 815,000 35% Tax rate 9 Depreciation straight-ine 10 to zero over tax life 12 13 Complete the following analysis. Do not hard code values in your calculations. 14 15 16Costs 18 EBT 19 Taxes Sales 17 Depreciation Net income 21 22 OCF Sheet1 | 100% Attempt(s) 1/3 F3 F4 FS F6