Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please i need help with this finance problems. See attachment below. Homework Week 3 Breakeven There are four problems in this assignment. Work each problem

Please i need help with this finance problems. See attachment below.

image text in transcribed 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 8

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurial Finance

Authors: Chris LeachJ LeachRonald Melicher

3rd Edition

0324561253, 9780324561258

More Books

Students also viewed these Finance questions

Question

The number of new ideas that emerge

Answered: 1 week ago

Question

Technology

Answered: 1 week ago