Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete and show work in an excel spreadsheet following the Demo Exercise. Do transfer the financial data to the spreadsheet. However, no need

image text in transcribedimage text in transcribedimage text in transcribed

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" 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 Accounts Receivable Cost of Sales: Food 24,960 Inventory Beverage 5,280 Prepaid Rent 14,000 11,500 7,488 20,000 Others 660 Total Current Assets Total Cost of Sales 30,900 Fixed Assets: Gross Profit: Furniture, Fixture & Equipment Food 9,870 53,040 (FF&E) Beverage 18,720 Accumulated Depreciation (FF&E) -4,000 Others 540 Total Gross Profit Building 20,000 Operating (Controllable) Expenses: Long term Investments 8,580 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 6,790 Repairs and Maintenance 1,857.60 Accrued Payroll 6,540 Music and Entertainment 2,889.60 Accrued Taxes 3,500 Total Operating Expenses 58,493.50 Operating Income Total Current Liabilities Other (Non-controllable) Expenses: Long Term Debt 12,000 Rent 7,000 Total Liabilities Depreciation 500 Owner's Equity 40,620 Interest 500 Retained Earnings 17,988 Total Non-controllable Expenses 8,000 Total Owner's Equity Income Before Income Taxes Income Taxes (1,161.30) Total Liabilities and Owner's Equity Net Income Focus

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

Payroll Accounting 2016

Authors: Jeanette Landin, Paulette Schirmer

2nd edition

978-1259821950, 1259821951, 1259572196, 978-1259572197

More Books

Students also viewed these Accounting questions