Question

In: Finance

In 1997 Michelle Green started Green-Log Manufacturing, a company dedicated to manufacturing environmental friendly man made...

In 1997 Michelle Green started Green-Log Manufacturing, a company dedicated to manufacturing environmental friendly man made logs that can be burned in fire places, fire pits in the backyard, and when camping. The logs are made from environmental friendly products like cardboard and clean wax and emit fewer greenhouse gases and less harsh chemicals. The logs come in three pound and five pound sizes. Green-logs are also available with citronella to ward off mosquitos. The Green-Logs have been well received. Revenue and profits have grown steadily.

Based on the recommendation from her sales and marketing department Ms. Green is considering adding a new product line of Green-Log fire starters. These fire starters would be ideal for the outdoor market of camping, fishing, backpacking, and tailgating. Ms. Green has asked her sales and marketing team to come up with a sales forecast for units and pricing. She has also asked her manufacturing team to come up with alternatives for the production of the fire starters including what equipment is needed and what the projected costs would be.

The sales and marketing team hired Smith and Smith Consulting to conduct a market survey. The total cost for this consulting was $32,500. Based on the survey and their own experience the sales and marketing has provided a sales forecast. The suggested price of the fire starter is $2.50 per starter and they would be sold as a four pack for $10.00. The unit sales forecast is 20,000 4-packs in year 1, 45,000 in year 2, 60,000 in year 3, 75,000 in year 4, and then increasing by 5,000 each year thereafter. Sales and marketing expenses are expected to be 10% of total revenue.

The production team forecasts that the fixed costs needed for the fire starter production line will be $90,000 per year. Variable costs for materials (cardboard, wood shavings, wax, packaging, etc.) will be $0.85 per unit or $3.40 per four pack. The labor and maintenance costs will vary based on what equipment will be purchased.

There are two brands of equipment that will do the job; The ABC brand and the XYZ brand. The ABC brand is more expensive, but higher quality and more efficient. It will cost $525,000 plus an additional $30,000 for shipping and installation. The equipment would be depreciated to zero over 5 years using straight line depreciation. It is expected that the equipment would last for 8 years and would be sold then for $55,000. Maintenance of the ABC equipment would cost $5,000 per year but every 3 years the equipment would need an overhaul that would increase the cost to $75,000 for that year. Since the ABC equipment is more efficient the variable labor cost would be $0.60 per four pack.

The XYZ brand is less expensive. It will cost $395,000 plus an additional $40,000 for shipping and installation. The equipment would be depreciated to zero over 5 years using straight line depreciation. It is expected that the equipment would last for 8 years and would be sold then for $35,000. Maintenance of the ABC equipment would cost $10,000 per year but every 3 years the equipment would need an overhaul that would increase the cost to $85,000 for that year. The variable labor cost with the XYZ brand equipment would be $0.80 per four pack. The increase in working capital (accounts receivable and inventory) is expected to be $60,000 at the beginning of the project and will be the same for both machines. The company’s cost of capital is 14% and its tax rate is 40%. Since her production team believes that both brands of equipment will last for eight years Michelle wants this analyzed as an eight year project.

Michelle has always believed in buying quality so she is leaning towards the ABC brand equipment. But after hearing that you have learned about capital budgeting in your Finance class at UVU she wants to take advantage of your expertise. Michelle has asked you to analyze her choices and give her some advice on which option would provide the best financial outcome for Green-Log Manufacturing.

Prepare an analysis and professional report for Michelle. The report should be professionally written and include a two page letter, plus attached schedules. The letter should explain what analytical techniques you are using, why you are using those techniques, what the results show, what you would recommend to Michelle and why. Make sure that the letter is well organized and professionally written. Also make sure that the letter includes the following:

1. The cash flows associated with the different equipment brands for each year of the project.

2. The PB period, Discounted PB, IRR, and NPV for the two alternatives.

3. Your recommendation of which brand of equipment should be purchased.

4. Attach to your letter schedules that show your analysis and your work. Please submit files. A Word file with your letter and an Excel file with your analysis.

Solutions

Expert Solution

Present value of Cash flow=(Cash flow)/((1+i)^N)
i=discount rate=cot of capital=14%=0.14
N=year of Cash Flow
ANALYSIS OF CASH FLOW FOR ABC BRAND
Cost of consulting $32,500is a sunkcost and not relevant for this analysis
Initial Cash Flow:
Cost of machine $525,000
Shipping and installation $30,000
Total Initial outlay $555,000
After tax Salvage Value $33,000 55000*(1-0.4)
Annual Cash Flow:
N Year 1 2 3 4 5 6 7 8
a Sales in Units(Machine ABC)             20,000 45000 60000 75000 80000 85000 90000 95000
b=a*$10 Sales Revenue $200,000 $450,000 $600,000 $750,000 $800,000 $850,000 $900,000 $950,000
ANALYSIS OF CASH FLOW FOR XYZ BRAND
Cost of consulting $32,500is a sunkcost and not relevant for this analysis
Initial Cash Flow:
Cost of machine $395,000
Shipping and installation $40,000
Total Initial outlay $435,000
After tax Salvage Value $21,000 35000*(1-0.4)
Annual Cash Flow:
N Year 1 2 3 4 5 6 7 8
a Sales in Units(Machine XYZ)             20,000 45000 60000 75000 80000 85000 90000 95000
b=a*$10 Sales Revenue $200,000 $450,000 $600,000 $750,000 $800,000 $850,000 $900,000 $950,000
PB(years) Discounted PB(years) IRR NPV
Equipment ABC 4.21 6.23 20.40% $156,956
Equipment XYZ 4.02 5.59 23.23% $188,089
Equipment XYZ should be selected
It has higher NPV and higher IRR

Related Solutions

In 1997 Michelle Green started Green-Log Manufacturing, a company dedicated to manufacturing environmental friendly man made...
In 1997 Michelle Green started Green-Log Manufacturing, a company dedicated to manufacturing environmental friendly man made logs that can be burned in fire places, fire pits in the backyard, and when camping. The logs are made from environmental friendly products like cardboard and clean wax and emit fewer greenhouse gases and less harsh chemicals. The logs come in three pound and five pound sizes. Green-logs are also available with citronella to ward off mosquitos. The Green-Logs have been well received....
PLEASE SHOW WORK IN EXCEL THANK YOU! Green-Log Manufacturing Capital Budgeting Analysis In 1997 Michelle Green...
PLEASE SHOW WORK IN EXCEL THANK YOU! Green-Log Manufacturing Capital Budgeting Analysis In 1997 Michelle Green started Green-Log Manufacturing, a company dedicated to manufacturing environmental friendly man made logs that can be burned in fire places, fire pits in the backyard, and when camping. The logs are made from environmental friendly products like cardboard and clean wax and emit fewer greenhouse gases and less harsh chemicals. The logs come in three pound and five pound sizes. Green-logs are also available...
In 2004 David Lee started Lee Manufacturing, a company dedicated to manufacturing simple yet efficient gas...
In 2004 David Lee started Lee Manufacturing, a company dedicated to manufacturing simple yet efficient gas barbecues. The barbecues are made of aluminum and stainless steel and are priced at the middle of the market. David’s goal has always been to make a barbecue that cooks great food. This means, good quality parts, simple construction, even heat, no hot or cold spots, and a barbecue that will hold temperature from the lowest setting to the highest setting. David’s motto is...
St Lucia Green Ltd. is a company that makes eco-friendly products. It is expected that the...
St Lucia Green Ltd. is a company that makes eco-friendly products. It is expected that the company will achieve an EPS of AUD 10 next year. The company’s current payout ratio is 40%. The required rate of return is 17%. Its return on equity is 23%. a) What is the share price of St Lucia Green Ltd. if it does not pursue a growth strategy? b) Suppose St Lucia Green now has a plan to pursue a growth strategy. Calculate...
St Lucia Green Ltd. is a company that makes eco-friendly products. It is expected that the...
St Lucia Green Ltd. is a company that makes eco-friendly products. It is expected that the company will achieve an EPS of AUD 10 next year. The company’s current payout ratio is 40%. The required rate of return is 17%. Its return on equity is 23%. a) What is the share price of St Lucia Green Ltd. if it does not pursue a growth strategy? b) Suppose St Lucia Green now has a plan to pursue a growth strategy. Calculate...
Case One: Green Machine, Inc. Green Machine, Inc., a company devoted to producing eco-friendly household products,...
Case One: Green Machine, Inc. Green Machine, Inc., a company devoted to producing eco-friendly household products, is a wholly owned subsidiary of Colossal Corporation. Green Machine's most famous and best-selling product is the Eco-Widget—a handheld, solar-powered device that recharges a variety of electronics on the go, including cell phones, laptops, and tablets. Colossal Corporation has uncovered an incident of theft at Green Machine: Approximately one month ago, over 400 Eco-Widgets were stolen from Green Machine's Adelphi, Maryland warehouse. Shortly after...
Case One: Green Machine, Inc. Green Machine, Inc., a company devoted to producing eco-friendly household products,...
Case One: Green Machine, Inc. Green Machine, Inc., a company devoted to producing eco-friendly household products, is a wholly owned subsidiary of Colossal Corporation. Green Machine's most famous and best-selling product is the Eco-Widget—a handheld, solar-powered device that recharges a variety of electronics on the go, including cell phones, laptops, and tablets. Colossal Corporation has uncovered an incident of theft at Green Machine: Approximately one month ago, over 400 Eco-Widgets were stolen from Green Machine's Adelphi, Maryland warehouse. Shortly after...
You are the environmental specialist for a company that has just purchased a property and started...
You are the environmental specialist for a company that has just purchased a property and started construction of a home office. During excavation you find that the site is part of an inactive landfill. Testing of soil samples shows that vinyl chloride, a hazardous waste, is present in concentrations that exceed regulatory standards. What is your next action? If the remediation of the problem is very costly, will you seek participation by other parties? If so, why?
8) Environmental Sustainability: Currently, about 97% of scientists agree that we are experiencing man-made global warming....
8) Environmental Sustainability: Currently, about 97% of scientists agree that we are experiencing man-made global warming. Yet policy makers continue to ignore climatological science. For example in May 2018, Representative Mo Brooks (R-AL) suggested during a Congressional hearing that rocks falling into the ocean might account for the rise in ocean levels (USA Today, 05-17-18; an analysis by The Washington Post found that it would take the top five inches of all land surface flowing into the ocean every year...
Munoz Manufacturing Company was started on January 1, 2018. The company was affected by the following...
Munoz Manufacturing Company was started on January 1, 2018. The company was affected by the following events during its first year of operation: Acquired $1,700 cash from the issue of common stock. Paid $540 cash for direct raw materials. Transferred $420 of direct raw materials to work in process. Paid production employees $650 cash. Paid $370 cash for manufacturing overhead costs. Applied $220 of manufacturing overhead costs to work in process. Completed work on products that cost $1,070. Sold products...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT