Autosave $$

N$17AAvv{f}_x$

Hola Kola $-$ The Valuation of the Zero$-$Calorie Soda Project

Scenario $1($Base Case$)$

Monthly Sales $($units$)$

Increase $($Decrease$)$ in Sales Volume

Unit Sale Price $($pesos$)$

Increase $($Decrease$)$ in Sales Pric

Unit Raw Material Cost $($pesos$)$

Increase $($Decrease$)$ in Raw Material Cost

Monthly Labor Costs $($pesos$)$

Increase $($Decrease$)$ in Direct Labor Costs

Monthly Energy Costs $($pesos$)$

Increase $($Decrease$)$ in Energy Costs

$6$ Year

Cost of New Equipment $($peses$)9$ Resale Value of Equipment $($pesos$)$

Less Taxes

$1$ Net Resale Value of Equipment $($pesos$)$

Working Capital Requirements $($pesos$)$

Receivables $(($Sales$/365)*$ Avg Collection Period$)$

Inventories $($One month materials costs$)$

$27$

$28$

Change in Working Capital Requirement $($pesos$)$

$1$ Annual Sales $($Units$)$

$32$ Annual Sales Revenue $($pesos$)$

$34$ Operating Expenses $($pesos$)$

Raw Material Costs

Direct Labor Cos

Energy Costs

Building Renta

General Administrat

Total Operating Expenses $($pesos$)$

Operating Profit Before Tax $($pesos$)$

Taxes $($pesos$)$

Operating Profit After Tax $($pesos$)$

Project's Operating Cash Flow $($pesos$)$

Depreciation $($pesos$)$

Erosion of Existing Sales $($pesos$)$

Choralng Flow $($pesos$)$

Project's Free Cash Flow $($pesos$)$

Present Value of Cash Flow $($pesos$)$

NPV $($pesos$)$

IRR

Payback Period $($Years$)$

Profitability Index

$4$ Sheet$1$

Ready $,$ ix ${?}^2$ Accessibility: Investigate

esc

$2$

$3$

$5$

Cost of New Equipment $($pesos$)$

Resale Value of Equipment $($pesos$)$

$[\frac{?}{?}\%$ Overhead $to$ Sales $],[$ Building Rental $(pesos)],[$ Average Collection Period $(Days)],[$ Average Payment Period $(Days)],[$ Years $of$ Straight$-$line Depreciation $],[$ Cost $of$ Capital $],[$ Tax Rate $],[$ Erosion $(pesos)]$

$0$

$2$

G

H

$1$