Project 1 Calculations must be done in Excel - You must create your own spreadsheet (do...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Project 1 Calculations must be done in Excel - You must create your own spreadsheet (do not copy and paste someone else's). This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV). Happy corporation projects their future unit sales for a new headphone. The projected unit sales are as below. 1 2 3 4 5 Unit sales 75000 89000 120000 96000 60000 To produce the headphones, the initial net working capital of $2,000,000 is required and additional net working capital is also required each year, which is 20% of the projected sales increase for the following year. The net working capital will be recovered at the end of a project. In addition, the initial installation cost of the machine for production is $21,000,000. The machine will be depreciated for tax purposes using straight-line depreciation with the useful life of 8 years. Also, costs and unit price are as below. Fixed cost $3,120,000 per year Variable cost Price $285 per unit $415 per unit In five years, the machine can be sold for about 30% of its acquisition cost. The tax rate is 30% and the required rate of return is 15%. Tasks (a) What is the NPV of the project? Explain and defend your processes, answer, and calculations clearly. (b) Assuming that the project can be repeated indefinitely, what is the NPV of the project? Suppose that there is another project with the NPV of $4 million and the NPV of $6 million. Which project would you choose, assuming that two projects are mutually exclusive and can be repeated indefinitely? Why? Explain and defend your processes, answer, and calculations clearly. Project 1 Calculations must be done in Excel - You must create your own spreadsheet (do not copy and paste someone else's). This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV). Happy corporation projects their future unit sales for a new headphone. The projected unit sales are as below. 1 2 3 4 5 Unit sales 75000 89000 120000 96000 60000 To produce the headphones, the initial net working capital of $2,000,000 is required and additional net working capital is also required each year, which is 20% of the projected sales increase for the following year. The net working capital will be recovered at the end of a project. In addition, the initial installation cost of the machine for production is $21,000,000. The machine will be depreciated for tax purposes using straight-line depreciation with the useful life of 8 years. Also, costs and unit price are as below. Fixed cost $3,120,000 per year Variable cost Price $285 per unit $415 per unit In five years, the machine can be sold for about 30% of its acquisition cost. The tax rate is 30% and the required rate of return is 15%. Tasks (a) What is the NPV of the project? Explain and defend your processes, answer, and calculations clearly. (b) Assuming that the project can be repeated indefinitely, what is the NPV of the project? Suppose that there is another project with the NPV of $4 million and the NPV of $6 million. Which project would you choose, assuming that two projects are mutually exclusive and can be repeated indefinitely? Why? Explain and defend your processes, answer, and calculations clearly.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
The operations manager of a company that produces frozen dinners had received numerous complaints from supermarkets about the companys Chick-n-Gravy dinners. The manager spilled/mixed items,...
-
The Riteway Ad Agency provides cars for its sales staff. In the past, the company has always purchased its cars from a dealer and then sold the cars after three years of use. The companys present...
-
In terms of the access coritrol mechanism used in an electronic funds transfer system, what function does a plastic debit or credit card fulfil? Why should cards be issued only after a formal...
-
No. The role of the investment banker is more important if the stock demand curve has a steep slope and the negative signaling effect is substantial. Under such conditions, the investment banker will...
-
Professional ethics and reporting division performance. Marcia Miller is division controller and Tom Maloney is division manager of the Ramses Shoe Company. Miller has line responsibility to Maloney,...
-
. . . . ( GAAP ) ( ) . , / . , , . )
-
Sleep Tight, Inc., manufactures comforters. The estimated inventories on January 1 for finished goods, work in process, and materials were $40,000, $35,000 and $26,000 respectively. The desired...
-
The police arrest Kache, a drug addict, on suspicion of a burglary in which a silver jug and a gold antique jug were stolen. At Kitu Kidogo Police Station, Kache complains of withdrawal symptoms, but...
-
Assume that the discount rate is exactly 0 (and the following monetary values are in $million). Picking a time horizon, T, you are told that (as calculated at time zero), for a particular portfolio,...
-
Assume that weekly spending of all customers is normally distributed with a mean of $28.10 and standard deviation of $2.10. If the company has 2500 customers per year purchasing frozen food, Answer...
-
Planck determined the relationship between the energy of a photon and its frequency (recall that photons travel as waves). This relationship is expressed as Planck's constant: h= 6.626 x 10-4 J-s...
-
Johnny and Leon are adult partners in a business selling sporting goods. The partnership records, excluding GST , for the current income year disclose the following: Receipts ($): 400,000 New sales...
-
Adam Smith fue un escocs libre pensador propulsor de la llamada Teora Clsica, que expone en su principal publicacin "La riqueza de las naciones" su teora sobre: Seleccione una: a. Las Ventajas...
-
Data 9.2 on page 540 introduces the dataset Cereal, which includes information on the number of grams of fiber in a serving for 30 different breakfast cereals. The cereals come from three different...
-
Develop a brief answer to each of the following questions. 1. What makes accounting a valuable discipline? 2. Why do managers in governmental and not-for-profit organizations need to understand...
-
Siglo Pharmaceuticals has recently been formed to develop a new type of drug treatment for cancer. Previously a partnership, Siglo has now become a corporation. Describe the various groups that will...
-
Max owns and operates a minimart. Which of Maxs actions described below are business transactions? Explain why any other actions are not considered transactions. 1. Max reduces the price of a gallon...
Study smarter with the SolutionInn App