Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

Need help calculating financial ratio analysis that includes liquidity, profitability, and solvency

image text in transcribed
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%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Statement Analysis

Authors: K. R. Subramanyam, John J. Wild

10th edition

73379433, 73379432, 978-0073379432

More Books

Students also viewed these Accounting questions

Question

14. Now reconcile what you answered to problem 15 with problem 13.

Answered: 1 week ago