"Please solve using Excel"

Uplansfdasdfasdfh

Lastly, your team needs to consider what you can do with the craft brewery after the project life is over. After brainstorming, you feel that there are $3$ possible outcomes after the $6$ years are up$.$ First, while the expected beverage sales are positive, there is the chance that the business does not go as expected and that your team can just cease operations after the project life. Second, you feel that if things go right, there is the possibility that you develop a good menu of craft beverages and an outside investor would want to purchase the craft brewery portion of your business. Lastly, there is the possibility that you simply continue operations, which you will value as a perpetuity when analyzing which option is best. The necessary assumptions are given below in Exhibit $4.$

Exhibit $4$: Terminal Options

Option A $$ Cease Operations Option B $$ Sell to Investor Option C $$ Continue Operations

Project ends after $6$th year. No future cash flows. Sell craft brewery operations to an outside investor for an estimated $$600,000$ at the end of the $6$th year. Capital gains rate is $15\%.$ Continue operations indefinitely after the $6$th year. Net operating profits after taxes is expected to grow $1\mathrm{.}5\%$ annually.

Your team is unsure about what the best option is and is hoping you can help them determine which one would add the most value to the business. Additionally, from your time in business school, you are aware that valuation techniques are very sensitive to the assump

"Please solve using Excel"