Managerial accounting Please answer the balance sheet. The journal entries, T accounts and Trial balance pictures has been provided.
MOD2 EXCELXISX Week Review iew Help Tell me what you want to do SDUNN 3 - Excel Sally Dunn Home Insert Draw Page Layout Formulas Share Comments AutoSum . A Calibri Fom atti nal Fom letas Styl S. I Insert Delete Fonmat Bru. L-2- Fort& Selec& -E-E Merge & Center $.%,,, Clear. . . Format Painter Filter Select Clipboard Font Alignment Number Cells Editing O P QR S A young entrepreneur with a passion for shoes has a new start-up, Shoes for You, Inc. with a calendar 6 year end of December 31, 2016. Complete the lournal Entries for all transactions listed for Shoes for 7 You, Inc.for the first quarter ending March 31, 2016. Be sure to indude a date for each journal entry 8 You do not need to provide explanations for the Journal Entries. The first lournal Entry has been done 9 for you. (16 points-graded for accuracy and format, including Excel spreadsheet links.) 10 11 Transactions: Journal Entrics: Debit 11/2/2016 Cash 2 1/15/2016 3 2/1/2016 Common Stock 12 1 1/2/2016 ssued 10,000 shares of stock to investors consisting of friends and family. shares 13 14 2 1/15/2016 Received a loan of $300,000 from the bank 15 3 2/1/2016 Puchased a building for office and retail space for S240,000. They paid 20% down in 16 Bank loan Purchased a building Paid cash Note payable Equipment were sold at par value of $10 each. 240,000 48,000 192,000 cash and signed a long-term mortgage note for the rest 4 2/1/2016 5 2/1/2016 6 2/3/2016 10 1.200 1,170 74 2/1/2016 Paid $1,200 in cosh to purchase display equipment for the shoe showroom 18 5 2/1/2016 The company purchased a six month insurance policy and paid cash in advance of $1,170. 19 6 2/3/2016 Purchased shoe inventory on account for $92,500 20 7 2/26/2016 Recorded shoe sales to a local basketball team, sold on account for $3,900. 21 8 3/1/2016 Paid $60,000 of the Account Payable for the shoe inventory to the supplier 229 3/27/2016 The company received a cash payment in full from the local basketball team. 23 10 3/31/2016 Shoe sales in cash for February and March were $36,700 24 11 3/31/2016 Cost of Goods Sold for the February and March sales (cash and credit) were $22,330. 25 12 3/31/2016 Salaries and woges expense for February and March combined was $13,500. Of this Advance Insurance 1,170 92,500 Account payable Account receivable cost of nds ad in casn o monthly 8 3/1/2016 total, $12,000 was paid in cash and $1,500 will be paid in April. 9 3/27/2016 3.900 60000 27 13 3/31/2016 The company records depreciation monthly. The building has a useful economic life of Accounts receivable A. Journal Entries B.T-Accts C. Trial Balaceance Sheet E. Retained Earnings F.. O Type here to search 2/10/2019 SDUNN MOD2 EXCEL.XSX Week 3 - Excel Sally Dunn-X File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments AutoSum . A Calibri Custom Fill Format as. Cell Formatting Table Styles Insert Delete Fonmat 6848 Sort & Find & Filter, Select i Blu-EA !E Merge & Center . $ % , 5 Format Painter Clear Clipboard Number Editing Shoes for You, Inc Trial Balance March 31,2016 Debit 318,230 240,000 1,200 23 Accumulated Depreciation 24 Accounts Payable 25 Salaries and Wages Expense 26 Bank Notes Payable 27 Mortgage Note Payable 1,020 32,500 192,000 30 31 Cost of goods sold Salaries and Wages Expense 22,330 13,500 A Journal Entries B.T-Accts C.Trial Balance D. Balance Sheet E. Retained Earnings .. +90% O Type here to search 2/10/2019 0 MFE 6100 Module 2 Assign 182 Excel Workbook (1) - Excel Sally Dunn-X File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments AutoSum A Fill X Cut General Pa 3Format Painter.lu Merge & Center $.%,,, Conditional Format as Cell Formatting Table Styles . Insert Delete Fom at Fort& Selec& Sort & Find & Filter Select . . . Clear . Clipboard Number Cells Editing A1 Module 2 Assignments 1 and 2 Excel Workbook A B 0 Module 2 Ass s 1 and 2 Excel Workboolk MFE 6100 4 NOTE that Parts D, E, F, and G make up Assignment 2 for Module 2. You do not 5 need to complete Assignment 2 until Week 4. 7 Please complete Parts D, E, F, and G for Assignment 2 on a copy of the 8 completed Excel worksheet that you submitted for Assignment 1 in Week 3. 9 Prior to starting Assignment 2, you should use the Solution to Assignment 1 to 10 make any needed corrections to Parts A, B, and C on your spreadsheet so that 11 you have the correct starting data needed to complete Parts D, E, F, and G on 12 3 Assig 14 Complete a Classified Balance Sheet for Shoes for You, Inc. for March 31, 2016, 15 in proper format. (18 points-graded for accuracy and format, including Excel 16 spreadsheet links) 17 18 Use the Check Figures from Part B here. Part D (Week 4 20 Solution: A Journal Entries B.T-Accts C. Trial BalanceD. Balance Sheet E. Retained Earnings .. + 100% O Type here to search 2/10/2019
