Record all Journal Entries (JE) for the transactions below- located on the first excel tab of the template Complete the Income Statement for December- located on the second excel tab of the template Calculate the required ratios- located on the third excel tab of the template After you update the excel template, save it and turn it in COMPLETED this space.

Kate's Cards MBC (Note: This is a continuation of the Serial Problem: Kate's Cards from Chapters 1 through 4.) SP5. Kate was a little worried about some of the practices of Fred Abbott, the CEO of Sentiments, and de- cided that an association with Sentiments could damage the reputation of her own company. Kate is very concerned that her business be viewed as socially responsible and any damage to her reputation at this early stage could prove very difficult to overcome. She therefore decided to concentrate her efforts on producing a quality product that consumers would be proud to purchase and send to their loved ones. As expected, November saw a boom in Kate's greeting card business. She invested in additional computer graphics equipment, which she partially funded with a bank loan of $15,000 and an additional investment of her own funds into the business. The loan carries an interest rate of six percent with interest payments required semiannually. The entire principal balance is due in one balloon payment in two years. Kate uses a perpetual inventory system. As of December 2, 2018, Kate's Cards had the following account balances: Cash Accounts receivable. Inventory. Other current assets. Computer equipment $11,900 16,800 16,000 3,600 38,900 Accumulated depreciation Accounts payable Other current liabilities Long-term note payable Common stock ... Retained earnings $ 1,600 13,800 900 15,000 25,000 30,900 The company had the following transactions during December 2018: Dec 1 Paid $1,200 rent for the month. 7 Paid $1,800 to employees. Of this amount, $900 was for an amount owed from November. Wages due to employees at the end of each month are recorded as Other Current Liabilities. 9 Received $5,400 from customers as payment on account. 12 Sold, for cash, $11,000 of greeting cards. This merchandise had cost $6,000 to produce. 14 Purchased additional inventory totaling $7,000 on account with terms of 2/10, n/45. 15 Paid cash for supplies (listed as Other Current Assets) in the amount of $600. 19 Sold, on account with terms of 2/10, n/30, greeting cards totaling $6,000. The merchandise had cost $4,000 to produce. 21 Paid additional wages of $1,400. 25 Paid the total owed for the merchandise that was purchased on December 14. 28 Received payment in full from the customer that purchased the merchandise on December 19. 31 Depreciation for the month totaled $900. 31 A physical count of inventory and supplies revealed that $13,000 and $2,000, respectively, were on hand at year-end. Assume that Other Current Assets consists only of the cost of supplies. Description Dr. Cr. Date Dec. 14 Dec. 15 Dec. 19 Dec. 21 Dec. 25 Dec. 28 Dec. 31 $ $ Kate's Cards Income Statement For Month Ended December 31, 2018 Sales revenue Sales discounts Net sales Cost of goods sold Gross profit Wages expense Supplies expense Rent expense Depreciation expense Operating expense Income (loss) from operations Interest expense Net income (loss) $ $ $ Gross Profit Percentage Return on Sales Percentage Kate's Cards MBC (Note: This is a continuation of the Serial Problem: Kate's Cards from Chapters 1 through 4.) SP5. Kate was a little worried about some of the practices of Fred Abbott, the CEO of Sentiments, and de- cided that an association with Sentiments could damage the reputation of her own company. Kate is very concerned that her business be viewed as socially responsible and any damage to her reputation at this early stage could prove very difficult to overcome. She therefore decided to concentrate her efforts on producing a quality product that consumers would be proud to purchase and send to their loved ones. As expected, November saw a boom in Kate's greeting card business. She invested in additional computer graphics equipment, which she partially funded with a bank loan of $15,000 and an additional investment of her own funds into the business. The loan carries an interest rate of six percent with interest payments required semiannually. The entire principal balance is due in one balloon payment in two years. Kate uses a perpetual inventory system. As of December 2, 2018, Kate's Cards had the following account balances: Cash Accounts receivable. Inventory. Other current assets. Computer equipment $11,900 16,800 16,000 3,600 38,900 Accumulated depreciation Accounts payable Other current liabilities Long-term note payable Common stock ... Retained earnings $ 1,600 13,800 900 15,000 25,000 30,900 The company had the following transactions during December 2018: Dec 1 Paid $1,200 rent for the month. 7 Paid $1,800 to employees. Of this amount, $900 was for an amount owed from November. Wages due to employees at the end of each month are recorded as Other Current Liabilities. 9 Received $5,400 from customers as payment on account. 12 Sold, for cash, $11,000 of greeting cards. This merchandise had cost $6,000 to produce. 14 Purchased additional inventory totaling $7,000 on account with terms of 2/10, n/45. 15 Paid cash for supplies (listed as Other Current Assets) in the amount of $600. 19 Sold, on account with terms of 2/10, n/30, greeting cards totaling $6,000. The merchandise had cost $4,000 to produce. 21 Paid additional wages of $1,400. 25 Paid the total owed for the merchandise that was purchased on December 14. 28 Received payment in full from the customer that purchased the merchandise on December 19. 31 Depreciation for the month totaled $900. 31 A physical count of inventory and supplies revealed that $13,000 and $2,000, respectively, were on hand at year-end. Assume that Other Current Assets consists only of the cost of supplies. Description Dr. Cr. Date Dec. 14 Dec. 15 Dec. 19 Dec. 21 Dec. 25 Dec. 28 Dec. 31 $ $ Kate's Cards Income Statement For Month Ended December 31, 2018 Sales revenue Sales discounts Net sales Cost of goods sold Gross profit Wages expense Supplies expense Rent expense Depreciation expense Operating expense Income (loss) from operations Interest expense Net income (loss) $ $ $ Gross Profit Percentage Return on Sales Percentage