P11.5 A small motel with a small dining room has the following estimates for Year 0007:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
P11.5 A small motel with a small dining room has the following estimates for Year 0007: Sales Revenue Rooms sales revenue $350,000 Dining room sales revenue Cost of sales: dining room Direct expenses Wages expense Rooms expense Dining room expenses Cost of sales: food Other operating expenses Rooms expense Dining room expense Other income (vending machines) $150,000 35% of sales revenue 25% of rooms sales revenue 40% of dining sales revenue 25% of rooms sales revenue 40% of dining room sales revenue 35% of dining room sales revenue 5% of rooms revenue 10% of dining room revenue $5,500 Indirect Expenses Administrative & general $25,600 expenses Marketing expenses $15,400 Property operation & $16,700 maint. expense Utilities expense $12,500 Land rental expense $28,300 Interest expense $11,500 Depreciation Expenses Building $50,200 Furniture and equipment $24,800 In July of 0007, the owner plans to buy $30,000 of new equipment (for cash), less a $5,400 trade-in of used equipment. The vending machines contractor will continue to pay the same commission rate in Year 0007. During 0007, principal payments on a mortgage on the building will be $30,300, and principal payments on a bank loan will be $25,300. The owner, who is also the only shareholder in the company, plans to pay herself dividends of $42,000 during Year 0007. a. Prepare a budgeted income statement for Year 0007. b. Calculate the motel's cash flow for Year 0007. PROBLEMS 491 P11.5 A small motel with a small dining room has the following estimates for Year 0007: Sales Revenue Rooms sales revenue $350,000 Dining room sales revenue Cost of sales: dining room Direct expenses Wages expense Rooms expense Dining room expenses Cost of sales: food Other operating expenses Rooms expense Dining room expense Other income (vending machines) $150,000 35% of sales revenue 25% of rooms sales revenue 40% of dining sales revenue 25% of rooms sales revenue 40% of dining room sales revenue 35% of dining room sales revenue 5% of rooms revenue 10% of dining room revenue $5,500 Indirect Expenses Administrative & general $25,600 expenses Marketing expenses $15,400 Property operation & $16,700 maint. expense Utilities expense $12,500 Land rental expense $28,300 Interest expense $11,500 Depreciation Expenses Building $50,200 Furniture and equipment $24,800 In July of 0007, the owner plans to buy $30,000 of new equipment (for cash), less a $5,400 trade-in of used equipment. The vending machines contractor will continue to pay the same commission rate in Year 0007. During 0007, principal payments on a mortgage on the building will be $30,300, and principal payments on a bank loan will be $25,300. The owner, who is also the only shareholder in the company, plans to pay herself dividends of $42,000 during Year 0007. a. Prepare a budgeted income statement for Year 0007. b. Calculate the motel's cash flow for Year 0007. PROBLEMS 491
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
In Problem 10.16, we projected financial statements for Walmart Stores for Years +1 through +5. The data in Chapter 12s Exhibits 12.1612.18 include the actual amounts for 2008 and the projected...
-
Reflection at normal incidence consider an electromagnetic wave in vacuum, with field components of the form let the wave be incident upon a medium of dielectric constant E and permeability ? = 1...
-
What are the key characteristics of OB as a scientific discipline?
-
Inventory Analysis} Callahan Company reported the following information for the current year: \section*{Required:} 1. Compute Callahan's (a) gross profit ratio, (b) inventory turnover ratio, and (c)...
-
The following data were taken from the accounts of Delhi Hardware, a small retail business. Determine the gross profit. Sales ...................... $113,500 Sales returns and allowances...
-
Which of the following statements regarding life insurance needs is / are correct? 1. The human life value approach looks forward for information. 2. The capitalization of income approach looks at...
-
Determining wages paid The wages payable and wages expense accounts at February 28, after adjusting entries have been posted at the end of the first month of operations, are shown in the following T...
-
Jane McDonald is a 28-year-old solicitor at a prestigious law firm in Sydney. Jane rents a studio apartment near the Sydney central business district, paying $650 per week. She estimates her other...
-
Long range HR Planning is merely a wishful thinking. Do you agree with this statement? Why?
-
Highlight the whole entrepreneurial process. Which are the reasons why the entrepreneurs find it hard to step out and let others manage the business. How can an entrepreneur can be successful while...
-
You are a project scheduling manager, working for PriaTel Consulting. PriaTel Consulting has been contracted by PASK Technologies to provide Telephone Technical Support as well as a Customer Support...
-
2 (10 points) Let f (x) = Evaluate each of the following: 1. f'(1)= 2. f'(6)=
-
How many ways can 3 different people out of 5 people be chosen for a debate team? counting methods way
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19 year-old nanny $125 per week for 48 weeks during the current year. a. What is the employers portion of...
-
Mull plc acquired shares in two companies as follows: Skye Ltd Ordinary shares - 8 million acquired on 1 June 1996 for \( 4.50\) each. Preference shares - \( 5000008 \%\) redeemable preference shares...
-
You are the accountant responsible for the Rag group consolidation. The profit and loss accounts of Rag plc, Tag Ltd and Bobtail Ltd for the year ended 31 March 1999 are given opposite....
-
The balance sheets of A plc and its investee companies B Ltd and D Ltd, and of B Ltd's investee company C Ltd at 31 March 1998 (the accounting date for all four companies) are given below: 1....
Study smarter with the SolutionInn App