this is the question please format the answer as seen in the below pictures with the excel charts and labels

Three different companies each purchased trucks on January 1, Year 1, for $84,000. Each truck was expected to last four years or 250,000 miles. Salvage value was estimated to be $7,000. All three trucks were driven 77,000 miles in Year 1, 57,000 miles in Year 2, 52,000 miles in Year 3, and 72,000 miles in Year 4. Each of the three companies earned $73,000 of cash revenue during each of the four years. Company A uses straight-line depreciation, company B uses double-declining-balance depreciation, and company C uses units-of-production depreciation.

Answer each of the following questions. Ignore the effects of income taxes.

Required

1. a-1. Calculate the net income for Year 1.

2. a-2. Which company will report the highest amount of net income for Year 1?

3. b-1. Calculate the net income for Year 4.

4. b-2. Which company will report the lowest amount of net income for Year 4?

5. c-1. Calculate the book value on the December 31, Year 3, balance sheet.

6. c-2. Which company will report the highest book value on the December 31, Year 3, balance sheet?

7. d-1. Calculate the retained earnings on the December 31, Year 4, balance sheet.

8. d-2. Which company will report the highest amount of retained earnings on the December 31, Year 4, balance sheet?

   e. Which company will report the lowest amount of cash flow from operating activities on the Year 3 statement of cash flows?

the content is visable but i will attach it in a word document. please format the exact same and IN order.

please format the exact same

Word File Edit View Insert Format Tools Table Window Help 16% 18% Tue 1:13 PM Q E AutoSave CFT .. chegg #2 - Saved to my Mac a 8 Times New... v 12 - A A A Aa y A Aanhandle AaArcade ::viv= ==== AaBbCcDc AabtcDtEt AaBbc Aabebele Paste Nam! B ! | x 3 x x Nu Sparing Title ADA Heating Hacing ? Suhlilla $ Dictate Editar Styles Pere 2 Three del cuerpurdod tucha w January 1984,000. Backwa spectada aur year 210,00 Sepe ALPS7000 euch www 77000 in Form In Your 2 four year.Carp Alghindereditor,cary Blasa dos-cedir-bladet, end party Clasa 200 Yearded cheese check und den Arawer wacht how to increason Home 1 Cou! 2. Wher company wil sport the chest but at nu cate or 6-1. Co the income 2. Nikh.corporywisport relation to ol Close DNT Dr. 2. With Right Dera was 1. Crowler le Dr. Lule da. Which company will report the highest mount of red carings or the December 3, Year 4 balesetet? a. When the cast iron petite www car Complete the question by writerios your name Is the bass below. armers beca Raunched -L. Cabbat the rate for You. Pourtant cast to Ikedalam ? WWWww 1 - Calone for -2 With wet the ghost Tower Calcune technologi 2 which corpswwin Wount of more towy -1. Celou show on the Duce 3, Yer 3, behal 6-2. Who Mportelles. Dockwave Ure December 31, Year 3. clasele! 61 Colete the medings of the December 31 Yordache S2 Which Pawl patteritestant reading on the Decarb, belse host? c. Who are lowed a fouch lon for perangsar starter show! Camp is only to your ows in the tasted. kxgal Puered Bloc Beq. Pesured 3-1. we I 3-2. With wet game of time tar Wars? por me Hati 1 C Page 1 of 3 0 words CS English (United States Focus E + 140% AutoSave OFF AGO " chegg #2 - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments EvEvp 41 Aalhacafe Aaronde AaBbccc AaBbccDdEt AaBb Aasbecte Times New... v 12 ~ A Aav A BU X B ! | v x x ADAY Peaid = = = Normal Nu Sparang Hasting 1 Harding Title Sulit Styles Pere Dictate Editar 2 Troca pudo hos January 1584.000.Cadiluweeled ILI SU 250,000 miles. Selvepes we sellabe 5000. Althree suchs were crven 77000 miles In Yer STDOD Tes In Year 2 62. Wes in year and in Word Earth of the three contiene a case where is $300 cachem four yur. Corpuri derecelor cargary Blasa douchy bulance de rester and curry Coca reden Answer wa Arawurwuch of the flow rotagoratusta AM 51 Calcune Benson for et 2. We copery wla porttitor out that corres 3.1. Cette at noen for 2. Nikh corpory will report the amount of retinoon Ya? 22 HERE We heel to in the wees? 11. Ce treening on the website se Sasa 3.2. With corpury will report the heat arourt a la rederiert Docentur 31 Yurbulas hout a. When contra il port this fant flow ten sporting Actress on tavarat o carro Cerpleie tab guests to your artists tetem PENSA Besired C D E a Celular UK PERKY 1. The world! WWWWWWWWWW Nunca -- Csitten noe for Your ! -2. Which will surt? 1 Calculate the net inanie to read 2 which companwl path WMNI of nutnost 47 o-l. Calculehe 24 W Curswet 2. What the lipesz boku no Ya 3.ee sheet 5-1 Cabr the red vrange of the December that 52. Which comparire of the December 4. balance sheet shut 6. Whccomo leport the loweza Ouro cochon Property Stics on the ear 3 sterrentocochows? Campion this question by astring your answers in the tabs below. EXTRA B od Bad Pused >1. Oke retirer un C 12 cm 3-2. Wishampa wimport that our nations for wear ? Here H1 Carper; CURRY Campec complete this question by taring your answers in the tabs below. Pequins Paide Bac Red Band J-3. Cabot Uber. Wer 4 4-2Where to come le 31, 4, Rwand Corsa Surat Required