MD&A

profilejugxyaev
ACCT460.xlsx
Home>Business & Finance homework help>Accounting homework help>MD&A

Horizontal Analysis

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

Vertical Analysis

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, 2014 As of April 30, 2014 As of April 30, 2014
Assets: Assets:
Revenues: Revenues: Cash 101,800 Cash 332,000
Service Revenue 28,000 Service Revenue 189,000 Acct Rec'able 20,000 Acct Rec'able 67,000
Total Revenue 28,000 Total Revenue 189,000 PP In 1,100 PP In 1,100
Equipment 55,000 Equipment 122,000
Expenses: Expenses: Accu. Dep. 500 Accu. Dep. 3,300
Salary Expense 4,500 Salary Expense 40,000 Supplies 2,600 Supplies 12,000
Rent Expense 1,200 Rent Expense 8,000 Total Assets 180,000 Total Assets 530,800
Utility Expense 300 Utility Expense 2,400
Depreciation Expense 500 Depreciation Expense 2,855 Liabilities and Stockholders' Equity Liabilities and Stockholders' Equity
Insurance Expense 100 Insurance Expense 2,000 Liabilities: Liabilities:
Supply Expense 400 Supply Expense 4,300 Accounts Payable 8,000 Accounts Payable 192,000
Total Expenses 7,000 Total Expenses 59,555 Salary Payable 3,000 Salary Payable 10,000
Total Liabilities 11000.00 Total Liabilities 202000.00
21,000 129,445
Stockholders' Equity: Stockholders' Equity:
Common Stock 150,000 Common Stock 203,800
Retained Earnings 19000 Retained Earnings 125000
Total Stockholders' Equity 169000.00 Total Stockholders' Equity 328800.00
Total Liabilities & Stockholders' Equity 180,000 Total Liabilities & Stockholders' Equity 530,800
For the Month Ended 4/30/2014
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, 2014 As of April 30, 2014 As of April 30, 2014
Assets: Assets:
Revenues: Revenues: Cash 101,800 56.56% Cash 332,000 62.55%
Service Revenue 28,000 100.00% Service Revenue 189,000 100.00% Acct Rec'able 20,000 11.11% Acct Rec'able 67,000 12.62%
Total Revenue 28,000 100.00% Total Revenue 189,000 100.00% PP In 1,100 0.61% PP In 1,100 0.21%
Equipment 55,000 30.56% Equipment 122,000 22.98%
Expenses: Expenses: Accu. Dep. 500 0.28% Accu. Dep. (3,300) -0.62%
Salary Expense 4,500 16.07% Salary Expense 40,000 21.16% Supplies 2,600 1.44% Supplies 12,000 2.26%
Rent Expense 1,200 4.29% Rent Expense 8,000 4.23% Total Assets 180,000 100.00% Total Assets 530,800 100.00%
Utility Expense 300 1.07% Utility Expense 2,400 1.27%
Depreciation Expense 500 1.79% Depreciation Expense 2,855 1.51% Liabilities and Stockholders' Equity Liabilities and Stockholders' Equity
Insurance Expense 100 0.36% Insurance Expense 2,000 1.06% Liabilities: Liabilities:
Supply Expense 400 1.43% Supply Expense 4,300 2.28% Accounts Payable 8,000 4.44% Accounts Payable 192,000 36.17%
Total Expenses 7,000 25.00% Total Expenses 59,555 31.51% Salary Payable 3,000 1.67% Salary Payable 10,000 1.88%
Total Liabilities 11000.00 6.11% Total Liabilities 202000.00 38.06%
21,000 75.00% 129,445 68.49%
Stockholders' Equity: Stockholders' Equity:
Common Stock 150,000 83.33% Common Stock 203,800 38.39%
Retained Earnings 19000 10.56% Retained Earnings 125000 23.55%
Total Stockholders' Equity 169000.00 93.89% Total Stockholders' Equity 328800.00 61.94%
Total Liabilities & Stockholders' Equity 180,000 100.00% Total Liabilities & Stockholders' Equity 530,800 100.00%