Question

In: Finance

Construct a proforma income statement using the information given below.   Ernie’s Echos, Inc. (EEI), projects unit...

Construct a proforma income statement using the information given below.  

Ernie’s Echos, Inc. (EEI), projects unit sales for a new six-octave voice emulation implant as follows:

Year

Unit Sales

1

110,000

2

127,000

3

115,000

4

98,000

5

92,000

6

75,000

Total fixed costs are $1,850,000 per year, variable production costs are $315 per unit, and the units are priced at $455 each. The equipment needed to begin production has an installed cost of $27,500,000. Because the implants are intended for professional singers, this equipment is considered industrial machinery and thus qualifies as seven-year MACRS property. EEI is in the 22 percent marginal tax bracket. Construct the proforma income statement (using Excel) to compute net income and operating cash flow.

Solutions

Expert Solution

Formulas will be as follows:


Related Solutions

Construct a proforma income statement using the information given below.   Ernie’s Echos, Inc. (EEI), projects unit...
Construct a proforma income statement using the information given below.   Ernie’s Echos, Inc. (EEI), projects unit sales for a new six-octave voice emulation implant as follows: Year Unit Sales 1 110,000 2 127,000 3 115,000 4 98,000 5 92,000 6 75,000 Total fixed costs are $1,850,000 per year, variable production costs are $315 per unit, and the units are priced at $455 each. The equipment needed to begin production has an installed cost of $27,500,000. Because the implants are intended...
QUIZ (MUST BE TYPED) With the information given below, construct Pedro Inc.’s Balance Sheet, Income Statement...
QUIZ (MUST BE TYPED) With the information given below, construct Pedro Inc.’s Balance Sheet, Income Statement and Retained Earnings Statement for 2016 (NO PREFERRED STOCK). (In 000’s) December 31, 2016 Cash                                                    $          ? Notes Payable                                     500,000 Sales                                                   10,000,000 Accounts Receivable                          850,000 Accounts Payable                               1,200,000 Long-term Debt                                  18,000,000 Common Stock (10,000 shares)         10,000 Additional Capital                              4,990,000 Retained Earnings (2015)                 5,050,000 Gross Fixed Assets                             32,350,000 Cost of Goods Sold                            4,000,000 Other Operating Expenses                 1,450,000 Inventory                                            1,980,000 Interest Expense                                 2,500,000 Tax Rate 50%...
Using the Below​ Data:                                                                                                              ​A: Prepare an Income Statement using the information given below. Make sure...
Using the Below​ Data:                                                                                                              ​A: Prepare an Income Statement using the information given below. Make sure to identify Gross​ Pofit, Operating​ Income, and Net Income. ​B: Calculate the​ P/E Ratio Inventories ​$ 50,000 Cost of Goods Sold ​$ 250,000 Administrative Expenses ​$ 50,000 Accumulated Depreciation ​$ 150,000 Sales ​$ 600,000 Depreciation Expense                 ​$ 25,000 Selling Expense ​$ 150,000 Common Stoock Dividends ​$ 8,000 Interest Expense ​$ 8,000 Corporate Tax Rate ​40% Cmmon Stock Shares ​100,000 Current Stock Market Price ​$...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
Using the information given below, prepare an income statement, Statement of Retained Earnings and balance sheet...
Using the information given below, prepare an income statement, Statement of Retained Earnings and balance sheet for Hanson Storage from the adjusted trial balance. No additional investments in the company were made during the year. ( really need help with making an income statement, statement of retained earnings, and balance sheet. HANSON PRODUCTS COMPANY Adjusted Trial Balance December 31, 2018 Debit Credit Cash $    14,400 Accounts receivable 35,000 Allowance for doubtful accounts 800 Merchandise inventory 50,400 Office supplies 900 Prepaid...
Use the information in the table below to construct an income statement for 2015 and balance...
Use the information in the table below to construct an income statement for 2015 and balance sheets for 2014 and 2015.  Then, find Operating Cash Flow, change in Net Working Capital, Net Capital Spending, Cash Flow to Creditors, Cash Flow to Shareholders, and Free Cash Flow.  The tax rate is 34% and the plowback ratio is 60%. 2014 2015 Sales 1700 Costs of Goods Sold 650 Depreciation Expense 200 Interest Expense 75 Total Fixed Assets 2200 3300 Accumulated Depreciation 400 Can be...
Use the information in the table below to construct an income statement for 2015 and balance...
Use the information in the table below to construct an income statement for 2015 and balance sheets for 2014 and 2015.  Then, find Operating Cash Flow, change in Net Working Capital, Net Capital Spending, Cash Flow to Creditors, Cash Flow to Shareholders, and Free Cash Flow.  The tax rate is 34% and the plowback ratio is 60%. 2014 2015 Sales 1700 Costs of Goods Sold 650 Depreciation Expense 200 Interest Expense 75 Total Fixed Assets 2200 3300 Accumulated Depreciation 400 Can be...
Given the following information please construct a balance sheet and an income statement for the company....
Given the following information please construct a balance sheet and an income statement for the company. It provides software via a cloud subscription. There is no inventory. All information in $000 Total Revenues                                            5,374 Cash                                                                  908 Common Stock                                                651 Cost of Revenues Subscription                     925 Interest Expense                                               16 Additional Paid in Capital                           3,954 Retained Earnings                                       (630) Cost of Revenues Professional Services     365 Gross Margin                                                4,084 Short term securities                                       87 Long term debt                                            2,328 Accounts Receivable                                  ...
Given the following information please construct a balance sheet and an income statement for the company....
Given the following information please construct a balance sheet and an income statement for the company. It provides software via a cloud subscription. There is no inventory. All information in $000 Total Revenues                                            5,374 Cash                                                                  908 Common Stock                                                651 Cost of Revenues Subscription                     925 Interest Expense                                               16 Additional Paid in Capital                           3,954 Retained Earnings                                       (630) Cost of Revenues Professional Services     365 Gross Margin                                                4,084 Short term securities                                       87 Long term debt                                            2,328 Accounts Receivable                                  ...
. Use the information given below to create the Income Statement, Statement of Changes in Owner’s...
. Use the information given below to create the Income Statement, Statement of Changes in Owner’s Equity and Statement of Financial Position for Mikes Maintenance Company for the year ended Dec. 31 . The balances for the accounts of Mike's Maintenance Co. for the year ended December 31 are as follows. Account $ Account $ A/P 7,000 Wages expense 35,500 A/R 6,500 Rent expense 6,000 Cash 10,500 Supplies 1,200 Land 50,000 Building 125,000 Unearned revenue 4,000 Supplies expense 21,500 Mike’s...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT