FV = PV x (1+r)5; $100,000 = $65,000 x (1=r)5; 1.53846 = (1+r)5; (1.53846) 1/5 = 1+r; 1.08998 = 1+r; annual rate = 8.998$ 13. PV of Annjuity = Payment x [1-(1+r)-5]/r; $33,520 = $10,000 x [1-(1+r)-5]/r Period 9nper0 = 5; Payment = $10,000; Present Value (PV) = $33,250; Future Value (FV) = $0; Rate of Return =
In year 2 it reports a $40,000 loss. For year 3, it reports taxable income from operations of $100,000 before any loss carryovers. Using the corporate tax rate table, determine how much tax Willow Corp. will pay for year 3. Answer: $4,500. Description (1) Year 3 taxable income $100,000 (2) Year 1 NOL carryforward ($30,000) (3) Year 2 NOL carryforward ($40,000) (4) Taxable income reported 30,000 (1) - (2) -
1. What is the firm average collection period? Average collection formula: (Gapenski, 2008 pg.536) 30% pay on the 10 and take discount 40% pay on the 30 30% pay average 40 ACP = (0.3 x 10 days) + (0.4 x 30 days) + (0.3 x 40 days) 3 + 12 + 12 = 27 days 2. Calculate the firm’s current receivables balance Receivables balance = ADB x ACP, where ADB = Average Daily Billing. I got the ADB dividing the Gross sales by the 360 days: $1,200.000 / 360 = $3,333.33 Receivables balance = $3,333.33 x 27 = $89,999.91 3.
If operating capital as of 12/31/2010 is $502.2 million, what is the free cash flow for 12/31/2011? Computation of the Free Cash Flow NOWC= ($5.60 + $56.20 + $112.40) NOWC = $174.20 Net Plant and Equipment= ($11.20 + $28.10) Net Plant and Equipment= $39.30 Operating Capital= $174.20 - $39.30 Operating Capital= $134.90 Total Operating Capital=$134.90 + 397.50 Total Operating Capital=$532.40 Change in operating Capital= $532.40 - $502.20 Change in operating Capital= $30.20 FCF= $65.16 - $30.20 FCF=$34.96 b. What is the horizon value as of 12/31/2011? Horizon value = 37.06/ (.11-.06) Horizon value = $741.15 c. What is the value of operations as of 12/31/2010? Value of operations in 2010= $34.96 + $741.15 Value of operations in 2010= $776.11 Value of operations in 2009=$741.15-$41.95 Value of operations in 2009=$699.20 d. What is the total value of the company as of 12/31/2010?
Cash flow per share= $3.00 Price /cash flow ratio= 8.0 8.0 x 3.00 = $24.00 $24.00 / $1.50 = 16 (P/E) 3-5 ROE $100millions (sales) x 3% (profit margin) = $30 million (Net income) Net Income/assets= ROE $30 millions/$50 millions (total assets) = 6% 6% x 2.0 (equity multiplier) = 12% (ROE) 3-6 Du Pont Analysis ROA=10% Profit margin= 2% ROE= 15% ROA x Equity Multiplier= ROE (Profit Margin) (Total asset turnover)= ROA 10/2=5 (this is the firm’s total asset turnover) 15/10=1.5 (this is the firm’s equity multiplier) 3-7 Current and Quick Ratios Current assets= $3 million Current ratio= 1.5 Quick ratio= 1.0 Current assets/ Current liability= current ratio $3million/1.5= $2 million (level of current liability) Current Assets - Current Liability= Inventory $3millions – $2 millions = $1 million (level of
After adding $15,300 to the $15,000 in savings, the cash flow for year 2 would equal $30,300. For year 3, the depreciation expense would equal $85,000 * .15, or $12,750. The tax on the year 3 deprecation would then be $12,750 * .40, which equals $5,100. After adding $5,100 to the $15,000 in savings, the cash flow for year 3 would equal
Margin of Safety (DOLLARS) Budgeted – break even = 100,000-62500= 37500 (Percentage) 37.500/100.000= 37.5% (Units) 37500/250= 150 3.Compute the company’s margin of safety in units assuming the proposal is accepted. Margin of Safety (Dollars) 137500-58929= 78571 (Units) 78571/275= 286 4. Compute the increase or decrease in profit assuming the proposal is accepted, show the contribution Income Statement for current and proposed. Present Proposed Sales 100,000 137500 Variable expense 64000 80000 CM 36000 57500 Fixed cost 22500 244750 Net income 13500 32750 difference: 19250 4a. What is the operating leverage for the current and proposed?
1. Given the following information: Total assets $250,000 Debt (12% interest rate) $150,000 Equity $40,000 Variable costs of production $150 per unit Fixed cost of production $50,000 Units Sold 1,000 Sales price $210 per unit What happens to operating income and net income if output is increased by 10 percent? Verify your answer. Solution: The operating income: Revenues: $210 x (1,000) = $210,000 Expenses: $150 x (1,000) + $50,000 = $200,000 Operating income: $210,000 - 200,000 = $10,000 Net income: $10,000 - (.12 x 150,000) = ($8,000) With 10% increase in revenue: Revenues: $210 x (1,100) = 231,000 Expenses: $150 x (1,100) + $50,000 = $215,000 Operating income: $231,000 - $215,000 = $16,000 Net income $16,000 - (.12 x $150,000) = ($2,000) Operating income rose from $10,000 to $16,000 for a 60% increase. Net income rose from ($8,000) to ($2,000) which cut losses by $6,000.
Question 1 In summary: Product Line 1 (time in minutes) Line 2 (time in minutes) Profit ( $ ) X1 SUPER 3 4 42 X2 EXCELLENT 6 2 87 Let X1 = Number of SUPER model produced during 8 hour shift. X2 = Number of EXCELLENT model produced during 8 hour shift. Max 42X1 + 87X2 ST X1 + X2 ≤ 480 3X1 + 6X2 ≤ 480 4X1 + 2X2 ≤ 480 X1, X2 ≥ 0 It is recommended to produce 80 units of EXCELLENT and none SUPER in order to get the maximum profit (See attached print-out, table № 1). If the company wants to produce SUPER, the maximum profit will reduce by $1.5 per each unit, with $6960 - $1.5 = $6958.5 (See attached print-out, table № 2). As the company has extra 320 minutes
(4 points) Problem 4: We need 1,000 electric drills per year. The ordering cost for these is $100 per order and the carrying cost is assumed to be 40% of the per unit cost. In orders of less than 120, drills cost $78; for orders of 120 or more, the cost drops to $50 per unit. Should we take advantage of the quantity discount? (4 points) Problem 5: George Heinrich uses 1,500 per year of a certain subassembly that has an annual holding cost of $45 per unit.