Please answer the Statement of Cash flows and do the Ratio analysis. The journal entries, t-accounts, trial balance and balance sheet are been provided in the photos

MFE 6100 Module 2 Assign 182 Excel Workbook (1) - 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 General Fill Pa 3 lu.-g.. conditional Fombatas Styles . Insert Delete Format : Merge & Center $.%,,, Sort & Find & Filter Select . Format Painter Formatting Table Styles Clear . Clipboard Number Cells Editing A1 Module 2 Assignments 1 and 2 Excel Workbook Module 2 Assi 1 and 2 Excel Workbook MFE 6100 4 Assiqnment 2, Part F Week 4 5 Complete a Statement of Cash Flows for the quarter ending March 31, 2016 6 in proper format. The Statement of Cash Flows format should match that 7 used in Module 1. All amounts listed in your Statement of Cash Flows must 8 be properly linked to amounts listed in your Journal Entries, T-Accounts, or 9 Balance Sheet. (16 points-graded for accuracy and format, including Excel 10 11 Cash Used for Operating Activities Check Figure is ($32,570). Make sure your 12 Ending Cash Balance matches your Cash Balance on your Balance sheet. 13 14 Solution: 16 17 18 19 20 C. Trial Balance D. Balance Sheet E. Retained Earnings ement of Cash Flows G. Ratio + 100% O Type here to search 2/10/2019 MFE 6100 Module 2 Assign 182 Excel Workbook (1) - Excel Sally Dunn 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 3 . 1 u .-2.A. Conditional For batas Styles . Conditional Format as Cell Formatting Table Styles Insert Delete Format Merge & Center $ . % , Sort & Find & Filter Select . Format Painter Clear. Clipboard Number Cells Editing A1 Module 2 Assignments 1 and 2 Excel Workbook 0 Module 2 Assignments 1 and 2 Excel Workbook MFE 6100 4 A 5 Based on your completed Balance Sheet, calculate the Current Ratio and the 6 Debt to Equity Ratio. All amounts used in the ratios must be properly linked 7 to the Balance Sheet. (6 points-graded for accuracy and format, including 8 Excel spreadsheet links) Part G 10 e are no Check Figures provided for Part G 12 Solution: 13 14 15 16 17 18 19 20 D. Balance Sheet E. Retained Earnings F. Statement of Cash Flows G. Ratio Analysis + 100% O Type here to search 2/10/2019 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 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 SDUNN MOD2 EXCEL.XSX Week 3 - Excel Sally Dunn-X File Home Insert Draw Page Layout Formulas Data Review iew Help Tell me what you want to do Share Comments AutoSum . A Calibri Custom Paste Copy Conditional Format as Cell Formatting Table Styles Styles Insert Delete Fonmat & Center Format Painter ClrFilterSelect Clipboard Font Alignment Number Editing 0 March 31,2016 Debit Credit 318,230 240,000 1,200 23 Accumulated Depreciation 1,020 25 Salaries and Wages Expense 26 Bank Notes Payable 27 Mortgage Note Payable 192,000 31 Salaries and Wages Expense 32 Insurance 33 Depreciation Expense 13,500 667,620 667,620 A.Journal Entries B.T-Acts C.Trial Balance D. Balance SheetE. Retained Earnings +90% 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