Question

In: Accounting

Problem 4-25 Capacity Usage and Growth [LO2] - Do not sell fixed assets The most recent...

Problem 4-25 Capacity Usage and Growth [LO2] - Do not sell fixed assets

The most recent financial statements for Retro Machine, Inc., follow. Sales for 2017 are projected to grow by 10 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets and accounts payable increase spontaneously with sales.

RETRO MACHINE, INC.
2016 Income Statement
Sales $ 744,050
Costs 578,850
Other expenses 15,550
Earnings before interest and taxes $ 149,650
Interest paid 11,300
Taxable income $ 138,350
Taxes (35%) 48,423
Net income $ 89,928
Dividends $ 26,989
Addition to retained earnings 62,939
RETRO MACHINE, INC.
Balance Sheet as of December 31, 2016
Assets Liabilities and Owners’ Equity
Current assets Current liabilities
Cash $ 22,990 Accounts payable $ 61,390
Accounts receivable 36,710 Notes payable 15,420
Inventory 78,280 Total $ 76,810
Total $ 137,980 Long-term debt $ 142,100
Fixed assets Owners’ equity
Net plant and equipment $ 371,890 Common stock and paid-in surplus $ 127,000
Accumulated retained earnings 163,960
Total $ 290,960
Total assets $ 509,870 Total liabilities and owners’ equity $ 509,870


In 2016, the firm operated at 70 percent of capacity. Construct the pro forma income statement and balance sheet for the company. Assume that the company cannot sell fixed assets. This implies that asset utilization may remain less than 100 percent next year as well. (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.)

Pro Forma Income Statement
Sales $
Costs
Other expenses
EBIT $
Interest
Taxable income $
Taxes (35%)
Net income $
Pro Forma Balance Sheet
Assets Liabilities and Owners’ Equity
Current assets Current liabilities
Cash $ Accounts payable $
Accounts receivable Notes payable
Inventory Total $
Total $ Long-term debt $
Fixed assets Owners’ equity
Net plant and equipment $ Common stock and paid-in surplus $
Accumulated retained earnings
Total $
Total assets $ Total liabilities and owners’ equity $


What is the EFN? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g. 32. A negative answer should be indicated by a minus sign.)
  
EFN           $

I got answer for EFN is -62165 but it say is not correst, can anyone solve this for me thank you

Solutions

Expert Solution

RETRO MACHINE, INC.
2017 Performa Income Statement
2016 2017 Working
Sales $744,050 $818,455 =$744050*110%
Less: Costs $578,850 $636,735 =$578850*110%
Less: Other expenses $15,550 $17,105 =15550*110%
Earnings before interest and taxes $149,650 $164,615
Less: Interest paid $11,300 $11,300 Interest Paid Constant
Taxable income $138,350 $153,315
Less: Taxes (35%) $48,423 $53,660 Tax Rate Same
Net income $89,928 $99,655
Dividends $26,989 $29,908 =(26989/89928)*99655
Addition to retained earnings $62,939 $69,747
RETRO MACHINE, INC.
2017 Proforma Balance Sheet
Current Asets Current liabilties
Cash (22990*110%) $25,289 Accounts payable(61390*110%) $67,529
Accounts receivable(36710*110%) $40,381 Notes payable $15,420
Inventory (78280*110%) $86,108 Total $82,949
Total $151,778 Long term debt $142,100
Fixed assets Owner's equity
Net Plant.equipment $371,890 Common stock $127,000
Retained earnings (163960+69747) $233,707
Total Assets $523,668 Total $585,756
EFN (Negative) -$62,088

Related Solutions

Problem 4-25 Capacity Usage and Growth [LO2] - Do not sell fixed assets The most recent...
Problem 4-25 Capacity Usage and Growth [LO2] - Do not sell fixed assets The most recent financial statements for Retro Machine, Inc., follow. Sales for 2017 are projected to grow by 10 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets and accounts payable increase spontaneously with sales. RETRO MACHINE, INC. 2016 Income Statement Sales $ 756,800 Costs 585,600 Other expenses 20,800 Earnings before interest and...
Problem 4-24 Calculating EFN [LO2] The most recent financial statements for Crosby, Inc., follow. Sales for...
Problem 4-24 Calculating EFN [LO2] The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement Sales $ 763,000 Costs 598,000 Other expenses 34,000 Earnings before interest and taxes $ 131,000 Interest paid 30,000 Taxable income...
In the previous problem, suppose the most recent dividend was $4 and the dividend growth rate...
In the previous problem, suppose the most recent dividend was $4 and the dividend growth rate is 6 percent. Assume that the overall cost of debt is the weighted average of that implied by the two outstanding debt issues. Both bonds make semiannual payments. The tax rate is 35 percent. What is the company’s WACC? Please show work and calculations, thank you! (THIS IS THE PREVIOUS PROBLEM-BELOW) Filer Manufacturing has 8.2 million shares of common stock outstanding. The current share...
P4-4 EFN [LO2] The most recent financial statements for GPS, Inc., are shown here:   Income Statement...
P4-4 EFN [LO2] The most recent financial statements for GPS, Inc., are shown here:   Income Statement Balance Sheet   Sales $23,800     Assets $114,000     Debt $33,600     Costs 16,600     Equity 80,400     Taxable income $7,200       Total $114,000       Total $114,000     Taxes (30%) 2,160       Net income $5,040   Assets and costs are proportional to sales. Debt and equity are not. A dividend of $1,560 was paid, and the company wishes to maintain a constant payout ratio. Next year's sales are projected to be $28,000. Required: What is...
Problem 4-4 Money Market Funds (LO2, CFA2) The Aqua Liquid Assets Money Market Mutual Fund has...
Problem 4-4 Money Market Funds (LO2, CFA2) The Aqua Liquid Assets Money Market Mutual Fund has a NAV of $1 per share. During the year, the assets held by this fund appreciated by 1.1 percent. If you had invested $30,000 in this fund at the start of the year, how many shares would you own at the end of the year? What will the NAV of this fund be at the end of the year? Final Shares ______ Net Asset...
Problem 2-19 Multiple Predetermined Overhead Rates; Applying Overhead [LO2-1, LO2-2, LO2-4] High Desert Potteryworks makes a...
Problem 2-19 Multiple Predetermined Overhead Rates; Applying Overhead [LO2-1, LO2-2, LO2-4] High Desert Potteryworks makes a variety of pottery products that it sells to retailers. The company uses a job-order costing system in which departmental predetermined overhead rates are used to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Molding Department is based on machine-hours, and the rate in the Painting Department is based on direct labor-hours. At the beginning of the year, the company provided...
Problem 2-19 (Algo) Multiple Predetermined Overhead Rates; Applying Overhead [LO2-1, LO2-2, LO2-4] High Desert Potteryworks makes...
Problem 2-19 (Algo) Multiple Predetermined Overhead Rates; Applying Overhead [LO2-1, LO2-2, LO2-4] High Desert Potteryworks makes a variety of pottery products that it sells to retailers. The company uses a job-order costing system in which departmental predetermined overhead rates are used to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Molding Department is based on machine-hours, and the rate in the Painting Department is based on direct labor-hours. At the beginning of the year, the company...
An MNC expects to sell fixed assets it utilizes in Europe in the distant future. In...
An MNC expects to sell fixed assets it utilizes in Europe in the distant future. In order to hedge the sale of these assets in the distant future, the MNC could create a(n) ____ that ____ the expected value of the assets in the future. asset; matches asset; exceeds liability; matches liability; is less than
Problem 3-24 EFN and Internal Growth The most recent financial statements for Retro Machine, Inc., follow....
Problem 3-24 EFN and Internal Growth The most recent financial statements for Retro Machine, Inc., follow. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. RETRO MACHINE, INC. 2016 Income Statement Sales $ 752,000 Costs 587,000 Other expenses 23,000 Earnings before interest and taxes $ 142,000 Interest paid 12,000 Taxable income $ 130,000 Taxes (30%) 39,000 Net income...
Albion Corporation has $550,000 in net fixed assets and is currently operating at 90% capacity. The...
Albion Corporation has $550,000 in net fixed assets and is currently operating at 90% capacity. The firm's sales are $1,210,000 and they are forecasted to grow by 15% next year. a. What is the maximum sales level Albion's net fixed assets can support? b. What is Albion's target capital intensity ratio? c. What level of net fixed assets will Albion need to support its projected sales? d. How much additional net fixed assets will need to be acquired for next...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT