$\backslash$table$[[,$Expected Value$],[$Projected base year price per bottle $($$$),$$ $5],[6$ projected base year sale quantity $(000),200,000],[7$ Expected Growth Rate in sale quantitiy,$10\%],[8$ COGS margin $($COGS$/$Sales$),67\mathrm{.}4\%],[9$ Variable Operating Expenses $($before depr.$)/$ Sales,$10\%],[10$ Fixed Operating Costs $($$$000),$$ $115],[11$ Initial investment in plant and equipment $($$$000),$$ $450,000],[12$ Depreciation Method,Straight Line$],[13$ Depreciable life of plant and equipment $($Years$),5],[14$ Tax Rate,$21\%],[15$ Project WACC,$13\mathrm{.}25\%]]$

$16$

$17$

$18$

$19$ Sales growth rates

$\backslash$table$[[20,$FCF Calculation $($ $$000),2023,2024,2025,2026,2027,2028],[21,$Revenues,,$$1,000,000,$$$1,100,000,$$$1,210,000,$$$1,331,000,$$$1,464,100],[22,$Less: Cost of goods sold,,$$674,000,$$$741,400,$$$815,540,$$$897,094,$$$986,803],[23,$Equals: Gross profit,,$$326,000,$$$358,600,$$$394,460,$$$433,906,$$$477,297],[24,4$ Less: Operating expenses before depreciation,,$$100,000,$$$110,000,$$$121,000,$$$133,100,$$$146,410],[,25$ Equals: EBIIDA,,$$226,000,$$$248,600,$$$273,460,$$$300,806,$$$330,887],[,26$ Less: Depreciation and amortization,,$$90,000,$$$180,000,$$$270,000,$$$360,000,$$$450,000],[,27$ Equals: EBIT,,$$136,000,$$$68,600\mathrm{.}00,$$$3,460\mathrm{.}00,-$$$59,194\mathrm{.}00,-$$$119,113,40],[,28$ Less: Tax,,$$107,440,$$$54,194\mathrm{.}00,$$$2,733\mathrm{.}40,-$ $$46,763\mathrm{.}26,-594,099\mathrm{.}59],[,29$ Equals: NI$,,$$$28,560,$$$14,406\mathrm{.}00,$$$726\mathrm{.}60,-$$$12\mathrm{.}430\mathrm{.}74,-$$$25,013\mathrm{.}81],[,30$ Plus: Depreciation,,$$197,440,$$$234,194\mathrm{.}00,$$$272,733\mathrm{.}40,$$$313,236\mathrm{.}74,$$$355,900\mathrm{.}41],[,31$ OCF,$ $(450,000\mathrm{.}00),$$$226,000,$$$248,600\mathrm{.}00,$$$273,460,00,$$$300,806\mathrm{.}00,$$$330,886\mathrm{.}60]]$

$\backslash$table$[[$Revenues$,,,$$$1,000,000,$$$1,100,000,$$$1,210,000,$$$1,331,000,$$$1,464,100],[$Less$.$ Cost of goods sold,,,$$674,000,$$$741,400,$$$815,540,$$$897,094,$$$986,803],[$Equals: Gross profit,,,$$326,000,$$$358,600,$$$394,460,$$$433,906,$$$477,297],[$Less: Operating expenses before depreciation,,,$$100,000,$$$110,000,$$$121,000,$$$133,100,$$$146,410],[$Equals: EBITDA,,,$$226,000,$$$248,600,$$$273,460,$$$300,806,$$$330,887],[$Less: Depreciation and amortization,,,$$90,000,$$$180,000,$$$270,000,$$$360,000,$$$450,000],[$Equals: EBIT,,,$$136,000,$$$68,600\mathrm{.}00,$$$3,460\mathrm{.}00,-$$$59,194\mathrm{.}00,-$$$119,113\mathrm{.}40],[$Less: Tax,,,$$107,440,$$$54,194\mathrm{.}00,$$$2,733\mathrm{.}40,-$$$46,763\mathrm{.}26,-$$$94,099\mathrm{.}59],[$Equals: NI$,,,$$$28,560,$$$14,406\mathrm{.}00,$$$726\mathrm{.}60,-$$$12,430\mathrm{.}74,$$$25,013\mathrm{.}81],[$Plus: Depreciation,,,$$197,440,$$$234,194\mathrm{.}00,$$$272,733\mathrm{.}40,$$$313,236\mathrm{.}74,$$$355,900\mathrm{.}41],[$OCF$,,(450,000\mathrm{.}00),$$$226,000,$$$248,600\mathrm{.}00,$$$273,460\mathrm{.}00,$$$300,806\mathrm{.}00$

$,$$$330,886\mathrm{.}60]]$

$\backslash$table$[[,],[$NPV$,$$$492,144\mathrm{.}07$

Find cash, accounting, and financial breakeven sales quantity by using goal seek in base year $(2024).$