Question: Hi, I have to create a revised trial balance, revised balance sheet 2017, revised income statement 2017, revised retained earnings 2017, revised cash flow 2017
Hi, I have to create a revised trial balance, revised balance sheet 2017, revised income statement 2017, revised retained earnings 2017, revised cash flow 2017 and grab the quick ratios. Can you please help












TRIAL BALANCE As of December 31, 2017 Milestone One Workbook Instructions Note: Refer to the Final Project Scenario document for Peyton's ratio formulas. Peyton Approved Ratio Analysis 2017 2016 Current Ratio (Working Capital) 5.79 5.18 Quick Ratio 4.89 4.91 4.60 A/R Turnover 4.79 6.34 5.04 Inventory Turnover 7.36 Gross Margin 68% Return on Sales 53% Return on Equity 125% Return on Assets 101% Milestone One Workbook Instructions Revised Peyton Approved Statement of Cash Flow for Year Ended 12/31/2017 Prelimnary Peyton Approved Statement of Retained Earnings for Year Ended 12/31/2017 Beginning Balance: plus Net Income less Dividends: Ending Balance \$ 50,144.84 175,576.18 105,000.00 $120,721.02 Peyton Approved Income Statement for Year Ended 12/31/2017 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit Operating Expenses: Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Total Operating Expenses: Net Income \$ 327,322.55 1,205.64 328,528.19 105,834.29 859.77 106,694.06 221,834.13 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091.08 1,549.74 818.31 490.98 46,257.95 175,576.18 TRIAL BALANCE As of December 31, 2017 Milestone One Workbook Instructions Note: Refer to the Final Project Scenario document for Peyton's ratio formulas. Peyton Approved Ratio Analysis 2017 2016 Current Ratio (Working Capital) 5.79 5.18 Quick Ratio 4.89 4.91 4.60 A/R Turnover 4.79 6.34 5.04 Inventory Turnover 7.36 Gross Margin 68% Return on Sales 53% Return on Equity 125% Return on Assets 101% Milestone One Workbook Instructions Revised Peyton Approved Statement of Cash Flow for Year Ended 12/31/2017 Prelimnary Peyton Approved Statement of Retained Earnings for Year Ended 12/31/2017 Beginning Balance: plus Net Income less Dividends: Ending Balance \$ 50,144.84 175,576.18 105,000.00 $120,721.02 Peyton Approved Income Statement for Year Ended 12/31/2017 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit Operating Expenses: Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Total Operating Expenses: Net Income \$ 327,322.55 1,205.64 328,528.19 105,834.29 859.77 106,694.06 221,834.13 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091.08 1,549.74 818.31 490.98 46,257.95 175,576.18
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
