PLEASE USE EXCEL AND SHOW FORMULAS. THANK YOU IN ADVANCE************

Sparkling Water, Inc., expects to sell 3.7 million bottles of drinking water each year in perpetuity. This year each bottle will sell for $1.46 in real terms and will cost $.82 in real terms. Sales income and costs occur at year-end. Revenues will rise at a real rate of 1.3 percent annually, while real costs will rise at a real rate of 1.2 percent annually. The real discount rate is 8 percent. The corporate tax rate is 23 percent. What is the company worth today? (Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to the nearest whole number, e.g., 1,234,567.) Value of the firm