Question

The production line produces a product which currently has annual sales of $1,000,000 and has a contribution to the business beyond ingredients of $500,000. Your line is currently operating at full standard capacity. You are putting in new equipment which will make the line more efficient and last for 10 years. The equipment will increase the capacity of the line by 30%. - so, add capability to produce $300,000 more per year   and will eliminate 3 positions of manual labor when fully operational the second year. A manual position of labor costs $30000 per year with benefits. A 6-month supply of ingredients is always kept. It is expected that the learning curve will result in zero increased capacity in year 1 but the full 30% in year 2   . The equipment will costs $600000 engineering and installation will cost $100000. Sales will grow at a rate so all production can be sold. Advertising and promotion to get that growth will cost $50,000 per year. The company has a WACC of 15% but uses a hurdle rate of 18% for projects of this risk type.                   OUTLINE THE CASH FLOWS IN THE CHART BELOW - please note some cash flows are positive and some are negative - you will need to make sure they sum appropriately                                                                 EVALUATE THE INVESTMENT WITH PAYBACK, IRR and NPV

CASH FLOW CALCULATIONS:                                               

Capacity of new line, sales growth, additional ingredients, additional advertising, savings from eliminating manual positions, increase in income before taxes, Depreciation, Estimated taxes at 35%, increase in income after taxes + depreciation, additional inventory, cost of equipment, cost of installation, and Net Cash Flow.

Answer 1

Cashflow	1	2	3	4	5	6	7	8	9	10	Comment
Sales	1,000,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000
Less - Ingredient Cost*	500,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000
Less -Labour Cost	90,000	-	-	-	-	-	-	-	-	-	30000*3
Less - Advertising	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000
Less - Taxes	101,500	185,500	185,500	185,500	185,500	185,500	185,500	185,500	185,500	185,500
Less - Instrument Cost	700,000	-	-	-	-	-	-	-	-	-
Less - WC (extra inventory)	250,000	325,000	325,000	325,000	325,000	325,000	325,000	325,000	325,000	325,000
Net Cashflow	(691,500)	89,500	89,500	89,500	89,500	89,500	89,500	89,500	89,500	89,500
*Assumed to be same rate as yr 1

PnL (Taxes computation)	1	2	3	4	5	6	7	8	9	10	Comment
Sales	1,000,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000	1,300,000
Less - Ingredient Cost	500,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000
Gross Margin	500,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000	650,000
Less -Labour Cost	90,000	-	-	-	-	-	-	-	-	-	30000*3
Less - Advertising	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000	50,000
Net Margin	360,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000	600,000
less - Instrument Dep*	70,000	70,000	70,000	70,000	70,000	70,000	70,000	70,000	70,000	70,000
Profit before tax	290,000	jeff jeffy Next > < Previous Related Solutions Chibucos Company has two products: A and B. The annual production and sales level of Product... Chibucos Company has two products: A and B. The annual production and sales level of Product A is 9,094 units. The annual production and sales level of Product B is 15,826. The company uses activity-based costing and has prepared the following analysis showing the estimated total cost and expected activity for each of its three activity cost pools 28. A potential investor is seeking to invest $1,000,000 in a venture, which currently has 1,000,000... 28. A potential investor is seeking to invest $1,000,000 in a venture, which currently has 1,000,000 shares held by its founders, and is targeting a 40% return five years from now. The venture is expected to produce half a million dollars in income per year at year 5. It is known that a similar venture recently produced $1,000,000 in income and sold shares to the public for $20,000,000. What is the percent ownership of our venture that must be sold... 8. Campbell Computing Inc. currently has sales of $1,000,000, and its days sales outstanding is 30... 8. Campbell Computing Inc. currently has sales of $1,000,000, and its days sales outstanding is 30 days. The financial manager estimates that offering longer credit terms would (1) increase the days sales outstanding to 50 days and (2) increase sales to $1,200,000. However, bad debt losses, which were 2 percent on the old sales, would amount to 5 percent on the incremental sales only (bad debts on the old sales would stay at 2 percent). Variable costs are 80 percent... Geoffrey’s Toy Box currently has sales of $1,000,000, and its days sales outstanding is 30 days.... Geoffrey’s Toy Box currently has sales of $1,000,000, and its days sales outstanding is 30 days. The new CFO estimates that offering longer credit terms would (1) increase the days sales outstanding to 50 days and (2) increase sales to $1,200,000. However, bad debt losses, which were 2 percent on the old sales, would increase to 5 percent on the incremental sales while bad debts on the old sales would stay at 2 percent. Variable costs are 80 percent of... Geoffrey’s Toy Box currently has sales of $1,000,000, and its days sales outstanding is 30 days.... Geoffrey’s Toy Box currently has sales of $1,000,000, and its days sales outstanding is 30 days. The new CFO estimates that offering longer credit terms would (1) increase the days sales outstanding to 50 days and (2) increase sales to $1,200,000. However, bad debt losses, which were 2 percent on the old sales, would increase to 5 percent on the incremental sales while bad debts on the old sales would stay at 2 percent. Variable costs are 80 percent of... Your corporation is considering investing in a new product line. The annual revenues (sales) for the... Your corporation is considering investing in a new product line. The annual revenues (sales) for the new product line are expected to be $132,767.00 with variable costs equal to 50% of these sales. In addition annual fixed costs associated with this new product line are expected to be $68,969.00 . The old equipment currently has no market value. The new equipment cost $51,167.00 . The new equipment will be depreciated to zero using straight-line depreciation for the three-year life of... Your corporation is considering investing in a new product line. The annual revenues (sales) for the... Your corporation is considering investing in a new product line. The annual revenues (sales) for the new product line are expected to be $235,990.00 with variable costs equal to 50% of these sales. In addition annual fixed costs associated with this new product line are expected to be $67,829.00 . The old equipment currently has no market value. The new equipment cost $57,941.00 . The new equipment will be depreciated to zero using straight-line depreciation for the three-year life of... Your corporation is considering investing in a new product line. The annual revenues (sales) for the... Your corporation is considering investing in a new product line. The annual revenues (sales) for the new product line are expected to be $356,811.00 with variable costs equal to 50% of these sales. In addition annual fixed costs associated with this new product line are expected to be $59,415.00 . The old equipment currently has no market value. The new equipment cost $74,013.00 . The new equipment will be depreciated to zero using straight-line depreciation for the three-year life of... Your corporation is considering investing in a new product line. The annual revenues (sales) for the... Your corporation is considering investing in a new product line. The annual revenues (sales) for the new product line are expected to be $356,811.00 with variable costs equal to 50% of these sales. In addition annual fixed costs associated with this new product line are expected to be $59,415.00 . The old equipment currently has no market value. The new equipment cost $74,013.00 . The new equipment will be depreciated to zero using straight-line depreciation for the three-year life of... Your corporation is considering investing in a new product line. The annual revenues (sales) for the... Your corporation is considering investing in a new product line. The annual revenues (sales) for the new product line are expected to be $111,755.00 with variable costs equal to 50% of these sales. In addition annual fixed costs associated with this new product line are expected to be $50,141.00 . The old equipment currently has no market value. The new equipment cost $82,433.00 . The new equipment will be depreciated to zero using straight-line depreciation for the three-year life of... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Dr C #1 An object with mass = 5 kg is oscillating on the end of... Calculate the value of a bond that matures in 13 years and has a $1,000 par... The documentary Gender Revolution implies that gender today—gender identities and categories—are vastly different today than they... 12. What is the payment in month 13 on a CAM loan for $250,000 with a... Which of the following is true of variable costing? It expenses administrative costs as costs of... Individual Age Gender (Male=1) Family Size Cigarettes/Day Alcohol/Day Total Claims 1 25 1 2 0 3... Festus and Fran have decided to buy a house. The purchase price is $175,000. They have... ADVERTISEMENT About @ 2020 WizEdu