Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve for orange cells using information provided in green cells, and include how you got the solution begin{tabular}{|c|c|c|c|c|c|c|c|} hline multicolumn{8}{|c|}{ Given } hline

Please solve for orange cells using information provided in green cells, and include how you got the solution image text in transcribed
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|c|}{ Given } \\ \hline Investment & \multicolumn{2}{|c|}{$4,000,000} & & & & & \\ \hline Plant life & & 5 & & & & & \\ \hline \multicolumn{8}{|l|}{ Salvage value } \\ \hline Vanable Cost % & \multirow{5}{*}{$} & \multirow{2}{*}{\begin{tabular}{r} 45% \\ 1,000,000 \end{tabular}} & & & & & \\ \hline Fixed operating cost & & & & & & & \\ \hline Tax rate & & \multirow{2}{*}{\begin{tabular}{l} 38% \\ 10% \end{tabular}} & & & & & \\ \hline Working capital & & & Change in revenues & & & & \\ \hline Required Rate of Return & & 15% & & & & & \\ \hline & & & & & & & \\ \hline \multicolumn{8}{|c|}{ Solution } \\ \hline & \multicolumn{7}{|c|}{ Year } \\ \hline & & 0 & 1 & 2 & 3 & 4 & 5 \\ \hline Salos volume & & & 1,000,000 & 1.500,000 & 3,000,000 & 3,500,000 & $2,000,000 \\ \hline Unit Price & & & 2.00 & 2.00 & 2.50 & 2.50 & 2.50 \\ \hline & & & & & & & \\ \hline \multicolumn{8}{|l|}{\begin{tabular}{l} Revenues \\ Variablo. Oporating Costs \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{\begin{tabular}{l} Variable Oporating Costs \\ Fixed Operating Costs \end{tabular}}} \\ \hline & & & & & & & \\ \hline \multicolumn{8}{|l|}{ Depreciation Expense } \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{\begin{tabular}{l} Net Operating Income \\ Less: Taxes \end{tabular}}} \\ \hline & & & & & & \multicolumn{2}{|c|}{\begin{tabular}{l} Less: Taxes \\ NOPAT \end{tabular}} \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{ Plus: Depreciation }} \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{ Less: CAPEX }} & \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{ Less: Working Capital }} & \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{ Free Cash Flow }} \\ \hline & & & & & & & \\ \hline \multirow{2}{*}{\multicolumn{8}{|c|}{\begin{tabular}{|l|} NPV \\ IRR \\ \end{tabular}}} \\ \hline & & & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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