A small motel with a small dining room has the following estimates for Year 0007: Sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A small motel with a small dining room has the following estimates for Year 0007: Sales Revenue $350,000 $150,000 35% of sales revenue Rooms sales revenue Dining room sales revenue Cost of sales: dining room Direct expenses 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 Wages expense Rooms expense Dining room expenses Cost of sales: food Other operating expenses Rooms expense Dining room expense Other income 5% of rooms revenue 10% of dining room revenue $5,500 (vending machines) contractor will continue to pay the same commission rate in Year 0007. PROB Indirect Expenses Administrative & general $25,600 $15,400 $16,700 expenses Marketing expenses Property operation & maint. expense Utilities expense Land rental expense Interest expense $12,500 $28,300 $11,500 Depreciation Expenses Building Furniture and equipment $50,200 $24,800 To 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. 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. h. Calculate the motel's cash flow for Year 0007. A small motel with a small dining room has the following estimates for Year 0007: Sales Revenue $350,000 $150,000 35% of sales revenue Rooms sales revenue Dining room sales revenue Cost of sales: dining room Direct expenses 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 Wages expense Rooms expense Dining room expenses Cost of sales: food Other operating expenses Rooms expense Dining room expense Other income 5% of rooms revenue 10% of dining room revenue $5,500 (vending machines) contractor will continue to pay the same commission rate in Year 0007. PROB Indirect Expenses Administrative & general $25,600 $15,400 $16,700 expenses Marketing expenses Property operation & maint. expense Utilities expense Land rental expense Interest expense $12,500 $28,300 $11,500 Depreciation Expenses Building Furniture and equipment $50,200 $24,800 To 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. 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. h. Calculate the motel's cash flow for Year 0007.
Expert Answer:
Answer rating: 100% (QA)
1 Income statement sales revenues Particulars Room sales revenue 350000 dining room sales revenue 15... View the full answer
Related Book For
Essentials of corporate finance
ISBN: 9780073405131
6th Edition
Authors: Stephen A. Ross, Randolph Westerfield, Bradford D. Jordan
Posted Date:
Students also viewed these finance questions
-
Automatic transmissions, Inc., has the following estimates for its new gear assembly project; price = $1,280 per unit; variable costs = $340 per unit, fixed costs = $5.5 million; quantity = 80,000...
-
Furry Friends Food Manufacturing has compiled the following estimates for operations For each of the following, perform a break-even analysis showing computation of the (a) Contribution margin ; (b)...
-
Benson Designs has prepared the following estimates for a longterm project it is considering. The initial investment is $18,250, and the project is expected to yield after-tax cash inflows of $4,000...
-
(CMA, adapted) Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Bob Anderson, the controller, is responsible for preparing Roletters...
-
Use the information provided to determine the values for the missing information (indicated by shaded boxes): Current assets on December 31, 2018 ? $275,000 Current liabilities on December 31, 2018 ?...
-
Consider the accompanying data file to estimate the logistic regression model for predicting college admission (Admit equals 1 if admitted, 0 otherwise). Predictor variables include the applicants...
-
With reference to Exercise 12.9, determine individual \(95 \%\) confidence intervals for the differences of mean reaction times. Data From Exercise 12.9 12.9 To find the best arrangement of equipment...
-
Liquid Chemical, Ltd. sells a range of high- grade chemical products throughout the Pacific North-west from its main plant in Vancouver, British Columbia. The companys products, because of their...
-
Drs. Glenn Feltham and David Ambrose began operations of their physical therapy clinic, called Northland Physical Therapy, on January 1, 2020. The annual reporting period ends December 31. The trial...
-
Consumer Research, owned by Chandler Robertson, is retained by large companies to test consumer reaction to new products. On January 31, 20X1, the firms worksheet showed the following adjustments...
-
1. above is the FY 2016 numbers for the company Sturm, Ruger & Co, as posted 2. In a spreadsheet, the following should be included: (a) the name of the ratio that you are calculating (b) number or...
-
Identify the most appropriate approach and then design. Provide a rationale as to why this approach and design would be most appropriate. Develop a hypothetical research scenario that would...
-
Describe why the observational approach and predictive design is the most appropriate methodology to be used considering the research scenario. Develop a hypothetical research scenario that would...
-
Discuss three of the major threats to validity related to the repeated measures approach. What is it about this approach that would make these threats important to consider?
-
To explore how student project groups develop through various stages. INSTRUCTIONS 1. Think about the last time you were assigned to a student group to complete a course-related project. 2. Next,...
-
What is the minimum number of IVs required for a factorial design? What is the minimum number of levels that should be included for each IV?
-
Sales 1,250,000 -750,000 Inventory purchase Property and equipment purchase -280,000 Interest payment on long-term debt -25,000 Payment of wages -315,000 Payment of rent Borrowing long-term debt...
-
In order to get an idea on current buying trends, a real estate agent collects data on 10 recent house sales in the area. Specifically, she notes the number of bedrooms in each house as follows: a....
-
Take a look back at Figure to answer the following questions: a. If you have $100, how many polish zlotys can you get? b. How much is one euro worth? c. If you have five million euros, how many...
-
This question illustrates what is known as discount interest. Imagine you are discussing a loan with a somewhat unscrupulous lender. You want to borrow $12,000 for one year. The interest rate is 13...
-
For the firm in Problem, suppose the book value of the debt issue is $60 million. In addition, the company has a second debt issue, a zero coupon bond with 20 years left to maturity; the book value...
-
On 1 January 2023, Blue Jay Ltd revalued land from \(\$ 300000\) to \(\$ 500000\). On 1 January 2024, the company subsequently revalued the land to \(\$ 420000\). And on 1 January 2025 , the company...
-
The following data from Lyre Ltd's accounts relates to two assets at 30 June 2023. At 30 June 2023 Lyre Ltd decides to adopt the revaluation model for both these assets. On this date land has a fair...
-
Crane Ltd has proposed that the company adopt the revaluation model for fixed assets. Some of these assets are hard to obtain and certain items have increased in value in the current period, however...
Study smarter with the SolutionInn App