Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please find the ratios and include the formulas ASSETS Current Cash $ 75 Accounts Receivable 40 Inventories 90 Total Current Assets $205 LIABILITIES Current Accounts
please find the ratios and include the formulas
ASSETS Current Cash $ 75 Accounts Receivable 40 Inventories 90 Total Current Assets $205 LIABILITIES Current Accounts Payable Wages Payable Taxes Payable Total Current Liabilities $ 60 40 25 $ 125 Long Term Property $ 125 Plant 200 Equipment 250 Less Deprecation (50) Total Long Term Assets $ 525 Long Term Bank Loans Line of Credit Lease Obligations Other Long Term Obligations Total Long Term Liabilities $ 150 50 25 0 $ 225 Flagstaff Marriott Hotel - 600 Rooms June 30, 2008 Operating Information 1. Total Rooms 18,000 = 600 X 30 days in June 2. Total out of order and complimentary rooms = 75 3. Total Rooms Sold in June = 15,300 4. Total Guests = 18,360 3 0 21 5. Total Room Revenue = $ 1,185,000 6. Total Restaurant Customers = 11,000 7. Total Restaurant Revenue = $125,000 8. Total Food Cost = $35,500 9. Total Hotel Profit (Net Profit) = $ 550,000 10. Number common shares outstanding = 1,000,000 11. Stock Price = $12.00 1 2 23 44 12. Total Hotel Revenue = $ 1,575,000 Operating ratios and Activity Ratios Total Occupancy % Available Occupancy % Average Guests per Room Average Room Rate Average Food Check - RevPAR Food Cost% 0 11 Liquidity ratios 12 13 Current Ratio 14 Accounts Receivable Turnover 15 16 Profitability Ratios 17 18 Profit Margin % 19 Return on Assets(use the balance for June 30) 20 Return on Owner Equity (use the balance for June 30) 21 Earnings per Share 22 Price/Earnings Ratio (PE Ratio) 205,000/125,000=1.64 1,575,000/40,000=39.375 (550,00/1,575,000)*100=34.9% (550,000/730,000) *100=75.3% (550,000/380,000)*100=144.7% 550,000/1,000,000=0.55 12/0.55=21.82 Average Room Rate Average Food Check RevPAR Food Cost% Liquidity ratios 205,000/125,000=1.64 1,575,000/40,000=39.375 Current Ratio Accounts Receivable Turnover 5 6 Profitability Ratios 7 18 Profit Margin % 19 Return on Assets(use the balance for June 30) 20 Return on Owner Equity (use the balance for June 30) 21 Earnings per Share 22 Price/Earnings Ratio (PE Ratio) 23 24 Solvency ratios 25 26 Solvency Ratio 27 Debt Equity Ratio (550,00/1,575,000)*100=34.9% (550,000/730,000)*100=75.3% (550,000/380,000) *100=144.7% 550,000/1,000,000=0.55 12/0.55=21.82 550,000/350,000=1.57 350,000/380,000=0.92 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