\

1	Perform the analysis of a financial statement of ABC Corporation using the statements provided
2	Perform the following ratio analysis on the statements of ABC Corporation using the statements provided
		Current Ratio
		Return On Asset Ratio
		Net Profit Ratio
		Debt To Equity Ratio

a) Perform the analysis of a financial statement of ABC Corporation using the statements provided

b) Perform the following ratio analysis on the statements of ABC Corporation using the statements provided

PLEASE USE EXCEL

Period: 2019 2018 2017 1 Revenue Sale of tablets Sale of laptops Repair services Total Revenue $ 4,000 8,000 12,000 24,000 3,000 6,000 6,000 15,000 2,000 4,000 3,000 9,000 2 Cost of Goods/Services Cost tablets sold Cost of laptops sold Cost of repair services (repair technician) Total Cost Of Goods and Services Gross Profit 2,000 4,000 4,000 10,000 14,000 1,500 3,000 2,000 6,500 8,500 1,000 2,000 1,000 4,000 5,000 1,000 2,500 500 700 200 1,200 1,700 400 3 Operating Expenses Shop rent Employee salaries Utilities Advertisments Office Supplies Cleaning Interest on loans Depreciation charges for equipment, furniture, etc Taxes Total Expenses 600 200 1,000 5,500 600 800 200 500 1,500 200 400 10,700 400 300 1,500 200 1,500 200 300 6,400 300 7,300 Net Profit (Net Income) 3,300 1,200 (1,400) Mid Term Quiz Income Statement Balance Sheet Ratios For Trucking Companies A Assets Current Aseets 1 Cash at hand 2 Cash in the bank 3 Inventory for sale (Tablets) Inventory for sale (Laptops) 5 Accounts Recivables (uncolected revenue from clients) Marketable investments (stocks, bonds, CDs etc) 7 Suspense account (unreconciled assets) Etc Total Current Assets $500 $3,000 $20,000 $15,000 $10,000 $0 $300 $2,500 $15,000 $15,000 $12,000 $0 $200 $1,500 $10,000 $10,000 $14,000 $0 4 6 8 $48,500 $44,800 $35,700 1 2 3 4 Fixed Assets Shop Furniture Delivery Van Equipment Real Estate Etc Total Fixed Assets $5,000 $15,000 $2,000 $0 $6,000 $16,000 $3,000 $5,000 $17,000 $4,000 5 $22,000 $25,000 $26,000 Total Assets $70,500 $69,800 $61,700 $5,000 $10,000 B Liabilities Current Liabilities (Short Term Liabilities) 1 Short term loan from bank 2 Accounts Payables (debts owed to suppliers) 3 Salaries Payable (salaries owed to staff) Suspense Account (unreconciled liabilities) Etc Total Current Liabilities $6,000 $12,000 $7,000 $13,000 4 5 $15,000 $18,000 $20,000 1 2 Long Term Liabilities Long term loan from bank Loan used to buy the van Etc Total Long Term Liabilities $10,000 $15,000 $11,000 $16,000 $12,000 $17,000 3 $25,000 $27,000 $29,000 Total Liabilities $40,000 $45,000 $49,000 c Equity 1 Share Capital (Contributed by the owner) 2 Accumulated Retained Profits (or Losses) $10,000 $20,500 $10,000 $14,800 $10,000 $2,700 Total Equity $30,500 $24,800 $12,700 Mid Term Quiz Income Statement Balance Sheet Ratios For Trucking Companies + Period: 2019 2018 2017 1 Revenue Sale of tablets Sale of laptops Repair services Total Revenue $ 4,000 8,000 12,000 24,000 3,000 6,000 6,000 15,000 2,000 4,000 3,000 9,000 2 Cost of Goods/Services Cost tablets sold Cost of laptops sold Cost of repair services (repair technician) Total Cost Of Goods and Services Gross Profit 2,000 4,000 4,000 10,000 14,000 1,500 3,000 2,000 6,500 8,500 1,000 2,000 1,000 4,000 5,000 1,000 2,500 500 700 200 1,200 1,700 400 3 Operating Expenses Shop rent Employee salaries Utilities Advertisments Office Supplies Cleaning Interest on loans Depreciation charges for equipment, furniture, etc Taxes Total Expenses 600 200 1,000 5,500 600 800 200 500 1,500 200 400 10,700 400 300 1,500 200 1,500 200 300 6,400 300 7,300 Net Profit (Net Income) 3,300 1,200 (1,400) Mid Term Quiz Income Statement Balance Sheet Ratios For Trucking Companies A Assets Current Aseets 1 Cash at hand 2 Cash in the bank 3 Inventory for sale (Tablets) Inventory for sale (Laptops) 5 Accounts Recivables (uncolected revenue from clients) Marketable investments (stocks, bonds, CDs etc) 7 Suspense account (unreconciled assets) Etc Total Current Assets $500 $3,000 $20,000 $15,000 $10,000 $0 $300 $2,500 $15,000 $15,000 $12,000 $0 $200 $1,500 $10,000 $10,000 $14,000 $0 4 6 8 $48,500 $44,800 $35,700 1 2 3 4 Fixed Assets Shop Furniture Delivery Van Equipment Real Estate Etc Total Fixed Assets $5,000 $15,000 $2,000 $0 $6,000 $16,000 $3,000 $5,000 $17,000 $4,000 5 $22,000 $25,000 $26,000 Total Assets $70,500 $69,800 $61,700 $5,000 $10,000 B Liabilities Current Liabilities (Short Term Liabilities) 1 Short term loan from bank 2 Accounts Payables (debts owed to suppliers) 3 Salaries Payable (salaries owed to staff) Suspense Account (unreconciled liabilities) Etc Total Current Liabilities $6,000 $12,000 $7,000 $13,000 4 5 $15,000 $18,000 $20,000 1 2 Long Term Liabilities Long term loan from bank Loan used to buy the van Etc Total Long Term Liabilities $10,000 $15,000 $11,000 $16,000 $12,000 $17,000 3 $25,000 $27,000 $29,000 Total Liabilities $40,000 $45,000 $49,000 c Equity 1 Share Capital (Contributed by the owner) 2 Accumulated Retained Profits (or Losses) $10,000 $20,500 $10,000 $14,800 $10,000 $2,700 Total Equity $30,500 $24,800 $12,700 Mid Term Quiz Income Statement Balance Sheet Ratios For Trucking Companies +