Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide data needed to complete the efficiency ratio section highlighted in YELLOW. BALANCE SHEET Assets Current Assets Cash and Securities Accounts Receivable Retainage Inventory
Please provide data needed to complete the efficiency ratio section highlighted in YELLOW.
BALANCE SHEET Assets Current Assets Cash and Securities Accounts Receivable Retainage Inventory Earnings in Excess of Billings Prepaid Expenses Other Current Assets $1.965,767.78 $4,039,991.71 $959,836.96 $86,764.92 $298,254.42 $54,228.08 $203,355.29 18.13% 37.25% 8.85% 0.80% 2.75% 0.50% 1.88% Total Current Assets $7,608, 199,15 70.15% 22.60% 31.40% 4.70% 0.60% Long Term Assets Property Construction Equipment Vehicles Office Equipment Total Fixed assets Depreciation Net Fixed Assets Other Assets Total Long Term (Fixed) Assets $2,451,109.06 $3,405,523.21 $509,743.92 $65,073.69 $6,431,449.89 $3,438,060.06 $2,993,389.83 $244,026.34 Use this for your FA newness ratio -31.70% 2.25% 100.00% $3,237,416.18 29.85% TOTAL ASSETS $10,845,615.33 100.00% Current Liabilities Notes Payable Accounts Payable Retainage (Subcontracts) Billings in Excess of Earnings Income Taxes Payable Other Current Laibilities $244,026.34 $2,207,082.72 $357,905.31 $1,014,065.03 $75,919.31 $67,242.82 2.25% 20.35% 3.30% 9.35% 0.70% 0.62% Total Current Liabilities $3,966,241.53 36.57% Long Term Liabilities Mortgages Equipment/Vehicle Financing Other Liabilities $639,891.30 $1,057,447.49 $214,743.18 5.90% 9.75% 1.98% Total Long Term Liabilities Liabilities Owners Equity $1,912,081.98 $5,878,323.51 17.63% 54.20% Stock Retained Earnings Total Owners Equity $2.895,779.29 $2,071,512.53 26.70% 19.10% 100.00% $4,967,291.82 45.80% Liabilities & Owners Equity $10,845,615.33 100.00% barato ja pelety 4 dl the way all thing ---- Na Pull on TB RATIOS Company Industry Standard U.S. Average ( 1.0(15.0% 17.0% Return on Assets 7.2% > 5.0% 5.1% Leverage Ratios Debt to Equity Ratio 1.2 1.0) 2.3 Current Liabilities to Equity Ratio 0.B > 1.0 1.2 Revenue to Equity 9.3 s 15.0 9.9 Asset Tumover Ratio 4.3 23.0 3 Fixed Asset Ratio 60.3% 30.0%-60.0% 38.8% Underbillings to Equity Ratio 6.0% 1.0 1.6 Fixed Asset Newness 46.5% 40.0%-60.0% 34.5% G&A to Revenue Ratio 20% 35.4% Efficiency Ratios Days in Accounts Receivable 1.0(15.0% 17.0% Return on Assets 7.2% > 5.0% 5.1% Leverage Ratios Debt to Equity Ratio 1.2 1.0) 2.3 Current Liabilities to Equity Ratio 0.B > 1.0 1.2 Revenue to Equity 9.3 s 15.0 9.9 Asset Tumover Ratio 4.3 23.0 3 Fixed Asset Ratio 60.3% 30.0%-60.0% 38.8% Underbillings to Equity Ratio 6.0% 1.0 1.6 Fixed Asset Newness 46.5% 40.0%-60.0% 34.5% G&A to Revenue Ratio 20% 35.4% Efficiency Ratios Days in Accounts ReceivableStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started