Assume that you are a consultant working for GLORY Ltd., which is investigating the possibility of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assume that you are a consultant working for GLORY Ltd., which is investigating the possibility of releasing a new gaming console known as GR1. This system has been linked to human brain functions, and despite this, it is still quite controversial due to the reported, but unconfirmed, adverse effects on human behaviour that come from prolonged use. Communities that are concerned with health are also campaigning against the adoption of games that could potentially harm players' health. The project manager at GLORY Ltd., Mr. Smith, needs an in-depth analysis of the intriguing GR1 project. He insisted that a review is to be done before the firm drops $27 million on brand-new machinery for this venture. Mr. Smith handed over to you a report that displayed the following information and estimates: The project will be extended for another seven years so that more precise data on the potential adverse effects of using GR1 can be collected and analyzed. The usefulness of the machinery is predicted to last for ten years. GLORY Ltd will spend an additional $1.5 million on renovations to the production bay and installation costs after purchasing the necessary machinery. These expenses are considered long-term investments and should be recorded as capital expenditures. GLORY Ltd will be responsible for the 8% import duty on the purchase price of the equipment from France, while the supplier will be responsible for the $80,000 in shipping costs. These property, plant, and equipment (PPE) would be depreciated over a 10-year useful life at a tax-allowable straight-line rate of 10%. However, at the end of the project, the company intends to sell the equipment for an estimated $7 million. The consultants estimate that sales of 48,000 GR1 consoles will be possible in the first year, with sales increasing by 25% each year until year 3; after that, sales are anticipated to fall by 20% each year until the end of the project, due to a number of market factors. 50% of sales will go towards variable operating expenses. Prices for the consoles will start at $500 in the first year, increase by 10% in the fourth year, and stay unchanged until the end of the project's life. Depreciation is not included in the $600,000 annual fixed operating cost. It is estimated that the new production line will call for an initial investment of $800,000 in inventory and $250,000 in debtors (account receivable), with the increase in creditors offsetting the cost by $150,000. (accounts payable). Until the project is fully recovered at the end of its life, no additional net working capital (NWC) investments will be made. The GR1 project can use preexisting facilities from a different production line, which brings in $260,000 annually after expenses. This assembly line will be retired as soon as the GR1 project gets underway. Additionally, GLORY plans to spend $100,000 annually in a promotion and advertising program for the duration of the project. The weighted average cost of capital (WACC) of the company, which has varied in the range of 13% to 20% in recent times, is used to derive the required rate of return. The analyst has no idea what rate will work best for the project, but she is using the required rate of 13% to determine the project's worth. The tax rate for corporations is 30%. The discounted payback period is 5 years. Due to the game industry's rapid expansion and the rapid advancement of technology in many different areas, the project manager is hesitant to make a final decision. As an alternative, GLORY has proposed the GR2, an improved version of a safe and classic gaming system. This GR2 project would have the same total initial investment as the GR1 project, and the following net future cash flows are forecasted (after all adjustments): Year-1: $14,300,000; Year-2: $15,500,000; Year-3: $12,800,000; Year-4: $8,800,000; Year-5: $7,500,000; Year-6: $5,100,000; In order to make an informed decision about the GR1 project in the upcoming meeting, the project manager of GLORY Ltd needs a detailed explanation of all relevant issues. The project manager is looking for a formal report that breaks down the cash flow projections and explains the outcomes of the most common capital budgeting techniques used to assess projects. The project manager is also keen to examine a detailed comparison of GR1 and GR2 projects with regards to the outcomes of applicable capital budgeting methods using both 13 and 20 percent required rates, crossover rate, and any other factors that can aid in taking a final decision. Required: Table of cash flow Cusing Excel) and show Excel Formulae and comment on each project. Assume that you are a consultant working for GLORY Ltd., which is investigating the possibility of releasing a new gaming console known as GR1. This system has been linked to human brain functions, and despite this, it is still quite controversial due to the reported, but unconfirmed, adverse effects on human behaviour that come from prolonged use. Communities that are concerned with health are also campaigning against the adoption of games that could potentially harm players' health. The project manager at GLORY Ltd., Mr. Smith, needs an in-depth analysis of the intriguing GR1 project. He insisted that a review is to be done before the firm drops $27 million on brand-new machinery for this venture. Mr. Smith handed over to you a report that displayed the following information and estimates: The project will be extended for another seven years so that more precise data on the potential adverse effects of using GR1 can be collected and analyzed. The usefulness of the machinery is predicted to last for ten years. GLORY Ltd will spend an additional $1.5 million on renovations to the production bay and installation costs after purchasing the necessary machinery. These expenses are considered long-term investments and should be recorded as capital expenditures. GLORY Ltd will be responsible for the 8% import duty on the purchase price of the equipment from France, while the supplier will be responsible for the $80,000 in shipping costs. These property, plant, and equipment (PPE) would be depreciated over a 10-year useful life at a tax-allowable straight-line rate of 10%. However, at the end of the project, the company intends to sell the equipment for an estimated $7 million. Assume that you are a consultant working for GLORY Ltd., which is investigating the possibility of releasing a new gaming console known as GR1. This system has been linked to human brain functions, and despite this, it is still quite controversial due to the reported, but unconfirmed, adverse effects on human behaviour that come from prolonged use. Communities that are concerned with health are also campaigning against the adoption of games that could potentially harm players' health. The project manager at GLORY Ltd., Mr. Smith, needs an in-depth analysis of the intriguing GR1 project. He insisted that a review is to be done before the firm drops $27 million on brand-new machinery for this venture. Mr. Smith handed over to you a report that displayed the following information and estimates: The project will be extended for another seven years so that more precise data on the potential adverse effects of using GR1 can be collected and analyzed. The usefulness of the machinery is predicted to last for ten years. GLORY Ltd will spend an additional $1.5 million on renovations to the production bay and installation costs after purchasing the necessary machinery. These expenses are considered long-term investments and should be recorded as capital expenditures. GLORY Ltd will be responsible for the 8% import duty on the purchase price of the equipment from France, while the supplier will be responsible for the $80,000 in shipping costs. These property, plant, and equipment (PPE) would be depreciated over a 10-year useful life at a tax-allowable straight-line rate of 10%. However, at the end of the project, the company intends to sell the equipment for an estimated $7 million. The consultants estimate that sales of 48,000 GR1 consoles will be possible in the first year, with sales increasing by 25% each year until year 3; after that, sales are anticipated to fall by 20% each year until the end of the project, due to a number of market factors. 50% of sales will go towards variable operating expenses. Prices for the consoles will start at $500 in the first year, increase by 10% in the fourth year, and stay unchanged until the end of the project's life. Depreciation is not included in the $600,000 annual fixed operating cost. It is estimated that the new production line will call for an initial investment of $800,000 in inventory and $250,000 in debtors (account receivable), with the increase in creditors offsetting the cost by $150,000. (accounts payable). Until the project is fully recovered at the end of its life, no additional net working capital (NWC) investments will be made. The GR1 project can use preexisting facilities from a different production line, which brings in $260,000 annually after expenses. This assembly line will be retired as soon as the GR1 project gets underway. Additionally, GLORY plans to spend $100,000 annually in a promotion and advertising program for the duration of the project. The weighted average cost of capital (WACC) of the company, which has varied in the range of 13% to 20% in recent times, is used to derive the required rate of return. The analyst has no idea what rate will work best for the project, but she is using the required rate of 13% to determine the project's worth. The tax rate for corporations is 30%. The discounted payback period is 5 years. Due to the game industry's rapid expansion and the rapid advancement of technology in many different areas, the project manager is hesitant to make a final decision. As an alternative, GLORY has proposed the GR2, an improved version of a safe and classic gaming system. This GR2 project would have the same total initial investment as the GR1 project, and the following net future cash flows are forecasted (after all adjustments): Year-1: $14,300,000; Year-2: $15,500,000; Year-3: $12,800,000; Year-4: $8,800,000; Year-5: $7,500,000; Year-6: $5,100,000; In order to make an informed decision about the GR1 project in the upcoming meeting, the project manager of GLORY Ltd needs a detailed explanation of all relevant issues. The project manager is looking for a formal report that breaks down the cash flow projections and explains the outcomes of the most common capital budgeting techniques used to assess projects. The project manager is also keen to examine a detailed comparison of GR1 and GR2 projects with regards to the outcomes of applicable capital budgeting methods using both 13 and 20 percent required rates, crossover rate, and any other factors that can aid in taking a final decision. Required: Table of cash flow Cusing Excel) and show Excel Formulae and comment on each project. The consultants estimate that sales of 48,000 GR1 consoles will be possible in the first year, with sales increasing by 25% each year until year 3; after that, sales are anticipated to fall by 20% each year until the end of the project, due to a number of market factors. 50% of sales will go towards variable operating expenses. Prices for the consoles will start at $500 in the first year, increase by 10% in the fourth year, and stay unchanged until the end of the project's life. Depreciation is not included in the $600,000 annual fixed operating cost. It is estimated that the new production line will call for an initial investment of $800,000 in inventory and $250,000 in debtors (account receivable), with the increase in creditors offsetting the cost by $150,000. (accounts payable). Until the project is fully recovered at the end of its life, no additional net working capital (NWC) investments will be made. The GR1 project can use preexisting facilities from a different production line, which brings in $260,000 annually after expenses. This assembly line will be retired as soon as the GR1 project gets underway. Additionally, GLORY plans to spend $100,000 annually in a promotion and advertising program for the duration of the project. The weighted average cost of capital (WACC) of the company, which has varied in the range of 13% to 20% in recent times, is used to derive the required rate of return. The analyst has no idea what rate will work best for the project, but she is using the required rate of 13% to determine the project's worth. The tax rate for corporations is 30%. The discounted payback period is 5 years. Due to the game industry's rapid expansion and the rapid advancement of technology in many different areas, the project manager is hesitant to make a final decision. As an alternative, GLORY has proposed the GR2, an improved version of a safe and classic gaming system. This GR2 project would have the same total initial investment as the GR1 project, and the following net future cash flows are forecasted (after all adjustments): Year-1: $14,300,000; Year-2: $15,500,000; Year-3: $12,800,000; Year-4: $8,800,000; Year-5: $7,500,000; Year-6: $5,100,000; In order to make an informed decision about the GR1 project in the upcoming meeting, the project manager of GLORY Ltd needs a detailed explanation of all relevant issues. The project manager is looking for a formal report that breaks down the cash flow projections and explains the outcomes of the most common capital budgeting techniques used to assess projects. The project manager is also keen to examine a detailed comparison of GR1 and GR2 projects with regards to the outcomes of applicable capital budgeting methods using both 13 and 20 percent required rates, crossover rate, and any other factors that can aid in taking a final decision. Required: Table of cash flow Cusing Excel) and show Excel Formulae and comment on each project.
Expert Answer:
Answer rating: 100% (QA)
To create the cash flow tables in Excel follow these steps Open Microsoft Excel In the first column list the years from 0 to 10 representing the proje... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
Can you create a meme for me using a communication concept?
-
You must prepare a Statement of Advice (SoA) that addresses all the questions raised in the letter on the following three pages of this document. Assume that you are a team of graduate accountants...
-
In Exercises 2324, find the standard form of the equation of each hyperbola satisfying the given conditions. Foci: (0, -4), (0, 4); Vertices: (0, -2), (0, 2)
-
At the beginning of 2018, the new CEO of Optimus Ltd. introduced two new initiatives to improve the company's performance. First of all, she introduced "blowout" sales offering prices at deep...
-
The following is a record of Cannondale Companys transactions for Boston Teapots for the month of May 2015. Instructions (a) Assuming that perpetual inventories are not maintained and that a physical...
-
A penstock supplies water to Pelton turbine with a head of \(80 \mathrm{~m}\). One-third of head is lost in penstock due to friction. The flow rate of water from the nozzle is \(2.5 \mathrm{~m}^{3} /...
-
A company working on a 75 percent learning curve has decided that the production standard should be 85 hours of production for the 100th unit. How much time should be required for the first unit? If...
-
Suppose that the supply curve of serving in the military is S(P) = P, where Q = S(P) is several hours employed in military service a day. There are only mercenaries in the army (there is no draft). P...
-
Please answer! 3 points A T-bill that is 210 days from maturity is selling for $97,000. The T-bill has a face value of $100,000. 1. Calculate the discount yield. 2. Calculate the bond equivalent...
-
How does Vistera use ML/AI to improve brick-and-mortar retail using image stockouts recognition technology and automated visual analytics. a. Discuss Vistera's ML/AI process or factory b. How do...
-
You are the Financial Director of Harambee Ltd ("Haramboo) Harambee is a listed company on the Namibian Stock Exchange with 100 000 ordinary shares issued at 30 June 2019 and 20 000 10% cumulative,...
-
Based on the information provided pls answer the following questions: ? 1. What was the amount of total assets for RFC on December 31, 2013? 2. What was the amount of net income for RFC for fiscal...
-
Discuss the key features of the following associated with the financial service industry: Financial products and services of the organisation Financial agency agreements Financial industry codes of...
-
Perform research on financial service institutions in your geographic area. Describe in detail the financial services that each provides, comparing interest rates, fees, and investment options. Which...
-
Hoping to increase sales, Festival Cruises began advertising for a Valentines Day Cruise package which the cruise liner guarantees to be the most romantic experience of you and your partners entire...
-
MgO prevents premature evaporation of Al in a furnace by maintaining the aluminum as Al2O3. Another type of matrix modifier prevents loss of signal from the atom X that readily forms the molecular...
-
Take-a-Break Travel Company offers spring break travel packages to college students. Two of its packages, a seven-day, six-night trip to Cancun and a five-day, four-night trip to Jamaica, have the...
-
Montross Seating manufactures desk chairs for commercial distribution. Each chair is produced at a cost of $15 and sold for $25. What is the contribution margin ratio for desk chairs?
-
The company for which you work recently implemented time-driven activity-based costing (TDABC) in conjunction with its ERP system. Management is pleased with the revised product and customer cost...
-
Consider the wage equation, where WAGE is measured in dollars per hour, education and experience are in years, and \(M E T R O=1\) if the person lives in a metropolitan area. Use the data file cps 5...
-
The data file \(b r 2\) contains data on 1080 houses sold in Baton Rouge, Louisiana, during mid-2005. We will be concerned with the selling price (PRICE), the size of the house in square feet (SQFT),...
-
In this exercise we explore the relationship between total household expenditures and expenditures on telephone services. Use the data file malawi_small (malawi has more observations). a. Using...
Study smarter with the SolutionInn App