Prepare firms pro forma income statement and balance sheet

Assignment Help Financial Accounting
Reference no: EM131527556

Assignment: Pro Forma Income Statement and Balance Sheet

Below is the income statement and balance sheet for Blue Bill Corporation for 2013. Based on the historical statements and the additional information provided, construct the firm's pro forma income statement and balance sheet for 2014.

Blue Bill Corporation
Income Statement
For the year ended 2013
  2012 2013
Revenue $60,000 $63,000
Cost of goods sold 42,000 44,100
Gross margin 18,000 18,900
SG&A expense 6,000 6,300
Depreciation expense 1,800 2,000
Earnings Before Interest and Taxes (EBIT) 10,200 10,600
Interest expense 1,500 1,800
Taxable income 8,700 8,800
Income Tax Expense 3,045 3,080
Net income 5,655 5,720
Dividends 750 800
To retained earnings $4,905 $4,920

Additional income statement information:
Sales will increase by 5% in 2014 from 2013 levels.
COGS and SG&A will be the average percent of sales for the last 2 years.
Depreciation expense will increase to $2,200.
Interest expense will be $1,900.
The tax rate is 35%.
Dividend payout will increase to $850.

Blue Bill Corporation
Balance Sheet
December 31, 2013
  2013
Current assets  
Cash $8,000
Accounts receivable 3,150
Inventory 9,450
Total current assets      20,600
Property, plant, and equipment (PP&E)      28,500
Accumulated depreciation      16,400
Net PP&E      12,100
Total assets $32,700
   
Current liabilites  
Accounts payable $3,780
Bank loan (10%) 3,200
Other current liabilities 1,250
Total current liabilities 8,230
Long-term debt (12%) 4,800
Common stock 1,250
Retained earnings 18,420
Total liabilities and equity $32,700

Additional balance sheet information:
The minimum cash balance is 12% of sales.
Working capital accounts (accounts receivable, accounts payable, and inventory) will be the same percent of sales in 2014 as they were in 2013.
$8,350 of new PP&E will be purchased in 2014.
Other current liabilities will be 3% of sales in 2014.
There will be no changes in the common stock or long-term debt accounts.
The plug figure (the last number entered that makes the balance sheet balance) is bank loan.

Reference no: EM131527556

Questions Cloud

Determine the cost of goods sold : Office Depot operates a chain of office supply stores throughout the United States. For 2004, Office Depot reported (in thousands) net sales of $13,564,699.
Describe the international events involving the us military : Describe the two (2) international events involving the US military from the past five (5) years you investigated that can be traced back to a foreign policy.
Four types of operating systems : Create a comparison chart that lists and compares the features and functions of the four types of operating systems discussed this week
Prepare a single-step income statement : Summary operating data for The Meriden Company during the current year ended June 30, 2006, are as follows: cost of merchandise sold, $3,240,000.
Prepare firms pro forma income statement and balance sheet : Based on the historical statements and the additional information provided, Prepare the firm's pro forma income statement and balance sheet for 2014.
Customers to order products online : Evaluate alternatives to the company self-hosting the site. Build a Gantt chart using Microsoft Project or equivalent software, showing all tasks associated.
Determine gross profit to be reported on income statement : The following data were extracted from the accounting records of Meniscus Company for the year ended April 30, 2006.
What you can do to help prevent the negative influences : Explain what you can do to help prevent the negative influences of media, parenting, and the nuclear family, and ensure their positive influence on child growth and development.
Discuss the depreciation expense on office equipment : The following expenses were incurred by a merchandising business during the year. In which expense section of the income statement should each be reported.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd