Multi Step Income Statement | ||
Sales | Amount ($) | Amount ($) |
Rooms | 550,000 | |
Less : Allowance | (1,000) | 549,000 |
Food | 250,000 | |
Net Sales | 799,000 | |
Less : COGS (Refer WN 1) | (66,000) | |
Gross Margin | 733,000 | |
Operating Expenses (Refer WN 2) | ||
General & Admin | (385,000) | |
Selling Expenses | (83,470) | |
Oprg Income | 264,530 | |
Other Income | ||
Interest | 1,800 | |
(30,000 @ 12% p.a. for 6 months) | ||
Less : Other Expenses | ||
Management Fees (Refer WN 5) | (26,852) | |
Interest | (30,000) | |
Other Expenses | (15,000) | |
Income before Tax | 194,478 | |
Less : Income Taxes @ 30% | (58,343) | |
Income Net of Tax | 136,135 |
WN 1 : Cost of Food Sold | Amount ($) |
Beginning Inventory | 5,000 |
Cost of Food Purchased | 65,000 |
Cost of Food Available for Sale | 70,000 |
Less : Ending Inventory | (4,000) |
Cost of Food Sold | 66,000 |
WN 2 : Operating Expenses | Amount ($) |
General and Administrative | |
Salaries and Wages | |
Room - Dept | 90,000 |
Food - Dept | 60,000 |
Administrative & General - salary | 60,000 |
Information and Telecom | 12000 |
Electricity | 15,000 |
Insurance (36,000/2 = 18,000) 9000 transfer from advances. 18000$ transferred from Advances Account to Income Statement) | 18,000 |
Maintenance | 40,000 |
Depreciation (assumed on Office Equipment) | 40,000 |
Payroll Taxes (Refer WN 3) | 29,200 |
Free Meals | 800 |
Amortization on Intangibles | 5,000 |
Property Taxes | 15,000 |
A | 385,000 |
Selling Expenses | |
Franchise Fees (Refer WN 5) | 21,470 |
Advertising | 12,000 |
Supplies | |
Food Dept | 20,000 |
Room Dept | 30,000 |
B | 83,470 |
Operating Expenses (A + B) | 468,470 |
WN 3 : Payroll Taxes | Amount ($) | ||
Food Dept | Room Dept | Total | |
Gross Salaries | 60,000 | 90,000 | |
Taxes @ 20% | 12,000 | 18,000 | |
Fringe Benefits included above (free meals) | (500) | (300) | |
Payroll Taxes | 11,500 | 17,700 | 29,200 |
Free Meals | 500 | 300 | 800 |
WN 4 : Management Fees | Amount ($) | ||
Net Room Sales | Gross operating Profit | Total | |
549,000 | 264,530 | ||
Management Fees | 10,980 | 15,872 | 26,852 |
WN 5 : Franchise Fees | Amount ($) | ||
Net Room sales | Net Food Sales | ||
549,000 | 250,000 | ||
Franchise Fees | 16,470 | 5,000 | 21,470 |
de. Round a Prepare an income statement figures to the nearest $1. Problem 25 The Kaminski...
The Beach M (RM has woma operated departments rooms and oth Agim you as of December 31, 2012 1. The BBM invested $30,000 on July 1, 20X2, in Daytona Aircraft Bonds. The funds wet Problem 20 138 Che Account Balance Insurance (hine) Rams department-salaries and wages Ford deurtment - salaries and wages Supplies & other --Food department Food purchases Roxam sales Interest income Cost of food sold Rood sales A&G-salaries Advertising Maintenance-contract Information & telecommunications systems Depreciation Electricity Heating oil...
The Colonial Hotel asked you to help prepare income statement for 2019. The following infomration is provided to you as of December 31, 2019. Account Tile Account Balance Insurance General Manager's Salary (Admin & Gen.) Salaries and Wages - Rooms Salaries and Wages - Food Supplies - Food $5,000 30,000 80,000 60,000 20,000 Food Purchase Room Sales Interest Income Interest Expense Cost of Food Sold 55,000 380,000 1,000 21,000 Food Sales Wages (Admin & Gen.) Advertising Property Operation & Maintenance...
Problem 17: The Greenhill Hotel’s total revenue for 20X1 totaled $5,000,000, while total expenses totaled $4,500,000. Assume the sources of its revenue and the distribution of its expenses were exactly like the lodging industry averages shown in Exhibit 1 of the chapter. Required: What was the hotels net income for 20X1? What were the hotel’s room sales for 20X1? What were the hotel’s rentals and other income for 20X1? What were the hotels salaries, wages, and benefits for 20X1? Exhibit...
27. Construction of income statement and balance sheet (L02-1 & (2-3 ) For December 31, 20X1. the balance sheet of Baxter Corporation was as follows: Current Assets Liabilities Cash $ 15,000 Accounts payable $ 17,000 Accounts receivable 20,000 Notes payable 25,000 Inventory 30,000 Bonds payable 55,000 Prepaid expenses 12,500 Fixed Assets Stockholders' Equity Plant and equipment (gross) $255,000 Preferred stock $ 25,000 Less: Accumulated Common stock 60,000 depreciation 51.000 Paid-in capital 30,000 Net plant and equipment $204,000 Retained earnings 69.500...
Prepare the pro forma income statement for a two-department company A hotel operation has 120 rooms and a 100-seat restaurant. Please prepare a pro forma income statement for the next year to determine the forecasted net income. Rooms department: In the previous year of operations the occupancy rate was 70% and the average room rate was $48. The GM is forecasting the occupancy rate to increase by 5% and the average room rate is to be increased by $4. Cost...
PLZ Follow the format of exhibit 3 And Typing the Answer There is no number of the room on the book so I don't think that is necessary. The following are several accounts and balances from the general ledger of the Hilltop Motel Allowances - Rooms $ 500 Commissions 1,000 Income Statement 173 Contract Cleaning 1,800 Dry Cleaning 1,200 Fringe Benefits 3,000 3,000 Laundry Linen Expense Operating Supplies Other Expenses Payroll Taxes 1,000 1,500 1,800 2,000 Salaries Sales-Transient (Group) Sales-Transient...
The Statement of Cash Flows 215 Problem 14 sed balance sheets of the Spartan Inn are as follows: The condensed bala Spartan Inn Condensed Balance Sheets December 31, 20X1 and 20X2 20X1 Assets Current Assets: 20X2 Cash $ $ Marketable Securities Accounts Receivable Inventory Total Current Assets Investments Property and Equipment: 30,000 50,000 100,000 20,000 200,000 100,000 40,000 50,000 95,000 25,000 210,000 60,000 500,000 5,000,000 1,000,000 (1,600,000) 4,900,000 $5,200,000 500,000 6,000,000 1,100,000 (2,000,000) 5,600,000 $5,870,000 Land Building Equipment Accumulated Depreciation...
Complete a vertical and horizontal analysis for the summary operating statement. Summary Operating Statement WN 20x1 20x2 Variance (Horizontal) #/$ 300 79,388 72.5% 183.62 133.12 176.20 300 81,140 74.1% 191.33 141.78 185.65 6 Rooms Available: 7 Rooms Sold: 8 Occupancy: 9 ADR: 10 Rooms RevPAR: 11 Total RevPAR: 12 13 Operating Revenue 14 Rooms 15 Food and Beverage Miscellaneous Income 17 Total Operating Revenue 16 14,577,225 4,444,791 271,725 19,293,741 15,524,516 4,517,064 287,236 20,328,816 18 1 3 19 Departmental Expenses 20...
please help! Problem No. 1 Purpose: To incorporate the concepts related to the Income Statement, Balance Sheet, Statement of Cash Flows and Ratio Analysis. Resources Provided: 1. Summary Operating Statement and Statistics 2. Comparable Balance Sheet with Additional Information 3. Statement of Cash Flow Template Required: STATEMENTS TO BE USED TO COMPLETE ITEM COMPARATIVE STATEMENT ITEM OPERATING BALANCE OF CASH STATEMENT SHEET FLOWS Re-Create and finish financial statement in Excel using PDF provided. X X Complete Vertical Analysis Complete Horizontal...
Prepare the corporation's cash Tu Problem 90 d on its income statement t asset and liability accounts at the During 20X6, Brymer Hotel earned net income of $258,000. Included on its income for 20X6 was depreciation expense of $150,000. Its current asset and liabilit beginning and end of 20X6 had balances as follows: Cash 142,000 counts receivable Food inventory Prepaid insurance Accounts payable Accrued payroll Taxes payable The Statement of Cash Flows 211 March 31 20X5 $ 25,000 20X6 $...