the work is in excel form
please let me know the kind of information you need
thank you
Wisata Cleaning me Statement For the thinded September 2015 Wenata Balth September 2015 2 Service Depenses $17.00000 300.00 31 Aug in 11 12 1 516 SORO 60000 5700000 3 S 5 $ 5 5 5 5 Advertising pens Miscellaneous pense Salary Hent Expense Depreciation Conse Insurance sules per Top Nel come 14 15 TO 17 18 5.400.00 1.500.00 SODO TO000 500.00 11.2. 5.250,00 Anes 15 31 Aug 15 Lt G 5 50000 15000 AP Ne 10000 Supos $ 6,500.00 3.000.00 President 5 7.500.00 Prepaid 5 L100005 TA TS 50.00 5,150.00 Common stock Cleaning time 12.00000 Band Loud Depreci 200005 Total Tech 1.000.00 Acumulated arti 350.00 Tota 3.558,00 5 Total Asset $100.000.00 Totaleht 500000 5000.00 100005 S-51.000.000 20 $ 105,900.00 565,150.00 22 3 Wayata Cleaning in Statement of Metained Earnings For the Month Ended September 30, 2015 5 Hepininfetained Earnings FS Ratio 1850001 Y 11 $ G TA SON 1,150.00 14 Depreciation Insurance Dopplies Tataltem Net Income 0 1.500.00 5 450.00 5 10000 500.00 $ 11,00 5 5,750,00 Common Mo Hearings To 5 DO 3.000000 2005 (1) 21,000.00 $9,156.40 12 18 19 30 Cleaning met 13.000.000 Accumulated 1200001 18 od Accumulated Depreciati 125000 To $550.00 YA 105.700.00 65,150.00 Total Debt 5109.100.00 365,150.0 Wapata Cleaning, Inc. Statement of Retained farning For the Month Ended September 19, 2015 5 $ Beginning Retained Parnings Ninne Total Dividends Ending Metained in 5 5 $ (85000) 5.750.00 4,300.00 1.000,00 900.00 Weighted average common to standing 9,000.00 A D 3 4 E 5 Analysis Liquidity Ratio Net Working Capital Formula September 2015 6 7 8 9 Current ratio Quick ratio 10 Profitability Cash Ratio Gross Profit percentage 12 13 14 15 Net Income percentage Operating Profit Ratio 16 17 18 19 0 1 Debt Analysis Debt Ratio Interest Coverage Ratio N/A FS Ratios Interest Coverage Ratio N/A Asset Management Analysis Inventory Turnover N/A Days-Sales-in-Inventory N/A Accounts Receivable Turnover Receivable Collection Period Return on Assets Total Asset Turnover Fixed Asset Turnover Stockholder's Reward Analysis Earnings Per Share Dudanden Charm FS Ratios A B D Stockholder's Reward Analyst Earnings Per Share Dividends Per Share 36 37 38 39 40 41 42 43 Dividends Payout Ratio Return on Equity 44 45 46 17 18 19 0 1 2 Wayat Cleaning in from Mat For the Month nded September 2015 Wealing Be the September 2015 $ 17,000.00 Service ever pencer UTY Adversing benie Miscellaneous pense Salary tense Hent pense Depreciation Expense Insurance Expense Supplies Expense Total Expenses Net Income 1 100.150 5 5 5 840000 1,500.00 450.00 $ 100.00 5 500.00 $ 11,20 5,750.00 Arts 30 Sep 15 31 Aug 1 15 Cath 75000915000 count was 3150000 500000 ALL 500.00 Salary 100 Supplies 5 600.000,000.00 Une Service 000 Prepaident $ 7.500.000 Total Current bites. 200.000.000 Wrepaid in 3 1,100.00 CA 5 530.00 15000 tully Common och TODO 5.000 Cleaning forment 12.000.00 min $1,000.00 50.00 Accumulated Depreciate 12006 Totality 51,900.00 Trock 10,000.00 Accumulated recit 25000 Total S2000 Total Annet 5 105,000.00 55.150.00 Total Duty $105.900.00 355, 150,00 Wayate Cleaning Inc. Statement of Retained Earnings For the Month Ended September 30, 2015 FS Ratios Netcome $ 5,750.00 Alated Opreciate 250.00 5 YATA S. Tatal Arts $ 105,000.00 565,190,00 Wayata Cleaning in Statement of Retained Earnings For the Month Ended September 30, 2015 Beginning and Earnings Net Incom Total Dividends Ending Metained Farnings 5 $ 3 $ $ ISO) 5.750.00 4,900.00 1,000.00 3,900.00 Weighted average common stock outstanding 69.000.00 A B 4 D Ratio Net Working Capital Analysis Liquidity Formula 2015 5 6 7 8 9 Current ratio Quick ratio Profitability Cash Ratio Gross Profit percentage Net Income percentage 10 11 12 13 14 15 16 17 18 19 20 21 22 Operating Profit Ratio Debt Analysis Debt Ratio Interest Coverage Ratio N/A Asset Management Analysis Inventory Turnover Ratios N/A B D E Asset Management Analysis Inventory Turnover N/A Days Sales-in-Inventory N/A Accounts Receivable Turnover Receivable Collection Period Return on Assets Total Asset Turnover Fixed Asset Turnover Stockholder's Reward Analysis Earnings Per Share Dividends Per Share donde una Datu B D Return on Assets Total Asset Turnover 30 31 32 33 34 35 36 37 38 39 Fixed Asset Turnover Stockholder's Reward Analysis Earnings Per Share Dividends Per Share Dividends Payout Ratio 40 41 42 43 Return on Equity 44 45 47 48 Ratios Wayat Cleaning me Statement For the Month nded September 4, 2015 31.000.00 9 10 11 300.00 Service Reven beses uti Advertising and Miss me Salary pense be Detection Insurance Sus Dei Totaltepenas Net 13 10 15 5 5 5 5 $ 3 5 Wawei. Balance Sheet September 10, 2015 Anet 10-15 31415 30 Sep 15 554000 50.150.00 ACRE 3 350000 $ $15.000.000 Salary Payable Supplies 5 10000 000 Uredice Prepaid 57.000.00 7.500.000 Total Current Os Bread 1.100.00 Total $0.00 $ 150.00 57300000 50000000 Cleaning 100005 11. Acum DO 0.0055 Truck TR000 DOS AccuwDeprecat 125000 $ 2.55 Tales 105, 18.00 Total Duty 3105.00.0 61.150.00 240000 1 500.00 450.00 100.00 500.00 5 19 0.00 23 Welat Cleaning State of Retired Earnings For the Month fed september 30, 2015 25 atos 13 18 Totale Net 5 11,00 $ 5,750.00 Truck Total 11 100000 1000 $.00 $5.500.00 $ 150.00 31 27 To Wayta Cleaning Inc. Statement of Metodaning For the Month Ended: September 2015 5101 DO 150 24 25 25 Deine Stained in 28 Tot Divided $ 15 5 500 900.00 100000 Weledere common 000.00 614 36 40 75 Analysis Liquidity Ratio Net Working Capital Formula September 2015 Current ratio 3 3 0 1 Quick ratio Profitability Cash Ratio Gross Profit percentage 13 Net Income percent Operating Profi Ratio 86 17 18 19 Debt Analysis Debt Ratio Ratio A B D E Debt Analysis F Debt Ratio Interest Coverage Ratio N/A Asset Management Analysis inventory Turnover N/A Days-Sales-In-Inventory N/A 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Accounts Receivable Turnover Receivable Collection Period Return on Assets Total Asset Turnover Fixed Asset Tumover Stockholder's Reward Analysis Earnings Per Share FS Ratios WC For the Midd september 2015 09 ROS 5 ODE c Serve es LIVE Advertising Miscellaneous Salary Experie Hent Expense Depreciation Expense Insurance Expense Suplies Expense Total Expenses Net Income $ 2. W 5 S R400.00 1,500.00 450.00 $ 100.00 500.00 $11,250.00 $ 5.750.00 $ A 30- 31 Aug 1 ch S5425000 15000 cm Acreceivabi 5 50000 Salary Buples 5 000.000.00 5 705 Prepaid $ 1.100.000 Tinta 1.00 Com Cleaning Coment 13000.00 Accumulated precis 17000 Truri 1800000 Accumulated Deprecia 1250.00 Total $ 20,000 $ Total Assets S105.300.00 50.150.00 5700000 5000000 5000 8500 Total Dettol $10,000.150.00 Wayrala Cleaning Inc. Statement of Retained Earnings For the Month Inded September 30, 2015 FS Ratios SE Insurance Expense Supplies Experts $ $ 100.00 50000 $ 11,00 wand 35 W to 17 1 19 NO 1 G Cleanet 19.000 Acumben 200.00 Truck 1300000 Acceder 50.00 310.00 ola 10.00.651 Net om DOS VA www Warate Cleaning In Statement of Retained Earnings For the Month Ended September 10, 2015 1 5 Henning Retained tai Net Income Total Dividends Ending detained Earnings $ 180.00 5,500 4,000.00 1.000.00 1,900.00 $ $ Weighted average common stock outstanding 69,000.00 Analysis Liquidity Ratio Net Working Capital Formula Total Current Assets Total Liabilities Assets September 2015 Current ratio Current Assets / Current Liabilities Quick ratio Cash AR Marketable Sercurities/ Current Lia. Profitability Cash Ratio Gross Profit percentage Cash+Marketable Sercurities/ Current Lia. Gross Profit/Total Sales *100 Net Income percentage Net Income/ Total Sales 100 Operating Profit Ratio Operating Profit/ Revenue - Net Sales 100 Debt Analysis Debt Ratio Total Liabilities/Total Assets Interest Coverage Ratio EBIT /Interest Expenses IN/A ES Ratios Interest Coverage Ratio EBIT /Interest Expenses Asset Management Analysis N/A Inventory Turnover COGS / Average Inventory N/A Days-Sales-in-Inventory Ending Inventory / COGS 365 N/A Accounts Receivable Turnover Net Sales / Average Accounts Receivable Receivable Collection Period Accounts Receivable/Total Net Sales 365 Return on Assets Net Assets / Average Assets Total Asset Turnover Net Sales / Average Total Assets Fixed Asset Turnover Net Sales / Average Fixed Assets Stockholder's Reward Analysis Earnings Per Share Net Income / Average Outstanding Shares handenecha and nad standartins cheren FS Ratios D F Return on Assets Net Assets / Average Assets Total Asset Turnover Net Sales / Average Total Assets Fixed Asset Turnover Net Sales / Average Fixed Assets Stockholder's Reward Analysis Earnings Per Share Net Income / Average Outstanding Shares Dividend Pald/Average Outandstanding Shares Dividends Per Share Dividends Payout Ratio Dividend / Net Income Return on Equity Net Income / Shareholders Equity 7:06 - LTE Done Comprehensive Case 6 FS Analys... FS istiti Lup A 7:07 4 LTE Done Comprehensive Case 6 FS Analys... FS Ratio ini 7:07 LTE Done Comprehensive Case 6 FS Analys... FS Ratios 30-Sep-15 31-Aug-15 $ 16,600.00 $6,000 00 400.00 $ $ 7,000.00 $ $ 24,000.00 $ 5,000.00 Wayzata Cleaniny Inc. Balance Sheet 55 September 30, 2015 6 7 Assets 30-Sep-15 31-Aug-15 Liabilities 8 Cash $ 54,750.00 $ 59,150.00 Account Payables 9 Account receivables $ 6,500.00 $ Salary Payable Supplies $ 6,500.00 $ 6,000.00 Unearned Service Revenue 11. Prepaid Rent $ 7,500.00 $ Total Current abilities 12. Prepaid Insurance $ 1,100.00 $ Total CA $ 76,350.00 $ 65,150.00 Equity Common Stock 15 Cleaning Equipment 12,000.00 $ Retained Earnings 26 Accumulated Depreciati (200 00) $ Total Equity 7 Truck 18,000.00 $ 8 Accumulated Depreciati (250.00) $ 9 Total FA $ 29,550.00 $ Total Assets $ 105,900.00 $ 65,150.00 Total Debt + Equity $ 78,000.00 $60,000.00 $ 8.900.00 $ 1850.00) $ 81,900.00 $59,150.00 $ 105,900.00 $ 65,150.00 12 14. 15 Miscellaneous Expense Salary Expense Rent Expense Depreciation Expense Insurance Expense Supplies Expense Total Expenses Net Income Prepaid Rent Prepaid Insurance Total CA $ $ $ 8,400.00 $ 1,500.00 $ 450.00 $ 100.00 $ 500.00 $ 11,250.00 $ 5,750.00 17 18 19 Cleaning Equipment Accumulated Depreciatic Truck Accumulated Depreciati Total FA Total Assets 20 21 22 Wayzata Cleaning, Inc. Statement of Retained Earnings For the Month Ended September 30, 2015 2 A CON 24 25 26 Beginning Retained Earnings Net Income Total Dividends Ending Retained Earnings $ s $ $ $ (850.00) 5,750.00 4,900.00 1,000.00 3,900.00 27 28 29 30 31 2 3 1 Weighted average common stock outstanding 69,000.00 8 30-Sep-15 31-Aur 15 $ 16,600.00 $ 6,000.00 400.00 $ $ 7,000.00 $ $ 24,000.00 $ 5,000.00 Assets 30-Sep-15 31-Aug-15 Llabilities Cash $ 54,750.00 $ 59,150.00 Account Payables Account receivables $ 6,500.00 $ Salary Payable Supplies s 6,500.00 $ 6,000.00 Unearned Service Revenue Prepaid Rent $ 7,500.00 $ Total Current Liabilities Prepaid Insurance S 1,100.00 $ Total CA $ 76,350.00 $ 65,150.00 Equity Common Stock Cleaning Equipment 12,000.00 S Retained Earnines Accumulated Depreciati (200.00) Total Equity Truck 18,000.00 $ Accumulated Depreciatie (250.00) $ Total FA $ 29,550.00 $ Total Assets $ 105,900.00 $ 65,150.00 Total Debt + Equity $ 78,000.00 $ 60,000 00 $ 3,900.00 $ (850.00) $ 81,900.00 $ 59,150.00 $ 105,900.00 $65,150.00 Wisata Cleaning me Statement For the thinded September 2015 Wenata Balth September 2015 2 Service Depenses $17.00000 300.00 31 Aug in 11 12 1 516 SORO 60000 5700000 3 S 5 $ 5 5 5 5 Advertising pens Miscellaneous pense Salary Hent Expense Depreciation Conse Insurance sules per Top Nel come 14 15 TO 17 18 5.400.00 1.500.00 SODO TO000 500.00 11.2. 5.250,00 Anes 15 31 Aug 15 Lt G 5 50000 15000 AP Ne 10000 Supos $ 6,500.00 3.000.00 President 5 7.500.00 Prepaid 5 L100005 TA TS 50.00 5,150.00 Common stock Cleaning time 12.00000 Band Loud Depreci 200005 Total Tech 1.000.00 Acumulated arti 350.00 Tota 3.558,00 5 Total Asset $100.000.00 Totaleht 500000 5000.00 100005 S-51.000.000 20 $ 105,900.00 565,150.00 22 3 Wayata Cleaning in Statement of Metained Earnings For the Month Ended September 30, 2015 5 Hepininfetained Earnings FS Ratio 1850001 Y 11 $ G TA SON 1,150.00 14 Depreciation Insurance Dopplies Tataltem Net Income 0 1.500.00 5 450.00 5 10000 500.00 $ 11,00 5 5,750,00 Common Mo Hearings To 5 DO 3.000000 2005 (1) 21,000.00 $9,156.40 12 18 19 30 Cleaning met 13.000.000 Accumulated 1200001 18 od Accumulated Depreciati 125000 To $550.00 YA 105.700.00 65,150.00 Total Debt 5109.100.00 365,150.0 Wapata Cleaning, Inc. Statement of Retained farning For the Month Ended September 19, 2015 5 $ Beginning Retained Parnings Ninne Total Dividends Ending Metained in 5 5 $ (85000) 5.750.00 4,300.00 1.000,00 900.00 Weighted average common to standing 9,000.00 A D 3 4 E 5 Analysis Liquidity Ratio Net Working Capital Formula September 2015 6 7 8 9 Current ratio Quick ratio 10 Profitability Cash Ratio Gross Profit percentage 12 13 14 15 Net Income percentage Operating Profit Ratio 16 17 18 19 0 1 Debt Analysis Debt Ratio Interest Coverage Ratio N/A FS Ratios Interest Coverage Ratio N/A Asset Management Analysis Inventory Turnover N/A Days-Sales-in-Inventory N/A Accounts Receivable Turnover Receivable Collection Period Return on Assets Total Asset Turnover Fixed Asset Turnover Stockholder's Reward Analysis Earnings Per Share Dudanden Charm FS Ratios A B D Stockholder's Reward Analyst Earnings Per Share Dividends Per Share 36 37 38 39 40 41 42 43 Dividends Payout Ratio Return on Equity 44 45 46 17 18 19 0 1 2 Wayat Cleaning in from Mat For the Month nded September 2015 Wealing Be the September 2015 $ 17,000.00 Service ever pencer UTY Adversing benie Miscellaneous pense Salary tense Hent pense Depreciation Expense Insurance Expense Supplies Expense Total Expenses Net Income 1 100.150 5 5 5 840000 1,500.00 450.00 $ 100.00 5 500.00 $ 11,20 5,750.00 Arts 30 Sep 15 31 Aug 1 15 Cath 75000915000 count was 3150000 500000 ALL 500.00 Salary 100 Supplies 5 600.000,000.00 Une Service 000 Prepaident $ 7.500.000 Total Current bites. 200.000.000 Wrepaid in 3 1,100.00 CA 5 530.00 15000 tully Common och TODO 5.000 Cleaning forment 12.000.00 min $1,000.00 50.00 Accumulated Depreciate 12006 Totality 51,900.00 Trock 10,000.00 Accumulated recit 25000 Total S2000 Total Annet 5 105,000.00 55.150.00 Total Duty $105.900.00 355, 150,00 Wayate Cleaning Inc. Statement of Retained Earnings For the Month Ended September 30, 2015 FS Ratios Netcome $ 5,750.00 Alated Opreciate 250.00 5 YATA S. Tatal Arts $ 105,000.00 565,190,00 Wayata Cleaning in Statement of Retained Earnings For the Month Ended September 30, 2015 Beginning and Earnings Net Incom Total Dividends Ending Metained Farnings 5 $ 3 $ $ ISO) 5.750.00 4,900.00 1,000.00 3,900.00 Weighted average common stock outstanding 69.000.00 A B 4 D Ratio Net Working Capital Analysis Liquidity Formula 2015 5 6 7 8 9 Current ratio Quick ratio Profitability Cash Ratio Gross Profit percentage Net Income percentage 10 11 12 13 14 15 16 17 18 19 20 21 22 Operating Profit Ratio Debt Analysis Debt Ratio Interest Coverage Ratio N/A Asset Management Analysis Inventory Turnover Ratios N/A B D E Asset Management Analysis Inventory Turnover N/A Days Sales-in-Inventory N/A Accounts Receivable Turnover Receivable Collection Period Return on Assets Total Asset Turnover Fixed Asset Turnover Stockholder's Reward Analysis Earnings Per Share Dividends Per Share donde una Datu B D Return on Assets Total Asset Turnover 30 31 32 33 34 35 36 37 38 39 Fixed Asset Turnover Stockholder's Reward Analysis Earnings Per Share Dividends Per Share Dividends Payout Ratio 40 41 42 43 Return on Equity 44 45 47 48 Ratios Wayat Cleaning me Statement For the Month nded September 4, 2015 31.000.00 9 10 11 300.00 Service Reven beses uti Advertising and Miss me Salary pense be Detection Insurance Sus Dei Totaltepenas Net 13 10 15 5 5 5 5 $ 3 5 Wawei. Balance Sheet September 10, 2015 Anet 10-15 31415 30 Sep 15 554000 50.150.00 ACRE 3 350000 $ $15.000.000 Salary Payable Supplies 5 10000 000 Uredice Prepaid 57.000.00 7.500.000 Total Current Os Bread 1.100.00 Total $0.00 $ 150.00 57300000 50000000 Cleaning 100005 11. Acum DO 0.0055 Truck TR000 DOS AccuwDeprecat 125000 $ 2.55 Tales 105, 18.00 Total Duty 3105.00.0 61.150.00 240000 1 500.00 450.00 100.00 500.00 5 19 0.00 23 Welat Cleaning State of Retired Earnings For the Month fed september 30, 2015 25 atos 13 18 Totale Net 5 11,00 $ 5,750.00 Truck Total 11 100000 1000 $.00 $5.500.00 $ 150.00 31 27 To Wayta Cleaning Inc. Statement of Metodaning For the Month Ended: September 2015 5101 DO 150 24 25 25 Deine Stained in 28 Tot Divided $ 15 5 500 900.00 100000 Weledere common 000.00 614 36 40 75 Analysis Liquidity Ratio Net Working Capital Formula September 2015 Current ratio 3 3 0 1 Quick ratio Profitability Cash Ratio Gross Profit percentage 13 Net Income percent Operating Profi Ratio 86 17 18 19 Debt Analysis Debt Ratio Ratio A B D E Debt Analysis F Debt Ratio Interest Coverage Ratio N/A Asset Management Analysis inventory Turnover N/A Days-Sales-In-Inventory N/A 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Accounts Receivable Turnover Receivable Collection Period Return on Assets Total Asset Turnover Fixed Asset Tumover Stockholder's Reward Analysis Earnings Per Share FS Ratios WC For the Midd september 2015 09 ROS 5 ODE c Serve es LIVE Advertising Miscellaneous Salary Experie Hent Expense Depreciation Expense Insurance Expense Suplies Expense Total Expenses Net Income $ 2. W 5 S R400.00 1,500.00 450.00 $ 100.00 500.00 $11,250.00 $ 5.750.00 $ A 30- 31 Aug 1 ch S5425000 15000 cm Acreceivabi 5 50000 Salary Buples 5 000.000.00 5 705 Prepaid $ 1.100.000 Tinta 1.00 Com Cleaning Coment 13000.00 Accumulated precis 17000 Truri 1800000 Accumulated Deprecia 1250.00 Total $ 20,000 $ Total Assets S105.300.00 50.150.00 5700000 5000000 5000 8500 Total Dettol $10,000.150.00 Wayrala Cleaning Inc. Statement of Retained Earnings For the Month Inded September 30, 2015 FS Ratios SE Insurance Expense Supplies Experts $ $ 100.00 50000 $ 11,00 wand 35 W to 17 1 19 NO 1 G Cleanet 19.000 Acumben 200.00 Truck 1300000 Acceder 50.00 310.00 ola 10.00.651 Net om DOS VA www Warate Cleaning In Statement of Retained Earnings For the Month Ended September 10, 2015 1 5 Henning Retained tai Net Income Total Dividends Ending detained Earnings $ 180.00 5,500 4,000.00 1.000.00 1,900.00 $ $ Weighted average common stock outstanding 69,000.00 Analysis Liquidity Ratio Net Working Capital Formula Total Current Assets Total Liabilities Assets September 2015 Current ratio Current Assets / Current Liabilities Quick ratio Cash AR Marketable Sercurities/ Current Lia. Profitability Cash Ratio Gross Profit percentage Cash+Marketable Sercurities/ Current Lia. Gross Profit/Total Sales *100 Net Income percentage Net Income/ Total Sales 100 Operating Profit Ratio Operating Profit/ Revenue - Net Sales 100 Debt Analysis Debt Ratio Total Liabilities/Total Assets Interest Coverage Ratio EBIT /Interest Expenses IN/A ES Ratios Interest Coverage Ratio EBIT /Interest Expenses Asset Management Analysis N/A Inventory Turnover COGS / Average Inventory N/A Days-Sales-in-Inventory Ending Inventory / COGS 365 N/A Accounts Receivable Turnover Net Sales / Average Accounts Receivable Receivable Collection Period Accounts Receivable/Total Net Sales 365 Return on Assets Net Assets / Average Assets Total Asset Turnover Net Sales / Average Total Assets Fixed Asset Turnover Net Sales / Average Fixed Assets Stockholder's Reward Analysis Earnings Per Share Net Income / Average Outstanding Shares handenecha and nad standartins cheren FS Ratios D F Return on Assets Net Assets / Average Assets Total Asset Turnover Net Sales / Average Total Assets Fixed Asset Turnover Net Sales / Average Fixed Assets Stockholder's Reward Analysis Earnings Per Share Net Income / Average Outstanding Shares Dividend Pald/Average Outandstanding Shares Dividends Per Share Dividends Payout Ratio Dividend / Net Income Return on Equity Net Income / Shareholders Equity 7:06 - LTE Done Comprehensive Case 6 FS Analys... FS istiti Lup A 7:07 4 LTE Done Comprehensive Case 6 FS Analys... FS Ratio ini 7:07 LTE Done Comprehensive Case 6 FS Analys... FS Ratios 30-Sep-15 31-Aug-15 $ 16,600.00 $6,000 00 400.00 $ $ 7,000.00 $ $ 24,000.00 $ 5,000.00 Wayzata Cleaniny Inc. Balance Sheet 55 September 30, 2015 6 7 Assets 30-Sep-15 31-Aug-15 Liabilities 8 Cash $ 54,750.00 $ 59,150.00 Account Payables 9 Account receivables $ 6,500.00 $ Salary Payable Supplies $ 6,500.00 $ 6,000.00 Unearned Service Revenue 11. Prepaid Rent $ 7,500.00 $ Total Current abilities 12. Prepaid Insurance $ 1,100.00 $ Total CA $ 76,350.00 $ 65,150.00 Equity Common Stock 15 Cleaning Equipment 12,000.00 $ Retained Earnings 26 Accumulated Depreciati (200 00) $ Total Equity 7 Truck 18,000.00 $ 8 Accumulated Depreciati (250.00) $ 9 Total FA $ 29,550.00 $ Total Assets $ 105,900.00 $ 65,150.00 Total Debt + Equity $ 78,000.00 $60,000.00 $ 8.900.00 $ 1850.00) $ 81,900.00 $59,150.00 $ 105,900.00 $ 65,150.00 12 14. 15 Miscellaneous Expense Salary Expense Rent Expense Depreciation Expense Insurance Expense Supplies Expense Total Expenses Net Income Prepaid Rent Prepaid Insurance Total CA $ $ $ 8,400.00 $ 1,500.00 $ 450.00 $ 100.00 $ 500.00 $ 11,250.00 $ 5,750.00 17 18 19 Cleaning Equipment Accumulated Depreciatic Truck Accumulated Depreciati Total FA Total Assets 20 21 22 Wayzata Cleaning, Inc. Statement of Retained Earnings For the Month Ended September 30, 2015 2 A CON 24 25 26 Beginning Retained Earnings Net Income Total Dividends Ending Retained Earnings $ s $ $ $ (850.00) 5,750.00 4,900.00 1,000.00 3,900.00 27 28 29 30 31 2 3 1 Weighted average common stock outstanding 69,000.00 8 30-Sep-15 31-Aur 15 $ 16,600.00 $ 6,000.00 400.00 $ $ 7,000.00 $ $ 24,000.00 $ 5,000.00 Assets 30-Sep-15 31-Aug-15 Llabilities Cash $ 54,750.00 $ 59,150.00 Account Payables Account receivables $ 6,500.00 $ Salary Payable Supplies s 6,500.00 $ 6,000.00 Unearned Service Revenue Prepaid Rent $ 7,500.00 $ Total Current Liabilities Prepaid Insurance S 1,100.00 $ Total CA $ 76,350.00 $ 65,150.00 Equity Common Stock Cleaning Equipment 12,000.00 S Retained Earnines Accumulated Depreciati (200.00) Total Equity Truck 18,000.00 $ Accumulated Depreciatie (250.00) $ Total FA $ 29,550.00 $ Total Assets $ 105,900.00 $ 65,150.00 Total Debt + Equity $ 78,000.00 $ 60,000 00 $ 3,900.00 $ (850.00) $ 81,900.00 $ 59,150.00 $ 105,900.00 $65,150.00
