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-4 EFN [LO2] The most recent financial statements for Cardinal, Inc., are shown here: Income...
Problem 4-4 EFN [LO2] The most recent financial statements for Cardinal, Inc., are shown here: Income Statement Balance Sheet   Sales $ 31,000   Assets $ 73,200   Debt $ 36,700   Costs 18,400   Equity 36,500   Taxable income $ 12,600     Total $ 73,200     Total $ 73,200   Taxes (22%) 2,772     Net income $ 9,828 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $3,700 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales...
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...
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 25 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 $ 751,000   Costs 586,000   Other expenses 22,000   Earnings before interest and taxes $ 143,000   Interest paid 18,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...
Problem 4-7 Calculating Sustainable Growth [LO3] The most recent financial statements for Bello Co. are shown...
Problem 4-7 Calculating Sustainable Growth [LO3] The most recent financial statements for Bello Co. are shown here: Income Statement Balance Sheet   Sales $ 20,000 Current assets $ 11,920 Debt $ 16,360   Costs 13,700 Fixed assets 31,050 Equity 26,610   Taxable income $ 6,300     Total $ 42,970     Total $ 42,970   Taxes (22%) 1,386     Net income $ 4,914 Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 45 percent dividend payout ratio. What is the...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT