PLEASE USE EXCEL AND SHOW FORMULAS THX

Operating cash inflows A firm is considering renewing its equipment to meet increased demand for its product. The cost of equipment modifications is $1.83 million plus $104,000 in installation costs. The firm will depreciate the equipment modifications under MACRS, using a 5-year recovery period (see table I. Additional sales revenue from the renewal should amount to $1.12 million per year, and additional operating expenses and other costs (excluding depreciation and interest) will amount to 42% of the additional sales. The firm is subject to a tax rate of 40%. (Note: Answer the following questions for each of the next 6 years.) a. What incremental earnings before depreciation, interest, and taxes will result from the renewal? b. What incremental net operating profits after taxes will result from the renewal? c. What incremental operating cash inflows will result from the renewal? Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes *These percentages have been rounded to the nearest whole percent to simplify calculations while retaining realism. To calculate the actual depreciation for tax purposes, be sure to apply the actual unrounded percentages or directly apply double-declining balance (200%) depreciation using the half-year convention