Question

In: Economics

An olive oil factory requires a fixed capital investment of $3,000,000 and a working capital of...

An olive oil factory requires a fixed capital investment of $3,000,000 and a working capital of $250,000. The average annual cost of production is $1,200,000 whereas the average annual income from sales is $2,000,000. The tax rate on profits is known to be 15% and the rate of interest is 10%. The expected lifetime of the equipment is 15 years and the annual rate of depreciation is 6% of the initial value. a)Calculate the rate of return on investment. Comment on the investment’s feasibility. b)Calculate the payout period by neglecting the time value of money. Comment on the investment’s feasibility. c)Calculate the payout period by considering the time value of money. Comment on the investment’s feasibility.

Solutions

Expert Solution

Sales 2000
Production cost 1200
Depreciation 180
Profit before tax 620
Tax 93
Profit after tax 527
Profit after tax 527
Add: Depreciation 180
Less: Changes in working capital 250
Cash flow from operations 457
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Cash Flows -3000 457 457 457 457 457 457 457 457 457 457 457 457 457 457 457
IRR 12.70%
As IRR is greater than rate of interest, investment looks feasible
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Cumulative Cash flows -3000 -2543 -2086 -1629 -1172 -715 -258 199 656 1113 1570 2027 2484 2941 3398 3855

Payout period is between year 6 and year 7, as cumulative cash flows are converting positive in year 7.

To be exact the payout period is 6 + 258/457 = 6.56 years

The invested amount is received back in 6.56 years, which looks good.

Discounted cash flows (3,000.00) 415.45 377.69 343.35 312.14 283.76 257.96 234.51 213.19 193.81 176.19 160.18 145.61 132.38 120.34 109.40
Cumulative discounted cash flows (3,000.00) (2,584.55) (2,206.86) (1,863.51) (1,551.37) (1,267.61) (1,009.65) (775.13) (561.94) (368.13) (191.93) (31.76) 113.86 246.23 366.58 475.98

Using 10% discount rate, above are the discounted cash flows

Cumulative discounted cash flows are converting positive in 12th year.

Discounted payout period is somewhere between 11 and 12 year.

To be exact 11 + 31.76/145.61 = 11.22

We are able to acheive the desired return of 10% in 11.22 years, while life of project is 15 years, which makes the investment feasible.  

Rahul Sunny answered 2 years ago
Next > < Previous

Related Solutions

An olive oil factory requires a fixed capital investment of $3,000,000 and a working capital of...
An olive oil factory requires a fixed capital investment of $3,000,000 and a working capital of $250,000. The average annual cost of production is $1,200,000 whereas the average annual income from sales is $2,000,000. The tax rate on profits is known to be 15% and the rate of interest is 10%. The expected lifetime of the equipment is 15 years and the annual rate of depreciation is 6% of the initial value. a) Calculate the rate of return on investment....
ABRUZZI OLIVE OIL COMPANY Abruzzi Olive Oil Company is a small producer of premium olive oil....
ABRUZZI OLIVE OIL COMPANY Abruzzi Olive Oil Company is a small producer of premium olive oil. Cheryl Sounders, the owner of Abruzzi, is currently developing a budgets spreadsheet to explore the impact of various sales goals on production. In 2017, the company had monthly sales as follows: January 9200 February 9000 March 9400 April 8600 May 8000 June 8500 July 8200 August 7500 September 8900 October 9300 November 9200 December 9600 At a planning meeting in November 2017, Jay Peters,...
The Abruzzi Olive Oil Company is a small producer of premium olive oil. Cheryl Sounders, the...
The Abruzzi Olive Oil Company is a small producer of premium olive oil. Cheryl Sounders, the owner of Abruzzi, is currently developing a budget spreadsheet to explore the impact of various sales goals on production. Month Sales January 9,200 February. 9,000 March 9,400 April 8,600 May 8,000 June 8,500 July 8,200 August 7,500 September 8,900 October 9,300 November 9,200 December. 9,600 At a planning meeting in November 2020, Jay Peters, the marketing manager for Abruzzi, told Cheryl that he expected...
The workers at Olisur Olive Oil Factory, work four days a week, 15 hours a day....
The workers at Olisur Olive Oil Factory, work four days a week, 15 hours a day. Each day of the week, at least the following numbers of workers are needed: on weekdays 105 workers per day; on weekends 45 workers per day. There are 165 workers in the factory. Formulate a linear programming model that will reveal a schedule for the workers to maximize the sum of their consecutive days off (define decision variables; indicate objective function, constraints, and sign...
A project has an installed cost of $500,000 and requires an additional working capital investment of...
A project has an installed cost of $500,000 and requires an additional working capital investment of $100,000. The project replaces an existing piece of equipment that has an estimated salvage value of $7000 and has a book value of $2000. The firm's marginal tax rate is 40 percent. What is the Initial Outlay for this project? Answer: IO = $595,000 How do you calculate this problem?
A pizza restaurant requires 200 grams of flour, 10 ml of olive oil, 100 ml of...
A pizza restaurant requires 200 grams of flour, 10 ml of olive oil, 100 ml of tomato sauce and 200 grams of cheese to make one of their basic pizzas. The restaurant’s supplier sells bags of flour weighing 5 kg each, drums of olive oil containing 5 litres, cans of tomato sauce containing 2 litres and bags of grated cheese weighing 1 kg. Write a python program to ask the user how many pizzas they expect to make in the...
In its first year of business, Ollie’s Olive Oil produced 104,000 quarts of olive oil. During...
In its first year of business, Ollie’s Olive Oil produced 104,000 quarts of olive oil. During its first year, the company sold 100,000 quarts of olive oil. Costs incurred during the year were as follows: Ingredients used $228,800 Direct labor 104,000 Variable overhead 197,600 Fixed overhead 98,800 Variable selling expenses 50,000 Fixed selling and administrative expenses 20,000 Total actual costs $699,200 a. 1. What was the actual production cost per quart under variable costing? 2. What was the actual production...
Rosehut Olive Oil Company makes two grades of olive oil: standard and extra virgin. Rosehut has...
Rosehut Olive Oil Company makes two grades of olive oil: standard and extra virgin. Rosehut has identified two activity cost pools, the related costs per pool, the cost driver for each pool, and the expected usage for each pool. Activity Total Activity Cost Cost Driver Standard Extra Virgin Washing, Pressing & Filtering (WPF) $ 1,673,150 Washing, Pressing, and Filtering hours 46,400 hours 107,100 hours Bottling $ 706,500 Number of bottles 314,000 bottles 78,500 bottles Additional information about each grade of...
what's the SWOT analysis of Bertolli Olive Oil
what's the SWOT analysis of Bertolli Olive Oil
Are there any significant difference between working capital management and working capital investment?
Are there any significant difference between working capital management and working capital investment?
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT