PLEASE SHOW ME THE STEP BY STEP HOW TO DO IT.

2) Inspect this section of an income statement and report to the school leader what their profit/loss is for their study trips by grade level (write a short paragraph explaining it to them, give me an spreadsheet reporting a grade level profit / loss in the next tab). Sample Profit and Loss Answer: Compute the profit/loss for the study trip, by grade. $600.00 $59.79 $3,035.38 Bill Bill $55.50 Bill $1,200.00 Bill $100.00 $2.686.12 $2.674.11 IGNORE CAMPING TRIP - WE ARE ONLY ANALYZING STUDY TRIP Expenses 5830 - Field Trips Expenses Journal 7/1/2014 14 - 15 Camping Trip Deposit, Pacific Skyline Council, Everest Bill 9/9/2014 Aug 14 Camping Trip, A. King, Everest 9/12/2014 Aug 14 Food for Camping Trip, Everest 9/25/2014 Aug 14 Camping Trip, P. Giamoni, Everest 2/23/2015 Jan 15 Study Trip 11 Grade, Boys & Girls of Santa Cruz, Everest Bill 3/10/2015 Mar 15 Study Trip 9 Grade, S.Langley, Everest 3/10/2015 Mar 15 Study Trip 11 Grade, E. Baba, Everest Bill 3/10/2015 Mar 15 Study Trip 11 Grade, P. Giamoni, Everest 3/10/2015 Mar 15 Study Trip 9 Grade, E. Lee, Everest 3/18/2015 Feb 15 Study Trip 10 Grade, A. Heyneman, Everest 3/19/2015 Mar 15 Study Trip 9 Grade, S.Langley, Everest Bill 3/19/2015 Mar 15 Study Trip 10 Grade, C. Schaefer, Everest 3/20/2015 Mar 15 Study Trip 9 Grade, J. Wong, Everest 3/20/2015 Mar 15 Study Trip 9 Grade, N. Balabanian, Everest 3/23/2015 Mar 15 Study Trip 12 Grade, M. Sircar, Everest Bill 3/23/2015 Mar 15 Study Trip 11 Grade, A. Coffee, Everest 3/25/2015 Mar 15 Study Trip 11 Grade, S. Sussman, Everest Bill 3/25/2015 Mar 15 Study Trip 9 Grade, Spartan Shops, Inc., Everest 4/3/2015 Mar 15 Study Trip 11 Grade, T. Hashimoto, Everest Total - 5830 - Field Trips Expenses Bill $501.69 Bill $4,133.24 Bill $114.24 $1,265.13 Bill $316.85 Bill $118.16 Bill $2.228.60 $705.54 Bill $48.81 $1,552.50 Bill $153.52 Revenue 8693 - Field Trips Cash Receipt 8/15/2014 $20.00 Any donation that is 35.00 is 9th Any donation that is 50.00 is 10th Cash Receipt Deposit 8/15/2014 8/20/2014 $40.00 $700.00 Deposit 8/30/2014 $2,350.00 Deposit 8/30/2014 $860.00 9/18/2014 S920.00 $330.00 9/21/2014 Deposit Deposit Deposit Deposit 9/28/2014 $140.00 $80.00 9/28/2014 12/11/2014 Deposit $20.00 $35.00 2/9/2015 2/13/2015 Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt $35.00 $35.00 2/13/2015 2/13/2015 2/13/2015 $50.00 $35.00 Cash Receipt 2/13/2015 Cash Receipt Cash Receipt 2/13/2015 2/13/2015 Camping Trip Payment Camping Trip Payment Aug 14 Camping Trip, Everest Aug 14 Camping, Everest Aug 14 Camping, Everest Sep 14 Camping Trip, Everest Sep 14 Camping Trip, Everest Sep 14 Camping Trip. Everest Sep 14 Camping Trip, Everest Dec 14 Camping Trip, Everest Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Feb 15 Study Trip 9 Grade, Everest Feb 15 Study Trip 9 Grade, Everest Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Mar 15 Study Trip 0. Everest Mar 15 Study Trip 10. Everest Mar 15 Study Trip 11 Grade, Everest Mar 15 Study Trip 9 Grade, Everest Mar 15 Study Trip 11, Everest Mar 15 Study Trip 10 Grade, Everest Mar 15 Study Trip 11 Grade, Everest $50.00 $50.00 $35.00 2/13/2015 $50.00 Cash Receipt Cash Receipt 2/13/2015 $35.00 Cash Receipt $35.00 2/13/2015 2/13/2015 2/16/2015 Cash Receipt Deposit $50.00 $730.00 Deposit 2/18/2015 $1,360.00 $50.00 Cash Receipt 2/28/2015 Cash Receipt 3/17/2015 $35.00 3/17/2015 $250.00 Deposit Deposit Deposit 3/17/2015 $1,130.00 3/17/2015 $750.00 Deposit 3/17/2015 $165.00 3/17/2015 $900.00 Deposit Deposit 3/17/2015 $2,085.00 3/31/2015 $2,320.00 Deposit Total - 8693 - Field Trips 2) Inspect this section of an income statement and report to the school leader what their profit/loss is for their study trips by grade level (write a short paragraph explaining it to them, give me an spreadsheet reporting a grade level profit / loss in the next tab). Sample Profit and Loss Answer: Compute the profit/loss for the study trip, by grade. $600.00 $59.79 $3,035.38 Bill Bill $55.50 Bill $1,200.00 Bill $100.00 $2.686.12 $2.674.11 IGNORE CAMPING TRIP - WE ARE ONLY ANALYZING STUDY TRIP Expenses 5830 - Field Trips Expenses Journal 7/1/2014 14 - 15 Camping Trip Deposit, Pacific Skyline Council, Everest Bill 9/9/2014 Aug 14 Camping Trip, A. King, Everest 9/12/2014 Aug 14 Food for Camping Trip, Everest 9/25/2014 Aug 14 Camping Trip, P. Giamoni, Everest 2/23/2015 Jan 15 Study Trip 11 Grade, Boys & Girls of Santa Cruz, Everest Bill 3/10/2015 Mar 15 Study Trip 9 Grade, S.Langley, Everest 3/10/2015 Mar 15 Study Trip 11 Grade, E. Baba, Everest Bill 3/10/2015 Mar 15 Study Trip 11 Grade, P. Giamoni, Everest 3/10/2015 Mar 15 Study Trip 9 Grade, E. Lee, Everest 3/18/2015 Feb 15 Study Trip 10 Grade, A. Heyneman, Everest 3/19/2015 Mar 15 Study Trip 9 Grade, S.Langley, Everest Bill 3/19/2015 Mar 15 Study Trip 10 Grade, C. Schaefer, Everest 3/20/2015 Mar 15 Study Trip 9 Grade, J. Wong, Everest 3/20/2015 Mar 15 Study Trip 9 Grade, N. Balabanian, Everest 3/23/2015 Mar 15 Study Trip 12 Grade, M. Sircar, Everest Bill 3/23/2015 Mar 15 Study Trip 11 Grade, A. Coffee, Everest 3/25/2015 Mar 15 Study Trip 11 Grade, S. Sussman, Everest Bill 3/25/2015 Mar 15 Study Trip 9 Grade, Spartan Shops, Inc., Everest 4/3/2015 Mar 15 Study Trip 11 Grade, T. Hashimoto, Everest Total - 5830 - Field Trips Expenses Bill $501.69 Bill $4,133.24 Bill $114.24 $1,265.13 Bill $316.85 Bill $118.16 Bill $2.228.60 $705.54 Bill $48.81 $1,552.50 Bill $153.52 Revenue 8693 - Field Trips Cash Receipt 8/15/2014 $20.00 Any donation that is 35.00 is 9th Any donation that is 50.00 is 10th Cash Receipt Deposit 8/15/2014 8/20/2014 $40.00 $700.00 Deposit 8/30/2014 $2,350.00 Deposit 8/30/2014 $860.00 9/18/2014 S920.00 $330.00 9/21/2014 Deposit Deposit Deposit Deposit 9/28/2014 $140.00 $80.00 9/28/2014 12/11/2014 Deposit $20.00 $35.00 2/9/2015 2/13/2015 Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt $35.00 $35.00 2/13/2015 2/13/2015 2/13/2015 $50.00 $35.00 Cash Receipt 2/13/2015 Cash Receipt Cash Receipt 2/13/2015 2/13/2015 Camping Trip Payment Camping Trip Payment Aug 14 Camping Trip, Everest Aug 14 Camping, Everest Aug 14 Camping, Everest Sep 14 Camping Trip, Everest Sep 14 Camping Trip, Everest Sep 14 Camping Trip. Everest Sep 14 Camping Trip, Everest Dec 14 Camping Trip, Everest Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Feb 15 Study Trip 9 Grade, Everest Feb 15 Study Trip 9 Grade, Everest Suggested donation for Spring Study Trip Suggested donation for Spring Study Trip Mar 15 Study Trip 0. Everest Mar 15 Study Trip 10. Everest Mar 15 Study Trip 11 Grade, Everest Mar 15 Study Trip 9 Grade, Everest Mar 15 Study Trip 11, Everest Mar 15 Study Trip 10 Grade, Everest Mar 15 Study Trip 11 Grade, Everest $50.00 $50.00 $35.00 2/13/2015 $50.00 Cash Receipt Cash Receipt 2/13/2015 $35.00 Cash Receipt $35.00 2/13/2015 2/13/2015 2/16/2015 Cash Receipt Deposit $50.00 $730.00 Deposit 2/18/2015 $1,360.00 $50.00 Cash Receipt 2/28/2015 Cash Receipt 3/17/2015 $35.00 3/17/2015 $250.00 Deposit Deposit Deposit 3/17/2015 $1,130.00 3/17/2015 $750.00 Deposit 3/17/2015 $165.00 3/17/2015 $900.00 Deposit Deposit 3/17/2015 $2,085.00 3/31/2015 $2,320.00 Deposit Total - 8693 - Field Trips