The condensed income statements for years 20x1 and 20x2 for the Ruhf Inn are shown below:
20x1 20x2
Room revenue $ 2,500,000 $3,000,000
Room labor costs 400,000 500,000
Room other expenses 300,000 350,000
Room income 1,800,000 2,150,000
Undistributed operating expenses 500,000 600,000
Interest expense 200,000 250,000
Rent expense 100,000 120,000
Other fixed charges 400,000 400,000
Income before taxes 600,000 780,000
Income taxes 200,000 260,000
Net Income 400,000 520,000
Required:
1. Determine the following for each year:
a. Number of times interest earned ratio
b. Fixed charge coverage ratio
c. profit margin
d. Room labor cost percentage
e. Average tax rate
2. Prepare a common size income statement for 20x1 and 20x2 and comment on any significant differences in the percentages
1.
No of time interest earned ratio | EBIT/Interest | (600,000+200,000)/200,000 = 4 times | (780000+250000)/400000 = 4.12 times |
Fixed charge coverage ratio | EBIT+fixed charge/Interest+fixed charge |
(800000+400000+100000)/(200,000+400,000+100,000) = 1.86 times |
(1030000+400000+120000)/(250000+400000+120000) = 2.01 times |
Profit margin | (assuming net profit) Net Income/Room Revenue*100 | 400000/2500000*100 = 16% | 520000/3000000*100 =17.33% |
Room Labor cost % | (assuming % of sales) Labor Cost/room revenue*100 | 400000/2500000*100 = 16% | 500000/3000000*100 = 16.67% |
2.
20x1 | 20x2 | |||
Room revenue | 2,500,000.00 | 100.00% | 3,000,000.00 | 100.00% |
Room labor cost | 400,000.00 | 16.00% | 500,000.00 | 16.67% |
Room other expenses | 300,000.00 | 12.00% | 350,000.00 | 11.67% |
Gross profit | 1,800,000.00 | 72.00% | 2,150,000.00 | 71.67% |
Undistributed Operating expense | 500,000.00 | 20.00% | 600,000.00 | 20.00% |
Rent expense | 100,000.00 | 4.00% | 120,000.00 | 4.00% |
other fixed charges | 400,000.00 | 16.00% | 400,000.00 | 13.33% |
Operating income (EBIT) | 800,000.00 | 32.00% | 1,030,000.00 | 34.33% |
Interest | 200,000.00 | 8.00% | 250,000.00 | 8.33% |
EBT | 600,000.00 | 24.00% | 780,000.00 | 26.00% |
Taxes thereon | 200,000.00 | 8.00% | 260,000.00 | 8.67% |
Net income | 400,000.00 | 16.00% | 520,000.00 | 17.33% |
The condensed income statements for years 20x1 and 20x2 for the Ruhf Inn are shown below:...
Shown here are condensed income statements for two different companies (assume no income taxes). Miller CompanySales$1,000,000Variable expenses (80%)800,000Income before interest200,000Interest expense (fixed)60,000Net income$140,000 Weaver CompanySales$1,000,000Variable expenses (60%)600,000Income before interest400,000Interest expense (fixed)260,000Net income$140,000Required:1. Compute times interest earned for Miller Company and for Weaver Company
294 Chapter 5 The Mantle Inn commenced operation the Inn's financial condition. Bala Problem 21 un commenced operations on lanuary 1, 20X1. and has been operating for two years. Assume that you are the new assistant manager and denne desire to gain some insight into s nhancial condition, Balance sheets and condensed income statements for the first two years are as follows: Balance Sheets Mantle Inn December 31, 20X1 and 20x2 Assets 20X1 20X2 Current Assets: $ Cash 10,000 $...
Condensed financial data are presented below for the Phoenix Corporation: 20X2 20X1 Accounts receivable $ 267,500 $ 230,000 Inventory 312,500 257,500 Total current assets 670,000 565,000 Intangible assets 50,000 60,000 Total assets 825,000 695,000 Current liabilities 252,500 200,000 Long-term liabilities 77,500 75,000 Sales 1,640,000 Cost of goods sold 982,500 Interest expense 10,000 Income tax expense 77,500 Net income 127,500 Cash flow from operations 71,000 Cash flow from investing activities (6,000 ) Cash flow from financing activities (62,500 ) Tax rate...
Required information [The following information applies to the questions displayed below.] Shown here are condensed income statements for two different companies (assume no income taxes). Miller Company Sales $1,300,000 Variable expenses (80%) 1,040,000 Income before interest 260,000 Interest expense (fixed) 76,000 Net income $ 184,000 Weaver Company Sales Variable expenses (60%) Income before interest Interest expense (fixed) Net income $1,300,000 780,000 520,000 336,000 $ 184,000 Required: 1. Compute times interest earned for Miller Company and for Weaver Company.. Times interest...
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...
294 Chapter 5 been operating for two in some insight into ments for the first Problem 21 The Mantle Inn commenced operations on January 1, 20X1, and has been ope years. Assume that you are the new assistant manager and desire to gain some the Inn's financial condition. Balance sheets and condensed income statements fe two years are as follows: Balance Sheets Mantle Inn December 31, 20X1 and 20X2 20X1 20X2 $ 10,000 $ 55,000 10,000 75,000 15,000 50,000 60,000...
Condensed financial data are presented below for the Phoenix Corporation: 20X2 20X1 Accounts receivable $ 267,500 $ 230,000 Inventory 312,500 257,500 Total current assets 670,000 565,000 Intangible assets 50,000 60,000 Total assets 825,000 695,000 Current liabilities 252,500 200,000 Long-term liabilities 77,500 75,000 Sales 1,640,000 Cost of goods sold 982,500 Interest expense 10,000 Income tax expense 77,500 Net income 127,500 Cash flow from operations 71,000 Cash flow from investing activities (6,000 ) Cash flow from financing activities (62,500 ) Tax rate...
Condensed financial data are presented below for the Phoenix Corporation: 20X2 20X1 Accounts receivable $ 267,500 $ 230,000 Inventory 312,500 257,500 Total current assets 670,000 565,000 Intangible assets 50,000 60,000 Total assets 825,000 695,000 Current liabilities 252,500 200,000 Long-term liabilities 77,500 75,000 Sales 1,640,000 Cost of goods sold 982,500 Interest expense 10,000 Income tax expense 77,500 Net income 127,500 Cash flow from operations 71,000 Cash flow from investing activities (6,000 ) Cash flow from financing activities (62,500 ) Tax rate...
20X1 AND 20X2 FINANCIAL STATEMENTS Bio-Fuels Generation Incorporated Statement of comprehensive income for the year ended December 31 20X2 $ 20X1 $ Revenue Cost of goods sold Gross profit 10,458,240 9,075,000 1,383,240 9,734,502 8,473,800 1,260,702 Expenses Selling and marketing Research and development General and administrative Other operating costs 103,500 370,020 458,200 15,900 947,620 92,400 365,100 423,900 14,200 895,600 Operating income Interest expense — line of credit Interest expense - long-term debt Earnings before taxes Income taxes Net income 435,620 (8,650)...
Required 1. For the years 20X2 and 20X1, conduct the DuPont Analysis and calculate the Return of Equity (ROE) for “Megasales Company”. (Please show the analytical computations for all components of the DuPont Analysis for the two respective years). 2. For the years 20X2 and 20X1, compute the Return of Equity (ROE) for “Megasales Company”. Analyze and interpret your results for the two years under examination. 3. Describe how each of the three components of the DuPont Analysis, affects the...