Question 3 Current Liabilities Accounts Payable-Trade 385,458 228,585 18,254 Question 3: You are given the following information about construction company XYZ. Please calculate current ratio, debt to equity ratio, collection period, and after-tax profit ratio. Compare it to industry average and discuss how well this construction company is doing compared to the rest in that industry. 11,562 Accounts Payable-Retention 22,546 Billings in Excess of Costs and Profits 5,218 Notes Payable 15,514 Accrued Payables 15,648 45,250 16,658 Balance Sheet Income Statement Current Year Last Year Accrued Taxes 10,521 8,254 ASSETS Accrued Vacation 3,564 3,002 Revenue 3,898,945 CURRENT ASSETS Other Current Liabilities 25,438 35,648 Cash 300,492 244,254 CONSTRUCTION COSTS 483.907 367.213 Materials Accounts Receivable-Trade 202.854 308,253 712,564 Total Current Liabilities Capital Leases Payable Warranty Reserves Labor 25,365 21,885 896,514 Accounts Receivable-Retention Inventory Long-Term Liabilities 153,215 99,073 Subcontract 1,452,352 15,234 Total Liabilities 637,122 466,286 Equipment 119,575 Costs and Profits in Excess of Billings 32,586 Notes Receivable 12,548 Prepaid Expenses 5,621 Other 5,452 4,825 Total Construction Costs 3,186,457 10,000 10,000 Owner's Equity Capital Stock Retained Eamings Current Period Net Income Other Current Assets 11.254 7,225 436,917 358,904 EQUIPMENT COSTS Total Current Assets 590,720 601,676 Rent and Lease Payments 45,425 Total Equity 446.917 368.904 FIXED AND OTHER ASSETS Depreciation 32,397 Total Liabilities and Equity 1.084.039 835.100 Land 72,000 72,000 Repairs and Maintenance 21,254 103,862 103,862 Fuel and Lubrication 29,245 Buildings Construction Equipment 97,284 93,284 Taxes, Licenses, and Insurance 1,254 Equipment Costs Charged to Jobs 119.575 Trucks and Autos 51,245 31,556 Office Equipment 56,896 42,546 Total Equipment Costs 10,000 Total Fixed Assets 381.287 343.248 Less Acc. Depreciation 224,512 182.990 GROSS PROFIT 702.488 Net Fixed Assets 160.238 156,775 Curent Year Last OVERHEAD 422,562 Year ASSETS LIABILITIES