1) GENUINE MOTOR PRODUCTS Revised Pro forma Income Statement For 2007 Sales (1,000,000 units @ $30 per unit) Fixed costs Total variable costs (1,000,000 units @ $18.80 per unit) Operating Income (EBIT) Interest (10.75% x $12,000,000) Earnings before taxes Taxes (35%) Earnings after taxes Shares Earnings per share * Fixed costs include $2,800,000 in depreciation $ 30,000,000 5,800,000 18,800,000 5,400,000 1,290,000 4,110,000 1,438,500 2,671,500 2,320,000 1.15
$ $ $
2) Although there is more shares, the Earnings after taxes are now higher due to the lower variable costs, which compensates for the increase in earnings based on the same 1,000,000 units at $30. Also the bigger part of the 14M invested, 10M was financied with issuing of
…show more content…
So the company will be indeed in trouble with sales volumes below the breakeven units quantity. 7) Sales volumes @ 1,500,000 units GENUINE MOTOR PRODUCTS Revised Pro forma Income Statement For 2007 Sales (1,500,000 units @ $30 per unit) Fixed costs Total variable costs (1,500,000 units @ $18.80 per unit) Operating Income (EBIT) $ 45,000,000 5,800,000 28,200,000 11,000,000
$
Interest (10.75% x $12,000,000) Earnings before taxes Taxes (35%) Earnings after taxes Shares Earnings per share * Fixed costs include $2,800,000 in depreciation
$ $
1,290,000 9,710,000 3,398,500 6,311,500 2,320,000 2.72
8) Having more automation indeed will increase the chance for the company to become more profitable. Once they reach their breakeven amount of units, each additional unit sold will contribute to the income, with $11.20. It is important to make sure the company the breakeven sale volume to cover the fixed costs and interest payments.
Consolidated Statements of Income (in thousands) 2003 2004 2005 Revenue Net sales Cost of goods sold Gross profit/(loss) Gross margin Operating expenses Sales and marketing Engineering and product development General and administrative Total operating expenses Operating income/loss Other income/expense Interest income/expense Other income/(expense) Income before provision for income taxes Income taxes Net income/(loss) Net margin 61,529 41,072 20,457 33.2% 64,063 43,155 20,908 32.6% 60,144 45,835 14,309 23.8%
Operating Taxes & Licenses | 18,613 | 17,989 | 2% | 2% | Insurance & Claims | 13,526 | 13,006 | 2% | 2% | Provision for Depreciation | 2,726 | 2,738 | .3% | .3% | Total Operating Expenses | 848,242 | 775,535 | 97% | 97% | | Operating Income
From the industry benchmark report for 2014, (appendix) between the year 2013 and 2014 our share value increased from 15.80 to 27.04 placing us ahead of everyone in our world. That is an increase of 172%. From out firm reports (appendix), our net income of 2,764,446 unfortunately fell short of our profit forecast. of 3,501,014. Even though our share holder’s value was the highest amongst our competitors, our profit before taxes was second to Bikes ‘R’Us by a total of $450,000. They had a profit of 4,339,987 while we only had a profit of 3,949,209. A part of the reason why our net income didn’t meet our forecasts and profit before taxes fell short of Bikes’R’Us is due to
Question 1: Using budget data, how many motors would have to be sold for Waltham Motors Division to breakeven?
| |Net Operating Income |$6,600,000 |$12,600,000 |$15,000,000 |$7,800,000 |$3,000,000 | | | | | | | | |Taxes |($2,244,000) |($4,284,000) |($5,100,000) |($2,652,000) |($1,020,000) | |Net Operating Profit After Taxes |$4,356,000 |$8,316,000 |$9,900,000 |$5,148,000 |$1,980,000 | | | | | | | | |Net Income |$4,356,000 |$8,316,000 |$9,900,000 |$5,148,000 |$1,980,000 | |Year |Units Sold | |Price Per Unit Year 1 - 4 | |1 |70,000 | |$300 | |2 |120,000 | | | | | |3 |140,000 | |Price Per Unit Year Five | |4 |80,000
Debt to Equity ℎℎ ′ 9,771+1,885 Dividend Payout Inventory Turnover = 0.069 Working backwards from the income tax expense, we estimate income tax rate to be 34%. NOPAT is then Operating profit taxes, or 3,137*(1-0.34) = 0.319 Average
Additional Financing required is calculated as the plug variable for Notes Payable using the percentage of sales approach by varying all other accounts that change according to sales,
$135,000 $90,000 TOTAL REVENUE $3,136,500 $2,352,375 $1,568,250 Expences TOTAL VARIABLE COSTS $454,000 $340,500 $227,000 TOTAL FIXED COSTS $1,403,000 $1,403,001 $1,403,002 TOTAL EXPENSE BEFORE IT $1,857,000 $1,743,501 $1,630,002 EBIT $1,279,500 $608,874 -$61,752 Depreciation $320,000 $320,001 $320,002 EBITDA $1,599,500 $928,875 $258,250 Furnishing Interest $110,000 $110,000 $110,000 20yr Mortgage Interest $182,000 $182,000 $182,000 TOTAL INTEREST $292,000 $292,000 $292,000 TAXES (40%) $395,000.00 $126,749.60 -$141,500.80 Furnishing Principal $180,160 $180,160 $180,160 20yr Mortgage Principal $49,713 $49,713 $49,713 TOTAL PRINCIPAL $229,873 $229,873 $229,873 NET INCOME $362,627 -$39,749 -$442,124 DIVIDEND PAYMENT $29,010 -$3,180 -$35,370 RETAINED EARNINGS $333,617 -$36,569 EBIT/INTEREST 4.38 2.09 (0.21) EBITDA/INTEREST 5.48 3.18 0.88 BURDEN $675,121.67 $675,121.67 $675,121.67 EBIT/BURDEN 1.90 0.90 (0.09) ROE= Net Income/OE (H1) 32.97% -3.61% -40.19% Revenue Estimates Revenue Item 100% Monthly 75%
Exhibit 21 displays Mustang’s income statement for the twelve months ended June 30, 2016 and June 30, 2015. During the financial year 2016, the Company did not generate any revenue from their core business activities. In the twelve months ended June 30, 2016, Mustang’s net loss widened to $10,282,313, compared to a net loss of $6,620,704 in the same period in 2015. The increase in net losses was primarily due to the significant increase (+120%) in the Company’s administration costs as compared to the same period in 2015. The administration costs include employee benefit and consulting fees expenses (+38%), compliance costs (+412%), share based payments (+100%), travel costs (83%), accounting and audit costs (270%) and other costs. Further,
|250000 indirect employees & 9000 vehicle for distribution). |position in profitability due to drop in prices by nearly 30% since 1950’s. |
EBIT EBIT*(1-t) Dep Capex A/R Inventory A/P WC FCFF NPV 2010 2011 2012 2013 2014 2015 2016 (1,250) 583 994 1,277 1,392 1,503 1,623 (750) 350 596 766 835 902 974 0 152 152 152 152 164 178 1,470 952 152 152 334 361 389 0 729.4931507 1112.0718 1363.1471 1472.1982 1589.9708 1717.1718 0 359.661 500.121 396.008 426.724 460.858 497.724 0 330.118 496.601 605.884 653.308 705.575
To sum up, if Superior reduces the price of product 101, its profit will increase significantly to breakeven.
Presented below is Mills’ Company financial data as of December 31, 2012: Sales 5,230,000 Sales Discount 310,000 Sales Salaries 311,000 Sales Returns 158,000 Sales Commissions 60,000 Freight-out 41,000 Office Salaries 123,000 Office Supplies Expense 23,000 Gain on sale of Investment 120,000 Rental Revenue 80,000 Loss on disposal of division 385,000 Interest expense 50,000 Ordinary Shares dividends 80,000 Beginning Inventory 960,000 Preferred Shares dividends 130,000 Ending Inventory 100,000 Freight-in 120,000 Purchases 218,000 Purchases Discounts 35,000 Depreciation understated due to an error (net of tax) 26,000 Tax rate 25% Beginning Retained Earnings 2012 420,000
sales to Searl Company (ending | | | | Inventory) | 21,000 | Pearce Company 's percentage of Searl Company 's income | | | | realized from third parties, .80($675,000) | 540,000 | | | | | | | Controlling interest in Consolidated Income | $2,337,000 | Exercise 6-5 2011 Pearce Company 's income from its independent operations $1,500,000 Plus: Pearce Company 's interest in the realized net income of Searl Company: Reported Net income $600,000 Less Amortization of difference between implied and book value ($75,000 + $112,500) (187,500) Less unrealized profit included therein ($90,000 - ) (18,000) Income realized in transaction with third parties $394,500 Pearce Company 's interest therein (0.8 $394,500) $315,600 Controlling interest in consolidated net income $1,815,600 2012 Pearce Company 's income from its independent operations $1,800,000 Plus: Pearce Company 's interest in the realized net income of Searl Company: Reported Net income $750,000 Less amortization of difference between implied and book value (75,000) Less profit included therein that has not been realized in transactions with third parties ($105,000 - ) (21,000) Plus profit realized in 2012 ($90,000 -) 18,000 Income realized in transaction with third parties $672,000 Pearce Company 's interest therein (0.8 $672,000) 537,600 Controlling
Ford has two major segments, automotive sector and financial services sector. These are presented as two sectors to evaluate performance of each and make appropriate decisions and to have consistency in reporting. The profitability of the automotive sector is affected by wholesale unit volumes, the margin of profit for each vehicle, and the fixed costs. The fixed costs can be really affected by any variation of units of sold. If the company does not sell as many vehicles as what was planned, the fixed costs will be same, therefore will decrease the profit for Ford. If the company sells more than what was planned, this will also increase the profit, because the fixed costs will not change.