Kerwin Motors is a chain of car dealerships. Sales in the fourth quarter of last year were $4,500,000. Suppose management projects that its current year's quarterly sales will increase by 2% in quarter 1, by another 5% in quarter 2, by another 7% in quarter 3, and by another 6% in quarter 4. Management expects cost of goods sold to be 45% of revenues every quarter, while operating expenses should be 30% of revenues during each of the first two quarters, 20% of revenues during the third quarter, and 35% during the fourth quarter. Requirement Prepare a budgeted income statement for each of the four quarters and for the entire year. Prepare the first portion of the budgeted income statement through gross profit, then complete the statement. (Round the amounts to the nearest whole dollar.) Kerwin Motors Budgeted Income Statement For the Upcoming Year Sales Less: Cost of goods sold Gross profit Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year

Kerwin Motors is a chain of car dealerships. Sales in the fourth quarter of last year were $4,500,000. Suppose management projects that its current year's quarterly sales will increase by 2% in quarter 1, by another 5% in quarter 2, by another 7% in quarter 3, and by another 6% in quarter 4. Management expects cost of goods sold to be 45% of revenues every quarter, while operating expenses should be 30% of revenues during each of the first two quarters, 20% of revenues during the third quarter, and 35% during the fourth quarter. Requirement Prepare a budgeted income statement for each of the four quarters and for the entire year. Prepare the first portion of the budgeted income statement through gross profit, then complete the statement. (Round the amounts to the nearest whole dollar.) Kerwin Motors Budgeted Income Statement For the Upcoming Year Sales Less: Cost of goods sold Gross profit Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter9: Capital Budgeting And Cash Flow Analysis

Section: Chapter Questions

Problem 20P

See similar textbooks

Similar questions

Suppose the company has just the opposite news and now expects unit sales for August, September, and October to be double (200%) the original estimates. What effect will this have on the company’s net income and borrowing? Explain your findings.
Macom Manufacturing has total contribution margin of $61,250 and net income of $24,500 for the month of June. Marcus expects sales volume to increase by 10% in July. What are the degree of operating leverage and the expected percent change in income for Macom Manufacturing? 0.4 and 10% 2.5 and 10% 2.5 and 25% 5.0 and 50%
Dodge Ball Bearings had sales of 12,000 units at $20 per unit last year. The marketing manager projects a 35 percent increase in unit volume sales this year with a 5 percent price decrease (due to a price reduction by a competitor). Returned merchandise will represent 8 percent of total sales. What is your net dollar sales projection for this year?
Cyber Security Systems had sales of 4,600 units at $65 per unit last year. The marketing manager projects a 30 percent increase in unit volume sales this year with a 40 percent price increase. Returned merchandise will represent 5 percent of total sales. What is your net dollar sales projection for this year?
Dodge Ball Bearings had sales of 14,000 units at $70 per unit last year. The marketing manager projects a 15 percent increase in unit volume sales this year with a 10 percent price decrease (due to a price reduction by a competitor). Returned merchandise will represent 10 percent of total sales. What is your net dollar sales projection for this year? Net sales
Central Networks had sales of 3,600 units at $80 per unit last year. The marketing manager projects a 10 percent increase in unit- volume sales this year with a 10 percent increase in price. Returned merchandise will represent 10 percent of total sales. What is your net dollar sales projection for this year? Net sales
Consider the following scenario: Fuzzy Button Clothing Company’s income statement reports data for its first year of operation. The firm’s CEO would like sales to increase by 25% next year. 1. Fuzzy Button is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT). 2. The company’s operating costs (excluding depreciation and amortization) remain at 70.00% of net sales, and its depreciation and amortization expenses remain constant from year to year. 3. The company’s tax rate remains constant at 40% of its pre-tax income or earnings before taxes (EBT). 4. In Year 2, Fuzzy Button expects to pay $100,000 and $896,963 of preferred and common stock dividends, respectively. Complete the Year 2 income statement data for Fuzzy Button, then answer the questions that follow. Round each dollar value to the nearest whole dollar.
Consider the following scenario: Green Caterpillar Garden Supplies Inc.'s Income statement reports data for its first year of operation. The firm's CEO would like sales to increase by 25% next year. 1. Green Caterpillar is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before Interest and taxes (EBIT). 2. The company's operating costs (excluding depreciation and amortization) remain at 60% of net sales, and its depreciation and amortization expenses remain constant from year to year. 3. The company's tax rate remains constant at 25% of its pre-tax income or earnings before taxes (EBT). 4. In Year 2, Green Caterpillar expects to pay $100,000 and $1,759,500 of preferred and common stock dividends, respectively. Complete the Year 2 Income statement data for Green Caterpillar, then answer the questions that follow. Be sure to round each dollar value to the nearest whole dollar. Net sales Less: Operating costs, except depreciation…
Consider the following scenario: Blue Hamster Manufacturing Inc.'s income statement reports data for its first year of operation. The firm's CEO would like sales to increase by 25% next year. 1. Blue Hamster is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT). 2. The company's operating costs (excluding depreciation and amortization) remain at 65% of net sales, and its depreciation and amortization expenses remain constant from year to year. 3. The company's tax rate remains constant at 25% of its pre-tax income or earnings before taxes (EBT). 4. In Year 2, Blue Hamster expects to pay $200,000 and $2,280,656 of preferred and common stock dividends, respectively. Complete the Year 2 income statement data for Blue Hamster, then answer the questions that follow. Be sure to round each dollar value to the nearest whole dollar. Blue Hamster Manufacturing Inc. Income Statement for Year Ending December…
Consider the following scenario: Green Caterpillar Garden Supplies Inc.’s income statement reports data for its first year of operation. The firm’s CEO would like sales to increase by 25% next year. 1. Green Caterpillar is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT). 2. The company’s operating costs (excluding depreciation and amortization) remain at 60% of net sales, and its depreciation and amortization expenses remain constant from year to year. 3. The company’s tax rate remains constant at 25% of its pre-tax income or earnings before taxes (EBT). 4. In Year 2, Green Caterpillar expects to pay $100,000 and $1,759,500 of preferred and common stock dividends, respectively. A. Complete the Year 2 income statement data for Green Caterpillar, then answer the questions that follow. Be sure to round each dollar value to the nearest whole dollar. Green Caterpillar…
Consider the following scenario: Cute Camel Woodcraft Company’s income statement reports data for its first year of operation. The firm’s CEO would like sales to increase by 25% next year. 1. Cute Camel is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT). 2. The company’s operating costs (excluding depreciation and amortization) remain at 65% of net sales, and its depreciation and amortization expenses remain constant from year to year. 3. The company’s tax rate remains constant at 25% of its pre-tax income or earnings before taxes (EBT). 4. In Year 2, Cute Camel expects to pay $100,000 and $1,773,844 of preferred and common stock dividends, respectively. Complete the Year 2 income statement data for Cute Camel, then answer the questions that follow. Be sure to round each dollar value to the nearest whole dollar. Need help with Year 2 values and questions at bottom
ZNet Co. is a web-based retail company. The company reports the following for the past year. The company’s CEO believes that sales for next year will increase by 20% and both profit margin (%) and the level of average invested assets will be the same as for the past year. 1. Compute return on investment for the past year. 2. Compute profit margin for the past year. 3. If the CEO’s forecast is correct, what will return on investment equal for next year? 4. If the CEO’s forecast is correct, what will investment turnover equal for next year? Sales . $5,000,000 Operating income . $1,000,000 Average invested assets . $12,500,000