Small Business Excel Sheet Exercise
Sheet1 JAMES CONFECTIONERS Monetary Statements INCOME STATEMENTS 20XX RATIO ANALYSIS 20XX SUBJECT INDUSTRY MEDIAN Gross sales Present 1.7 COGS Fast zero.eight GP A/R Flip 15.7 SGA Exp. Avg Coll 23 Deprec. Inv Flip four.9 EBIT (Oper. Revenue) Curiosity OI ROI EBT OPM Revenue Taxes FA Flip eight.2 Web Revenue Debt/TA zero.7 Instances Int 2.three BALANCE SHEETS 20XX ROE 16.5 ASSETS ROA 5.6 CURRENT ASSETS Money Accounts Receivable Inventories Different Present TOTAL CURRENT ASSETS FIXED ASSETS Gross PP&E Collected Depreciation Web PP&E Different Mounted TOTAL ASSETS LIABILITIES & EQUITY CURRENT LIABILITIES Accounts Payable/Accruals Brief Time period Debt TOTAL CURRENT LIABILITIES LONG TERM DEBT STKHLDRS EQUITY Widespread Inventory (par+paid-in) Retained Earnings TOTAL LIABILITIES & EQUITY Sheet2 Sheet3 -research paper writing service