Question

In: Finance

A juice manufacturer conducted a marketing study three years ago to determine the consumers’ preferences for...

A juice manufacturer conducted a marketing study three years ago to determine the consumers’ preferences for different type of juices including organic juices. This study was very extensive and detrimental in their decision to start a new organic juice division today. It cost them $1,000,000 to perform this study.

The company is considering introducing organic juices. The company will add a new assembly line in order to produce the organic juices separate from their existing assembly line for regular non-organic juices.

The project has an anticipated life of 4 years.

The new assembly line has a cost of $1,500,000. It will require $500,000 to customize it to the new specifications for organic juice production, and $100,000 for transportation and shipping to the company’s plant.

The new machine falls into 5-years MACRS category (20%, 32%, 19.2%, 11.52%, 11.52% and 5.76%).

The organic juice production will require inventories to increase by $1,000,000 at time 0; in addition, accounts payables and accruals will increase by $450,000 and $150,000 respectively.

The organic juice is expected to generate sales revenue of $700,000 million the first year. The revenue is expected to increase by $300,000 every year. Each year the operating costs (excluding depreciation) are expected to equal 50 percent of sales revenue.

In order to do this expansion, the company will borrow $3 million. The annual interest expense on this borrowing $400,000.

The organic juice is expected to decrease the company’s existing non-organic juice sale by $350,000 per year before tax basis.

The company can sell the new machine at the end of 4 years for $50,000 in the market. The company’s cost of capital is 12 percent. The company’s tax rate is 40 percent.

What is the initial investment CF0?

What is the CF1 to be used in NPV calculations?

What is the non-operating cash flow for year 4?

What is cash flow 4 to be used in NPV calculations?

What is the NPV of the project?

Solutions

Expert Solution

Answer 1 Working
Calculation of initial investment CF0 Depreciation calculation
CF0 Year Depreciable value of assembly line Depreciation rate Depreciation Book value
Cost of new assembly line -$1,500,000.00 1 2100000 20% 420000 1680000
Assembly line customization cost -$500,000.00 2 2100000 32% 672000 1008000
Transportation and shipping cost -$100,000.00 3 2100000 19.20% 403200 604800
Increase in Inventories -$1,000,000.00 4 2100000 11.52% 241920 362880
Increase in accounts payable $450,000.00 5 2100000 11.52% 241920 120960
Increase in accruals $150,000.00 6 2100000 5.76% 120960 0
Initial Investment -$2,500,000.00
Answer 2
Calculation of cash flow for Year 1 CF1
CF1
Sales revenue (less decrease in non organic juice sale ) 350000
Less : Operating cost 350000
less : Interest expense 400000
less : Depreciation 420000
Profit before tax -820000
Less : Tax @ 40% -328000
Profit after tax -492000
Add : Depreciation 420000
Cash flow For Year 1 -72000
Answer 3
Non operating cash flow for Year 4
Sale value of plant 50000
Less : Book value of plant at the end of 4th year 362880
Loss on sale -312880
Tax shield on Loss @ 40% 125152
Non operating cash flow for Year 4 (Sale value + Tax shield) 175152
Answer 4
Calculation of cash flow for Year 4 CF4
CF4
Sales revenue 1250000
Less : Operating cost 800000
less : Interest expense 400000
less : Depreciation 241920
Profit before tax -191920
Less : Tax @ 40% -76768
Profit after tax -115152
Add : Depreciation 241920
Add : Non operating cash flow 175152
Add : Recovery of net working capital 400000
Cash flow For Year 4 701920
Answer 5
Calculation of NPV
Year Discount factor @ 12% Cash flow Present Value
0 1 -$2,500,000.00 -$2,500,000.00
1 0.892857143 -$72,000.00 -$64,285.71
2 0.797193878 $118,800.00 $94,706.63
3 0.711780248 $101,280.00 $72,089.10
4 0.635518078 $701,920.00 $446,082.85
NPV -$1,951,407.13
Working
Calculation of cash flow for Year 2 & 3
CF2 CF3
Sales revenue (less decrease in non organic juice sale ) 650000 950000
Less : Operating cost 500000 650000
less : Interest expense 400000 400000
less : Depreciation 672000 403200
Profit before tax -922000 -503200
Less : Tax @ 40% -368800 -201280
Profit after tax -553200 -301920
Add : Depreciation 672000 403200
Cash flow For Year 1 118800 101280

Related Solutions

A company manufactures fitness equipment. Two years ago, it conducted a marketing study to collect consumers’...
A company manufactures fitness equipment. Two years ago, it conducted a marketing study to collect consumers’ views and perception about a new fitness equipment that they intend to produce. The study cost them $1,000,000. Today, the company is considering introducing a new fitness equipment. The CFO has collected the following information about the proposed product. The project has an anticipated economic life of 4 years, after that it will not be continued and will be terminated. The company will have...
Several years ago, researchers conducted a study to determine whether the "accepted" value for normal body...
Several years ago, researchers conducted a study to determine whether the "accepted" value for normal body temperature, 98.6oF, is accurate. They used an oral thermometer to measure the temperatures of a random sample of healthy men and women aged 18 to 40. As is often the case, the researchers did not provide their original data. Allen Shoemaker, from Calvin College, produced a data set with the same properties as the original temperature readings. His data set consists of one oral...
In a study conducted by WOMMA (Word of Mouth Marketing Association), 81% of consumers are influenced...
In a study conducted by WOMMA (Word of Mouth Marketing Association), 81% of consumers are influenced by a friend's social media posts. Their research also revealed that the average American mentions a brand some sixty times a week in online and offline conversations. How powerful and influential is social media word-of-mouth to a brand or a public figure? Find an example of where social word-of-mouth has made or broken an organization and an example where it has changed government or...
ARG Inc, is a manufacturer of dairy products that was formed three years ago by three...
ARG Inc, is a manufacturer of dairy products that was formed three years ago by three sisters who, as directors, retain sole ownership of its ordinary share capital. One-third of the initial share capital was provided by each sister. However, the company has managed to return a profit in each year of operation as shown in the financial statements. ARG Inc. has an overdraft limit of $3.2 million and pays interest on its overdraft at a rate of 6 percent...
A study conducted a few years ago claims that the adult males spend an average of...
A study conducted a few years ago claims that the adult males spend an average of 11 hours a week watching sports on television. A recent sample of 100 adult males showed that the mean time they spend per week watching sports on television is 9.50 hours with a standard deviation of 2.2 hours. a. Use the result to give a 95% confidence interval for the mean time they spend per week watching sports on television. b. Does the study...
A study was conducted to determine if students in different college years differ on the number...
A study was conducted to determine if students in different college years differ on the number of hours of sleep they obtain. On a specified mid-semester Wednesday morning 25 Freshmen, 25 Sophomore, 25 Junior and 25 Senior college students reported the number of Hours of Sleep they had obtained on the previous evening. Answer the following question referring to the following tables. Descriptive Statistics Year Mean Std. Deviation N Freshmen 7.7080 1.86881 25 sophomore 7.1600 1.34412 25 Junior 7.4400 1.47422...
7. A study conducted a few years ago claims that the adult males spend an average...
7. A study conducted a few years ago claims that the adult males spend an average of 11 hours a week watching sports on television. A recent sample of 100 adult males showed that the mean time they spend per week watching sports on television is 9.50 hours with a standard deviation of 2.2 hours. a. Use the result to give a 95% confidence interval for the mean time they spend per week watching sports on television. a. Does the...
A study was conducted to determine if there is a difference between the investing preferences of midlevel managers in the public and private sectors in New York City.
A study was conducted to determine if there is a difference between the investing preferences of midlevel managers in the public and private sectors in New York City. A random sample of 320 public-sector employees and 380 private-sector employees was taken. The sampled participants were then asked about their retirement investment decisions and classified as being either “aggressive,” if they invested only in stocks or stock mutual funds, or “balanced” if they invested in some combination of stocks, bonds, cash,...
A study conducted several years ago reported that 24 percent of public accountants changed companies within...
A study conducted several years ago reported that 24 percent of public accountants changed companies within 4 years. The American Institute of CPAs would like to update the study. They would like to estimate the population proportion of public accountants who changed companies within 4 years with a margin of error of 4% and a 95% level of confidence. (Round your z value to 3 decimals. Round up your answers to the next whole number.) a. To update this study,...
GfK, a European custom marketing research company, conducted a two-year, two-part study to determine the new...
GfK, a European custom marketing research company, conducted a two-year, two-part study to determine the new trends in European youth and culture—what matters to European teenagers, and lows international marketers should approach them. Exploratory research form of focus groups watt conducted first to identify issues that are salient to European youths the issues in focus groups were quantified by conducting a descriptive longitudinal survey. The survey was conducted in two parts spanning 16 different European countries, including Denmark, Norway, Sweden,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT