Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer the following three questions based on the tables provided above. 1. What is Current Ratio for the period ending March 31 2015? (3

image text in transcribed

Please answer the following three questions based on the tables provided above.

1. What is Current Ratio for the period ending March 31 2015? (3 points)

2. What is Average Age of Accounts Payable for the period ending March 31 2016? (3 points)

3. What is the cost structure for the period ending March 31 2016 based on the provided data? (4 points)

2016 $ 10,000,000 3/31/2016 160,000 2,000,000 205,200 70,000 250,000 40,000 2,725,200 360,000 211,200 148,800 60,000 12,000 48,000 47,000 243,800 2,969,000 1,600,000 4,000,000 3,200,000 200,000 9,000,000 1,000,000 Balance Sheets Account 3/31/2015 Cash 390,000 Accounts Receivable 3,400,000 Retainage Receivable 300,000 Material Inventory 170,000 Under-billings 500,000 Other Current Assets 40,000 Total Current Assets 4,800,000 Equipment (Gross) 360,000 Less: Acc. Dep. 139,200 Equipment (Net) 220,800 Building (Gross) 60,000 Less: Acc. Dep. 9,000 Building (Net) 51,000 Land 47,000 Total Non-Current Assets 318,800 Total Assets 5,118,800 Equities Liabilities Account Payable 560,000 Subcontracts Payable 1,270,000 Retainage Payable 170,000 Over-billings 600,000 Note Payable (current) 300,000 Income Tax Payable 58,000 Current Portion (L/T/D) 200,000 Other Current Liability 42,000 Total Current Liability 3,200,000 Long Term Debt 818,800 Total Liability 4,018,800 Net Worth Capital Stock 840,000 Retained Earnings 260,000 Total Net Worth 1,100,000 Total Equities 5,118,800 Income Statements 2015 Account $ Earnings 14,000,000 Cost of Construction Labor 2.240,000 Material 5,600,000 Subcontracts 4,480,000 Other Direct Cost (JOH) 280,000 Total Direct Cost 12,600,000 Gross Profit 1,400,000 Operating Expense Variable Operating Expense Auto and Truck 210,000 Communications 84,000 Interest (Work in progress) 140,000 Insurance (Work in progress) 204,200 Other Variable Expense 28,000 Total Variable Operating Expense 666,200 Fixed Operating Expense Contributions 5,000 Depreciation (Equipment) 72,000 Depreciation (Building) 3,000 Insurance (Equipment) 27,000 Interest (Equipment) 28,000 Rent 44,000 Salaries 334,800 Other Fixed Expense 10,000 Total Fixed Operating Exp. 523,800 Total Operating Expense 1,190,000 Net Profit (before tax) 210,000 Tax (28%) 58,800 Net Profit (after tax) 151,200 Dividends 21,200 Retained earnings 130,000 150,000 60,000 100,000 237,000 20,000 567,000 475,000 400,000 75,000 700,000 150,000 100,000 14,000 1,900,000 145,000 2,045,000 5,000 72,000 3,000 29,000 20,000 44,000 300,000 10,000 483,000 1,050,000 336,000> 0 700,000 224,000 924,000 2,969,000 2016 $ 10,000,000 3/31/2016 160,000 2,000,000 205,200 70,000 250,000 40,000 2,725,200 360,000 211,200 148,800 60,000 12,000 48,000 47,000 243,800 2,969,000 1,600,000 4,000,000 3,200,000 200,000 9,000,000 1,000,000 Balance Sheets Account 3/31/2015 Cash 390,000 Accounts Receivable 3,400,000 Retainage Receivable 300,000 Material Inventory 170,000 Under-billings 500,000 Other Current Assets 40,000 Total Current Assets 4,800,000 Equipment (Gross) 360,000 Less: Acc. Dep. 139,200 Equipment (Net) 220,800 Building (Gross) 60,000 Less: Acc. Dep. 9,000 Building (Net) 51,000 Land 47,000 Total Non-Current Assets 318,800 Total Assets 5,118,800 Equities Liabilities Account Payable 560,000 Subcontracts Payable 1,270,000 Retainage Payable 170,000 Over-billings 600,000 Note Payable (current) 300,000 Income Tax Payable 58,000 Current Portion (L/T/D) 200,000 Other Current Liability 42,000 Total Current Liability 3,200,000 Long Term Debt 818,800 Total Liability 4,018,800 Net Worth Capital Stock 840,000 Retained Earnings 260,000 Total Net Worth 1,100,000 Total Equities 5,118,800 Income Statements 2015 Account $ Earnings 14,000,000 Cost of Construction Labor 2.240,000 Material 5,600,000 Subcontracts 4,480,000 Other Direct Cost (JOH) 280,000 Total Direct Cost 12,600,000 Gross Profit 1,400,000 Operating Expense Variable Operating Expense Auto and Truck 210,000 Communications 84,000 Interest (Work in progress) 140,000 Insurance (Work in progress) 204,200 Other Variable Expense 28,000 Total Variable Operating Expense 666,200 Fixed Operating Expense Contributions 5,000 Depreciation (Equipment) 72,000 Depreciation (Building) 3,000 Insurance (Equipment) 27,000 Interest (Equipment) 28,000 Rent 44,000 Salaries 334,800 Other Fixed Expense 10,000 Total Fixed Operating Exp. 523,800 Total Operating Expense 1,190,000 Net Profit (before tax) 210,000 Tax (28%) 58,800 Net Profit (after tax) 151,200 Dividends 21,200 Retained earnings 130,000 150,000 60,000 100,000 237,000 20,000 567,000 475,000 400,000 75,000 700,000 150,000 100,000 14,000 1,900,000 145,000 2,045,000 5,000 72,000 3,000 29,000 20,000 44,000 300,000 10,000 483,000 1,050,000 336,000> 0 700,000 224,000 924,000 2,969,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Assurance And Auditing

Authors: Thomas Nelson

1st Edition

0170111342, 978-0170111348

More Books

Students also viewed these Accounting questions