Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi can you help me find the following financial ratio analysis based on the financial statement below? return on invested capital return on total assets
Hi can you help me find the following financial ratio analysis based on the financial statement below?
return on invested capital return on total assets Current ratio Quick ratio Inventory turnover= (Direct job cost/ Inventory) /Debt to asset ratio
13,772 Exhibit 2 Comparative Statements of Income and Expenses for the Most Recent Years Ended June 30 Two Years Last ago Year percent $ percent S INCOME 100.00 937,317 100.00 594,624 Contract Income DIRECT JOB COSTS 41.15 385,716 39.42 234,417 Materials Labor 23.24 217,870 25.13 149,404 Payroll Taxes 2.64 24,739 2.66 15,795 Truck and Travel 2.04 19,117 2.32 Subcontract .42 3,950 1.64 9,744 Equipment Rental 2.26 21,141 2.06 12,259 Miscellaneous 1.23 11.487 .08 556 TOTAL DIRECT JOB COSTS 72.98 684.020 73.31 435,947 GROSS PROFIT 27.02 253,297 26.69 158,677 OPERATING EXPENSE 26.88 251.958 37.94 225.591 INCOME (LOSS) FROM .14 1.339 (11.25 (66,914) OPERATIONS OTHER INCOME .18 1,700 .03 168 Interest Income Gain on sale of fixed .21 1,930 .00 assets TOTAL OTHER INCOME .39 3,360 .03 168 INCOME (LOSS) BEFORE .53 4,969 (11.22) (66,746) TAXES FEDERAL AND STATE .00 -0- .00 INCOME TAXES NET INCOME (LOSS) .53 4,969 (11.22) (66,746) -0- Exhibit 3 Balance Sheet June 30, last vear ASSETS CURRENT ASSETS Cash in Bank $10,030 Accounts Receivable - Employees 216 Accounts Receivable - Trade 54,571 Materials Inventory 54,667 Costs and Estimated Earnings in Excess of Billings 14,575 Prepaid Expenses 8.890 TOTAL CURRENT ASSETS $142,949 FIXED ASSETS, at cost Machinery and Equipment Accumulated Depreciation 63,083 (55,936) NET FIXED ASSETS 7,147 OTHER ASSETS Note Receivable - Officer Stock, at cost Refundable Deposits 11,072 500 300 TOTAL OTHER ASSETS 11,872 TOTAL ASSETS 161,968 LIABILITIES AND STOCKHOLDERS' EQUITY CURRENT LIABILITIES Accounts Payable $23,942 Payroll Taxes Payable 3,068 Accrued Interest 2,459 Accrued Insurance 5,517 Notes Payable - Bank 103,160 Billings in Excess of Cost and Estimated Earnings 79 TOTAL CURRENT LIABILITIES $138,225 LONG-TERM LIABILITIES Notes Payable - Bank 82,393 TOTAL LIABILITIES 220,618 STOCKHOLDERS' EQUITY Common Stock Treasury Stock Retained Earnings Exhibit 3 continued 33,520 (3,380) (88,790) TOTAL STOCKHOLDERS' EQUITY (58,650) TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY 161,968 BALANCE AT BEGINNING OF YEAR -- July 1, two years ago (22,044) ADD: Net Income (Loss) (66,746) BALANCE AT END OF YEAR -- June 30. last year (88,790) Exhibit 4 Level of Consumer Interest in Maintenance Agreement Response Percentage Extremely Interested 11.1 Somewhat Interested 50.0 Not at all Interested 26.4 Don't Know/Not Sure 12.5 Exhibit 5 Expected Price for a Maintenance Agreement Expected Annual Price Percentage $50 or less 21.5 51 to 75 26.9 76 to 100 29.3 101 to 125 16.2 126 to 150 4.6 over 150 1.5 Exhibit 6 Tax Assessment Home Values (Current Year) Home Value Number Percent Less than $ 25,000 3,375 3 $25,000 to $50,000 13,491 12 $50,001 to $75,000 25,857 23 $75,001 to $100,000 30.356 27 $100,001 to $125,000 20.236 18 $125,001 to $150,000 11,243 10 $150,001 to $175,000 4,497 $175,001 to $200,000 2,249 2 Over $200,000 1 112,428 -1.124 100 percent
Step 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