Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please i need help with my assignment. i have attached it with this post. thank you Homework Week 3 Breakeven There are four problems in
please i need help with my assignment. i have attached it with this post. thank you
Homework Week 3 Breakeven There are four problems in this assignment. Work each problem using the provided template. Meyerson's Bakery Projected Income Statement for Pie Line Sales Variable Costs Fixed Costs Earnings Before Interest and Taxes Interest Expense Earnings Before Taxes Taxes Net Income Additional Data Estimated Pie Sales in Units Price per Pie Variable Cost per Pie Tax Rate $25,000 7,500 20,000 (2,500) 3,000 (5,500) (1,925) (3,575) $ $ 2,500 10.00 3.00 35% Calculate the following Operating Break-even Points Units Dollars Target Level of EBIT Unit Sales Needed to Reach Target EBIT Price per Pie to Break Even on Net Income Assume you have 2500 units sold a b $15,000.00 c d Calculate this using goal seek this using goal seek profit = price x qty - cost* qty-fc Cymer, Inc. Annual Income Statements For the Fiscal Years 2005 to 2007 Dec-07 Dec-06 Total Revenue 521,696 543,855 Cost of Revenue 260,280 281,243 Gross Profit 261,416 262,612 Research Development 81,842 73,974 Selling General and Administrative 65,112 69,507 Net Operating Income 114,462 119,131 Other Income/Expenses Net 22,099 25,526 Earnings Before Interest And Taxes 136,561 144,657 Interest Expense 6,709 5,965 Income Before Tax 129,852 138,692 Income Tax Expense 44,413 46,137 Minority Interest 2,923 3,093 Net Income 88,362 95,648 Assumed S,G&A Expense Breakdown Variable Fixed 70% 30% Calculate and graph the DOL, DFL and DCL for each of the three years. Leverage Measures Degree of Operating Leverage Degree of Financial Leverage Degree of Combined Leverage Dec-05 383,648 227,290 156,358 64,025 51,657 40,676 12,048 52,724 6,936 45,788 262 1,026 46,552 Average Selling Price Unit Sales Interest Expense Variable Costs (% of Sales) Fixed Costs Preferred Dividends Common Shares Tax Rate Best Products Vintage Domestic $35,000 $27,000 1,500 1,850 750,000 1,000,000 60% 45% 10,000,000 7,000,000 1,000,000 5,000,000 8,000,000 35% 35% EU new $52,000 850 3,000,000 40% 20,000,000 600,000 3,000,000 35% Calculate the proforma income statement based on the assumptions above. Then calculate the breakeven in units and dollars Best Products Vintage Domestic EU new Sales Variable Costs Fixed Costs Earnings Before Interest and Taxes Interest Expense Earnings Before Taxes Taxes Net Income Preferred Dividends Net Income Available to Common Earnings per Common Share Break-even Point (Units) Break-even Point (Dollars) Degree of Operating Leverage Degree of Financial Leverage Degree of Combined Leverage Industry Average $30,000 1,250 1,500,000 48% 11,000,000 300,000 7,000,000 35% ulate the breakeven in units and dollars, and the DOL, DFL and DCL for each company and the industry Industry Average Break-even Analysis Case In Year 1, Jay Company expects to sell 2,243 units at $110 per unit. Sales are expected to increase 25% each year for years 2-4. The unit sales price will remain the same. Labor is 23% of sales, Overhead 10%, Materials 5%, and Variable Sales and Admin, 4%. Fixed Costs, are Factory Overhead (2%) and Sales and Admin (4%). Interest expense of $425 is evenly budgeted over the period. The company tax rate is 20%. a) Create the Sales Budget for the 4-year period. b) Calculate the variable cost per unit based on the cost given. c) Create a budgeted income statement for the 4-year period, using all the information provided and calculated. d) Calculate the CM ratio, Unit CM, Breakeven in units, Breakeven in dollars for the total 4-year period. e) If sales remain at the budgeted 4-year level, but fixed costs increase to $367,800, and the company wants to achieve target net income of $ $700,000, recalculate the CM ratio, Unit CM, Breakeven in units, Breakeven in dollars, and Target Breakeven in Units. f) Create a breakeven chart for Jay Company based on unit increments of 250 and the revised fixed costs of $367,800. (Hint: You want to graph sales, fixed costs and total costs (total variable and fixed) on one scatter plot.) a) Expected Sales (units) Unite Sales Price Total Sales Revenue UMUC, KK, 2009 1 2,243 $110 2 2,804 $110 3 3,505 $110 4 4,381 $110 7 Total 12,932 25% growth rate in sales UMUC, KK, 2009 8Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started