IF you could get the following ratios from the general ledger provided. Also the calculations. Thank You

1) Some of the ratios do NOT have sufficient data to compute a ratio.

In those ratios, simply type "Insufficient data to Compute".

The objective is to provide you an opportunity to employ critical thinking.

You need to be able to discern whether or not all elements are present.

2) In the ratios that require an "Average" - assume that the BEGINNING Account Balance = - 0-.

3) Remember, .50% is NOT the same as 50%.

4) Use all transactions that include "Sales on Account" as "Net Credit Sales".

5) Be sure to include your formulas in the proper cell. If you simply input an answer, feedback may be limited.

If you include your computations, additional feedback will be possible when an incorrect answer is given.

6) Complete all ratios in all 3 sections - Parts A, B & C. There are 4 ratios in Part A, 2 in Part B, and 3 in Part C.

A. Liquidity Ratios

1. Current Ratio

2. Acid Test Ratio

3. Inventory turnover

4. Accounts Receivable turnover

B. Solvency Ratios

1. Debt to Total Asset ratio

2. Times-interest-earned ratio

C. Profitability Ratios

1. Profit Margin

2. Asset Turnover

3. Return on Assets

		GENERAL LEDGER
ACCOUNT:		CASH				ACCOUNT	NO. 11
YEAR			POST.			BALANCE
MONTH	DAY	ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	1	Capital		$10,000.00		$10,000.00
	1	Prepaid Rent			$4,500.00	$5,500.00
	2	Prepaid Insurance			$1,800.00	$3,700.00
	4	Unearned Fees		$3,000.00		$6,700.00
	6	Accounts Receivable		$800.00		$7,500.00
	10	Miscellaneous Expense			$120.00	$7,380.00
	12	Accounts Payable			$800.00	$6,580.00
	14	Salary Expense			$400.00	$6,180.00
	17	Fees Earned		$3,175.00		$9,355.00
	18	Supplies			$750.00	$8,605.00
	24	Fees Earned		$1,850.00		$10,455.00
	26	Accounts Receivable		$1,600.00		$12,055.00
	27	Salary Expense			$400.00	$11,655.00
	29	Miscellaneous Expense			$130.00	$11,525.00
	30	Miscellaneous Expense			$200.00	$11,325.00
	30	Fees Earned		$2,050.00		$13,375.00
	30	Owners Drawing			$4,500.00	$8,875.00
ACCOUNT:		ACCOUNTS RECEIVABLE				ACCOUNT	NO. 12
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	1	Dustin Larkin Asset		$1,500.00		$1,500.00
	6	Cash Received			$800.00	$700.00
	12	Service Provided		$2,250.00		$2,950.00
	20	Service Provided		$1,100.00		$4,050.00
	26	Cash Received			$1,600.00	$2,450.00
	30	Earned Fees		$1,000.00		$3,450.00
ACCOUNT:		SUPPLIES				ACCOUNT	NO. 14
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	1	Dustin Larkin Suppplies		$1,250.00		$1,250.00
	18	Supplies Received		$750.00		$2,000.00
	30	Supplies on hand			$980.00	$1,020.00
ACCOUNT:		PREPAID RENT				ACCOUNT	NO. 15
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	1	Cash for Rent		$4,500.00		$4,500.00
	30	Expired Rent			$1,500.00	$3,000.00
ACCOUNT:		PREPAID INSURANCE				ACCOUNT	NO. 16
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	2	Cash for Insurance		$1,800.00		$1,800.00
	30	Expired Insurance			$150.00	$1,650.00
ACCOUNT:		OFFICE EQUIPMENT				ACCOUNT	NO. 18
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	1	Dustin Larkin Equipment		$7,500.00		$7,500.00
	5	Supplies on Account		$1,800.00		$9,300.00
ACCOUNT:		ACCUMULATED DEPRECIATION				ACCOUNT	NO. 19
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	30	Office Equipment			$500.00		$500.00
ACCOUNT:		ACCOUNTS PAYABLE				ACCOUNT	NO. 21
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	5	Purchased supplies			$1,800.00		$1,800.00
	12	Payment for supplies		$800.00			$1,000.00
ACCOUNT:		SALARIES PAYABLE				ACCOUNT	NO. 22
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	30	Receptionist salary			$120.00		$120.00
ACCOUNT:		UNEARNED FEES				ACCOUNT	NO. 23
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	4	Future work to be done			$3,000.00		$3,000.00
	30	Fees		$1,000.00			$2,000.00
ACCOUNT:		DUSTIN LARKIN, CAPITAL				ACCOUNT	NO. 31
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	1	Dustin Larkin Assets			$20,250.00		$20,250.00
	30	Closing Entry		$4,500.00			$15,750.00
	30	Closing Entry			$7,925.00		$23,675.00
ACCOUNT:		DUSTIN LARKIN, DRAWING				ACCOUNT	NO. 32
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	30	Cash withdrawings		$4,500.00		$4,500.00
	30	Closing Entry			$4,500.00	$-
ACCOUNT:		INCOME SUMMARY				ACCOUNT	NO. 33
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	30	Fees Earned			$12,425.00		$12,425.00
	30	Adjusting Entries		$4,500.00			$7,925.00
	30	Closing entry		$7,925.00			$-
ACCOUNT:		FEES EARNED				ACCOUNT	NO. 41
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	12	Services Provided			$2,250.00		$2,250.00
	17	Services Provided			$3,175.00		$5,425.00
	20	Services Provided			$1,100.00		$6,525.00
	24	Services Provided			$1,850.00		$8,375.00
	30	Services Provided			$2,050.00		$10,425.00
	30	Services Provided			$1,000.00		$11,425.00
	30	Fees			$2,000.00		$13,425.00
	30	Fees		$13,425.00			$-
ACCOUNT:		SALARY EXPENSE				ACCOUNT	NO. 51
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	14	Cash paid for help		$400.00		$400.00
	27	Cash paid for help		$400.00		$800.00
	30	Receptionist Salary		$120.00		$920.00
		Closing entry			$920.00	$-
ACCOUNT:		RENT EXPENSE				ACCOUNT	NO. 52
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	30	Expired Rent		$1,500.00		$1,500.00
	30	Closing Entry			$1,500.00	$-
ACCOUNT:		SUPPLIES EXPENSE				ACCOUNT	NO. 53
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	30	Supplies on hand		$1,020.00		$1,020.00
ACCOUNT:		DEPRECIATION EXPENSE				ACCOUNT	NO. 54
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013	30	Office Equipment		$500.00		$500.00
	30	Closing Entry			$500.00	$-
ACCOUNT:		INSURANCE EXPENSE				ACCOUNT	NO. 55
			POST.			BALANCE
DATE		ITEM	REF.	DEBIT	CREDIT	DEBIT	CREDIT
2013
	30	Expired Insurance		$150.00		$150.00
	30	Closing Entry			$150.00	$-