Answered step by step
Verified Expert Solution
Question
1 Approved Answer
9. Please go back to the original spreadsheet numbers. As an alternative before beginning this project, the company can reduce the initial outlay by $300,000.
9. Please go back to the original spreadsheet numbers. As an alternative before beginning this project, the company can reduce the initial outlay by $300,000. This would increase the variable costs to 50% of sales and decrease the disposition value to $400,000. What is the new net present value____________, and the new net present value breakeven level of sales___________, and would this be a good move for the company?
Please answer using Excel.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline Years & 0 & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline \multicolumn{10}{|l|}{ Acquisition stage cash flow: } \\ \hline Initial Outlay & (800,000) & & & & & & & & \\ \hline \multicolumn{10}{|l|}{ Operating stage cash flow: } \\ \hline Sales & & 600,000 & 600,000 & 600,000 & 600,000 & 600,000 & 600,000 & 600,000 & 600,000 \\ \hline Fixed Cost & & (220,000) & (220,000) & (220,000) & (220,000) & (220,000) & (220,000) & (220,000) & (220,000) \\ \hline Variable Cost & & (240,000) & (240,000) & (240,000) & (240,000) & (240,000) & (240,000) & (240,000) & (240,000) \\ \hline Depreciation expense & & (68,000) & (68,000) & (68,000) & (68,000) & (68,000) & (68,000) & (68,000) & (68,000) \\ \hline Taxable income & & 72,000 & 72,000 & 72,000 & 72,000 & 72,000 & 72,000 & 72,000 & 72,000 \\ \hline Taxes & & (20,160) & (20,160) & (20,160) & (20,160) & (20,160) & (20,160) & (20,160) & (20,160) \\ \hline After tax income & & 51,840 & 51,840 & 51,840 & 51,840 & 51,840 & 51,840 & 51,840 & 51,840 \\ \hline Add back depreciation & & 68,000 & 68,000 & 68,000 & 68,000 & 68,000 & 68,000 & 68,000 & 68,000 \\ \hline Operating cash flows & & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 \\ \hline Disposition stage cash flow: & & & & & & & & & 500,000 \\ \hline Total cash flow & (800,000) & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 619,840 \\ \hline Present Value & 872,591 & & & & & & & & \\ \hline Net Present Value & 72,591 & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline Years & 0 & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline \multicolumn{10}{|l|}{ Acquisition stage cash flow: } \\ \hline Initial Outlay & (800,000) & & & & & & & & \\ \hline \multicolumn{10}{|l|}{ Operating stage cash flow: } \\ \hline Sales & & 600,000 & 600,000 & 600,000 & 600,000 & 600,000 & 600,000 & 600,000 & 600,000 \\ \hline Fixed Cost & & (220,000) & (220,000) & (220,000) & (220,000) & (220,000) & (220,000) & (220,000) & (220,000) \\ \hline Variable Cost & & (240,000) & (240,000) & (240,000) & (240,000) & (240,000) & (240,000) & (240,000) & (240,000) \\ \hline Depreciation expense & & (68,000) & (68,000) & (68,000) & (68,000) & (68,000) & (68,000) & (68,000) & (68,000) \\ \hline Taxable income & & 72,000 & 72,000 & 72,000 & 72,000 & 72,000 & 72,000 & 72,000 & 72,000 \\ \hline Taxes & & (20,160) & (20,160) & (20,160) & (20,160) & (20,160) & (20,160) & (20,160) & (20,160) \\ \hline After tax income & & 51,840 & 51,840 & 51,840 & 51,840 & 51,840 & 51,840 & 51,840 & 51,840 \\ \hline Add back depreciation & & 68,000 & 68,000 & 68,000 & 68,000 & 68,000 & 68,000 & 68,000 & 68,000 \\ \hline Operating cash flows & & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 \\ \hline Disposition stage cash flow: & & & & & & & & & 500,000 \\ \hline Total cash flow & (800,000) & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 119,840 & 619,840 \\ \hline Present Value & 872,591 & & & & & & & & \\ \hline Net Present Value & 72,591 & & & & & & & & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started