Stuck on H, M and J entries. Not 100% sure of others, but these I am having trouble even entering to proceed.

Attached is my spreadsheet and a copy of the assignment w the data. Thanks.

P3-4 Analyzing the Effects of Transactions Using T-Accounts, Preparing an Income Statement, and Evaluating the Net Profit M Kaylee James, a connoisseur of fine chocolate, opened Kaylee's Sweets in Collegetown on February 1, 2014. The shop specialize candies and a line of gourmet ice cream. You have been hired as manager. Your duties include maintaining the store's financial transactions occurred in February 2014, the first month of operations. a. b. c. d. e. f. g. h. i. j. k. l. m. Received four shareholders' contributions totaling $30,200 cash to form the corporation; issued 400 shares of $.10 p Paid three months' rent for the store at $1,750 per month (recorded as prepaid expenses). Purchased and received candy for $6,000 on account, due in 60 days. Purchased supplies for $1,560 cash. Negotiated and signed a two-year $11,000 loan at the bank. Used the money from (e) to purchase a computer for $2,750 (for recordkeeping and inventory tracking); used the ba Placed a grand opening advertisement in the local paper for $400 cash; the ad ran in the current month. Made sales on Valentine's Day totaling $3,500; $2,675 was in cash and the rest on accounts receivable. The cost of t Made a $550 payment on accounts payable. Incurred and paid employee wages of $1,300. Collected accounts receivable of $600 from customers. Made a repair to one of the display cases for $400 cash. Made cash sales of $1,200 during the rest of the month. The cost of the candy sold was $600. Required: 1 & 2. Record in the T-accounts the effects of each transaction for Kaylee's Sweets in February, referencing each transacti letter. Show the ending balances in the T-accounts. An example amount has been posted to the Cash T-Account fro Cash Accounts Beg. bal. Beg. bal. 400 (l) End. bal. End. bal. 400 Supplies Inve Beg. bal. Beg. bal. End. bal. End. bal. Prepaid Expenses Equi Beg. bal. Beg. bal. End. bal. End. bal. Furniture and Fixtures Accoun Beg. bal. Beg. bal. End. bal. End. bal. Notes Payable Comm Beg. bal. Beg. bal. End. bal. End. bal. Additional Paid-in Capital Sales R Beg. bal. Beg. bal. End. bal. End. bal. Cost of Goods Sold Beg. bal. Repair Beg. bal. End. bal. End. bal. Advertising Expense Wage Beg. bal. Beg. bal. End. bal. End. bal. Required: 3 Prepare an income statement at the end of the month ended February 28, 2014. KAYLEE'S SWEETS Income Statement (unadjusted) For the Month Ended February 28, 2014 Revenues: Expenses: Total cost and expenses - Required: 5 After three years in business, you are being evaluated for a promotion. One measure is how effectively you manag The following data are available: Total assets Total liabilities Total stockholders' equity Net sale revenue Net income 2016* $ 88,000 49,500 38,500 93,500 22,000 * At the end of 2016, Kaylee decided to open a second store, requiri purchases prior to the store's opening in early 2017. 5-a. Calculate the net profit margin ratio for each year. (Round your answers to 1 decimal place.) Net Profit Margin Ratio 2016 2015 2014 5-b. % % % Do you think you should be promoted? YE S NO Evaluating the Net Profit Margin Ratio as a Manager LO3-4, 3-5, 3-6 1, 2014. The shop specializes in a selection of gourmet chocolate aining the store's financial records. The following issued 400 shares of $.10 par value common stock. ntory tracking); used the balance for furniture and fixtures for the store. current month. nts receivable. The cost of the candy sold was $1,600. referencing each transaction in the accounts with the transaction d to the Cash T-Account from transaction (l). Accounts Receivable Inventory Equipment Accounts Payable Common Stock Sales Revenue Repair Expense Wage Expense how effectively you managed the sales and expenses of the business. $ 2015 58,500 $ 22,000 36,500 82,500 11,000 2014 52,500 18,500 34,000 55,000 4,400 pen a second store, requiring loans and inventory P3-4 Analyzing the Effects of Transactions Using T-Accounts, Preparing an Income Statement, and Evaluating the Net Profit M Kaylee James, a connoisseur of fine chocolate, opened Kaylee's Sweets in Collegetown on February 1, 2014. The shop specialize candies and a line of gourmet ice cream. You have been hired as manager. Your duties include maintaining the store's financial transactions occurred in February 2014, the first month of operations. a. b. c. d. e. f. g. h. i. j. k. l. m. Received four shareholders' contributions totaling $30,200 cash to form the corporation; issued 400 shares of $.10 p Paid three months' rent for the store at $1,750 per month (recorded as prepaid expenses). Purchased and received candy for $6,000 on account, due in 60 days. Purchased supplies for $1,560 cash. Negotiated and signed a two-year $11,000 loan at the bank. Used the money from (e) to purchase a computer for $2,750 (for recordkeeping and inventory tracking); used the ba Placed a grand opening advertisement in the local paper for $400 cash; the ad ran in the current month. Made sales on Valentine's Day totaling $3,500; $2,675 was in cash and the rest on accounts receivable. The cost of t Made a $550 payment on accounts payable. Incurred and paid employee wages of $1,300. Collected accounts receivable of $600 from customers. Made a repair to one of the display cases for $400 cash. Made cash sales of $1,200 during the rest of the month. The cost of the candy sold was $600. Required: 1 & 2. Record in the T-accounts the effects of each transaction for Kaylee's Sweets in February, referencing each transacti letter. Show the ending balances in the T-accounts. An example amount has been posted to the Cash T-Account fro Cash Accounts R Beg. bal. Beg. bal. 400 (l) End. bal. End. bal. Supplies Inven Beg. bal. Beg. bal. End. bal. End. bal. Prepaid Expenses Equipm Beg. bal. Beg. bal. End. bal. End. bal. Furniture and Fixtures Accounts Beg. bal. Beg. bal. End. bal. End. bal. Notes Payable Common Beg. bal. Beg. bal. End. bal. End. bal. Additional Paid-in Capital Sales Re Beg. bal. Beg. bal. End. bal. End. bal. Cost of Goods Sold Beg. bal. Repair Ex Beg. bal. End. bal. End. bal. Advertising Expense Wage Ex Beg. bal. Beg. bal. End. bal. End. bal. Required: 3 Prepare an income statement at the end of the month ended February 28, 2014. KAYLEE'S SWEETS Income Statement (unadjusted) For the Month Ended February 28, 2014 Revenues: Expenses: Total cost and expenses Net income 0 $400 Required: 5 After three years in business, you are being evaluated for a promotion. One measure is how effectively you manag The following data are available: Total assets Total liabilities Total stockholders' equity Net sale revenue Net income 2016* $ 88,000 49,500 38,500 93,500 22,000 * At the end of 2016, Kaylee decided to open a second store, requiri purchases prior to the store's opening in early 2017. 5-a. Calculate the net profit margin ratio for each year. (Round your answers to 1 decimal place.) Net Profit Margin Ratio 2016 2015 2014 5-b. % % % Do you think you should be promoted? YE S NO and Evaluating the Net Profit Margin Ratio as a Manager LO3-4, 3-5, 3-6 ary 1, 2014. The shop specializes in a selection of gourmet chocolate maintaining the store's financial records. The following tion; issued 400 shares of $.10 par value common stock. inventory tracking); used the balance for furniture and fixtures for the store. the current month. counts receivable. The cost of the candy sold was $1,600. uary, referencing each transaction in the accounts with the transaction osted to the Cash T-Account from transaction (l). Accounts Receivable Inventory Equipment Accounts Payable Common Stock Sales Revenue Repair Expense Wage Expense e is how effectively you managed the sales and expenses of the business. 2015 $ 58,500 22,000 36,500 82,500 11,000 2014 $ 52,500 18,500 34,000 55,000 4,400 to open a second store, requiring loans and inventory g in early 2017. Required: 1 & 2. Record in the T-accounts the effects of each transaction for Kaylee's Sweets in February, referencing each transacti letter. Show the ending balances in the T-accounts. An example amount has been posted to the Cash T-Account fro Cash Beg. bal. a e k m 30,200 11,000 600 1,200 End. bal. 22,540 Accounts 400 5,250 1,560 11,000 400 550 1,300 (l) b d f g i j Beg. bal. k End. bal. Supplies Inve Beg. bal. d 1,560 Beg. bal. c End. bal. 1,560 End. bal. Prepaid Expenses Equip Beg. bal. End. bal. 5,250 Beg. bal. f 5,250 End. bal. Furniture and Fixtures Beg. bal. f 8,250 End. bal. 7,850 Account 400 l Beg. bal. i End. bal. Notes Payable Commo Beg. bal. Beg. bal. 11,000 e End. bal. 11,000 End. bal. Additional Paid-in Capital Beg. bal. End. bal. Sales R 30,160 a Beg. bal. m 30,160 End. bal. Cost of Goods Sold Beg. bal. m Repair Beg. bal. 600 End. bal. End. bal. 600 Advertising Expense Wage E Beg. bal. Beg. bal. 400 g End. bal. 400 End. bal. Required: 3 Prepare an income statement at the end of the month ended February 28, 2014. KAYLEE'S SWEETS Income Statement (unadjusted) For the Month Ended February 28, 2014 Revenues: Expenses: Total cost and expenses - Required: 5 After three years in business, you are being evaluated for a promotion. One measure is how effectively you manag The following data are available: Total assets Total liabilities Total stockholders' equity Net sale revenue 2016* $ 88,000 49,500 38,500 93,500 Net income 22,000 * At the end of 2016, Kaylee decided to open a second store, requir purchases prior to the store's opening in early 2017. 5-a. Calculate the net profit margin ratio for each year. (Round your answers to 1 decimal place.) Net Profit Margin Ratio 2016 % 2015 % 2014 % 5-b. Do you think you should be promoted? YE S NO ry, referencing each transaction in the accounts with the transaction sted to the Cash T-Account from transaction (l). Accounts Receivable 600 600 Inventory 6,000 6,000 Equipment 2,750 2,750 Accounts Payable 550 6,000 c 5,450 Common Stock 40 a 40 Sales Revenue 600 600 Repair Expense Wage Expense 1,300 j 1,300 is how effectively you managed the sales and expenses of the business. $ 2015 58,500 $ 22,000 36,500 82,500 2014 52,500 18,500 34,000 55,000 11,000 4,400 o open a second store, requiring loans and inventory in early 2017. CP3-2 Finding Financial Information LO3-2, 3-4, 3-6 Refer to the financial statements of Urban Outfitters in Appendix C at the end of the book. Required: 1. What is the company's revenue recognition policy? (Hint: Look in the notes to the financial statements.) 2. Assuming that $50 million of cost of sales was due to noninventory purchase expenses (distribution and occ much inventory did the company buy during the year? (Hint: Use a T-account of inventory to infer how much w INVENTORY (in thousands) Inventory purchased during the year: 3. Calculate selling, general, and administrative expenses as a percent of sales for each year presented. (Dollar Year Ended 2012 2011 2010 SG&A Expenses / Net Sales Revenue = Percentage By what percent did these expenses increase or decrease from fiscal years ended 2011 and 2012 and between (Hint: Percentage Change = [Current Year Amount Prior Year Amount]/Prior Year Amount.) % Change Incr. or Decr. Between years ended 2011 and 2012: Between years ended 2010 and 2011: 4. Compute the company's net profit margin for each year presented. (Dollars in thousands.) Fiscal Year Ended Net Income / Net Sales (or Operating) Revenues 2012 2011 2010 Explain net profit margin ratio and discuss the results shown above. = Net Profit Margin Ratio end of the book. notes to the financial statements.) rchase expenses (distribution and occupancy costs), how ount of inventory to infer how much was purchased.) sales for each year presented. (Dollars in thousands.) s ended 2011 and 2012 and between 2010 and 2011? Prior Year Amount.) ollars in thousands.)