Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. Please go back to the original spreadsheet numbers the original net present value is $72,591. Please run a net present value breakeven using this

image text in transcribed

8. Please go back to the original spreadsheet numbers the original net present value is $72,591. Please run a net present value breakeven using this original data and record the net present value level of sales here ___________. Prior to beginning this project, the company can increase the initial outlay by $150,000. This additional upfront acquisition stage cost would lower the variable costs to 30% of sales and increase the disposition value to $550,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 show work in 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}

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

Technical Analysis Of Stock Trends

Authors: Robert D. Edwards, John Magee

1st Edition

1607962233, 978-1607962236

More Books

Students also viewed these Finance questions

Question

Discuss the role of motivation in financial literacy.

Answered: 1 week ago