Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the spreadsheet provided, please run the following sensitivities: Please take sales up to $630,000 and down to $570,000 (up by 5% and down by

image text in transcribed

Using the spreadsheet provided, please run the following sensitivities:

  1. Please take sales up to $630,000 and down to $570,000 (up by 5% and down by 5%) and record the new net present value numbers.

  1. Returning to the original numbers, please take disposition value up to $525,000 and down to $475,000 (up by 5% and down by 5%) and record the new net present value numbers.

  1. Returning to the original numbers, please take variable costs up for all years to 42% and down to 38% (up by 5% and down by 5%) and record the new net present value numbers.

  1. Returning to the original numbers, please take fixed costs up for all years to $231,000 and down to $209,000 (up by 5% and down by 5%) and record the new net present value numbers.

  1. Returning to the original numbers, please take the tax rate to up to 29.4% and down to 26.6% (up by 5% and down by 5%) and record the new net present value numbers.

  1. Returning to the original numbers, please take the weighted average cost of capital for this project up to 10.5% and down to 9.5% (up by 5% and down by 5%) and record the new net present value numbers.

  1. From the answer to the prior six problems using the resulting range of outcome after making the 5% changes to the variables, which variable has the greatest influence on the net present value of this project?

  1. 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?

  1. 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?

  1. Going back to the prior two problems which of these alternatives is better for the company? The original method, the modification suggested in problem 8, or the modification in problem 9? Why?
0 1 2 3 4 5 6 7 8 Years Acquisition stage cash flow: Initial Outlay (800,000) Operating stage cash flow: Sales Fixed Cost Variable Cost Depreciation expense Taxable income Taxes After tax income Add back depreciation Operating cash flows 600,000 (220,000) (240,000) (68,000) 72,000 (20,160) 51,840 68,000 119,840 600,000 600,000 600,000 (220,000) (220,000) (220,000) (240,000) (240,000) (240,000) (68,000) (68,000) (68,000) 72,000 72,000 72,000 (20,160) (20,160) (20,160) 51,840 51,840 51,840 68,000 68,000 68,000 119,840 119,840 119,840 600,000 600,000 (220,000) (220,000) (240,000) (240,000) (68,000) (68,000) 72,000 72,000 (20,160) (20,160) 51,840 51,840 68,000 68,000 119,840 119,840 600,000 600,000 (220,000) (220,000) (240,000) (240,000) (68,000) (68,000) 72,000 72,000 (20,160) (20,160) 51,840 51,840 68,000 68,000 119,840 119,840 Disposition stage cash flow: 500,000 119,840 119,840 119,840 119,840 119,840 119,840 119,840 619,840 Total cash flow Present Value Net Present Value (800,000) 872,591 72,591

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_2

Step: 3

blur-text-image_3

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

New Principles Of Best Practice In Clinical Audit

Authors: Robin Burgess

2nd Edition

1138443646, 978-1138443648

More Books

Students also viewed these Accounting questions