Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

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

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808