Problem 10-9 Calculating Project OCF 1. Compute the OCF for this project Calculating Project OCF-Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVEW VIEW Sign In B.1 uB-5-L' Alignment Number Conditional Format as Cel Cells Editing Formatting Table Styles Clpboard A B Keiper, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The foxed 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 2,900,000 6 Estimated annual sales $ 2,190,000 815,000 Costs Tax rate 9 Depreciation straight-line to zero over tax life Complete the following analysis. Do not hard code values in your calculations 13 $ 2,190,000.00 3 4 Q W RTY G18 815,000 Costs Tax rate 35% "Depreciation straight-line to zero over tax life 9 10 12 13 Complete the following analysis. Do not hard code values in your calculations. 16 Costs 19 Taxes 14 15 Sales S 2,190,000.00 17 Depreciation EBT Net income 2OCF Sheetl - F3 F4 FS F6