$\backslash$table$[[,,,,,,,,],[$Propect Lption I: Purchase Snappal,Beverage Lo$.,,,,,,,],[,,,,,,,,],[,,,,,,,,],[$Expansion Project Title,$\backslash$table$[[$Project Description and$],[$Details$]],\backslash$table$[[$Project Cost$],[$Initial$],[$Inyestment$]]],\backslash$table$[[$First Year$],[$Cash Flow$]],\backslash$table$[[$Annual$],[$Growth$],[$Rate $15],[$uears$!]],\backslash$table$[[$Expenses$],[$as a$],[$percentag$],[$e of$]],\backslash$table$[[$Payback$],[$Periad$]],$NPY$,$IRA$],[$Purchase of Snappal Beverage Com,$\backslash$table$[[$This would be a tolal$],[$acquisition of Snappal$],[$Beverage Company. This$],[$company manufactures a$],[$line of ice teas of various$],[$flavors and has a reputation$],[$of using the best materials$],[$on Earth for making their$],[$drinks$.$ It is an established$],[$company$,$ with owners$],[$looking to retire. They are$],[$willing to provide part time$],[$consulting for up to one year$],[$to anyone who buys the$]],$$$25,000000,$$$8500000,8\%,28\%,,,]]$

Calculation of Minimum Payback Period:

Years

NPV of Projected Cash Flows

$\backslash$table$[[,$Year O Cash Flow,$\backslash$table$[[$Year $1$Cast$],[$Flow$]],\backslash$table$[[$Year $2$ Cash$],[$Flow$]],\backslash$table$[[$Year $3$ Cash$],[$Flow$]],\backslash$table$[[$Year $4$ Cash$],[$Flow$]],\backslash$table$[[$Year $5],[$Cash Flow$]]],[\backslash$table$[[$Projected Fievenues at annual growit$],[$Projected Expenses at $28\%$ of Rever$]],,,,,,],[\backslash$table$[[$Aninual Cash Flows$],[$Discount rate for each year $(6\%)$