Financial Analysis

Qunsl82020
07232020.xlsx
Home>Business & Finance homework help>Accounting homework help>Financial Analysis

Horizontal Analysis

Difference % Change Inc or Dec Difference % Change Inc or Dec
Jim's Auto Body Angel's Auto Body Jim's Auto Body Angel's Auto Body
Income Statement Income Statement Balance Sheet Balance Sheet
As of April 30, 2014 As of April 30, 2015 As of April 30, 2014 As of April 30, 2015
Assets: Assets:
Revenues: Revenues: Cash 101,800 Cash 145,000 43,200 42.44%
Service Revenue 28,000 Service Revenue 32,000 4,000 14.29% Acct Rec'able 20,000 Acct Rec'able 34,000 14,000 70.00%
Total Revenue 28,000 Total Revenue 32,000 4,000 14.29% PP In 1,100 PP In 1,100 - 0 0.00%
Equipment 55,000 Equipment 62,000 7,000 12.73%
Expenses: Expenses: Accu. Dep. 500 Accu. Dep. 750 250 50.00%
Salary Expense 4,500 Salary Expense 5,200 700 15.56% Supplies 2,600 Supplies 2,300 (300) -11.54%
Rent Expense 1,200 Rent Expense 1,300 100 8.33% Total Assets 180,000 Total Assets 243,650 63,650 35.36%
Utility Expense 300 Utility Expense 420 120 40.00%
Depreciation Expense 500 Depreciation Expense 500 0 0.00% Liabilities and Stockholders' Equity Liabilities and Stockholders' Equity
Insurance Expense 100 Insurance Expense 125 25 25.00% Liabilities: Liabilities:
Supply Expense 400 Supply Expense 325 -75 -18.75% Accounts Payable 8,000 Accounts Payable 22,000 14,000 175.00%
Total Expenses 7,000 Total Expenses 7,870 870 12.43% Salary Payable 3,000 Salary Payable 4,500 1,500 50.00%
Total Liabilities 11000.00 Total Liabilities 26500.00 15,500 140.91%
21,000 24,130 3,130 14.90%
Stockholders' Equity: Stockholders' Equity:
Common Stock 150,000 Common Stock 198,150 48,150 32.10%
Retained Earnings 19000 Retained Earnings 19000 - 0 0.00%
Total Stockholders' Equity 169000.00 Total Stockholders' Equity 217150.00 48,150 28.49%
Total Liabilities & Stockholders' Equity 180,000 Total Liabilities & Stockholders' Equity 243,650 63,650 35.36%

Vertical Analysis

Jim's Auto Body % of Total Revenue Angel's Auto Body % of Total Revenue Jim's Auto Body % of Total Revenue Angel's Auto Body % of Total Revenue
Income Statement Income Statement Balance Sheet Balance Sheet
As of April 30, 2014 As of April 30, 2014 As of April 30, 2014 As of April 30, 2014
Assets: Assets:
Revenues: Revenues: Cash 101,800 56.6% Cash 332,000 62.5%
Service Revenue 28,000 100.0% Service Revenue 189,000 100.0% Acct Rec'able 20,000 11.1% Acct Rec'able 67,000 12.6%
Total Revenue 28,000 100.0% Total Revenue 189,000 100.0% PP In 1,100 0.6% PP In 1,100 0.2%
Equipment 55,000 30.6% Equipment 122,000 23.0%
Expenses: Expenses: Accu. Dep. 500 -0.3% Accu. Dep. 3,300 -0.6%
Salary Expense 4,500 16.1% Salary Expense 40,000 21.2% Supplies 2,600 1.4% Supplies 12,000 2.3%
Rent Expense 1,200 4.3% Rent Expense 8,000 4.2% Total Assets 180,000 100.0% Total Assets 530,800 100.0%
Utility Expense 300 1.1% Utility Expense 2,400 1.3%
Depreciation Expense 500 1.8% Depreciation Expense 2,855 1.5% Liabilities and Stockholders' Equity Liabilities and Stockholders' Equity
Insurance Expense 100 0.4% Insurance Expense 2,000 1.1% Liabilities: Liabilities:
Supply Expense 400 1.4% Supply Expense 4,300 2.3% Accounts Payable 8,000 4.4% Accounts Payable 192,000 36.2%
Total Expenses 7,000 25.0% Total Expenses 59,555 31.5% Salary Payable 3,000 1.7% Salary Payable 10,000 1.9%
Total Liabilities 11000.00 6.1% Total Liabilities 202000.00 38.1%
21,000 75.0% 129,445 68.5%
Stockholders' Equity: Stockholders' Equity:
Common Stock 150,000 83.3% Common Stock 203,800 38.4%
Retained Earnings 19000 10.6% Retained Earnings 125000 23.5%
Total Stockholders' Equity 169000.00 93.9% Total Stockholders' Equity 328800.00 61.9%
Total Liabilities & Stockholders' Equity 180,000 100.0% Total Liabilities & Stockholders' Equity 530,800 100.0%
For the Month Ended 4/30/2014