Share Comments A1 f B D E 1 F G H K L 2 Below is a partially completed capital budgeting analysis: 3 4 Year o Year 1 Year 2 Year 3 5 6 Building Cost Equipment Cost Investment WC HINT: Building, Equipment, and Investment in WC costs occur only at time zero. -52,000 -38,000.000 -20,000.000 7 8 9 10 Sales Revenue Less: Operating Costs Less: Depreciation EBIT 11 31,604,000.000 22,250,000.000 9,400,000.000 0.000 -50,400.000 23,005,500.000 13,803,850.000 9,400,000.000 0.000 835,373.000 32,507,500.000 21,355,250.000 9,400,000.000 0.000 12 13 94,145.000 14 Less: Taxes NOPAT Plus: Depreciation Operating Cash Flow 15 9,400,000.000 -9,400,000.000 16 9,400,000.000 -34,000.000 17 18 20 a) xamine the analysis to ensure it contains no formula errors, then complete any missing calculations. b) Apply custom formatting to the entire application (except labels) so that numbers display with a thousands separator, in whole numbers, and IN THOUSANDS c) Modify the analysis so that IF a company has a negative NOPAT, the operating cash flow for that year and all following years is set to zero. For example, if the NOPAT in year 1