Pantheon Enterprises Course Computer Project Pantheon Enterprises is a well-developed large market cap high tech fimm...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Pantheon Enterprises Course Computer Project Pantheon Enterprises is a well-developed large market cap high tech fimm residing in Boston Massachusetts. It specializes in the development, manufacture, and licensing of a line of servers called "Rajun." Its main competitor is Cisco which therefore necessitates that Pantheon develop market niche and focus on being as efficient as possible! Considering the need to be on the cutting edge of innovation for competitive rest decided to incur $4.381.200 in research and development to promote its new product called "Tribe" and make it compatible with the balance of its product line and hence to develop in environment with increasing scale economies. Along with this, Pantheon decided to spend $2.723,700 to hire a market research firm Know--All & Associates (KIA). Initially, KIA conducted marketing tests in 62 economic zones in the US, Eastern Europe, Canada and several areas of Africa to determine an expected future sales level in both dollars and units that Pantheon world expect to realize The cost of the equipment to develop the new Tribox server is approximately $81.298,000 which will be depreciated on a five-year MACRS schedule. At the end of five years, it is expected that the remorable salvage value of the investment will be 9 percent of its original cost. Pabe con facture Trilux for which the variable costs per unit are expected to come in at $308 while overall fixed costs would be $9.856,000 per year. At this point KIA estimates that sales of Triax will be 116,000, 129,000, 145.000, 121,000, and 89,000 units respectively for the next five years with a sales price of $732 per unit. Sales of Rajun are expected to come in at 107,500, and 91,200 units respectively over the nex two years if Trilux is NOT developed. Of coune, erosion is expected if Tribus is developed as it would likely cable the original Rajun product. It is expected that Trihex would reduce Rajon sales by 31,750 units per year for the next two years sed market pressure would force the Rajus product to be discounted from its original price of $457 unit so $249Vble cost unit of Raju in $195 and fixed costs currently are $4,248,500 on an albis Working capital to support the Trilux will be approximately 21.25% of yearly sales for the life of the product which is expected to end after five years for which net working capital will be released back to Pantheon. The timing of the working capital will be exactly the same as the ch inflows which will be at the end of each yes. Lastly, the marginal corporate income tax rate is 39.675% and management dictates that the required rate of return for this project will be 15.95% You are to determine the NPV and the IRR of the project and give your recommendation to management as to whether the company should proceed with the project. In addition, you are to take the initiative and make a recommendation as to what you would reasonably change with respect to the project to make it more lucrative for Pantheon. Your presentation t be in the form of an Excel spreadbest professionally presented this means clean it up, make it flowing in its presentation, and create eye appeal! There see to be NO constant ber input which would destroy cell referencing for future use. To avoid this, you are to have a separate worksheet tab for data input that you can reference. Be careful, you will be penalized for any and all cell referencing that is destroyed. Additionally, you are to have separate worksheet tabs for Data Entry, NPV, and IRR. Do not submit your computer project early as I may come back and add requirements! Should I add a requirement-you will need a separate worksheet tab for each and every additional requirement that is assigned! When you see done, properly title and submit your work through Moodle by the deadline. If you have any questions, feel free to contact me and I will be in touch along the way... Pantheon Enterprises Course Computer Project Pantheon Enterprises is a well-developed large market cap high tech fimm residing in Boston Massachusetts. It specializes in the development, manufacture, and licensing of a line of servers called "Rajun." Its main competitor is Cisco which therefore necessitates that Pantheon develop market niche and focus on being as efficient as possible! Considering the need to be on the cutting edge of innovation for competitive rest decided to incur $4.381.200 in research and development to promote its new product called "Tribe" and make it compatible with the balance of its product line and hence to develop in environment with increasing scale economies. Along with this, Pantheon decided to spend $2.723,700 to hire a market research firm Know--All & Associates (KIA). Initially, KIA conducted marketing tests in 62 economic zones in the US, Eastern Europe, Canada and several areas of Africa to determine an expected future sales level in both dollars and units that Pantheon world expect to realize The cost of the equipment to develop the new Tribox server is approximately $81.298,000 which will be depreciated on a five-year MACRS schedule. At the end of five years, it is expected that the remorable salvage value of the investment will be 9 percent of its original cost. Pabe con facture Trilux for which the variable costs per unit are expected to come in at $308 while overall fixed costs would be $9.856,000 per year. At this point KIA estimates that sales of Triax will be 116,000, 129,000, 145.000, 121,000, and 89,000 units respectively for the next five years with a sales price of $732 per unit. Sales of Rajun are expected to come in at 107,500, and 91,200 units respectively over the nex two years if Trilux is NOT developed. Of coune, erosion is expected if Tribus is developed as it would likely cable the original Rajun product. It is expected that Trihex would reduce Rajon sales by 31,750 units per year for the next two years sed market pressure would force the Rajus product to be discounted from its original price of $457 unit so $249Vble cost unit of Raju in $195 and fixed costs currently are $4,248,500 on an albis Working capital to support the Trilux will be approximately 21.25% of yearly sales for the life of the product which is expected to end after five years for which net working capital will be released back to Pantheon. The timing of the working capital will be exactly the same as the ch inflows which will be at the end of each yes. Lastly, the marginal corporate income tax rate is 39.675% and management dictates that the required rate of return for this project will be 15.95% You are to determine the NPV and the IRR of the project and give your recommendation to management as to whether the company should proceed with the project. In addition, you are to take the initiative and make a recommendation as to what you would reasonably change with respect to the project to make it more lucrative for Pantheon. Your presentation t be in the form of an Excel spreadbest professionally presented this means clean it up, make it flowing in its presentation, and create eye appeal! There see to be NO constant ber input which would destroy cell referencing for future use. To avoid this, you are to have a separate worksheet tab for data input that you can reference. Be careful, you will be penalized for any and all cell referencing that is destroyed. Additionally, you are to have separate worksheet tabs for Data Entry, NPV, and IRR. Do not submit your computer project early as I may come back and add requirements! Should I add a requirement-you will need a separate worksheet tab for each and every additional requirement that is assigned! When you see done, properly title and submit your work through Moodle by the deadline. If you have any questions, feel free to contact me and I will be in touch along the way...
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Indicate which of the following statements are true or false: ________ The IRS is a division of the Treasury Department. ________ The IRS has four major divisions. ________ The IRS local offices...
-
Prepare a double column cash book with the help of following information for December 2016: 01 Started business with cash Cash paid into bank 03 05 06 10 14 18 20 22 27 30 Purchased goods from...
-
T-Account entries and balance sheet preparation. Whitley Products Corporation begins operations on April 1. The firm engages in the following transactions during April: (1) Issues 25,000 shares of...
-
Journ Co. purchased short- term investments in available- for- sale securities at a cost of $ 50,000 on November 25, 2013. At December 31, 2013, these securities had a fair value of $ 47,000. This is...
-
John Acracker owns orange groves and hires workers to pick his oranges. His production function is given: TABLE ONE # Pickers Oranges Picked 0 0 1 8 2 20 3 30 4 37 5 41 6 42 7 40 8 35 9 28
-
8. What is the market value of a zero coupon bond with a face value of $1,000 and 10 years to maturity, assuming an annual discount rate of 7%? A. $100.00 B. $258.42 C. $508.35 D. $1,000.00 E. None...
-
What part might a third-party auditor play in providing operations management with information on the reliability of an outsourcing vendor's controls?
-
What part does operations management play with respect to the disaster recovery controls associated with an outsourcing contract?
-
What is the difference between minimum total cost and short-range profit maximization policies in system design?
-
At what point in the typical analysis does the technique give way to the managerial review and evaluation process?
-
What is the main advantage of the typical optimization technique in comparison to simulation?
-
1. Why a good knowledge of accounting is necessary for a manager? 2. What are the advantages and limitations of a journal in accounting? 3. Describe fundamental accounting equation. How are revenue...
-
Which legal system is based on a detailed set of written rules and statutes that constitute a legal code?LO1
-
What are some examples of intellectual property?LO1
-
Which legal system decides cases by interpreting the law on the basis of tradition, precedent, and usage?LO1
Study smarter with the SolutionInn App