ABC company deals in agriculture machines. Due to severe price competition in the market, the company...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ABC company deals in agriculture machines. Due to severe price competition in the market, the company has been experiencing a decrease in revenues in recent times. The situation led the company to push its engineers to develop a unique and profitable product that could compete in the market. In the last company meeting, the design committee, headed by Mr Zakir, unveiled its unique product prototype called "Smart Seed Drill". This machine uses artificial intelligence to sow seeds to a certain depth and distance in the soil for cultivating crops. This equipment is attached to a tractor and further dragged onto the farm fields to ensure the seeds are sown and distributed to the soil properly. The machine uses sophisticated built-in technology to determine the depth and distance. The marketing department's surveys showed that this product would be a success and could secure a good market share if the company offered a competitive price. The survey results showed great demand for this product at the end of both customers and retailers. It took almost three years to develop the prototype and test the product before marketing it to various exhibitions. As long as the quality of the product was related, the product passed all the required safety and quality standards. The company had not yet started fully producing this product because the newly appointed CEO was very conservative in his approach. The CEO wants the design team to present a comprehensive feasibility report of this product to the firm's investment committee chaired by Mr Riduan. After the committee's approval, the CEO will approve the product's full production. The feasibility report must include all the estimates of revenues, related costs, and acceptable documentation. Mr Zakir is very experienced and has been involved in similar projects in his previous job. He started collecting the required information to prepare a comprehensive feasibility report. Using the marketing department survey report, he prepared the following Table 1. Table 1: Forecasted Unit Sales and Price of Smart Seed Drill Year 123456789 10 Unit Sales 30,000 34,000 38,800 38,000 36,000 36,000 35,500 35,500 34,500 34,000 Unit Price $1,000 $1,000 $1,000 $950 $950 $950 $950 $900 $900 $900 Using the data supplied by the marketing department, Mr Zakir prepared Table 1, presenting the forecasted unit sales of Smart Seed Drill over its economic life of ten years. Table 1 also shows the expected unit's selling price. Due to competitive pressure, the marketing department had indicated that prices would drop in later years. It is also the market phenomenon that market players (competitors) start producing similar products after some time. The project followed seven years of MACRS rates for depreciation, as shown in Table 2. The first year of depreciation using the MACRS rates would start from year 1, not year 0. Table 2: MACRS Depreciation Rates Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3 Years 33.33 44.45 14.81 7.41 Depreciation Rate for Recovery Period 7 Years 10 Years 14.29 10.00 24.49 18.00 17.49 14.40 12.49 11.52 8.93 8.92 8.93 4.46 5 Years 20.00 32.00 19.20 11.52 11.52 5.76 9.22 7.37 6.55 6.55 6.56 6.55 3.28 15 Years 5.00 9.50 8.55 7.70 6.93 6.23 5.90 5.90 5.91 5.90 5.91 5.90 5.91 5.90 5.91 2.95 20 Years 3.750 7.219 6.677 6.177 5.713 5.285 4.888 4.522 4.462 4.461 4.462 4.461 4.462 4.461 4.462 4.461 4.462 4.461 4.462 4.461 2.231 The cost of equipment was estimated to be $20 million. This cost included shipping, handling, and installation costs as well. The equipment was expected to be sold at a market price of $4 million after ten years. It was indicated that the product's manufacturing would occur in an existing unoccupied company plant. The market survey revealed that monthly leases for similar plants averaged $10,000 in the market. The variable costs of production per unit were estimated to be $400. The expected fixed costs were $15,00,000 annually. To start the project, the company would purchase an additional inventory of $500,000. The company would also increase account receivables and payables by $1,000,000 and $600,000, respectively. In the subsequent years, Mr Zakir expected that the company's net working capital would make up to 5% of the sales. The average cost of capital of the company was 14 per cent. It was estimated that the corporate tax would remain constant at 34%. Mr Zakir found that the annual interest expenses on the debt financing were worth $400,000. Required: a. Prepare the pro forma statement of the Smart Seed Drill project's annual cash flows b. What are the NPV and IRR of the project? c. Prepare the NPV profile. Show the graph and excel working d. The investment committee could argue that the annual unit sold may go up or down by 15 per cent from its base forecast. How may these two scenarios affect the decision? Calculate NPV and IRR if annual sold units increase and decrease by 15%. ABC company deals in agriculture machines. Due to severe price competition in the market, the company has been experiencing a decrease in revenues in recent times. The situation led the company to push its engineers to develop a unique and profitable product that could compete in the market. In the last company meeting, the design committee, headed by Mr Zakir, unveiled its unique product prototype called "Smart Seed Drill". This machine uses artificial intelligence to sow seeds to a certain depth and distance in the soil for cultivating crops. This equipment is attached to a tractor and further dragged onto the farm fields to ensure the seeds are sown and distributed to the soil properly. The machine uses sophisticated built-in technology to determine the depth and distance. The marketing department's surveys showed that this product would be a success and could secure a good market share if the company offered a competitive price. The survey results showed great demand for this product at the end of both customers and retailers. It took almost three years to develop the prototype and test the product before marketing it to various exhibitions. As long as the quality of the product was related, the product passed all the required safety and quality standards. The company had not yet started fully producing this product because the newly appointed CEO was very conservative in his approach. The CEO wants the design team to present a comprehensive feasibility report of this product to the firm's investment committee chaired by Mr Riduan. After the committee's approval, the CEO will approve the product's full production. The feasibility report must include all the estimates of revenues, related costs, and acceptable documentation. Mr Zakir is very experienced and has been involved in similar projects in his previous job. He started collecting the required information to prepare a comprehensive feasibility report. Using the marketing department survey report, he prepared the following Table 1. Table 1: Forecasted Unit Sales and Price of Smart Seed Drill Year 123456789 10 Unit Sales 30,000 34,000 38,800 38,000 36,000 36,000 35,500 35,500 34,500 34,000 Unit Price $1,000 $1,000 $1,000 $950 $950 $950 $950 $900 $900 $900 Using the data supplied by the marketing department, Mr Zakir prepared Table 1, presenting the forecasted unit sales of Smart Seed Drill over its economic life of ten years. Table 1 also shows the expected unit's selling price. Due to competitive pressure, the marketing department had indicated that prices would drop in later years. It is also the market phenomenon that market players (competitors) start producing similar products after some time. The project followed seven years of MACRS rates for depreciation, as shown in Table 2. The first year of depreciation using the MACRS rates would start from year 1, not year 0. Table 2: MACRS Depreciation Rates Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 3 Years 33.33 44.45 14.81 7.41 Depreciation Rate for Recovery Period 7 Years 10 Years 14.29 10.00 24.49 18.00 17.49 14.40 12.49 11.52 8.93 8.92 8.93 4.46 5 Years 20.00 32.00 19.20 11.52 11.52 5.76 9.22 7.37 6.55 6.55 6.56 6.55 3.28 15 Years 5.00 9.50 8.55 7.70 6.93 6.23 5.90 5.90 5.91 5.90 5.91 5.90 5.91 5.90 5.91 2.95 20 Years 3.750 7.219 6.677 6.177 5.713 5.285 4.888 4.522 4.462 4.461 4.462 4.461 4.462 4.461 4.462 4.461 4.462 4.461 4.462 4.461 2.231 The cost of equipment was estimated to be $20 million. This cost included shipping, handling, and installation costs as well. The equipment was expected to be sold at a market price of $4 million after ten years. It was indicated that the product's manufacturing would occur in an existing unoccupied company plant. The market survey revealed that monthly leases for similar plants averaged $10,000 in the market. The variable costs of production per unit were estimated to be $400. The expected fixed costs were $15,00,000 annually. To start the project, the company would purchase an additional inventory of $500,000. The company would also increase account receivables and payables by $1,000,000 and $600,000, respectively. In the subsequent years, Mr Zakir expected that the company's net working capital would make up to 5% of the sales. The average cost of capital of the company was 14 per cent. It was estimated that the corporate tax would remain constant at 34%. Mr Zakir found that the annual interest expenses on the debt financing were worth $400,000. Required: a. Prepare the pro forma statement of the Smart Seed Drill project's annual cash flows b. What are the NPV and IRR of the project? c. Prepare the NPV profile. Show the graph and excel working d. The investment committee could argue that the annual unit sold may go up or down by 15 per cent from its base forecast. How may these two scenarios affect the decision? Calculate NPV and IRR if annual sold units increase and decrease by 15%.
Expert Answer:
Answer rating: 100% (QA)
To prepare the pro forma statement of the Smart Seed Drill projects annual cash flows we need to consider various components such as revenues costs depreciation taxes working capital and salvage value ... View the full answer
Related Book For
Contemporary Financial Management
ISBN: 9780324289114
10th Edition
Authors: James R Mcguigan, R Charles Moyer, William J Kretlow
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Calculate the covariance of returns on the foreign index and the returns on the domestic index. An analyst produces the following joint probability function for a foreign index (FI) and a domestic...
-
The accounting records of Rhyme Redwood Corporation provide income statement data for 2012. Total revenue . . . . . . $ 940,000 Total expenses . . . . . . . 750,000 Income before tax . . . $ 190,000...
-
An industrial engineer employed by a beverage bottler is interested in the effects of two different types of 32-ounce bottles on the time to deliver 12-bottle cases of the product. The two bottle...
-
(a) What is the COE for a turbine with the following assumptions: 5 MW rating \(31 \%\) capacity factor \(\$ 1250 / \mathrm{kW}\) turbine cost \(\$ 91,000\) operations and maintenance cost/year Fixed...
-
As an accountant for the Lee Company, your supervisor gave you the following calculations of the gross profit for the first quarter: The three alternative cost flow assumptions are FIFO, Average, and...
-
MARS Ltd acquired a business from BARS Ltd in exchange for land having a fair value of $600 000. At the date of acquisition, MARS took control of identifiable assets with a fair value of $840 000,...
-
In Intuit QuickBooks how do I record this transaction?... Wrote check number 10010 to City Credit Union for payment of amount due (City Credit Union in the Account/Category field); $110.35.
-
If your taxable income is $190,000 and the marginal tax bracket between $157,500 and $200,000 is 32%, what would be the tax due on earnings above $157,500?
-
Three wooden beams and two steel plates are securely bolted together to form the composite member shown. Using the data given in the table, determine the largest permissible bending moment when the...
-
Provide a "big oh" run-time analysis for each of the following. When a value of "n" is used, it is the size of the input. You may assume max() and min() are constant-time in-line functions. [10pts....
-
1. State the asymptotic complexity of each of the following functions in simplest terms, using 0(f(n)) ("theta") notation. You do not need to provide any justification or proof. [2pts. ea.] (a) fa...
-
What is the excel formula to solve the below: Given the following cash flows, what is the project's payback period? Answer is 2.4 Year 0: -100 Year 1: 40 Year 2: 40 Year 3: 50 Year 4: 50 What is the...
-
Convert the following program from assembly to 14-bit machine code. You do not have to convert the first four 'equ' lines. Also assume that the first assembly instruction starts at Program Memory...
-
Presented below are data on three promissory notes. Determine the missing amounts. (Use 360 days for calculation. Do not round intermediate calculations.) Date of Note April 1 July 2 March 7 Terms 60...
-
APC16550D UART has a clock running at18.432 MHz and its baud rate is set to 2000.Determine the HEX contents of its DLM and DLL registers. Please can you explain step by step and in detail how you get...
-
Valley Stores, a U.S. department store chain, annually negotiates a contract with Alpine Watch Company, located in Switzerland, to purchase a large shipment of watches. On November 15, 2001, Valley...
-
The Bimbo Corporation has been experiencing a decline in sales relative to its major competitors. Because Bimbo is confident about the quality of its products, it suspects that this sales loss may...
-
Blue Moon Corporation has one million shares of common stock outstanding. In a typical annual election for the board of directors, shareholders representing 70 percent of the shares outstanding...
-
Derive the frequency equation for the longitudinal vibration of the systems shown in Fig. 8.28. M p. A, E.1 p.A. E,I M k p. A. E,I ell M k (a) (b) FIGURE 8.28 Bar with different end conditions. (c)
-
Fill in the Blank. The ____________ energy of a beam is denoted by \(\frac{1}{2} \int_{0}^{l} E I\left(\frac{\partial^{2} w}{\partial x^{2}} ight)^{2} d x\).
-
a. Longitudinal vibration of a bar b. Torsional vibration of a shaft c. Transverse vibration of a string \(c=\left(\frac{G}{ho} ight)^{1 / 2}\) Data:- \(c^{2} \frac{\partial^{2} w}{\partial...
Study smarter with the SolutionInn App