Question

In: Accounting

"Randy’s" an ice-cream manufacturer is planning to invest in anew product called "strawberry mint ice-cream...

"Randy’s" an ice-cream manufacturer is planning to invest in a new product called "strawberry mint ice-cream ", which will include real strawberries. To manufacture the product, Randy’s will have to buy a strawberries processor machine. In addition, since the old ice-cream machine of the company broke down it has to replace it with a new one. Below is the purchasing information about the two machines:

- A strawberries processor machine: The machine costs $500,000 and is depreciated in a straight line over 4 years. This machine has a salvage value of $30,000.

- A new ice-cream machine: The machine costs $850,000 and is depreciated in a straight line over 5 years. This machine has a scrap (salvage) value of $200,000.

Other information:

 The strawberry mint ice-cream project's estimated lifecycle is 5 years.

 Randy’s estimates that in the first year the Product will have revenues of $1 million, and then revenues are expected to increase by 12% annually.

 Production costs are expected to be 60% of the revenues.

 Marketing costs are expected to be 30% of the revenues in the first year and then after 10% of the revenues in the following years.

 At the end of year 5 Randy’s estimates that it will be able to sell the strawberries process machine for $120,000. The ice-cream machine will worth 0 and therefore will not be sold.

 During the last 5 years, Randy’s has spent $20,000 in the development of the strawberry mint ice cream.

 To support the project, Randy’s will need to invest in working capital. The company will need to invest at the beginning of each year in inventory 10% of the expected revenues in the following year, in accounts receivables 25% of the current year’s revenues. Accounts payable will amount to 15% of the cost of goods sold at the beginning of each year. All the working capital will be recovered at the end of the project in 5 years.

 Randy’s corporate tax is 25% and Capital gain tax is 20%.

 Randy’s cost of capital is 13%.

Should Randy’s undertake the project?









































































































































Solutions

Expert Solution

Note:- All figures are given as at year end, all inflows and profits are assumed to occur at year end.

Based on the given figures and requirements, the working capital requirements are:-

Year 0 1 2 3 4 5
Inventory Investment (10% of Next to next year Revenue) $          112,000 $            125,440 $          140,493 $          157,352 $                      -   $                   -  
Accounts Receivable (25% of Next year Revenue) $          250,000 $            280,000 $          313,600 $          351,232 $          393,380 $                   -  
Accounts Payable (15% of Next year Production Costs) $          (90,000) $          (100,800) $        (112,896) $        (126,444) $        (141,617) $                   -  
Net Working Capital Required $          272,000 $            304,640 $          341,197 $          382,140 $          251,763 $                   -  
Year 0 1 2 3 4 5
Revenue $         1,000,000 $      1,120,000 $      1,254,400 $      1,404,928 $    1,573,519
Less:- Production Costs (60% of Revenue) $          (600,000) $        (672,000) $        (752,640) $        (842,957) $     (944,112)
Less:- Marketing Costs $          (300,000) $        (112,000) $        (125,440) $        (140,493) $     (157,352)
Less:- Depreciation (500,000-30,000)/4 $          (117,500) $        (117,500) $        (117,500) $        (117,500)
Net Income before Tax $            (17,500) $          218,500 $          258,820 $          303,978 $        472,056
Less:- Corporate Tax @ 25% $                 4,375 $          (54,625) $          (64,705) $          (75,995) $     (118,014)
Net Income after Tax $            (13,125) $          163,875 $          194,115 $          227,984 $        354,042
Add:- Depreciation $            117,500 $          117,500 $          117,500 $          117,500 $                   -  
(A) Net Operating Cash Income $            104,375 $          281,375 $          311,615 $          345,484 $        354,042
(B) Proceeds from strawberries process machine(net of Tax) $        102,000
(C) Investment in Working Capital $       (272,000) $            (32,640) $          (36,557) $          (40,944) $          130,377 $        251,763
(D) Purchase of Strawberries process machine $       (500,000)
Total Cash Flows (A+B+C+D) $       (772,000) $               71,735 $          244,818 $          270,671 $          475,861 $        707,805
PV Factor @ 13% 1.000 0.885 0.783 0.693 0.613 0.543
PV of Cash Flows $       (772,000) $               63,482 $          191,729 $          187,589 $          291,855 $        384,168
Net Present Value $          346,822

Since the Net Present Value is positive, Randy should undertake this project.

Important Notes:-

1. Tax on Sale of Strawberries process machine = (120,000 - 30,000) * 20% = $18,000 . Hence, sale proceeds net of tax = $120,000 - $18,000 = $102,000

2. All figures except PV factors have been rounded off to whole numbers, alternate approach may be taken by using exact decimals.

3. Old ice-cream machine of the company broke down and had to be replaced in either case even if the Strawberry project was dropped, hence this cost is irreleveant for our project considerations. Similarly Development costs are obsolete and not relevant as these are sunk costs.


Related Solutions

At an ice cream store, there are 6 flavors of ice cream: banana, strawberry, vanilla, mint,...
At an ice cream store, there are 6 flavors of ice cream: banana, strawberry, vanilla, mint, chocolate and raspberry. How many different 2- flavor ice cream cones can be made? (5 points) Steve has 6 pants and 7 shirts in his closet. He wants to wear a different pant/shirt combination each day without buying new cloths for as long as he can. How many weeks can he do this for? (5 points)
Casper Ice Cream The Casper Ice Cream Company is an ice cream manufacturer in Richmond, Utah...
Casper Ice Cream The Casper Ice Cream Company is an ice cream manufacturer in Richmond, Utah famous for making Fat Boy Ice Cream Sandwiches. The owner, Mr. Casper, the grandson of the founder, is considering replacing an existing ice cream maker and batch freezer with a new maker which has a greater output capacity and operates with less labor. His only alternative is to overhaul his ice cream maker and batch freezer which have a current net book value of...
A survey determines that mint chocolate chip is the favorite ice cream flavor of 6% of...
A survey determines that mint chocolate chip is the favorite ice cream flavor of 6% of consumers. An ice cream shop determines that of 190 customers, 15 customers stated their preference for mint chocolate chip. Find the P-value that would be used to determine if the percentage of customers who prefer mint chocolate chip ice has increased at a 5% level of significance. P-value: __________ Round your answer to four decimal places as necessary.
Irene operates an ice cream store called Ice Queen Irene’s Ice Cream Dream, Incorporated. Irene is...
Irene operates an ice cream store called Ice Queen Irene’s Ice Cream Dream, Incorporated. Irene is the sole owner and shareholder. The company has been in operation for a few years now, so much that Irene has been able to hire employees and pay herself a salary of $150, 000 per year for being the President, CEO and Operations Manager of the company. From sourcing more affordable products, to keeping up to date with the industries latest gadgets for efficiency,...
Profit Planning Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady...
Profit Planning Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker Direct labor $ 21.00 Direct materials 25.50 Variable overhead 10.50 Total variable...
There are 10 ice creams. There are strawberry, coconut, matcha, and melon flavor. Suppose that each ice cream of the same flavor is indistinguishable from another.
  There are 10 ice creams. There are strawberry, coconut, matcha, and melon flavor. Suppose that each ice cream of the same flavor is indistinguishable from another. a. How many combinations are there such that there is at least 2 strawberry and at most 2 coconut ice cream? b. How many combinations are there such that there is at least 2 strawberry, at most 2 coconut ice cream, and at least 1 matcha if someone 3 ice creams. (Hint: There...
Imagine that you have decided to open a small ice cream stand on campus called "Ice-Campusades."...
Imagine that you have decided to open a small ice cream stand on campus called "Ice-Campusades." You are very excited because you love ice cream (delicious!) and this is a fun way for you to apply your business and economics skills! Here is the first month's scenario--you order the same number (and the same variety) of ice creams each day from the ice cream suppliers, and your ice creams are always marked at $1.50 each. However, you notice that there...
If Joe (a business taxpayer) acquires ice cream from the manufacturer for $330, and later sells...
If Joe (a business taxpayer) acquires ice cream from the manufacturer for $330, and later sells the ice cream to customers for $550, calculate the net GST payable or refundable. (Note: You do not have to refer to law, but must briefly explain your calculations)
Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...
Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker Direct labor $ 13.50 Direct materials 14.50 Variable overhead 6.00 Total variable costs $...
Connelly, Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...
Connelly, Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Since her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker      Direct labor $ 13.50      Direct materials 14.50      Variable overhead 6.00   Total variable costs $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT