50.1K

Verified Solution

Link Copied!

i need assistance with the Statement of cash flow please

i added the income statement

3 For Month Ending 6/30/20XX Consider the flow of the cash for each item when adding to the cash flow statement. Does the cash come in or go out? \begin{tabular}{|c|c|c|c|c|c|c|} \hline Balance Sheet Accounts. & \multicolumn{2}{|c|}{ Ending Balance } & \multicolumn{2}{|c|}{ Beginning Balance } & \multicolumn{2}{|c|}{ Change } \\ \hline Cash & $ & 231,917,00 & $ & 100,000.00 & $ & 131,917.00 \\ \hline Printer Equipment & $ & 105,000.00 & $ & 50,000,00 & $ & 55,000.00 \\ \hline Accumulated Depreciation - Printer Equipment & s & (28,875,00) & $ & 22,00000 & $ & (50,875,00) \\ \hline Vehicles & $ & 45,000.00 & $ & 45,000,00 & $ & - \\ \hline Accumulated Depreciation - Vehicles & $ & (20,000,00) & \$ & 20,000.00 & s. & (40,000.00) \\ \hline Right of Use Lease Asset & \$. & 169,400,00 & $ & 49,000.00 & 5 & 120,400.00 \\ \hline Accumulated Amortization - Rught of Use Lease Asset & 5 & (10,000,00) & 5 & 10,000.00 & 5 & (20,000.00) \\ \hline Interest Payable. & 3 & 1,670,00 & \$. & 500.00 & $ & 1,170.00 \\ \hline Note Paysble. & $ & 70,000,00 & \$. & 10,000.00 & s & 60.000 .00 \\ \hline Lease Liability & 5 & 135,400.00 & 5 & 15,000.00 & $ & 120,400,00 \\ \hline Bond payable & 5 & 75,000,00 & 5 & 7 & s & 75,000.00 \\ \hline Discount on Bond Payoble & s & (5,576.50) & 5 & & $ & (5,576,50) \\ \hline Retained Earnings & 5 & 109,000.00 & 53 & 131,500.00 & $ & (22,500,00) \\ \hline Common Stock. & s & 10,200,00 & $ & 5,000,00 & $ & 5,200,00 \\ \hline Additional Paid-in Capital & s & 63.800 .00 & s & 30,000.00 & s & 33,900.00 \\ \hline Treasury Stock & s & 1,250,00 & $ & (1,250.00) & $ & 2,500.00 \\ \hlinex2 & & & & & & 466,435,50 \\ \hline \end{tabular} Statement of Retained Eamings Cash Flow Worksheet Statement of Cash Flows Rotios 1 Sharper! Enterprises inc. 2 Statement of Cash flow 3 For Period Ending 6/30/20XX 4 5 6 7 8 9 10 11 12 13 \begin{tabular}{|l|l|r|} \hline Net income & $ & 69,198.33 \\ \hline Depreciation Expense & $ & 6,875.00 \\ \hline Increase Amortization of Bonds Discount & [insert value] & \\ \hline Increase in Interest Payable & [insert value] & \\ \hline Net cash provided by operating activities & $ & 76,073.33 \\ \hline \end{tabular} Equipment Purchases \begin{tabular}{l} Cash flows from investing activities \\ \hline Issuance of Common Stock \\ \hline Addition of Paid-in Capital \\ \hline Purchase of Treasury Stock \\ \hline Issuance of Bonds Payable \\ \hline Dividends Paid \\ \hline Nonter Dasuhle Neriuirar \\ \hline \end{tabular} Cash Flow Workheet Statement of Cash Flows Ratios fready DeAccessibility imestigate \begin{tabular}{|c|c|c|} \hline 15 & & 5 \\ \hline 16 & Issuance of Common Stock & [Insert value] \\ \hline 17 & Addition of Paid-in Capital & [Insert value] \\ \hline 18 & Purchase of Treasury Stock & [Insert value] \\ \hline 19 & Issuance of Bonds Payable & [Insert value] \\ \hline 20 & Dividends Paid & [insert value] \\ \hline 21 & Notes Payable Acquired & [Insert value] \\ \hline 22 & Cash Flows from financing activities & $ \\ \hline 23 & & \\ \hline 24 & Net increase/decrease in cash & $ \\ \hline 25 & Cash at Beginning of Period & 100,000,00 \\ \hline 26 & Cash at End of Period & 176,073.33 \\ \hline 27 & & HA \\ \hline 28 & Cash From Balance Sheet & 231,917.00 \\ \hline 29 & Variance & s \\ \hline \end{tabular} Statement of Retained Farnings Cash Flow Worksheet Statement of Cash Flows Ratios Income Statement For Month ending 6/30/20XX \begin{tabular}{l|ll|} \hline Revenues & & \\ \hline Revenue & S & 100,000.00 \\ \hline \multicolumn{1}{|c|}{} & & \\ \hline Total Revenues & $ & 100,000.00 \\ \hline \end{tabular} \begin{tabular}{l|lr|} \hline Operating Expenses: & \multicolumn{1}{l|}{} \\ \hline Rent Expense & S & 20,000.00 \\ \hline Interest Expense & $ & 3,926.67 \\ \hline Depreciation Expense & S & 6,875.00 \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline Total Operating Expenses: & $ & 69,198.33 \\ \hline \end{tabular} 3 For Month Ending 6/30/20XX Consider the flow of the cash for each item when adding to the cash flow statement. Does the cash come in or go out? \begin{tabular}{|c|c|c|c|c|c|c|} \hline Balance Sheet Accounts. & \multicolumn{2}{|c|}{ Ending Balance } & \multicolumn{2}{|c|}{ Beginning Balance } & \multicolumn{2}{|c|}{ Change } \\ \hline Cash & $ & 231,917,00 & $ & 100,000.00 & $ & 131,917.00 \\ \hline Printer Equipment & $ & 105,000.00 & $ & 50,000,00 & $ & 55,000.00 \\ \hline Accumulated Depreciation - Printer Equipment & s & (28,875,00) & $ & 22,00000 & $ & (50,875,00) \\ \hline Vehicles & $ & 45,000.00 & $ & 45,000,00 & $ & - \\ \hline Accumulated Depreciation - Vehicles & $ & (20,000,00) & \$ & 20,000.00 & s. & (40,000.00) \\ \hline Right of Use Lease Asset & \$. & 169,400,00 & $ & 49,000.00 & 5 & 120,400.00 \\ \hline Accumulated Amortization - Rught of Use Lease Asset & 5 & (10,000,00) & 5 & 10,000.00 & 5 & (20,000.00) \\ \hline Interest Payable. & 3 & 1,670,00 & \$. & 500.00 & $ & 1,170.00 \\ \hline Note Paysble. & $ & 70,000,00 & \$. & 10,000.00 & s & 60.000 .00 \\ \hline Lease Liability & 5 & 135,400.00 & 5 & 15,000.00 & $ & 120,400,00 \\ \hline Bond payable & 5 & 75,000,00 & 5 & 7 & s & 75,000.00 \\ \hline Discount on Bond Payoble & s & (5,576.50) & 5 & & $ & (5,576,50) \\ \hline Retained Earnings & 5 & 109,000.00 & 53 & 131,500.00 & $ & (22,500,00) \\ \hline Common Stock. & s & 10,200,00 & $ & 5,000,00 & $ & 5,200,00 \\ \hline Additional Paid-in Capital & s & 63.800 .00 & s & 30,000.00 & s & 33,900.00 \\ \hline Treasury Stock & s & 1,250,00 & $ & (1,250.00) & $ & 2,500.00 \\ \hlinex2 & & & & & & 466,435,50 \\ \hline \end{tabular} Statement of Retained Eamings Cash Flow Worksheet Statement of Cash Flows Rotios 1 Sharper! Enterprises inc. 2 Statement of Cash flow 3 For Period Ending 6/30/20XX 4 5 6 7 8 9 10 11 12 13 \begin{tabular}{|l|l|r|} \hline Net income & $ & 69,198.33 \\ \hline Depreciation Expense & $ & 6,875.00 \\ \hline Increase Amortization of Bonds Discount & [insert value] & \\ \hline Increase in Interest Payable & [insert value] & \\ \hline Net cash provided by operating activities & $ & 76,073.33 \\ \hline \end{tabular} Equipment Purchases \begin{tabular}{l} Cash flows from investing activities \\ \hline Issuance of Common Stock \\ \hline Addition of Paid-in Capital \\ \hline Purchase of Treasury Stock \\ \hline Issuance of Bonds Payable \\ \hline Dividends Paid \\ \hline Nonter Dasuhle Neriuirar \\ \hline \end{tabular} Cash Flow Workheet Statement of Cash Flows Ratios fready DeAccessibility imestigate \begin{tabular}{|c|c|c|} \hline 15 & & 5 \\ \hline 16 & Issuance of Common Stock & [Insert value] \\ \hline 17 & Addition of Paid-in Capital & [Insert value] \\ \hline 18 & Purchase of Treasury Stock & [Insert value] \\ \hline 19 & Issuance of Bonds Payable & [Insert value] \\ \hline 20 & Dividends Paid & [insert value] \\ \hline 21 & Notes Payable Acquired & [Insert value] \\ \hline 22 & Cash Flows from financing activities & $ \\ \hline 23 & & \\ \hline 24 & Net increase/decrease in cash & $ \\ \hline 25 & Cash at Beginning of Period & 100,000,00 \\ \hline 26 & Cash at End of Period & 176,073.33 \\ \hline 27 & & HA \\ \hline 28 & Cash From Balance Sheet & 231,917.00 \\ \hline 29 & Variance & s \\ \hline \end{tabular} Statement of Retained Farnings Cash Flow Worksheet Statement of Cash Flows Ratios Income Statement For Month ending 6/30/20XX \begin{tabular}{l|ll|} \hline Revenues & & \\ \hline Revenue & S & 100,000.00 \\ \hline \multicolumn{1}{|c|}{} & & \\ \hline Total Revenues & $ & 100,000.00 \\ \hline \end{tabular} \begin{tabular}{l|lr|} \hline Operating Expenses: & \multicolumn{1}{l|}{} \\ \hline Rent Expense & S & 20,000.00 \\ \hline Interest Expense & $ & 3,926.67 \\ \hline Depreciation Expense & S & 6,875.00 \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline Total Operating Expenses: & $ & 69,198.33 \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer