Calibri (Body) c Enter text or formula here Instructions: Ensure your Excel solutions below are rounded to nearest hundredth place (i.e. 55.476, should round to 55.48) General Ratio Analysis Compute the Using Words, Show Formula (i.e. Owner's Equity = Assets - Liabilities) Show Calculations Using an Excel Formula Explain What the Ratio Means, as it relates to Jane's Skateboards Current Ratio Debt to Total Assets Gross Profit Percentage Net Income by Net Sales Earnings per Common Share (EPS) Payout Ratio on Common Stock ing Entries 4.29 .20 50% 12.08% 94.04% 11 - Ratio Analysis 4.29 0.20363593 5000.00% 1208.33% 12 - Break Even Grading Rubric B rmula here Requirement #10: Prepare a post-closing trial balance as of July 31 in the space below. Janes Skateboard Post Closing Trial Balance For the Month Ended Jul! 31, 20XX Account Name Account Number Cash 111 Store Supplies 117 Prepaid Insurance 119 Merchandise Inventory 130 Store Fixtures 144 Accumulated Depreciation -Fixtures 145 Accounts Payable Income Tax Payable 212 213 Common Stock 311 Retained Earnings 312 Dividends 313 Sales Revenue 41 Cost of Good Sold 505 Store Rent Expense 511 Telephone Expense 517 Depreciation Expense 520 Electric Expense 522 Insurance Expense 525 Supplies Expense 530 Income Tax Expense 535 Total: 34,855 | 100,755 10 - Post Closing Tri... 11 - Ratio An ak Even Grading Rubric + G Arial 10 B I U S A v General . .. V fx Enter text or formula here B C D E F G H 3 4 Jane's Skateboards Inc. 5 Income Statement 6 For the Month Ending July 31 8 Revenues: 9 Sales Revenue 10 Less: Variable Expenses 11 Contribution Margin 12 Less: Fixed Expenses 13 Operating Income 14 15 Break-Even in Sales Dollars = 16 Break-Even in Units = 17 18 19 20 21 22 23 24 6 - Adjusted Trial Bal... 8 & 9 - Closing Entries 10 - Post Closing Tri.. 11 - Ratio Analysis 12 - Break Even Grading Rubric +