Need help calculating financial ratio analysis that includes liquidity, profitability, and solvency
For the Month Ended 4/30/2015 Income Statement Jim's Auto Body For the Month Ended 4/30/2015 Angel's Auto Body 2014 2015 Variance Dollars % Dollars % Service Revenue 28,000 32000 4,000 service Revenue 28,000 100.00% 189,000 100.00% Salary Expense 4,500 5,200 700 Salary Expense 4,500 16.07% 40,000 21.16% 1, 200 1,300 100 Rent Expense Rent Expense 1, 200 4.29% 8,000 4.23% Utility Expense 300 420 120 Utility Expense 300 1.07% 2,400 1.27% Depreciation Expense 500 500 Depreciation Expense 500 1.79% 2,855 1.51% Insurance Expense 100 125 25 Insurance Expense 100 0.36% 2,000 1.06% Supply Expense 400 320 08 Supply Expense 400 1.43% 4,300 2.28% Net Income 21,000 24, 135 3,135 Net Income 21,000 75.00% 129,445 68.49% VERTICAL ANALYSIS HORITZONTAL Balance Sheet Balance Sheet As of 4/30/2015 As of 4/30/2015 Jim's Auto Body Angel's Auto Body 2014 2015 Variance Dollars % Dollars Cash 101,800 145, 000 43,200 Cash 101, 800 56.56% 332,000 62.55% Acct Rec'able 20,000 34,000 14,000 Acct Rec'able 20,000 11.11% 67,000 12.62% PP In 1,100 1, 100 PP In 1, 100 0.61% 1, 100 0.21% Equipment 55,000 62,000 7,000 Equipment 55,000 30.56% 122,000 22.98% Accu. Dep. (500) 750 (250) Accu. Dep. (500) -0.28% -3,300 -0.62% Supplies 2,600 2,300 (300) Supplies 2,600 1.44% 12,000 2.26% Total Assets 180,000 243,650 63,650 Total Assets 180,000 100.00% 530,800 100.00% Accounts Payable 8,000 22,000 14,000 Accounts Payable 8,000 4.44% 192,000 36.17% Salary Payable 3,000 4,500 1,500 Salary Payable 3,000 1.67% 10,000 1.88% Total Liabilities 11,000 26,500 15,500 Total Liabilities 11,000 6.11% 202,000 38.06% Common Stock 150,000 198, 150 48, 150 0 Common Stock 150,000 83.33% 203, 800 38.39% Retained Earnings 19,000 19,000 Retained Earnings 19,000 10.56% 125,000 23.55% Total Stockholders' Equity 169,000 217, 150 48, 150 2 Total Stockholders' Equity 169,000 93.89% 328,800 61.94% Stockholders' Equity 180,000 243,650 63,650 Total Liabilities & 180,000 100.00% 530,800 100.00%