Can you help me complete the needed financial ratios chart (and check the ones that I did) It would be great if you could put your findings in the chart I already made. The highway averages I put in are correct, so if you would like to compare in the comment area that would be great as well. These ratios are all based on 2003.

(I will attach the statements too)

Calculation and analysis of the financial ratios:
	Formula	Ratio	Highway average	Comment
Ratios:
Current ratio	current assets/ current liabilities	1.77	1.6 to 1	Current ratio is within the range of industry average.
Quick ratio	quick assets/ current liabilities	1.25	1.2 to 1	Quick ratio is within the range of industry average.
Current Liabilities to Net Worth ratio	Current liabilitieset worth		90%
Debt to equity ratio	Total liabilities/ Total equity	1.10	1.3 to 1
Fixed assets to net worth	Net fixed assets/ net worth		60% to 80%
Current assets to total assets	Current assets/ total assets		0.6
Collection period	Accounts receivable x 365/ revenues		Less than 45 days
Average Age of accounts payable	(Accounts payable 365)/ (Materials + Subcontract)		Less than 45 days
Assets to revenues ratio	Total Assets/ Revenues		40% to 50%
Working Capital	Current Assets- Current liabilities		10
Working Capital Turns	Revenues/ working capital		10
Working capital turns when payments are passed to subs	Revenues- subcontractor/ working capital		10
Accounts Payable to Revenue Ratio	Accounts payable/ revenue		6-8%
Gross Profit Margin	Gross profit/ Revenue		22-27%
General Overhead Ratio	General Overhead/ Revenue		18%
Pretax Profit Margin	Net profit before taxes/ Revenues		4-6%
After Tax Profit Margin	Net profit after taxes/ revenues		?	NOT SURE IF THIS RATIO NEEDS TO BE DONE (if you can do it)
Pretax Return on Assets	Net profit before taxes/ total assets		?
After tax Return on Assets	Net profit after taxes/ total assets		?	NOT SURE IF THIS RATIO NEEDS TO BE DONE (if you can do it)
Pretax Return on Equity	Net profit before taxes/equity		15%
Degree of fixed asset newness	Net fixed assets/total fixed assets		Between 60 to 40%
Months in Backlog	Uncomplete Work on hand x 12/ revenues for 12 months		?

If you could also help fill in the rest of the guide I am using for the calculations:

Financial data for ratio analysis:
	2003	2002
2002 DOESN'T NEED TO BE FILLED UNLESS NECESSARY FOR CALC	(ooo)	(ooo)
Current assets	618,651	547,895
Total assets	1,060,410	983,819
Current liabilities	384,704	327,499
Total liabilities	555,519	528,950
Total equity	504,891	454,869
Accounts Payable
Accounts Receivable
Quick assets = cash & cash equivalents + short-term marketable securities+ Accounts receivable + Costs and earnings of estimated billings CHECK	480,187	457,794
Total revenue CHECK	184,491
Gross profit CHECK	226,450
Net Worth
Net Fixed Assets
Materials
Subcontract
Working Capital
General Overhead
Net profit
Uncomplete Work
Revenue for 12 months

GRANITE CONSTRUCTION INCORPORATED CONSOLIDATED STATEMENTS OF INCOME 2003 (000) Revenue: Construction $ 1,591,746 Material sales 252,745 Total revenue 1,844,491 Cost of revenue: Construction 1,413,538 Material sales 204,503 Total cost of revenue 1,618,041 Gross Profit 226,450 General and administrative expenses 151,879 Operating income 74,571 Other income (expense): Interest income 6,422 Interest expense -8,577 Gain on sales of property and equipment 4,714 Equity in income of affiliates 17,657 Other, net 2,738 22,954 Income before provision for income taxes and minority interest 97,525 Provision for income taxes 35,304 Income before minority interest 62,221 Minority interest in consolidated subsidiaries -1,717 Net income $ 60,504 FIGURE 6-7 Income Statement for Granite Construction, Inc. (Source: www.sec.gov.)GRANITE CONSTRUCTION INCORPORATED CONSOLIDATED BALANCE SHEETS 2003 2002 (000) (000) ASSETS Current assets Cash and cash equivalents $ 69,919 $ 52,032 Short-term marketable securities 90,869 96,900 Accounts receivable, net 288,210 265,896 Costs and estimated earnings in excess of billings 31,189 42,966 Inventories 29,878 29,984 Deferred income taxes 22,421 23,056 Equity in construction joint ventures 42,250 24,329 Other current assets 43,915 12,732 Total current assets 618.651 547,895 Property and equipment, net 344,734 347,963 Long-term marketable securities 41,197 33,762 Investments in affiliates 18,295 18,970 Other assets 37,533 35,229 Total Assets $ 1,060,410 $ 983,819 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Current maturities of long-term debt $ 8,182 $ 8,640 Accounts payable 135,468 118,813 Billings in excess of costs and estimated earnings 99,337 105,725 Accrued expenses and other current liabilities 105,717 94,321 Total current liabilities 348,704 327,499 Long-term debt 126,708 132,380 Other long-term liabilities 24,938 13,742 Deferred income taxes 44,297 40,011 Commitments and contingencies Minority interest in consolidated subsidiaries 10,872 15,318 Total Liabilities 555,519 528,950 Stockholders' equity Common stock 415 413 Additional paid-in capital 73,651 69,390 Retained earnings 442,272 398,383 Accumulated other comprehensive income (loss) 76 -1,402 Unearned compensation -11,523 -11,915 Total Equity 504,891 454,869 Total Liabilities and Equity $ 1,060,410 $ 983,819 FIGURE 6-8 Balance Sheet for Granite Construction Inc. (Source: www.sec.gov.)GRANITE CONSTRUCTION INCORPORATED BREAK DOWN OF PROPERT AND EQUIPMENT BREAK DOWN OF ACCOUNTS RECEIVABLE 2003 2002 2003 2002 (000) (000) (000) (000) Construction Contracts: Land 53,583 50,697 Completed and in progress 179,019 141,748 Quarry property 75,329 75,459 Retention 76,508 97,120 Buildings and leasehold improvements 64,276 59,229 Equipment and vehicles 693,657 656,857 Total Construction Contracts 255,527 238,868 Office furniture and equipment 13,926 11,782 Construction material sales 29,690 26,176 Total Property and Equipment 900,771 854,024 Other 4.238 3,071 Subtotal 289,455 268,115 Less accumulated depreciation, 556,037 506,061 depletion and amortization Less: allowance for doubtful accounts 1,245 2,219 Net Property and Equipment 344,734 347,963 Total 288,210 265,896 FIGURE 6-10 Breakdown of Property and Equipment for FIGURE 6-9 Breakdown of Accounts Receivable for Granite Granite Construction, Inc. Construction, Inc. (Source: www.sec.gov.) (Source: www.sec.gov.)