Using e xcel complete a statement of cash flows for the ending of March 31, 2016 in proper format.

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 Styles . I Insert Delete Fonmat Bru. L-2- Fort& Selec& -E-E Merge & Center $.%,,, Oclear . . . 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 File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments X Cut AutoSum . A Custom Fill Past Copy Conditional Format as Cell Formatting Table Styles Styles Insert Delete Fonmat Sort & Find & Filter Select i Format Painter I A [ Merge & Center . $ % , 58 48 Clear Clipboard Font Number Editing B C D FGHI L M NO RSTUV 1 100,000 48,000 2 1300,000 1,200 2 3 3,9001,170 2 3 36,700 60,000 3 12,000 3 1,170 60,000 92,500 32,5001 100,000 1 13,500 19 Buildin laries and Wages Payable Sales Revenue Insurance Ex 240,000 1,500 3,900 36,700 40,600 318,230 23 Accounts Receivable 3,9003,900 Bank Loan Payable Cost of Goods Sold ciation Expense 1,000 1,200 300,000 22,330 27 1,020 Invento 92,500 22,330 70,170 P&E 1,000 Mortgage Note Payable 192,000 1,020 A Journal Entries B. T-Accts C. Trial Balance D. Balance Sheet E. Retained Earnings .. + 100% O Type here to search 2/10/2019 e Get Homework Help With Cheo Managerial Accounting please (a)YC3x2 13)(b)Y (73-5(c)y./X Get Homework Help With Cheg + x x Chegg Study TEXTBOOK SOLUTIONS EXPERT Q&A Search Shoes for You, Inc. Balance Sheet March 31, 2016 Rate answer here. Current Assets Cash Accounts receivable S318,230 S0 $70,170 S780 Prepaid Insurance Total current assets $389,180 Building, Plant and equipment Building Display Equipment Less: Acc. Dep.-Equipment Total Building, Plant and equipment $240,000 S1,200 $240,180 otal 13:32 O Type here to search 2/10/2019 SDUNN MOD2 EXCEL.XSX Week 3 - Excel Sally Dunn File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments X Cut AutoSum . A Calibri General Fill Past Copy Format as. Cel Formatting Table Styles Insert Delete Fonmat 6848 Sort & Find & Filter, Select i Format Painter I A [ Merge & Center . $ % , 5 Clear Clipboard Font Number Editing ABC 18 Use the Check Figures from Part B here. Shoes for You, Inc. Balance Sheet March 31, 2016 19 20 Solution: Current Assets $318,230 Account receivable $70,170 Prpaid Insurance Total Assests $389,180 Building, Plant and equipment Building Display Equipment Less: Acc. Dep. Equipment Total Building, Plant and equipment Total Assets $240,000 1,200 $1,020 $240,180 $629,360 Liabilities and stockholders' Equity Current li C. Trial Balance D. Balance Sheet E. Retained Earnings F. Statement of Cash Flows G. Ratio + 100% O Type here to search 3:18 2/11/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 Fill Clear X Cut General Past Copy Conditional Format as Cell Formatting Table Styles Insert Delete Fonmat A Sort & Find & Filter Select i I [ Merge & Center . $ % , 58 48 Format Painter Clipboard Number Cells Editing F21 A B C Total Building, Plant and equipment Total Assets $240,180 $629,360 35 36 37 38 39 Liabilities and stockholders' Equity Current Liabilities Account Payable salaries and Wages Payable $32,500 $1,500 $34,000 Bank Notes Payable Mortgage Note Payable Total Liabilities Shareholder's Equity Common Stock Retained Earnings Total shareholder's Equity Total Liabilities and Shareholders' Equity $192,000 $526,000 $100,000 $3,360 46 $103,360 629,360 Working Retained Earnings $40,600-$22,330-$13,500-$390-$1,020 52 C. Trial BalanceD. Balance Sheet E. Retained EarningsF. Statement of Cash FlowsG. Ratio... C + 100% O Type here to search 3:18 2/11/2019