please show how to calculate in excel

Data table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Question list Incremental operating cash inflows Strong Tool Company has been considering purchasing a new lathe to replace a fully depreciated lathe that will last 5 more years. The new lathe is expected to have a 5-year life and depreciation charges of $2,240 in Year 1; $3,584 in Year 2; $2,128 in Year 3;\$1,344 in both Year 4 and Year 5 . The firm estimates the revenues and expenses (excluding depreciation) for the Question 1 new and the old lathes to be as shown in the following table. The firm is subject to a 40% tax rate on ordinary income. a. Calculate the operating cash inflows associated with each lathe. b. Calculate the incremental (relevant) operating cash inflows resulting from the proposed lathe replacement. c. Depict on a time line the incremental operating cash inflows calculated in part b. Question 3 a. Calculate the operating cash inflows associated with the new lathe below: (Round to the nearest dollar.) Question list Question 1 Question 2 Question 3 Incremental operating cash inflows Strong Tool Company has been considering purchasing a new lathe to replace a fully depreciated lathe that will last 5 more years. The new lathe is expected to have a 5-year life and depreciation charges of $2,240 in Year 1;$3,584 in Year 2; $2,128 in Year 3; $1,344 in both Year 4 and Year 5. The firm estimates the revenues and expenses (excluding depreciation) for the new and the old lathes to be as shown in the following table The firm is subject to a 40% tax rate on ordinary income. a. Calculate the operating cash inflows associated with each lathe. b. Calculate the incremental (rolevant) operating cash inflows resulting from the proposed lathe replacement. c. Depict on a time line the incremental operating cash inflows calculated in part b. (frounu io uie nearest vonar.) Incremental operating cash inflows Strong Tool Company has been considering purchasing a new lathe to replace a fully depreciated lathe that will last 5 more years. The new lathe is expected to have a 5-year life and depreciation charges of $2,240 in Year 1; $3,584 in Year 2; $2,128 in Year 3; $1,344 in both Year 4 and Year 5. The firm estimates the revenues and expenses (excluding depreciation) for the new and the old lathes to be as shown in the following table The firm is subject to a 40% tax rate on ordinary income. a. Calculate the operating cash inflows associated with each lathe. b. Calculate the incremental (relevant) operating cash inflows resulting from the proposed lathe replacement. c. Depict on a time line the incremental operating cash inflows calculated in part b. Incremental operating cash inflows Strong Tool Company has been considering purchasing a new lathe to replace a fully depreciated lathe that will last 5 more years. The new lathe is expected to have a 5-year life and depreciation charges of $2,240 in Year 1; $3,584 in Year 2; $2,128 in Year 3; \$1,344 in both Year 4 and Year 5. The firm estimates the revenues and expenses (excluding depreciation) for the new and the old lathes to be as shown in the following table The firm is subject to a 40% tax rate on ordinary income. a. Calculate the operating cash inflows associated with each lathe. b. Calculate the incremental (relevant) operating cash inflows resulting from the proposed lathe replacement. c. Depict on a time line the incremental operating cash inflows calculated in part b. Calculate the operating cash inflows associated with the old lathe below: (Round to the nearest dollar.) Question list Incremental operating cash inflows Strong Tool Company has been considering purchasing a new lathe to replace a fully depreciated lathe that will last 5 more years. The new lathe is expected to have a 5-year life and depreciation charges of $2,240 in Year 1;$3,584 in Year 2; $2,128 in Year 3;$1,344 in both Year 4 and Year 5. The firm estimates the revenues and expenses (excluding depreciation) for the Question 1 new and the old lathes to be as shown in the following table The firm is subject to a 40% tax rate on ordinary income. a. Calculate the operating cash inflows associated with each lathe. b. Calculate the incremental (rolevant) operating cash inflows resulting from the proposed lathe Question 2 replacement. c. Depict on a time line the incremental operating cash inflows calculated in part b. Question 3 b. Calculate the incremental (relevant) operating cash inflows resulting from the proposed lathe replacement. Calculate the incremental (relevant) operating cash inflows resulting from the proposed lathe replacement below: (Round to the nearest dollar.) (Round to the nearest dollar.) Question list Incremental operating cash inflows Strong Tool Company has been considering purchasing a new lathe to replace a fully depreciated lathe that will last 5 more years. The new lathe is expected to have a 5-year life and depreciation charges of $2,240 in Year 1;$3,584 in Year 2; $2,128 in Year 3;$1,344 in both Year 4 and Year 5. The firm estimates the revenues and expenses (excluding depreciation) for the Question 1 new and the old lathes to be as shown in the following table The firm is subject to a 40% tax rate on ordinary income. a. Calculate the operating cash inflows associated with each lathe. b. Calculate the incremental (rovevant) operating cash inflows resulting from the proposed lathe replacement. c. Depict on a time line the incremental operating cash inflows calculated in part b. Question 3 (Round to the nearest dollar.) c. Depict on a time line the incremental operating cash inflows calculated in part b. (Select the best choice below.)