Question

Lou's investment ($)           $7,890,000 Lou's desired ROI (Net income)           20% Lou's marginal...

Lou's investment ($)           $7,890,000
Lou's desired ROI (Net income)           20%
Lou's marginal tax rate           30%
Funds borrowed           $11,835,000
Interest rate           12%

Forecasted annual costs:                      
Depreciation, property taxes and insurance           $3,156,000           
Management fees           5%   of room sales      
Rooms department expenses           25%   of room sales      
Undistributed operating expenses           $1,262,400           

Assume the Bruno has 150 guestrooms, and it expects to have an occupancy rate of 70%. Also, assume a 365-day year in your calculations.

1. How much sales revenue should the motel genereate to cover all the costs and make the desired return?

Homework Answers

Answer #1
Investment 789000
ROI 20%
Return On Invetstment Investment
ROI
Return On Invetstment 157800
Add : Tax 30% 47340
Return Before Interest & Operating Expenses 205140
Add : Interest 12% 1420200
Depreciation , Tax & Insurance 3156000
Operating Expenses 1262400
Exp before Mgt Fees & Department Exp i.e 70 % 6043740
Management Fees 5% 431696
Room Department Exp 25% 2158479
Answer Sales Revenue 100% 8633914
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Problem 3. A proposed motel, Bruno's, is scheduled to open in two months. The owner, Lou...
Problem 3. A proposed motel, Bruno's, is scheduled to open in two months. The owner, Lou Bruno, seeks your advice on pricing. Although he knows he will have to modify your recommendations based on market prices, he desires a cost perspective. He gives you the following information: Lou's investment ($) $        9,224,000 Lou's desired ROI (Net income) 20% Lou's marginal tax rate 30% Funds borrowed $     13,836,000 Interest rate 12% Forecasted annual costs: Depreciation, property taxes and insurance $        3,689,600 Management fees 5%...
• Given the information below, answer questions from #11 to #12. TCA Hotel Income Statement For...
• Given the information below, answer questions from #11 to #12. TCA Hotel Income Statement For the Year Ended December 31, 2018 2018 ($) Rooms: Revenue 1,041,000 Expenses (Payroll & related expense and Others) 264,000 Room Department Income                          777,000 Food : Revenue                   626,000 Expenses (Cost of sales, Payroll & related expense and Others)                          507,000 Food Department Income             119,000 Others:         Revenue              52,000         Expenses (Payroll & related expense, and Others)            68,000 Other Departments Income...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...
Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January:   Bird house 6,000 units at $55 per unit   Bird feeder 4,500 units at $75 per unit Estimated inventories at January 1: Direct materials:   Wood 220 ft.   Plastic 250 lbs. Finished products:   Bird house 300...
Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with...
Budgeted Income Statement and Supporting Budgets The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January:   Birdhouse 6,000 units at $55 per unit   Bird feeder 4,500 units at $75 per unit Estimated inventories at January 1: Direct materials:   Wood 220 ft.   Plastic 250 lb. Finished products:   Birdhouse 300 units at...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
Budgeted Income Statement and Supporting Budgets The budget director of Feathered Friends Inc., with the assistance...
Budgeted Income Statement and Supporting Budgets The budget director of Feathered Friends Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December: Estimated sales for December: Bird house 3,200 units at $50 per unit Bird feeder 3,000 units at $70 per unit Estimated inventories at December 1: Direct materials: Wood 200 ft. Plastic 240 lbs. Finished products: Bird house 320 units at...
Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones,...
Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm’s marketing director, has completed the following sales forecast. ALPHA-TECH 20x5 Forecasted Sales (in thousands) Month Sales January $ 8,000 February 9,000 March 8,000 April 10,500 May 11,500 June 13,000 July 14,000 August 14,000 September 15,000 October 15,000 November 14,000 December 16,000 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. The following information...
Analysis and Interpretation of Liquidity and Solvency Balance sheets and income statements for Costco Wholesale Corporation...
Analysis and Interpretation of Liquidity and Solvency Balance sheets and income statements for Costco Wholesale Corporation follow. Costco Wholesale Corporation Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) August 28, 2016 August 30, 2015 August 31, 2014 Revenue Net Sales $116,073 $113,666 $110,212 Membership fees 2,646 2,533 2,428 Total revenue 118,719 116,199 112,640 Operating expenses Merchandise costs 102,901 101,065 98,458 Selling, general and administrative 12,068 11,445 10,899 Preopening expenses 78 65 63 Operating Income 3,672 3,624 3,220 Other...
You were recently hired by LW’s Bottle Emporium Ltd. (“LW”) as financial controller. LW sells a...
You were recently hired by LW’s Bottle Emporium Ltd. (“LW”) as financial controller. LW sells a high-end set of baby bottles including various sizes to meet the child’s needs throughout their early years. One of your first tasks is to prepare the master budget for the fourth quarter of 2020. To assist you in the preparation of the budget, and supporting schedules, you have been provided with the following information: As of September 30, 2020 LW had the following balance...