Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer all parts in excel. thank you Operating cash flows Richard and Linda Thomson operato a local lawn maintenance service for commercial and del

please answer all parts in excel.
thank you image text in transcribed
image text in transcribed
Operating cash flows Richard and Linda Thomson operato a local lawn maintenance service for commercial and del property. They have been using John Deereiding mower for the past wiel years belowe het is time to buy They would like to know the operating how old with the replica of the old riding mower. The following data are available There are 5 years of remaining users on the old mower 2. The old mower has a book 3. The new mower is expected to last 5 years 4 The Thomsons will flow a 5-you MACRS covery period for the new mowe 5. Depreciable value of the new wnmower 1.700 6. They are back to a 40% tasa 7. The new mewer in expected to be more fuel taneuverable, and durable the previous models and can built in reduced operating experts of $500 per year. 8. The Thomson will buy a mano contract that calls for annual payments of $114 Create an operating cash flow me for the replacement of Richard and Unda's John Deere riding mower Show the operating cash flow for the next years Call the incremental pering cash flow met below found to the nearest Richard and Linda Thomson Incremental Operating Cash Flow Replacement of John Deere Riding Mowat Year Savner how and improve 1 Amina con $ $ Babes To 5 3 Enterober in the ones and the Check Awe Check DO art 5 MacBook Air S 5 0 E Y . R K H F G S D 3 of 10 (1 complete) HW SC Data Table - law - ated orth ele, 10 years al pe ard und (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery year Recovery year 3 years 5 years 7 years 1 33% 20% 14% 10% 2 45% 32% 25% 18% 3 15% 19% 18% 14% 4 7% 12% 12% 12% 5 12% 9% 9% 6 5% 9% 8% 7 9% 7% 8 4% 6% 9 6% 10 6% 11 4% Totals 100% 100% 100% 100% *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 Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions