reveneu increase by 30%, gross margin increase by 1.0%, S&G improve by 1.0% R&D increase by 10%
Added by Tiffany A.
Step 1
Let's think step by step. Show more…
Show all steps
Your feedback will help us improve your experience
Supreeta N and 55 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
Year 1 Sales revenues increase 3.5% Gross margin is 50% SG&A increases 1.2% Year 0 17,000 9,200 7,800 4,790 1,700 1,310 155 1,155 404 751 225 526 $2000 of PP&E is purchased on January 1, New PP&E is depreciated over 10 years Inventory grows in line with COGS Assume that all other asset accounts grow in line with sales (3.5%). Accounts Payable grow in line with COGS Accrued and deferred income taxes grows in line with taxes. Long-term debt declines by $200 Unless otherwise stated, liability accounts grow in line with sales (3.5%) Treasury Stock purchases equal $300 Average interest cost of all interest bearing debt is 1.6% Dividend payout ratio is 22% Tax rate is 35% Funding requirements should be financed with short-term debt
Supreeta N.
Top executive officers of Baird Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Current Year: Sales revenue: $2,300,000 Cost of goods sold: $1,725,000 Gross profit: $575,000 Selling & administrative expenses: $304,000 Net income: $271,000 Cost of goods sold is usually 75 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $74,000. The president has announced that the company's goal is to increase net income by 15 percent. Required: 1. Using Excel, prepare a pro forma income statement. 2. What percentage increase in sales would enable the company to reach its goal? 3. The market may become stagnant next year, and the company does not expect an increase in sales revenue. 4. The production manager believes that an improved production procedure can cut the cost of goods sold by 2 percent. Prepare a pro forma income statement, still assuming the President's goal to increase net income by 15 percent. 5. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income. 6. The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $347,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that the cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. 7. Will the company reach its goal?
Manasvee S.
The production of a company for three successive years has increased by 10%, 30%, 90% respectively. What is the average annual increase in production?
Dj T.
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD