Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

show work and excel formula bars begin{tabular}{|c|c|c|c|c|c|c|c|} hline 3 & & & & & & & hline 4 & Marketing Survey & $11,800 &

show work and excel formula bars image text in transcribed
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 3 & & & & & & & \\ \hline 4 & Marketing Survey & $11,800 & & & & & \\ \hline 5 & Year 1 Revenue & $214,000 & & & & & \\ \hline 6 & Sales growth rate & 1.75% & & & & & \\ \hline 7 & variable costs ( % of revenue) & 60% & & & & & \\ \hline 8 & NWCYearo & $43,000 & & & & & \\ \hline 9 & Initial Investment & $207,000 & & & & & \\ \hline 10 & Yea 5: equipment & $98,000 & & & & & \\ \hline 11 & Tax & 22% & & & & & \\ \hline 12 & R & 14% & & & & & \\ \hline 13 & & & & & & & % \\ \hline 14 & & & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ \hline 15 & Sales & & $214,000.00 & $217,745.00 & $221,555.54 & $225,432.76 & $229,377.83 \\ \hline 16 & Variable costs & & $128,400,00 & $130,647.00 & $132,933.32 & $135,259.66 & $137,626.70 \\ \hline 17 & depreciation & & $20,700.00 & $20,700.00 & $20,700.00 & $41,400.00 & $41,400.00 \\ \hline 18 & EBIT & & $64,900.00 & $66,398.00 & $67,922.22 & $48,773.10 & $50,351.13 \\ \hline 19 & Tax & & $14,278.00 & $14,607.56 & $14,942.89 & $10,730.08 & $11,077.25 \\ \hline 20 & NI & & $50,622.00 & $51,790.44 & $52,979.33 & $38,043.02 & $39,273.88 \\ \hline 21 & OCF & & $71,322,00 & $72,490,44 & $73,679.33 & $79,443.02 & $80,673.88 \\ \hline 22 & & & & & & & \\ \hline 23 & & & & & & & \\ \hline 24 & & Year 0 & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ \hline 25 & Initial Investment & & & & & & \\ \hline 26 & Investment in NWC & & & & & & \\ \hline 27 & OCF & & & & & & \\ \hline 28 & Terminal CF & & & & & & \\ \hline 29 & Project of & & & & & & \\ \hline 30 & - & & & & & & \\ \hline 31 & & & & & & NPV & \\ \hline 32 & 3 & & & & & IRR & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 3 & & & & & & & \\ \hline 4 & Marketing Survey & $11,800 & & & & & \\ \hline 5 & Year 1 Revenue & $214,000 & & & & & \\ \hline 6 & Sales growth rate & 1.75% & & & & & \\ \hline 7 & variable costs ( % of revenue) & 60% & & & & & \\ \hline 8 & NWCYearo & $43,000 & & & & & \\ \hline 9 & Initial Investment & $207,000 & & & & & \\ \hline 10 & Yea 5: equipment & $98,000 & & & & & \\ \hline 11 & Tax & 22% & & & & & \\ \hline 12 & R & 14% & & & & & \\ \hline 13 & & & & & & & % \\ \hline 14 & & & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ \hline 15 & Sales & & $214,000.00 & $217,745.00 & $221,555.54 & $225,432.76 & $229,377.83 \\ \hline 16 & Variable costs & & $128,400,00 & $130,647.00 & $132,933.32 & $135,259.66 & $137,626.70 \\ \hline 17 & depreciation & & $20,700.00 & $20,700.00 & $20,700.00 & $41,400.00 & $41,400.00 \\ \hline 18 & EBIT & & $64,900.00 & $66,398.00 & $67,922.22 & $48,773.10 & $50,351.13 \\ \hline 19 & Tax & & $14,278.00 & $14,607.56 & $14,942.89 & $10,730.08 & $11,077.25 \\ \hline 20 & NI & & $50,622.00 & $51,790.44 & $52,979.33 & $38,043.02 & $39,273.88 \\ \hline 21 & OCF & & $71,322,00 & $72,490,44 & $73,679.33 & $79,443.02 & $80,673.88 \\ \hline 22 & & & & & & & \\ \hline 23 & & & & & & & \\ \hline 24 & & Year 0 & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ \hline 25 & Initial Investment & & & & & & \\ \hline 26 & Investment in NWC & & & & & & \\ \hline 27 & OCF & & & & & & \\ \hline 28 & Terminal CF & & & & & & \\ \hline 29 & Project of & & & & & & \\ \hline 30 & - & & & & & & \\ \hline 31 & & & & & & NPV & \\ \hline 32 & 3 & & & & & IRR & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions