Tue Mar 19 7:40 PM
Home Insert Draw Page Layout Formulas Data Review View Automate \( \nabla \)
N. SOLVED: Fill this...
Q.
\[
\text { ation (CCA) UCF }=
\]
of Shipping and
f Sales * Sales per
\( \mathrm{C}= \) NOWC for Year 2 -
NOWC as \% of Sales)
\[
\mathrm{VC}=43,500-21,750
\]
WACC\( \cdot \) Investment
rate * Salvage Value Net
- Investment (chan
\[
00-21,750-2,610+16,250
\]
\begin{tabular}{|l|r|r|}
\hline Sales per year in units & 1,450 \\
\hline Price & \( \$ \) & 200 \\
\hline Fixed cost & \( \$ \) & 100,000 \\
\hline VC per unit & \( \$ \) & 75 \\
\hline Inflation Rate & \( 2.5 \% \) \\
\hline Cost of Machine & \( \$ \) & 200,000 \\
\hline Cost of Shipping and Installation & \( \$ \) & 40,000 \\
\hline Tax rate & & \( 35 \% \) \\
\hline Salvage Value & \( \$ \) & 25,000 \\
\hline CCA Rate & & \( 530 \% \) \\
\hline NOWC as \% of Sales & \( 15 \% \) \\
\hline WACC & & \( 8 \% \) \\
\hline Plant Space Rent & \( \$ \) & 25,000 \\
\hline
\end{tabular}
16
18
18
20
Revenue
Variable costs
Fixed costs
Depreciation (CCA)
EBIT
Tax at \( 35 \% \)
Net income (NOPAT)
OCF \( (\mathrm{NI}+ \) Dep. \( ) \)
Capital investment
NOWC
Investment (changes) in NOWC
Opportunity cost
Net Salvage Value
Net Cash Flow
Year
0
1
2
3
3
E
F
G
\( \mathrm{H} \)
36
CCA-Machinery
Amadeus (base case)
Enter \( \quad \) Accessibility: Investigate
