Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Beg TB cycie Path, Inc. went into business as a corporation in early 2017 For the first few years, the corrany provided bicycle rental and
Beg TB cycie Path, Inc. went into business as a corporation in early 2017 For the first few years, the corrany provided bicycle rental and repair services only (no merchandise Dung 2020, the company began selling bicycles and related gear, and decided to use the FIFO Inventory method the other worksheets include the following SheetNam 1 Cycle Path's trial balance on January 2020, Badkground info 2 A list of events that occurred during 2020. Events Background info An accounting equation grid for you to analyze the imeacts of the events Grid Completion Required Note check fotos on rows 32-56 4 A worksheet to analyze the cost of inventory and the cost of goods sold Inventory completion Required enough rows ore provided ofter och event is a membentory lovers or the costs 5 A worksheet to prepare appropriate transaction and adjusting jours entre JES Completion Required 6 Aworksheet to prepare the 2020 Adjusted Trial Balance Complete Required 7 Worksheets to prepare the 2020 financal statement Finst Completion Required 8 A worksheet to prepare the 2020 closing ouma entre Closing Completion Required Ad TB LG Facebook HHH Shown below is the Post-Closing Trial Balance for Cycle Path at the end of 2019 Cycle Path, Inc. Post-Closing Trial Balance as of December 31, 2019 Account Debit Credit Cash 12,410 Accounts receivable 2,380 Supplies 153 Prepaid rent 680 Inventory 0 Land 3,400 Accounts payable 0 Salaries payable 384 Unearned revenue 765 Common stock 6,800 Retained earnings 10,574 Dividends declared 0 Service revenue Product Sales Costcods sold Suppl pense Salaries expense Rent expense Utilities expense Advertising expense Other operating expenses TOTALS 19,023 19,023 00 WOOOOOOO Bookmarks People Tob Window C Cycle Path, Inc. Went Inta Busix My Home X + s/70070/assignments/423238 Facebook er TV V.. 5 SIRS: Teen Depre... Ta Torrente be... Apple iCloud TOUWS EVENTOS a) Jan 6, 2020-Cycle Path paid the salaries povable b) an. 14, 2020 - The company acquired an additions cash from the sue of common stock d) e) Jan, 17, 2020 - The company paid $765 cash for sup e used by the business Jan. 21, 2020-Cycle Path purchased 35 bicycles and pear for later sale at a cost of $16,142. The bicycles and related gear were purchased on account with the terms 1/10, 30, Jan. 29, 2020-Cycle Path decided to pay $4,200 of its accounts payable balance from event (d) before the discount period expired, so Cycle Pathfirst applied the discount to the $4,200 amount so it could reduce its accounts payable balance (note: the actual payment is described in event below). After applying this discount, Cycle Path's inventory cost was $460 for each item See n Jan. 29, 2020-Cycle Path paid cash to settle parts of its accounts payable balance as described in event le & Feb 12, 2020 - The company sold 24 bleycles and related gear for a total price of $15,300. Sales of $11,050 were an account, while $4,250 were cash sales. Record gevenue Feb. 12. 2020. The cost to Cycle Path of each product sold in event it) was $460. Feb 17, 2020. The company paid the workers a total of $7.140 in salaries Feb 28, 2020. The company provided $30,600 of bicycle rental and repair services. The services were billed to the customers, Mar 1, 2020-Cycle Path rented a business var paying $4,080 in advance for a one year rental Mar 3, 2020. Pald cash to settle additional accounts payable in the amount of $3.213. The payment was made after the discount period expired. m Mar 11, 2020 - Collected $32,300 of accounts receivable 1) Apr .2020-Cycle Path performed 511,000 worth of bicycle rental and repair services for a local college: 510,200 was on account and 51,700 was for cash o) May 1, 2020. Pald 56,120 for one year's rent on office space in advance p) May 6.2020 Cycle Path purchased and paid cash for 8 bicycles and related rear for later sale at a cost of $ each d) May 17, 2020. The company paid accounts payable of $1,224, but not within the discount period the company uses the cross method). 1) Jun 1, 2020 Cycle Path rented larger building, pad 55.610 for 2 months' rent in advance 5) Jun 5, 2020. Cyce Path purchased, and aid cash for 12 bicycles and related tear for later sale at a cost of $180 each 1) lun. 12. 2020.cycle Path purchased 15 bicycles and feated near for later sale at a cost of $486 each The purchase was on account u Juri 23, 2020 - the camry old 32 bicycles and related Bear for a total price of $23,00 Sales of $17,000 were on account while 36,800 were cash sales Record revenue Jun 23, 2020. Record the cost of goods told related to the sale from event using the perpetual method w 2020 Made a refund to a tied user who returned bicyle. The sale had been a cash sale for $935 with cost of $480 Record the revenue part of the event 81 Jul 1, 2020-Made a refund to a difed customer who returned a bicycle. The sale had been cash sale for $935 with a cost of $400 Hecord the cost part of the vert 15.2020: l'aidemolovees total of $9,350 tasks for allemloyee earned during the current Red Aud 24.2020. Provided $22.000 or blodetelor service de the year. The seces were bled to the custom 1 20.2020 Recoin aed 5680 office revende sted dunettes nine months of the year ad been colected in the for year X x My Home C Cycle Path, Inc. Went Into Bus X eurs/70010/assignments/423238 Turer TV V... SIRS: Teen Depre... TO Torroed: the be... 5 Apple iCloud Faceboo nad been conected in the prior year bb) Oct. 1, 2020 - Sold additional bicycle rental and repair services worth $340 for one year's service, starting immediately. The customers paid cash for the full amount. c) Nov. 13, 2020 - Collected $43,350 of accounts receivable. dd) Nov. 20, 2020 - Pald an additional $4,675 to settle some accounts payable; the payment was made after the discount period expired. ee) Dec, 27, 2020 - Paid $2,380 of advertising expense during the year. ) Dec. 28, 2020 - Paid $3,553 of utilities expense for the year. gg) Dec. 28, 2020 - Paid $10,600 of other operating expense for the year. hh) Dec. 29, 2020 - Paid a dividend of $10,200 to the shareholders ii) Dec. 31, 2020 - There was $537 of supplies on hand at the end of the year i Dec. 31, 2020 - Recognized the expired rent from the prior year, van event (kl. office space (event (ol. and the building event r) for the year. k) Dec 31, 2020 - Recognized revenue for the current year earned from event (bb). 10 Dec 31, 2020 - Accrued salaries at December 31 were $1,020. Help 00 Tue Nov 3 2 53 56 PM 2400 Pro al 2020 (Read-Only) L- AH BS Layout Tables Charts Data NE CH How NI B Footting Read-On 542 Ternate and strate al : f w IT * . TH WI WH pro MacBook Pro 2400 Proj 2 Fall 20 2.2. KG 100% Home Layout Tables SmartArt Formulas Data Charts Font Review Edit FU Alignment alic - Call Body 11 Wrap Text Nun Paste Clear BU Merge H Value Balance $16,142 516,100 55,060 8 & Read-Only To create and edit, please activate Excel B5 . fx D E F G 1 Below is worksheet to analyze the cost of inventory and the cost of goods sold. 2 Remember, Cycle Path uses the FIFO inventory method. 3 (hintenter purchases as positive quantities and sales as negative quantities Event Quantity Value Unit Cost 4 Change Quantity Balance 5 35 $461,20 SIG.142 35 @ $46L 20 e) discount $4,200.00 19421 350 $460.00 7 hl (24) 5460,00 15110401 115460.00 el 9 2 10 11 3) 12 113 2014 1) 15 16 17 18 19 20 21 22 x 23 24 25 26 27 28 29 20 view Nurger F Date 96 Cengional Forming Home Layout Tables Charts mulas Date Font Art Fi Calor (30 wa Ted Clear RTU Merge Read-Only To create and edit, please activate Ex 89 : * fx D Use the worksheet below to prepare the propriate transaction dating force Path Fortuna entre, you must only use from the Chart of Antinors, and you must only use Accounting Equation act codes from the cell the 2 Jan 2020. Path paid the sales payable from 2019. Date Ba Acct 3 Esimos Account Names Dets dedits 1/5/20 Solarles Payable 5 Cash G completed as a comple 7 bi Jan 14, 2070. The company acquired an additional 542.500 cash from the common Date Bauc Acai S Account Names Debu des M Chart of Account Haut Act Eg Impact 100 cash A+ Atsup A As down LE Cap Les down SE Equity Sou down 10 11 12 110 Recette 120 Prepaid rent 130 Supphandl 140 250 Lt 15 fou 170 Ho Acourts Pay 210 SP 240 Lemed leven 20 Naya 30 on Red 30 dered MR. 17. 2020 - The comfort sed by the bus Et Date La imate Account Name: Debes Greth 13 14 15 16 dh 17 Ian. 21, 2020-yde Paperche des and related performer 1610 hbcles and related ar were purchased an out with the terms 1/10, 1/30 Dune BA Account Names bebe SIOS 520 Product 19 20 21 Coro 010 w table Jan 29, 2020 - Cod Poth decided to 54,200 of its contable balance from ved before the period expired recycle Puth first applied the discount to the $4,200 anosit could reducunya balance in the actualment is described in eventbrow Anetapalying the Chile's 550 sventory cost was $450 each item Baie Act Date De Account Names pat Credits 600 Instructions Grid boy Ad TB Fin SE Cloung+ om Ready Sum 23 MacBook Pro um Det %3 Doodle Formats M Chart of Accounts Basie Act Eg Impact 100% Home Layout Tables Formulas Date Alguneet Full Calcon Wrap Test- Clear u Merge 53 Read-Only To create and edit, please activate Excel B9 : A Use the worksheet below to prepare the appropriate transaction and more for ydeputh for journal G entries, you must only account names from the Chart of Accountains the 125, and you must only one 1 Accounting Equation impact codes from the listincts the 22 Jan. 29, 2020-Cycle Path paid cash to settle parts of its accounts payable balance described event Bati Acct 28 Date Eats Account Names bebits Credits 29 30 31 Feb 12, 2020 - The company sold 24 bicycles and related gear for a total price of $15,300. Sales of $11.05 were 32 account, while 4.250 were cath sales. Record revenue Date Bate Act Account Names 33 Eghoacts Debits Credits 34 as 36 32 N) Feb. 12. 2020. The cost to Cycle Path of each product sold in event was $460 Date Basi Acet Account Names Debits 38 Empacts Credits 39 40 42 0 Feb. 17, 2020. The company bad the workers a total of 57,140 in salaries Date si Act Account Names Credits Le impacts 44 45 46 Feb. 28, 2020 - The company provided $30,600 of bicycle rental and repair services. The services were bilied to the customers i Acct Date Account Names Debits 48 Compact so Beg TB Events Grid Inventory PES Adj TS Fins Closing + BE Instructions Ready Normal View Sun MacBook Pro Number Date HI Chart of Accounts F Algement Calib ab Wrap Text- Paste Clear B Merge * Read-Only To create an adit, please activate Excel B9 28 OC A B D Use the worksheet below to prepare the appropriate transaction and adjusting journal entries for Cycle Path. For journal entries, you must only use account names from the Chart of Account in cells thru 25, and you must only use Base 1 Accounting Equation impact codes from the list in cells thru 52 Mar. 1, 2020-Cycle Path rented a business van, paying $4,080 in advance for a one year rental. Basie Acct 53 Date Eq impacts Account Names Debits Credits 54 SS 56 Mar. 3, 2020 - Paid cash to settle additional accounts payable in the amount of 53.213. The payment was made after 57 the discount period expired. Basic Acet SB Date Elimpacts Account Names Debits Credits 59 60 61 62 Mar. 11. 2020 - Collected $32,300 of accounts receivable. Basic Acet Date Eg Impacts Account Names Debits Credits 64 65 66 Apr. 9,2020 Cycle Path performed $11.900 worth of bicycle rental and repair services for a local colleges $10,200 67 was on account and $1,700 was for cash. Basic Acct Date Account Names Debits Credits 68 Eg Impacts 69 70 5 SC BBD RENRE 72 o) May. 1. 2020. Paid 56,120 for one year's rent on office space in advance Date Basic Acct Account Names Debits E Impacts Credits 473 74 75 Beg TR Events Grid Inventory ES ATA Fin SA Closing Instructions Ready Normal View Edit SA Formulas Font Review F Data Alignment abc 33 Paste Wrap Text Clear Number Merge E H * Read-Only To create and edit, please activate Excel 88 fx A B D 1 Use the worksheet below to prepare the Adjusted Trial Balance for Cycle Path 3 Cyde Path, Inc. 4 Adjusted Trial Balance 5 as of December 31, 2020 6 7 Account Debit Credit 18 Cash 9 Accounts receivable 1. 1 10 Supplies 11 Prepaid rent 12 Inventory 13 Land 141 Accounts payable 15 Salaries payable 216 Unearned revenue 17 Common stock 18 Retained earnings 19 Dividends declared 20 Service revenue 21 Product sales 22 Cost of goods sold 23 Supplies expense 24 Salaries experise 25 Rent expense 126 Utilities expense 27 Advertising expense 28 Other operating expenses 29 TOTALS 30 31 32 34 35 36 37 3.8 in Sosing Excel File Edit View nat Tools Data Window Help 2400 Proj 2 Fall 2020 (1).xlsx 100% Home 2:25 Layout G Tables Charts Edit SmartArt Formulas Font Review Full Cal Boy Data Agent Nomor Paste Wrap Text General 83 Read-Only Marge A1 To create and edit, please activate Excel . 4 Income Statement 5 For the Year Ended December 31, 2020 5 Service revenge 7 Product sales, et 8 Cost of Goods 9 Gross Marga 10 Suppliesenie 11 Sense 12 Rentes 13 Uutis expense 14 A 15 Other operating 16 Nutcome Balance Sheet As of December 31, 2020 Cat Accounts receivable Les Preparent tnwestory Land TOTAL ASSETS Ronale Seres payable Subtotal thened and Caminen och TOTAL LAWITIES & EQUITY 18 Cycle Puth, Inc 19 Statement of Changes in Stockholders' Equity 20 For the Year Ended December , 2020 21 Beginning Comman ock 22 Plus Common wood 23 Ending Common stock 24 Betinin retained in 25 Puma 26 Low Dividends 27 Ending Retained Earnings 28 TOTAL STOCKHOLDERS' EQUITY Cycle Path, in Statement of Cash Flow For the Year Ended December 2020 Cash flow fromageries Cash forces No cash flow from species 30 Natash flow from sa 32 43 34 Garhw.fram financing activities Catherm stocket Ghamento dividende Net cash flow fra financing activities 17 38 Neincrease inch Bag TA fants Gruntary Novi Tas Closing Ready MacBook Pro FUL A Home Tables Charts Font Review Cody Narber Fama Wrap Text General Paste BTU Merge 96 Cerca Format Read-Only CA To create and edit, please activate Excel : * fx RI N Q Chat other Die Ant | 1 2 Use the wondheet below to prepare the propriedeling for you for almal met you only use Mames from the Chart of Accounts in this and you must only use an Accompact codes from the list in cele 2 Close revenue count Rasia Dube Account Name La impacts Cri 12/10 A. Asp A At 4 Leup 100 Caith 110 cm 130 Paltres 110 340 150 155 A bepec 6 7 Up Close expense counts Date Basie Act Es impacta 12/31/20 Account es Db Credit 9 10 11 12 13 220 220 30 318 15 16 22 410 311 d) Close dividends account Basic Act Date Accomes Gede 18 FO 30 TO SA end IS COM 20 SUGGE 22 23 24 ON 26 27 29 Fus AETH Geld Instructions very Coin Beg Turun Sumo MacBook Pro Beg TB cycie Path, Inc. went into business as a corporation in early 2017 For the first few years, the corrany provided bicycle rental and repair services only (no merchandise Dung 2020, the company began selling bicycles and related gear, and decided to use the FIFO Inventory method the other worksheets include the following SheetNam 1 Cycle Path's trial balance on January 2020, Badkground info 2 A list of events that occurred during 2020. Events Background info An accounting equation grid for you to analyze the imeacts of the events Grid Completion Required Note check fotos on rows 32-56 4 A worksheet to analyze the cost of inventory and the cost of goods sold Inventory completion Required enough rows ore provided ofter och event is a membentory lovers or the costs 5 A worksheet to prepare appropriate transaction and adjusting jours entre JES Completion Required 6 Aworksheet to prepare the 2020 Adjusted Trial Balance Complete Required 7 Worksheets to prepare the 2020 financal statement Finst Completion Required 8 A worksheet to prepare the 2020 closing ouma entre Closing Completion Required Ad TB LG Facebook HHH Shown below is the Post-Closing Trial Balance for Cycle Path at the end of 2019 Cycle Path, Inc. Post-Closing Trial Balance as of December 31, 2019 Account Debit Credit Cash 12,410 Accounts receivable 2,380 Supplies 153 Prepaid rent 680 Inventory 0 Land 3,400 Accounts payable 0 Salaries payable 384 Unearned revenue 765 Common stock 6,800 Retained earnings 10,574 Dividends declared 0 Service revenue Product Sales Costcods sold Suppl pense Salaries expense Rent expense Utilities expense Advertising expense Other operating expenses TOTALS 19,023 19,023 00 WOOOOOOO Bookmarks People Tob Window C Cycle Path, Inc. Went Inta Busix My Home X + s/70070/assignments/423238 Facebook er TV V.. 5 SIRS: Teen Depre... Ta Torrente be... Apple iCloud TOUWS EVENTOS a) Jan 6, 2020-Cycle Path paid the salaries povable b) an. 14, 2020 - The company acquired an additions cash from the sue of common stock d) e) Jan, 17, 2020 - The company paid $765 cash for sup e used by the business Jan. 21, 2020-Cycle Path purchased 35 bicycles and pear for later sale at a cost of $16,142. The bicycles and related gear were purchased on account with the terms 1/10, 30, Jan. 29, 2020-Cycle Path decided to pay $4,200 of its accounts payable balance from event (d) before the discount period expired, so Cycle Pathfirst applied the discount to the $4,200 amount so it could reduce its accounts payable balance (note: the actual payment is described in event below). After applying this discount, Cycle Path's inventory cost was $460 for each item See n Jan. 29, 2020-Cycle Path paid cash to settle parts of its accounts payable balance as described in event le & Feb 12, 2020 - The company sold 24 bleycles and related gear for a total price of $15,300. Sales of $11,050 were an account, while $4,250 were cash sales. Record gevenue Feb. 12. 2020. The cost to Cycle Path of each product sold in event it) was $460. Feb 17, 2020. The company paid the workers a total of $7.140 in salaries Feb 28, 2020. The company provided $30,600 of bicycle rental and repair services. The services were billed to the customers, Mar 1, 2020-Cycle Path rented a business var paying $4,080 in advance for a one year rental Mar 3, 2020. Pald cash to settle additional accounts payable in the amount of $3.213. The payment was made after the discount period expired. m Mar 11, 2020 - Collected $32,300 of accounts receivable 1) Apr .2020-Cycle Path performed 511,000 worth of bicycle rental and repair services for a local college: 510,200 was on account and 51,700 was for cash o) May 1, 2020. Pald 56,120 for one year's rent on office space in advance p) May 6.2020 Cycle Path purchased and paid cash for 8 bicycles and related rear for later sale at a cost of $ each d) May 17, 2020. The company paid accounts payable of $1,224, but not within the discount period the company uses the cross method). 1) Jun 1, 2020 Cycle Path rented larger building, pad 55.610 for 2 months' rent in advance 5) Jun 5, 2020. Cyce Path purchased, and aid cash for 12 bicycles and related tear for later sale at a cost of $180 each 1) lun. 12. 2020.cycle Path purchased 15 bicycles and feated near for later sale at a cost of $486 each The purchase was on account u Juri 23, 2020 - the camry old 32 bicycles and related Bear for a total price of $23,00 Sales of $17,000 were on account while 36,800 were cash sales Record revenue Jun 23, 2020. Record the cost of goods told related to the sale from event using the perpetual method w 2020 Made a refund to a tied user who returned bicyle. The sale had been a cash sale for $935 with cost of $480 Record the revenue part of the event 81 Jul 1, 2020-Made a refund to a difed customer who returned a bicycle. The sale had been cash sale for $935 with a cost of $400 Hecord the cost part of the vert 15.2020: l'aidemolovees total of $9,350 tasks for allemloyee earned during the current Red Aud 24.2020. Provided $22.000 or blodetelor service de the year. The seces were bled to the custom 1 20.2020 Recoin aed 5680 office revende sted dunettes nine months of the year ad been colected in the for year X x My Home C Cycle Path, Inc. Went Into Bus X eurs/70010/assignments/423238 Turer TV V... SIRS: Teen Depre... TO Torroed: the be... 5 Apple iCloud Faceboo nad been conected in the prior year bb) Oct. 1, 2020 - Sold additional bicycle rental and repair services worth $340 for one year's service, starting immediately. The customers paid cash for the full amount. c) Nov. 13, 2020 - Collected $43,350 of accounts receivable. dd) Nov. 20, 2020 - Pald an additional $4,675 to settle some accounts payable; the payment was made after the discount period expired. ee) Dec, 27, 2020 - Paid $2,380 of advertising expense during the year. ) Dec. 28, 2020 - Paid $3,553 of utilities expense for the year. gg) Dec. 28, 2020 - Paid $10,600 of other operating expense for the year. hh) Dec. 29, 2020 - Paid a dividend of $10,200 to the shareholders ii) Dec. 31, 2020 - There was $537 of supplies on hand at the end of the year i Dec. 31, 2020 - Recognized the expired rent from the prior year, van event (kl. office space (event (ol. and the building event r) for the year. k) Dec 31, 2020 - Recognized revenue for the current year earned from event (bb). 10 Dec 31, 2020 - Accrued salaries at December 31 were $1,020. Help 00 Tue Nov 3 2 53 56 PM 2400 Pro al 2020 (Read-Only) L- AH BS Layout Tables Charts Data NE CH How NI B Footting Read-On 542 Ternate and strate al : f w IT * . TH WI WH pro MacBook Pro 2400 Proj 2 Fall 20 2.2. KG 100% Home Layout Tables SmartArt Formulas Data Charts Font Review Edit FU Alignment alic - Call Body 11 Wrap Text Nun Paste Clear BU Merge H Value Balance $16,142 516,100 55,060 8 & Read-Only To create and edit, please activate Excel B5 . fx D E F G 1 Below is worksheet to analyze the cost of inventory and the cost of goods sold. 2 Remember, Cycle Path uses the FIFO inventory method. 3 (hintenter purchases as positive quantities and sales as negative quantities Event Quantity Value Unit Cost 4 Change Quantity Balance 5 35 $461,20 SIG.142 35 @ $46L 20 e) discount $4,200.00 19421 350 $460.00 7 hl (24) 5460,00 15110401 115460.00 el 9 2 10 11 3) 12 113 2014 1) 15 16 17 18 19 20 21 22 x 23 24 25 26 27 28 29 20 view Nurger F Date 96 Cengional Forming Home Layout Tables Charts mulas Date Font Art Fi Calor (30 wa Ted Clear RTU Merge Read-Only To create and edit, please activate Ex 89 : * fx D Use the worksheet below to prepare the propriate transaction dating force Path Fortuna entre, you must only use from the Chart of Antinors, and you must only use Accounting Equation act codes from the cell the 2 Jan 2020. Path paid the sales payable from 2019. Date Ba Acct 3 Esimos Account Names Dets dedits 1/5/20 Solarles Payable 5 Cash G completed as a comple 7 bi Jan 14, 2070. The company acquired an additional 542.500 cash from the common Date Bauc Acai S Account Names Debu des M Chart of Account Haut Act Eg Impact 100 cash A+ Atsup A As down LE Cap Les down SE Equity Sou down 10 11 12 110 Recette 120 Prepaid rent 130 Supphandl 140 250 Lt 15 fou 170 Ho Acourts Pay 210 SP 240 Lemed leven 20 Naya 30 on Red 30 dered MR. 17. 2020 - The comfort sed by the bus Et Date La imate Account Name: Debes Greth 13 14 15 16 dh 17 Ian. 21, 2020-yde Paperche des and related performer 1610 hbcles and related ar were purchased an out with the terms 1/10, 1/30 Dune BA Account Names bebe SIOS 520 Product 19 20 21 Coro 010 w table Jan 29, 2020 - Cod Poth decided to 54,200 of its contable balance from ved before the period expired recycle Puth first applied the discount to the $4,200 anosit could reducunya balance in the actualment is described in eventbrow Anetapalying the Chile's 550 sventory cost was $450 each item Baie Act Date De Account Names pat Credits 600 Instructions Grid boy Ad TB Fin SE Cloung+ om Ready Sum 23 MacBook Pro um Det %3 Doodle Formats M Chart of Accounts Basie Act Eg Impact 100% Home Layout Tables Formulas Date Alguneet Full Calcon Wrap Test- Clear u Merge 53 Read-Only To create and edit, please activate Excel B9 : A Use the worksheet below to prepare the appropriate transaction and more for ydeputh for journal G entries, you must only account names from the Chart of Accountains the 125, and you must only one 1 Accounting Equation impact codes from the listincts the 22 Jan. 29, 2020-Cycle Path paid cash to settle parts of its accounts payable balance described event Bati Acct 28 Date Eats Account Names bebits Credits 29 30 31 Feb 12, 2020 - The company sold 24 bicycles and related gear for a total price of $15,300. Sales of $11.05 were 32 account, while 4.250 were cath sales. Record revenue Date Bate Act Account Names 33 Eghoacts Debits Credits 34 as 36 32 N) Feb. 12. 2020. The cost to Cycle Path of each product sold in event was $460 Date Basi Acet Account Names Debits 38 Empacts Credits 39 40 42 0 Feb. 17, 2020. The company bad the workers a total of 57,140 in salaries Date si Act Account Names Credits Le impacts 44 45 46 Feb. 28, 2020 - The company provided $30,600 of bicycle rental and repair services. The services were bilied to the customers i Acct Date Account Names Debits 48 Compact so Beg TB Events Grid Inventory PES Adj TS Fins Closing + BE Instructions Ready Normal View Sun MacBook Pro Number Date HI Chart of Accounts F Algement Calib ab Wrap Text- Paste Clear B Merge * Read-Only To create an adit, please activate Excel B9 28 OC A B D Use the worksheet below to prepare the appropriate transaction and adjusting journal entries for Cycle Path. For journal entries, you must only use account names from the Chart of Account in cells thru 25, and you must only use Base 1 Accounting Equation impact codes from the list in cells thru 52 Mar. 1, 2020-Cycle Path rented a business van, paying $4,080 in advance for a one year rental. Basie Acct 53 Date Eq impacts Account Names Debits Credits 54 SS 56 Mar. 3, 2020 - Paid cash to settle additional accounts payable in the amount of 53.213. The payment was made after 57 the discount period expired. Basic Acet SB Date Elimpacts Account Names Debits Credits 59 60 61 62 Mar. 11. 2020 - Collected $32,300 of accounts receivable. Basic Acet Date Eg Impacts Account Names Debits Credits 64 65 66 Apr. 9,2020 Cycle Path performed $11.900 worth of bicycle rental and repair services for a local colleges $10,200 67 was on account and $1,700 was for cash. Basic Acct Date Account Names Debits Credits 68 Eg Impacts 69 70 5 SC BBD RENRE 72 o) May. 1. 2020. Paid 56,120 for one year's rent on office space in advance Date Basic Acct Account Names Debits E Impacts Credits 473 74 75 Beg TR Events Grid Inventory ES ATA Fin SA Closing Instructions Ready Normal View Edit SA Formulas Font Review F Data Alignment abc 33 Paste Wrap Text Clear Number Merge E H * Read-Only To create and edit, please activate Excel 88 fx A B D 1 Use the worksheet below to prepare the Adjusted Trial Balance for Cycle Path 3 Cyde Path, Inc. 4 Adjusted Trial Balance 5 as of December 31, 2020 6 7 Account Debit Credit 18 Cash 9 Accounts receivable 1. 1 10 Supplies 11 Prepaid rent 12 Inventory 13 Land 141 Accounts payable 15 Salaries payable 216 Unearned revenue 17 Common stock 18 Retained earnings 19 Dividends declared 20 Service revenue 21 Product sales 22 Cost of goods sold 23 Supplies expense 24 Salaries experise 25 Rent expense 126 Utilities expense 27 Advertising expense 28 Other operating expenses 29 TOTALS 30 31 32 34 35 36 37 3.8 in Sosing Excel File Edit View nat Tools Data Window Help 2400 Proj 2 Fall 2020 (1).xlsx 100% Home 2:25 Layout G Tables Charts Edit SmartArt Formulas Font Review Full Cal Boy Data Agent Nomor Paste Wrap Text General 83 Read-Only Marge A1 To create and edit, please activate Excel . 4 Income Statement 5 For the Year Ended December 31, 2020 5 Service revenge 7 Product sales, et 8 Cost of Goods 9 Gross Marga 10 Suppliesenie 11 Sense 12 Rentes 13 Uutis expense 14 A 15 Other operating 16 Nutcome Balance Sheet As of December 31, 2020 Cat Accounts receivable Les Preparent tnwestory Land TOTAL ASSETS Ronale Seres payable Subtotal thened and Caminen och TOTAL LAWITIES & EQUITY 18 Cycle Puth, Inc 19 Statement of Changes in Stockholders' Equity 20 For the Year Ended December , 2020 21 Beginning Comman ock 22 Plus Common wood 23 Ending Common stock 24 Betinin retained in 25 Puma 26 Low Dividends 27 Ending Retained Earnings 28 TOTAL STOCKHOLDERS' EQUITY Cycle Path, in Statement of Cash Flow For the Year Ended December 2020 Cash flow fromageries Cash forces No cash flow from species 30 Natash flow from sa 32 43 34 Garhw.fram financing activities Catherm stocket Ghamento dividende Net cash flow fra financing activities 17 38 Neincrease inch Bag TA fants Gruntary Novi Tas Closing Ready MacBook Pro FUL A Home Tables Charts Font Review Cody Narber Fama Wrap Text General Paste BTU Merge 96 Cerca Format Read-Only CA To create and edit, please activate Excel : * fx RI N Q Chat other Die Ant | 1 2 Use the wondheet below to prepare the propriedeling for you for almal met you only use Mames from the Chart of Accounts in this and you must only use an Accompact codes from the list in cele 2 Close revenue count Rasia Dube Account Name La impacts Cri 12/10 A. Asp A At 4 Leup 100 Caith 110 cm 130 Paltres 110 340 150 155 A bepec 6 7 Up Close expense counts Date Basie Act Es impacta 12/31/20 Account es Db Credit 9 10 11 12 13 220 220 30 318 15 16 22 410 311 d) Close dividends account Basic Act Date Accomes Gede 18 FO 30 TO SA end IS COM 20 SUGGE 22 23 24 ON 26 27 29 Fus AETH Geld Instructions very Coin Beg Turun Sumo MacBook Pro
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e2a6b1b_986668d43e245dca.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e374884_987668d43e307c8d.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e3e8b03_987668d43e3a67de.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e4c31c2_988668d43e435084.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e580980_988668d43e4f3b27.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e635ba1_989668d43e5c2db9.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e6e9346_990668d43e66b681.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e7ad406_991668d43e73a85a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e8c77a4_992668d43e848f79.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43e9665ea_993668d43e901c94.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43ea26e32_993668d43e9a454b.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668d43eaf3f54_994668d43ea6d610.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started