Periodic cash inflows Scenic Tours, Inc. is a provider of bus tours throughout New England. The corporation is considering the replacement of 10 of its older buses. The existing buses were purchased 4 years ago at a total cost of $2,656,000 and are being depreciated using MACRS and a 5-year recovery period (see table 1. The new buses would have larger passenger capacity and better fuel efficiency as well as lower maintenance costs. The total cost for 10 new buses is $2,962,000. Like the older buses, the new ones would be depreciated using MACRS and a 5-year recovery period. Scenic is subject to a tax rate of 21%. The following table presents revenues and cash expenses (excluding depreciation and interest) for the proposed purchase as well as the present fleet. Use all of the information given to calculate incremental (net) periodic cash flows for the proposed bus replacement. Data table (Click on the icon here D in order to copy the contents of the data table below into a spreadsheet) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Inese percentages nave 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 Calculate the incremental (net) periodic cash flows below: (Round to the nearest dollar.) (Round to the nearest dollar.) Year 3 Revenues: (000) New buses Old buses Incremental revenue Expenses: (000) New buses Old buses Incremental expense Depreciation: (000) New buses Old buses Incremental depreciation Incremental depreciation tax savings @21\% (Round to the nearest dollar.) \begin{tabular}{cc} Year & 4 \\ \hline \end{tabular} Revenues: (000) New buses Old buses Incremental revenue Expenses: (000) New buses Old buses Incremental expense Depreciation: (000) New buses Old buses Incremental depreciation Incremental depreciation tax savings @ 21\% \$ $ (Round to the nearest dollar.) \begin{tabular}{lll|l|l|l|l|} Year & 5 \\ \hline \end{tabular} Revenues: (000) New buses Old buses Incremental revenue Expenses: (000) New buses Old buses Incremental expense Depreciation: (000) New buses Old buses Incremental depreciation Incremental depreciation tax savings @21\% \begin{tabular}{ll|l} Year & 6 \\ \hline \end{tabular} Revenues: (000) New buses Old buses Incremental revenue Expenses: (000) New buses Old buses Incremental expense Depreciation: (000) New buses Old buses Incremental depreciation Incremental depreciation tax savings @ 21\% $ (Round to the nearest dollar.) Year Net Incremental Cash Flows Cash flows: (000) Revenues Less: Change in expenses Less: Taxes @ 21\% Depreciation tax savings Net operating cash inflows (Round to the nearest dollar.) \begin{tabular}{c} Year \\ \hline \end{tabular} Net Incremental Cash Flows Cash flows: (000) Revenues Less: Change in expenses Less: Taxes @ 21\% Depreciation tax savings Net operating cash inflows \begin{tabular}{lll|l|l|l|} Year & 3 \\ \hline \end{tabular} Net Incremental Cash Flows Cash flows: (000) Revenues Less: Change in expenses Less:Taxes@21\% Depreciation tax savings Net operating cash inflows (Round to the nearest dollar.) \begin{tabular}{c|l|} Year & 4 \\ \hline \end{tabular} Net Incremental Cash Flows Cash flows: (000) Revenues Less: Change in expenses Less: Taxes @ 21\% Depreciation tax savings Net operating cash inflows 1
