At Applebee’s, Presto tablets by E la Carte are being installed at every table.

Question

At Applebee’s, Presto tablets by E la Carte are being installed at every table. In total, Applebee’s will be purchasing 100,000 tablets. Customers will be able to pay their food bill and order appetizers and desserts using the tablets. The tablets are not replacing wait staff; wait staff will still take the orders for entrees. Applebee’s does not expect to reduce the work hours of its wait staff due to the tablet installation. By allowing customers to pay whenever they want using the tablets, it is expected that customers will be more satisfied, both with the ease and speed of payment. Diners are expected to get out the door faster with the new tablet payment method.

The tablets will also function as jukeboxes at individual tables since customers can select and pay for music tableside. In addition, customers will be able to play games on the tablets for a small fee.The

music and game sales revenue will be split between Applebee’s and E la Carte. In addition to the initial purchase price of the tablet hardware, Applebee’s will be paying E la Carte a subscription fee for the use and upkeep of the tablets. Data and assumptions Use the following assumptions for data for this exercise (all figures are assumptions only):

1. Each tablet has an initial purchase price of $250

2. The annual subscription fee per tablet is $50

3. Average revenue generated per day by each tablet is $1

4. Average number of days each tablet is in use each year is 360 days

5. Additional annual IT costs incurred for tablet integration into Applebee’s system is $225,000

6. The useful life of the tablets is four years.Ignore depreciation and taxes.

Questions

1. Calculate the NPV of the investment in the tablets using a discount rate of 6%.

2. Now calculate the NPV of the investment in the tablets using a discount rate of 12%.

3. Does this investment in the tablets appear to be a financially sound investment for Applebee’s? Why or why not?

4. Recalculate the NPV of the investment now using an estimated useful life for the tablets of three years instead of four years.

Assume a discount rate of 6%. What happens to the NPV

compared to when the useful life was assumed to be four years?

Does this investment still appear to be financially sound?

Explanation / Answer

Years 0 1 2 3 4 Revenue(split half)     18,000,000.00    18,000,000.00    18,000,000.00    18,000,000.00 Buying cost      25,000,000.00 subscription cost       5,000,000.00      5,000,000.00      5,000,000.00      5,000,000.00 IT Cost           225,000.00          225,000.00          225,000.00          225,000.00 Net (25,000,000.00)     12,775,000.00    12,775,000.00    12,775,000.00    12,775,000.00 at 6% PV ($25,000,000.00) $12,051,886.79 $11,369,704.52 $10,726,136.34 $10,118,996.55 at 6% 4 years NPV $19,266,724.20 As the NPV is positive, it is financially sound. at 6% 3 years NPV $9,147,727.65 As the NPV is still positive, it is financially sound. at12% PV ($25,000,000.00) $11,406,250.00 $10,184,151.79 $9,092,992.67 $8,118,743.45 at12% 4 years NPV $13,802,137.90 yes, even at 12%, the investemnt is sound as the NPV is positive

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.