Autosave D () @ '? v Home Insert Draw Page Layout Formulas Data Review View Automate Module 4 Assignment v e Calibri (Body) vz v A General v w oy Paste B I Uwv A v o Conditional Format Cell o L s Formatting as Table B7 = fx A B C D E B G H I J 1 |Purple Pineapple Co. has decided to sell Fragrance as well. The following transactions occurred during the 2 |month of May. Record each transaction listed below to show its impact on the accounting equation in the table 3 |provided. Record all entries that affect Cash Flows For any entry that impacts Retained Earnings, write a brief 4 description in the column provided. S, 6 7 4-May| ! Sold merchandise to Lucy's Department Store on account for $4,000, terms 2/10, n/30. The 8 16-May merchandise had cost Carol's $1,500 Sold merchandise to a customer for cash, $500. The merchandise had cost The Purple Pineapple 9 18-May Co., $200 Customer returned $200 of the merchandise from the sale on May 18 and was given a refund. 10 19-May The merchandise had cost $75. 11 26-May Received full amount due from Lucy's Department Store with discount 12 27-May Paid shipping charges on merchandise purchased on May 4, $450. Recorded the shrinkage adjustment. The inventory on hand as determined by taking a physical 13 30-May inventory at the end of May is $6000 14 15 16 17 Purple Pineapple Co. 18 Assets = liabilities + Stockholders Equity Estimate Customer Cash Flow Accounts Returns Account Refunds 19 Statement |Date Cash Receivable |Inventory |Inventory |Payable Payable Retained Earnings Income Statement 20 21 22 23 24 25 26 27 CH4 Transactions Additional Questions CH4 o Enter fi Accessibility: Investigate Styles Insert Delete Format v >v Sort & & v Filter Search (Cmd + Ctrl + U) /Qv () Comments Find & Sensitivity Add-ins Select N o B [ c o &4 Analyze Data Q + 120% AutoSave O A A P J . C ... xModule 4 Assignment Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share Calibri (Body) v 12 AA 207 V Insert v ab v General x Delete v Paste BIUV V Av $ ~ % 9 Conditional Format Cell Find & Sensitivity Analyze E Sort & Add-ins Formatting as Table Styles Format Filter Select Data B7 4 X V fx A B C D E F G H I J K L M N O P Q 16 17 Purple Pineapple Co. 18 Assets = liabilities + Stockholders Equity Estimate Customer Cash Flow Accounts Returns Account Refunds 19 Statement Date Cash Receivable Inventory Inventory Payable Payable Retained Earnings Income Statement 20 21 22 23 24 25 26 30 33 34 35 C 36 d 37 e 38 f 39 8 40 h 41 i 42 j 43 44 45 The following data for the current year ended December 31, 2016, was extracted 46 from the accounting records of Defender Co.: torn non CH4 Transactions Additional Questions CH4 + 120% Enter Accessibility: Investigate +AutoSave O A A P J . C ... xModule 4 Assignment Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share Insert v Calibri (Body) v 12 AA ab v General x Delete v Analyze Paste B I UVV Av E $ ~ % " Conditional Format Cell Sort & Find & Sensitivity Add-ins Formatting as Table Styles Format Filter Select Data B7 4 X V fx A B C D E F G H I J K L M N O P Q 39 8 40 h 41 i 42 j 43 44 45 The following data for the current year ended December 31, 2016, was extracted 46 from the accounting records of Defender Co.: 47 Cost of merchandise sold $950,000 48 Operating expenses 276,332 49 Sales 1,230,250 50 Prepare a multiple-step income statement for the year ended December 31, 2016. 51 52 Defender Co. 53 Income Statement 54 For the Year Ended December 31, 2016 55 Sales 56 Cost of merchandise sold 57 Gross profit 58 Operating expenses 59 Net income / loss 60 61 62 63 64 65 66 67 68 69 70 71 D CH4 Transactions Additional Questions CH4 + + 120% Enter Ex Accessibility: InvestigateAutoSave O A A P J . C ... xModule 4 Assignment Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share AA Insert v Calibri (Body) v 12 =1 g v General ZY AP- O. Ex Delete v Paste BIUV VAv EE $ ~ % " Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v v Filter Select Data 126 fx A B C D E F G H I J K L M N P Q R S T Details of invoices for purchases of merchandise are as follows: Merchandise Transportaticerms Returns and Allowances D CO V ON UI A W N 1,000 75 FOB shipping 150 3,500 FOB destinat 200 4,000 50 FOB shipping 275 2,150 FOB destinat 100 2,00 35 FOB shipping 175 3,750 FOB destinat 0 3,000 65 FOB shipping 300 5,000 --- FOB destinat 500 3,150 --- estinat 150 15 1,000 35 FOB shipping 250 16 Determine the amount to be paid in full settlement of each of the invoices, assuming that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period. Also 17 assume that the seller has prepaid the transportation expenses 18 19 20 21 22 23 25 26 27 28 30 31 32 The following data for the current year ended December 31, 2016, was extracted from the accounting records 33 of Defender Co.: 34 Cost of merchandise sold $950,000 35 Operating expenses 276,332 36 Sales 1,230,250 37 Prepare a multiple-step income statement for the year ended December 31, 2016. CH4 Transactions Additional Questions CH4 + Ready Accessibility: Investigate + 100%Q Search (Cmd + Ctrl + U) AutoSave O A A P J . C ... xModule 4 Assignment Comments Share Home Insert Draw Page Layout Formulas Data Review View Automate Insert v AA ab v General ZY AP- O. Calibri (Body) v 12 = Ex Delete v Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze DV Av E $ ~ % 9 Format v v Filter Select Data Paste BIUV Formatting as Table Styles 126 4 fx S T B D E F G H I J K L M N P Q R A assume that the senel nas prepaid the transportation expenses . 18 19 20 21 22 23 24 25 26 27 28 31 32 The following data for the current year ended December 31, 2016, was extracted from the accounting records 33 of Defender Co.: 34 Cost of merchandise sold $950,000 35 Operating expenses 276,332 36 Sales 1,230,250 37 Prepare a multiple-step income statement for the year ended December 31, 2016. 38 39 40 41 42 43 44 45 46 47 48 D CH4 Transactions Additional Questions CH4 + + 100% Ready Accessibility: Investigate