Question: Prepare a pro forma income statement and balance sheet for Webb Enterprises Where revenues are expected to grow by 20% in 2016. Make the following
x.png)
Where revenues are expected to grow by 20% in 2016. Make the following assumptions in making your forecast of the firms balance sheet for 2016:
The income statement expenses are a constant percentage of revenues except for interest, which remains equal in dollar amount to the 2015 level, and taxes, which equal 40% of earnings before taxes.
The cash and marketable securities balance remains equal to $ 500, and the remaining current asset accounts increase in proportion to revenues for 2015.
Net property, plant, and equipment increase in proportion to the increase in revenues and depreciation expenses for 2016 is $ 2,000.
Accounts payable increases in proportion to firm revenues.
Owners equity increases by the amount of firm net income for 2011 (no cash dividends are paid).
Long-term debt remains unchanged, and short-term debt changes in an amount that balances the balance sheet.
Balance Sheet 2015 Cash and marketable securitics Accounts reoeivabl Inventories 6,000 9.500 16,000 17000 33,000 Current assets Net property, plant, and equipment Total s 7.200 6,800 14,000 7,000 21,000 2,000 33,000 Accounts payable Short-term debt Current labilities Long-term debt Total liabilities Total owners equity Total liabilities and owners equity Income Statenment 2015 Revenues Cost of goods sold Gross profit Operating expenses Net operating iacome Interest expease Earnings before taxes Taxes Net income 5 30,000 (20,000 S 10,000 (8000) S 2,000 900) 1,100 (400)
Step by Step Solution
3.50 Rating (170 Votes )
There are 3 Steps involved in it
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style43 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style45 msonumberformat00220022 00000220022 ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
565-B-A-I (7093).xlsx
300 KBs Excel File
