90.2K

Verified Solution

Link Copied!

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.

Balance Sheet Current Last Income Statement Year Year Revenue 3.898,945 300,492 244,254 CONSTRUCTION COSTS 202,854 308,253 Materials 712,564 ASSETS CURRENT ASSETS Cash Accounts Receivable-Trade Accounts Receivable-Retention Inventory Costs and Profits in Excess of Billings Notes Receivable Prepaid Expenses Labor 896,514 25.365 21.885 Subcontract 1.452,352 32,586 15,234 Equipment Other 119.575 5.452 12,548 5,621 4,825 Total Construction Costs 3.186.457 11.254 7.225 Other Current Assets Total Current Assets 590,720 601.676 45,425 FIXED AND OTHER ASSETS 32.397 EQUIPMENT COSTS Rent and lease Payments Depreciation Repairs and Maintenance Fuel and Lubrication Taxes, licenses, and insurance Equipment Costs Charged to Jobs 21,254 Land 72,000 72,000 103.862 Buildings 103.862 29,245 1.254 Construction Equipment 97.284 93.284 51.245 31.556 119.575 10,000 Total Equipment Costs 56.896 42.546 Trucks and Autos Office Equipment Total Fixed Assets Less Acc. Depreciation Net Fixed Assets 381,287 343.248 GROSS PROFIT 702,488 224,512 182.990 160,258 OVERHEAD 422,562 156,775 Current Last Year Year ASSETS LIABILITIES Current Liabilities 385,458 228,585 Accounts Payable-Trade Accounts Payable-Retention Billings in Excess of Costs and Profits 22,546 18.254 5,218 11,562 Notes Payable 15,514 45,250 Accrued Payables 15,648 16,658 Accrued Taxes 10,521 8.254 Accrued Vacation 3,564 3,002 Other Current Liabilities 25,438 35.648 483,907 367,213 Total Current Liabilities Capital Leases Payable Warranty Reserves Long-Term Liabilities 153.215 99,073 Total Liabilities 637.122 466.286 Owner's Equity Capital Stock 10,000 10,000 436,917 358,904 Retained Earnings Current Period Net Income Total Equity 446,917 368,904 Total Liabilities and Equity 1,084,03 9 835,190

Answer & Explanation Solved by verified expert

See Answer