Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribedimage text in transcribedimage text in transcribed

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 Receivable

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

Business Analytics

Authors: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann

5th Edition

0357902211, 978-0357902219

Students also viewed these Finance questions