How do I find tot addition costs and incremental sales needed to cover costs? Also did I
Fantastic news! We've Found the answer you've been seeking!
Question:
How do I find tot addition costs and incremental sales needed to cover costs? Also did I calculate theincremental sales correctly?
Transcribed Image Text:
Historic Base Sales Sales Growth Category Growth Rate Incremental Growth Rate Total Sales Growth Rate Gross Margin Marketing and R&D Start-Up Expenses Launch Proj Yr 1 Proj Yr 2 Proj Yr 3 Proj Yr 4 Proj Yr 5 $ 139,500.00 $ 147,870.00 $ 155,263.50 $162,250.36 $168,740.37 $ 175,489.99 4% 4% 4% 4% 4% 2% 156 0.5% 0% 0% 6% 5% 4.50% 4% 4% 69% 69% 69% 69% 69% $ 700.00 Partial case returns net of salvage Label Conversion costs 1800 700 Freight charge/launch year expenses 400 Other miscellaneous 300 3200 New Investment PP&E Cap/Pump molds 1,590 Change parts 260 Pump assembly 570 Depreciable life 6 Table 2: NPV Analysis Initial Investment Incremental sales Incremental COGS Incremental gross profit Start up Proj Yr 1 Proj Yr 2 Proj Yr 3 Proj Yr 4 Proj Yr 5 -2,420 $ 8,370.00 $ $ 2,594.70 $ $ 5,775.30 $ 7,393.50 2,291.99 $ 5,101.52 $ $ 6,986.86 $ 2,165.93 $ 4,820.93 $ 6,490.01 $ 2,011.90 4,478.11 $ 6,749.61 $ 2,092.38 4,657.23 Depreciation $ 403.33 $ 403.33 $ 403.33 $ 403.33 $ 403.33 Marketing and R&D 700.00 Partial case returns net of salvage 1,800.00 - Label conversion costs 700.00 - Freight charge/launch year expenses 400.00 - Other miscellaneous 300.00 Incremental expenses $ 4,303.33 $ 403.33 $ 403.33 $ 403.33 $ 403.33 Cost reduction from new design 119 119 119 119 119 Incremental operating profit Related taxes $ 1,590.97 After tax imact on profits Add Back Depreciation Projected cash flows $ 429.56 1,161.41 $4,817.18 $ 1,300.64 $3,516.54 $ 4,536.60 $4,193.78 $ 1,224.88 3,311.72 $ 4,372.90 1,132.32 3,061.46 $ 1,180.68 3,192.22 $ 403.33 $ -2,420 $ 1,564.74 $ 403.33 $ 3,919.88 $ 403.33 $ 3,715.05 $ 403.33 $ 3,464.79 $ 403.33 3,595.55 NPV IRR $10,705.58 Discount rate: 105% 7% Table 3: Break Even Analysis Total additional costs: intial investment and additional expenses Incremental sales needed to cover costs Historic Base Sales Sales Growth Category Growth Rate Incremental Growth Rate Total Sales Growth Rate Gross Margin Marketing and R&D Start-Up Expenses Launch Proj Yr 1 Proj Yr 2 Proj Yr 3 Proj Yr 4 Proj Yr 5 $ 139,500.00 $ 147,870.00 $ 155,263.50 $162,250.36 $168,740.37 $ 175,489.99 4% 4% 4% 4% 4% 2% 156 0.5% 0% 0% 6% 5% 4.50% 4% 4% 69% 69% 69% 69% 69% $ 700.00 Partial case returns net of salvage Label Conversion costs 1800 700 Freight charge/launch year expenses 400 Other miscellaneous 300 3200 New Investment PP&E Cap/Pump molds 1,590 Change parts 260 Pump assembly 570 Depreciable life 6 Table 2: NPV Analysis Initial Investment Incremental sales Incremental COGS Incremental gross profit Start up Proj Yr 1 Proj Yr 2 Proj Yr 3 Proj Yr 4 Proj Yr 5 -2,420 $ 8,370.00 $ $ 2,594.70 $ $ 5,775.30 $ 7,393.50 2,291.99 $ 5,101.52 $ $ 6,986.86 $ 2,165.93 $ 4,820.93 $ 6,490.01 $ 2,011.90 4,478.11 $ 6,749.61 $ 2,092.38 4,657.23 Depreciation $ 403.33 $ 403.33 $ 403.33 $ 403.33 $ 403.33 Marketing and R&D 700.00 Partial case returns net of salvage 1,800.00 - Label conversion costs 700.00 - Freight charge/launch year expenses 400.00 - Other miscellaneous 300.00 Incremental expenses $ 4,303.33 $ 403.33 $ 403.33 $ 403.33 $ 403.33 Cost reduction from new design 119 119 119 119 119 Incremental operating profit Related taxes $ 1,590.97 After tax imact on profits Add Back Depreciation Projected cash flows $ 429.56 1,161.41 $4,817.18 $ 1,300.64 $3,516.54 $ 4,536.60 $4,193.78 $ 1,224.88 3,311.72 $ 4,372.90 1,132.32 3,061.46 $ 1,180.68 3,192.22 $ 403.33 $ -2,420 $ 1,564.74 $ 403.33 $ 3,919.88 $ 403.33 $ 3,715.05 $ 403.33 $ 3,464.79 $ 403.33 3,595.55 NPV IRR $10,705.58 Discount rate: 105% 7% Table 3: Break Even Analysis Total additional costs: intial investment and additional expenses Incremental sales needed to cover costs
Expert Answer:
Answer rating: 100% (QA)
To perform the NPV analysis and breakeven analysis we need to calculate the following 1 Incremental ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
State whether the data described below are discrete or continuous, and explain why The numbers of eyes that different people have Choose the correct answer below. A. The data are continuous because...
-
CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
In terms of the dielectric constant K, what happens to the electric flux through the Gaussian surface shown in Fig. 24.22 when the dielectric is inserted into the previously empty space between the...
-
The exponential distribution has a characteristic that is called the memory less property. This means P (X > x) = P (X > x + x0 | X > x0). To illustrate this, consider the calls coming into 911....
-
In Exercise 1-2, use determinants to find out if the matrix is invertible? 1. 2. 2 211 035 510
-
At Lofton Manufacturing Company, production workers in the Painting Department ate paid on the basis of productivity. The labor time standard for a unit ol production is established through periodic...
-
Rent With Us Management Inc. has purchased a large housing complex and must decide where to locate its offices and service facilities. The company has learned that locating each service in a...
-
Solve for ?. 175 R 60 degrees 115 degrees 130 degrees 230 degrees Q S 55 A
-
Develop a cost analysis and explain how you arrived at that number for the following scenario. scenario: A guy was placing material in a toolbox, but someone inadvertently struck the lid and cut the...
-
Aloha Company reported the following year-end information: Beginning work in process inventory $2,100,000 Beginning raw materials inventory 1,000,000 Ending work in process inventory 1,300,000 Ending...
-
14) A certain boat displaces a volume of 8.3 m of water. (The density of water is 1000 kg/m.) What is the mass of the water displaced by the boat? What is the buoyant force acting on the boat
-
Susie is a 55-year old woman, 64 in.tall, and 150lbs. After performing a PFT, her values were asfollows: FVC = 2.8 L, BTPS and FEV 1.0 =2.0 L, BTPS. Wereher values normal? Provide evidence for why or...
-
You've just eaten a Big Mac (two all beef patties, special sauce, lettuce, cheese, pickles, onions on a sesame seed bun).Explain which components will be hydrolyzed by each organ of the alimentary...
-
How would advocates of the Taylor Rule or Monetarism probably feel about the Fed's policy moves during the terms of Fed Chairs Bernanke, Yellen, and Powell? What is currency manipulation? Why would a...
-
QS 10-11 (Static) Straight-Line: Premium bond computations LO P3 Enviro Company Issues 8%, 10-year bonds with a par value of $250,000 and semiannual interest payments. On the issue date, the annual...
-
Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment...
-
Alia Khan Robotics Inc. has been in operation for 3 years. All of its manufacturing equipment, which has a useful life of 10 to 12 years, has been depreciated on a straight-line basis. During the...
-
Distinguish among the following bases ol comparison: intracompany, industry averages, and intercompany (b) Give the principal value of using each of the three bases of comparison.
-
(a) Josh Avers believes that the analysis ol linancial statements is directed at two characteristics of a company: liquidity and probability. Is Josh collect? Explain, (b) Are short-term creditors,...
Study smarter with the SolutionInn App