Question

please solve correclty

RHIM 4322 * Homework 3* Ratio Analysis Please complete and show work in an excel spreadsheet following the Demo Exercise. Do transfer the financial data to the spreadsheet. However, no need to show the explanatory notes like what is being provided in the Demo Exercise. Submit the Homework spreadsheet using this filename "RHIM4322-Last Name-Homework 3" 14,000 11,500 7,488 20,000 Calculate the 11 ratios for Gian's Italian Cuisine as of December 31, 2017 Revenues: Food 78,000 Beverage 24,000 Current Assets: Others 1,200 Cash Total Revenues 103,200 Cost of Sales: Accounts Receivable Food 24,960 Inventory Beverage 5,280 Prepaid Rent Others 660 Total Current Assets Total Cost of Sales 30,900 Fixed Assets: Gross Profit: Furniture, Fixture & Equipment Food 53,040 (FF&E) Beverage 18,720 Others 540 Accumulated Depreciation (FF&E) Total Gross Profit Building Operating (Controllable) Expenses: Long term Investments Salaries and Wages 29,870 Net Fixed Assets Employee Benefits 7,467.50 Total Assets Direct Operating Expenses 6,192 Marketing 3,612 Utilities 4,024.80 Current Liabilities: Administration & General 2,580 Accounts Payable Repairs and Maintenance 1,857.60 Accrued Payroll Music and Entertainment 2,889.60 Total Operating Expenses 58,493.50 Accrued Taxes Operating Income Total Current Liabilities Other (Non-controllable) Expenses: Long Term Debt Rent 7,000 Total Liabilities Depreciation 500 Interest Owner's Equity 500 Total Non-controllable Expenses Retained Earnings 8,000 Income Before Income Taxes Total Owner's Equity Income Taxes (1.161.30) Total Liabilities and Owner's Equity Net Income 9,870 4,000 20,000 8,580 6,790 6,540 3,500 12,000 40,620 17,988

use this spreadsheet

this is an example of how to do with difffent imformation, please follow this example to complete the excercise

Answer 1

INCOME STATEMENT
TOTAL REVENUE	103,200.00	A
COST OF SALE	30,990.00	B
GROSS PROFIT	72,210.00	C= A-B
TOTAL OPERATING EXPENSES	58,493.50	D
OPERATING INCOME	13,716.50	E = C-D
NON-CONTROLLABLE EXPENSES	8,000.00	F
INCOME BEFORE TAXES	5,716.50	G = E-F
INCOME TAX	1,161.30	H
NET INCOME	4,555.20	I=G-H

BALANCE SHEET
CURRENT ASSETS
CASH	14000
ACCOUNT RECEIVABLE	11500
INVENTORY	7488
PREPAID RENT	20000
TOTAL CURRENT ASSETS	52988
FIXED ASSETS
FURNITURE & FIXTURES	9870
ACCUMULATED DEPRECIATION	-4000
BUILDING	20000
LONG TERM INVESTMENT	8580
NET FIXED ASSETS	34450
TOTAL ASSETS	87438
CURRENT LIABILITIES
ACCOUNTS PAYABLE	6790
ACCRUED PAYROLL	6540
ACCRUED TAXES	3500
TOTAL CURRENT LIABILITIES	16830
LONG TERM DEBT	12000
TOTAL LIABILITIES	28830
OWNERS EQUITY	40620
RETAINED EARNINGS	17988
TOTAL OWNERS EQUITY	58608
TOTAL LIABILITIES AND OWNER'S EQUITY	87438

1	CURRENT RATIO	CURRENT ASSETS	/	CURRENT LIABILITES
		52988	/	16830
		3.15		DOLLARS
2	QUICK RATIO	CA-INVENTORY	/	CURRENT LIABILITES
		45500	/	16830
		2.70		DOLLARS
3	DEBT RATIO	TOTAL LIABILITES	/	TOTAL ASSETS
		28830	/	87438
		32.97	%
4	TIMES INTEREST EARNED	OPERATING INCOME	/	INTEREST EXPENSES
		13,716.50	/	500
		27.43		TIMES
5	INVENTORY TURNOVER	COGS	/	INVENTORY
		30,990.00	/	7488
		4.14		TIMES
6	FIXED ASSETS TUROVER	REVENUE	/	NET FIXED ASSETS
		103,200.00	/	34450
		3.00		TIMES
7	FOOD COST PERCENTAGE	COST OF FOOD SOLD	/	FOOD SALE
		24960	/	78000
		32.00	%
	ONLY FOOD SEGMENT IS TO BE CONSIDERED
8	LABOUR COST PERCENTAGE	LABOUR COST	/	TOTAL SALE
	^	29870+7467.5	/	103200
		36.18	%
	^ SALARIES AND WAGES AND EMPLOYEE BENEFITS IS TO BE CONSIDERED
9	NET PROFIT MARGIN	NET INCOME	/	REVENUE
		4,555.20	/	103,200.00
		4.41	%
10	RETURN ON ASSET	NET INCOME	/	TOTAL ASSETS
		4,555.20	/	87438
		5.21	%
11	RETURN ON EQUITY	NET INCOME	/	TOTAL EQUITY
		4,555.20	/	58608
		7.77	%