Sales Data Market Size (000 units) Market Share Average Sales Price ($/unit) Cost of Goods Data...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sales Data Market Size (000 units) Market Share Average Sales Price ($/unit) Cost of Goods Data Raw Materials ($/unit) Direct Labor Costs ($/unit) Operating Expense Data Sales and Marketing (% sales) Administrative (% sales) Interest on Term Loan ($ 000) Growth 5% 0.5% 2% 1% 4% 2005 16.0000 18.0000 15.0 2006 18 (75) 10,000 10,500 11,025 11,576.25 10.00% 10.50% 11.00% 11.50% 75.0000 76.5000 78.0300 79.5906 2007 16.1600 16.3216 18.7200 19.4688 16.5 15 (6,800) 18.0 Year 15 (6,800) 2008 16.4848 20.2476 19.5 14 (6,800) 2009 12,155.06 12.00% 81.1824 16.6497 21.0575 20.0 13 (6,800) 2010 12,762.81 12.50% 82.8061 16.8162 21.8998 20.0 13 (6,800) TABLE 19.7 SPREADSHEET Pro Forma Income Statement for Ideko, 2005-2010 Income Statement ($ 000) 1 Sales 2 Cost of Goods Sold 3 Raw Materials 4 Direct Labor Costs 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) 12 Pretax Income 13 Income Tax 14 Net Income Year 2005 75,000 2006 2007 2008 2009 2010 88,358 103,234 119,777 138,149 158,526 (16,000) (18,665) (21,593) (24,808) (28,333) (32,193) (18,000) (21,622) (25,757) (30,471) (35,834) (41,925) 41,000 48,071 55,883 64,498 73,982 84,407 (11,250) (14,579) (18,582) (23,356) (27,630) (31,705) (13,500) (13,254) (15,485) (16,769) (17,959) (20,608) 16,250 20,238 21,816 24,373 28,393 32,094 (5,500) (5,450) (5,405) (6,865) (7,678) (7,710) 10,750 14,788 16,411 17,508 20,715 24,383 (6,800) (6,800) (7,820) (8,160) (75) (6,800) 10,675 7,988 9,611 10,708 12,895 16,223 (3,736) (2,796) (3,364) (3,748) (4,513) (5,678) 6,939 5,193 6,247 6,960 8,382 10,545 To build the pro forma income statement, we begin with Ideko's sales. (Round to the nearest $ 000.) Income Statement ($ 000) Sales Income Statement ($ 000) Direct Labor Costs 2005 Income Statement ($ 000) Gross Profit 75,000 The next items in the income statement detail the cost of goods sold. (Round to the nearest $ 000.) Income Statement ($ 000) Raw Materials The same method can be applied to determine the direct labor costs. (Round to the nearest $ 000.) 2005 (16,000) Income Statement ($ 000) Sales and Marketing 2005 2006 (18,000) Gross profit is calculated next. (Round to the nearest $ 000.) 2005 2006 2005 (11,250) 2006 2007 2006 2006 2007 2007 2008 2007 2007 2008 2008 2009 2008 2008 2009 2009 2009 41,000 Sales, marketing, and administrative costs can be computed directly as a percentage of sales. (Round to the nearest $ 000.) 2010 2009 2010 2010 2010 2010 Income Statement ($ 000) 2005 (13,500) Next, we can project EBITDA over the next five years. (Round to the nearest $ 000.) Administrative Income Statement ($ 000) EBITDA Income Statement ($ 000) EBIT Next, we deduct interest expenses. Income Statement ($ 000) Pretax Income 2005 Income Statement ($ 000) Income Tax 2005 2005 2006 10,675 16,250 Next, we arrive at Ideko's earnings before interest and taxes. (Round to the nearest $ 000.) 2006 2005 (3,736) 2006 10,750 (Round to the nearest $ 000.) 2007 2006 2007 2006 2007 2008 2007 The final expense is the corporate income tax. (Round to the nearest $ 000.) 2008 2007 2008 2008 2009 2008 2009 2009 2009 2009 2010 2010 2010 2010 2010 After income taxes, we are left with Ideko's projected pro forma net income as the bottom line. (Round to the nearest $ 000.) Income Statement ($ 000) Net Income 2005 6,939 2006 2007 2008 2009 2010 Sales Data Market Size (000 units) Market Share Average Sales Price ($/unit) Cost of Goods Data Raw Materials ($/unit) Direct Labor Costs ($/unit) Operating Expense Data Sales and Marketing (% sales) Administrative (% sales) Interest on Term Loan ($ 000) Growth 5% 0.5% 2% 1% 4% 2005 16.0000 18.0000 15.0 2006 18 (75) 10,000 10,500 11,025 11,576.25 10.00% 10.50% 11.00% 11.50% 75.0000 76.5000 78.0300 79.5906 2007 16.1600 16.3216 18.7200 19.4688 16.5 15 (6,800) 18.0 Year 15 (6,800) 2008 16.4848 20.2476 19.5 14 (6,800) 2009 12,155.06 12.00% 81.1824 16.6497 21.0575 20.0 13 (6,800) 2010 12,762.81 12.50% 82.8061 16.8162 21.8998 20.0 13 (6,800) TABLE 19.7 SPREADSHEET Pro Forma Income Statement for Ideko, 2005-2010 Income Statement ($ 000) 1 Sales 2 Cost of Goods Sold 3 Raw Materials 4 Direct Labor Costs 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) 12 Pretax Income 13 Income Tax 14 Net Income Year 2005 75,000 2006 2007 2008 2009 2010 88,358 103,234 119,777 138,149 158,526 (16,000) (18,665) (21,593) (24,808) (28,333) (32,193) (18,000) (21,622) (25,757) (30,471) (35,834) (41,925) 41,000 48,071 55,883 64,498 73,982 84,407 (11,250) (14,579) (18,582) (23,356) (27,630) (31,705) (13,500) (13,254) (15,485) (16,769) (17,959) (20,608) 16,250 20,238 21,816 24,373 28,393 32,094 (5,500) (5,450) (5,405) (6,865) (7,678) (7,710) 10,750 14,788 16,411 17,508 20,715 24,383 (6,800) (6,800) (7,820) (8,160) (75) (6,800) 10,675 7,988 9,611 10,708 12,895 16,223 (3,736) (2,796) (3,364) (3,748) (4,513) (5,678) 6,939 5,193 6,247 6,960 8,382 10,545 To build the pro forma income statement, we begin with Ideko's sales. (Round to the nearest $ 000.) Income Statement ($ 000) Sales Income Statement ($ 000) Direct Labor Costs 2005 Income Statement ($ 000) Gross Profit 75,000 The next items in the income statement detail the cost of goods sold. (Round to the nearest $ 000.) Income Statement ($ 000) Raw Materials The same method can be applied to determine the direct labor costs. (Round to the nearest $ 000.) 2005 (16,000) Income Statement ($ 000) Sales and Marketing 2005 2006 (18,000) Gross profit is calculated next. (Round to the nearest $ 000.) 2005 2006 2005 (11,250) 2006 2007 2006 2006 2007 2007 2008 2007 2007 2008 2008 2009 2008 2008 2009 2009 2009 41,000 Sales, marketing, and administrative costs can be computed directly as a percentage of sales. (Round to the nearest $ 000.) 2010 2009 2010 2010 2010 2010 Income Statement ($ 000) 2005 (13,500) Next, we can project EBITDA over the next five years. (Round to the nearest $ 000.) Administrative Income Statement ($ 000) EBITDA Income Statement ($ 000) EBIT Next, we deduct interest expenses. Income Statement ($ 000) Pretax Income 2005 Income Statement ($ 000) Income Tax 2005 2005 2006 10,675 16,250 Next, we arrive at Ideko's earnings before interest and taxes. (Round to the nearest $ 000.) 2006 2005 (3,736) 2006 10,750 (Round to the nearest $ 000.) 2007 2006 2007 2006 2007 2008 2007 The final expense is the corporate income tax. (Round to the nearest $ 000.) 2008 2007 2008 2008 2009 2008 2009 2009 2009 2009 2010 2010 2010 2010 2010 After income taxes, we are left with Ideko's projected pro forma net income as the bottom line. (Round to the nearest $ 000.) Income Statement ($ 000) Net Income 2005 6,939 2006 2007 2008 2009 2010
Expert Answer:
Answer rating: 100% (QA)
It seems like youre asking for help in filling out a pro forma income statement for Ideko for the years 2006 to 2010 using the data provided in the gr... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Jen and Berry's sells ice-creams from its factory-shop in Petone. There is a managing director (Maynard Dibble), a marketing manager (Mary Salman) and a production manager (Peter Pritchard). Maynard...
-
In this question, you are hired by Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with...
-
Construct a multilevel bill of material for product Z. How many Us are needed to make each Z? How many Ws are needed to make eachZ? Z. (2) (3) (2) (1) (1) (4)
-
A consumer has demand function Can the demand function be used to determine which of the situation (p1, p2, w) = (2, 4, 200) or (p1, p2, w) = (2, 1, 100) is better from the consumer perspective? If...
-
Write a brief essay to explain both the similarities and the differences that exist between hedging and speculation.
-
A fleet of 100 taxis is divided into two groups of 50 cars each to determine whether premium gasoline reduces maintenance costs. Premium unleaded fuel is used in group A, while regular unleaded fuel...
-
(a) As a source of long-term financing, what are the major advantages of bonds over common stock? (b) What are the major disadvantages in using bonds for long-term financing?
-
John, an undocumented immigrant, or alien has been living in the United States for a few years now. John has contacted our office to assist with filing an asylum request. Some key facts to consider...
-
Carrie D'Lake, Reed A. Green, and Doug A. Divot share a passion for golf and decide to go into the golf club manufacturing business together. On January 2, 2015, D'Lake, Green, and Divot form the...
-
Calculate productivity for the private warehouse comparing existing productivity and productivity if robots were leased. Round your answers to two decimal places. 19 20 21 22 # of dedicated pickers...
-
From the results of the 2000 census, the population in Sukarame Village was 4,735 people, consisting of 1,941 people aged 0 - 14 years, 2,431 people aged 15 - 64 years and the rest over 64 years old....
-
1 Given log 3 what is log, 9? 4'
-
Superior Micro Products uses the weighted-average method of process costing. Data for the Assembly Department for May appear below: Work in process, May 1 Cost added during May Equivalent units of...
-
(c) A company enters into a long futures contract to buy 1,000 barrels of oil for $110 per barrel. The initial margin is $12,000 and the maintenance margin is $9000. What oil futures price will allow...
-
1. Marjorie corporations "total" reasonable business needs for 2021 was $320,000. Marjorie corporation accumulated earnings and profits ( E & P) at the beginning of 2021 was $210,000 ( including...
-
Fig. 1-58 shows a rectangular block of mass resting on top of a semi-cylindrical surface. If the block is slightly tipped at one end, find its frequency of oscillation. L Fig. 1-58
-
The following selected information was taken from Sun Valley Citys general fund statement of revenues, expenditures, and changes in fund balance for the year ended December 31, 2019: Revenues:...
-
Many advocates of standard costing take the position that these costs are a proper basis for inventory costing for external reporting purposes. Accounting Research Bulletin No. 43, however, reflects...
-
On January 1, a materials analyst is asked to determine the number of units of Item AZ to be ordered for March delivery. The production schedule calls for 4,800 units of AZ for January operations,...
-
What is indicated by a factory overhead spending variance?
-
Solve Chapter Problem 13.21, assuming the force is narrowband with a power spectral density given by \(S_{F}(\omega)=\frac{3 \times 10^{-3}}{2+5 \omega^{2}}\). Data From Chapter Problem 13.21: A SDOF...
-
Solve Chapter Problem 13.21, assuming the power spectral density is band limited with \(\omega_{1}=50 \mathrm{rad} / \mathrm{s}\) and \(\omega_{2}=200 \mathrm{rad} / \mathrm{s}\). Data From Chapter...
-
Fine Leather Ltd has provided the following production and sales information for each pair of its dress shoes. The fixed costs for the period are \($1\) 125 000. Required (a) Calculate the...
Study smarter with the SolutionInn App