Question needing answered: What are the operating cash flows in years 1 through 10 - adjusted for taxes and depreciation?

The Hydro Company, "HC", recently discovered a unique and very large aquifer in Florida that contains naturally pure water via a well it drilled in 2022. The aquifer is home to a natural alkaline water (pH 8.3) containing amounts of calcium, magnesium, potassium, silica, and sodium ideal for human consumption with no undesired qualities or contaminants. The water is sourced from over 5,000 feet below the surface and has never been impacted by human activity, as the source has been sealed deep underground for over 400 million years. Florida state hydrologists have performed multiple studies to assess the scale of the aquifer, labeling it as a "new source of water" and expecting the aquifer to produce billions of gallons. The geologists also determined this to be the deepest source of artesian water in the country, and possibly the world. HC has hired you as a financial consultant to evaluate the feasibility and profitability of this business opportunity. Capital Expenditures: HC is evaluating whether to commercialize the aquifer by building a bottling facility near the well. This facility would allow the company to clean and bottle the water, label the bottles, prepare bottles into shippable cases, and ship bottles out of the facility. The company already owns 100 acres of land surrounding the well and believes the cost of building a bottling facility would require capital expenditures and net working capital totaling $56 million. The primary fixed assets, forecasted to cost $52 million, would be a 120,000 sq. ft facility and all the equipment necessary to get the plant operational. In addition to the equipment, HC estimates they would also require a $4 million infusion of net working capital. Product Segments: HC would have two distinct business segments: private label manufacturing and branded bottled water under the company's brand, "Hydro Homies". Private label manufacturing allows retailers, vendors, and other brands to sell a product under their own name. This way, large brands don't have to own manufacturing facilities, rather they can just purchase bottled water, juice, or even food from a private label manufacturer and slap their name on it. For example, Kroger, the American supermarket company sells bottled Kroger water in their stores. This water is actually sourced from a private label manufacturer, Niagara Water, who has bottling facilities all over the U.S. The company's second segment is their personal water bottle brand, "Hydro Homies". These bottles would be marketed and sold to individuals all over the U.S. found in gas stations, convenience stores, Market: The bottled water market is highly competitive, with many brands competing for market share. Consumers are becoming increasingly concerned about the quality and safety of the water they drink. Many bottled water brands are sourced from surface water, which contain contaminants such as tritium, PFOs/PFAs, and microplastics. These brands commonly treat and clean their water through a process called reverse osmosis, which removes beneficial minerals from the water and making it less healthy to drink. Reverse osmosis is popular with familiar brands like Essentia, Dasani, and Aquafina (which are all tap water!). Since HC's aquifer hasn't been exposed to the surface, the only treatment needed is an ultra-violet and ozonation process, deeming the water to be natural and healthy rather than overprocessed. This works well for HC's value proposition as consumers are looking for a natural, healthy, and pure source of water. Pricing: Given the high quality and healthy attributes of the water, HC believes their customers will pay a premium for "Hydro Homies" and plans on pricing each bottle at $3.00 per unit. As for private label manufacturing, because bottles will be sold in bulk, each unit will be sold at $2.00. To keep up with inflation, the company plans on increasing the price per unit of each segment by 2% per year. Production: HC believes once the bottling facility is up and running, they will be able to produce 5.25 million bottles per year at full capacity. 60% of these bottles will be allocated to private label manufacturing and the remaining 40% will be for "Hydro Homies". Given it will take management some time to understand how to become fully efficient, HC believes it will take 2 years until they realize full capacity production. For the first year, HC projects 50% utilization, 75% for the second year, and 100% for the following 8 years. Fixed costs are projected to be 35% of total revenue and variable costs at 20% of total revenue for the first two years. After HC understands how to efficiently run the plant at 100% capacity, assume variable costs HC will depreciate fixed assets based on a 10-year MACRS schedule and assume the project will last 10 years. At the end of the project, HC forecasts a market sale of all fixed assets at $20 million. In addition, the firm expects a 21% marginal tax rate. Financing: Lastly, assume that HC will raise all of the capital to finance this project using a blend of debt and equity, and intends to use a capital structure based on the following existing outstanding sources. As a result, you base your cost of capital assumptions on the following: - The firm currently has 220,000 bonds outstanding with the following terms: Remainingmaturity=15yearsCouponrate=5.40%(paidsemiannually)Price=$990Par=$1000 - The firm currently has 8,000,000 common shares outstanding with the following price and market terms: Price=$54Beta=1.15Risk-freeRate=1%Expectedreturnofthemarket=8% - The firm currently has 500,000 preferred stock outstanding with the following price and terms: Price =$72 - Par =$100 - Dividend yield =4% (paid annually)