Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) Mandel Manufacturing,

image text in transcribedimage text in transcribed

(Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) Mandel Manufacturing, Inc. has a manufacturing machine that needs attention. i (Click the icon to view additional information.) Mandel expects the following net cash inflows from the two options: E (Click the icon to view the net cash flows.) Mandel uses straight-line depreciation and requires an annual return of 10%. (Click the icon to view Future Value of $1 table.) (Click the icon to view Future Value of Ordinary Annuity of $1 table.) Data Table - Requirement 1. Compute the payback, the ARR, the NPV, and the profitability index of these two options. Compute the payback for both options. Begin by completing the payback schedule for Option 1 (refurbish). Net Cash Outflows Net Cash Inflows Refurbish Current Machine Purchase New Machine Year Year Amount Invested Annual Accumulated Year 1 $ 3,990,000 0 $ 1,400,000 Year 2 1 $ 690,000 Year 3 2 310,000 Year 4 3 250,000 690,000 $ 310,000 250,000 190,000 130,000 130,000 130,000 130,000 430,000 370,000 310,000 250,000 250,000 250,000 Year 5 190,000 Year 6 130,000 Year 7 130,000 Year 8 250,000 7 130,000 Year 9 8 130.000 250,000 250,000 Year 10 Enter any number in the edit fields and then click Check Answer. 1,960,000 $ 6,600,000 Total - x Reference More Info The company is considering two options. Option 1 is to refurbish the current machine at a cost of $1,400,000. If refurbished, Mandel expects the machine to last another eight years and then have no residual value. Option 2 is to replace the machine at a cost of $4,400,000. A new machine would last 10 years and have no residual value. two options. 1 (refurbish). Print Done Year Amount Invested Annual Accumulated Requirements Present Value of $1 Periods 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 15% 16% 18% 20% Period 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.893 0.877 0.870 0.862 0.847 0.833 Period 2 0.980 0.961 0.943 0.925 0.907 0.890 0.873 0.857 0.8420.826 0.797 0.769 0.756 0.743 0.718 0.694 Period 3 0.971 0.942 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.712 0.675 0.658 0.641 0.609 0.579 Period 4 0.961 0.924 0.888 0.855 0.823 0.792 0.763 0.735 0.708 0.683 0.636 0.592 0.572 0.5520.516 0.482 Period 5 0.951 0.906 0.863 0.822 0.784 0.747 0.713 0.681 0.650 0.621 0.567 0.519 0.497 0.476 0.437 0.402 Period 6 0.942 0.888 0.837 0.790 0.746 0.705 0.666 0.630 0.596 0.564 0.507 0.456 0.432 0.410 0.370 0.335 Period 7 0.933 0.871 0.813 0.760 0.711 0.665 0.623 0.583 0.547 0.513 0.452 0.400 0.376 0.354 0.3140.279 Period 8 0.923 0.853 0.789 0.731 0.677 0.627 0.582 0.540 0.502 0.467 0.404 0.351 0.327 0.305 0.266 0.233 Period 9 0.914 0.837 0.766 0.703 0.6450.592 0.544 0.500 0.460 0.424 0.361 0.308 0.284 0.263 0.225 0.194 Period 10 0.905 0.820 0.744 0.676 0.614 0.558 0.508 0.463 0.422 0.386 0.322 0.270 0.247 0.227 0.191 0.162 Period 11 0.896 0.804 0.722 0.650 0.585 0.527 0.475 0.429 0.388 0.350 0.287 0.237 0.215 0.195 0.162 0.135 Period 12 0.887 0.788 0.701 0.625 0.557 0.497 0.444 0.397 0.356 0.319 0.257 0.208 0.187 0.168 0.137 0.112 Period 13 0.879 0.773 0.681 0.601 0.530 0.469 0.415 0.326 0.290 0.229 0.182 0.163 0.145 0.116 0.093 Period 14 0.870 0.758 0.661 0.577 0.505 0.442 0.388 0.340 0.299 0.263 0.205 0.160 0.141 0.125 0.099 0.078 Period 15 0.861 0.743 0.642 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.183 0.140 0.123 0.108 0.084 0.065 Period 16 0.853 0.728 0.623 0.534 0.458 0.394 0.339 0.292 0.252 0.218 0.163 0.123 0.107 0.093 0.071 0.054 Period 17 0.844 0.714 0.605 0.513 0.436 0.371 0.317 0.270 0.231 0.1980.146 0.108 0.093 0.080 0.060 0.045 Period 18 0.836 0.700 0.587 0.494 0.416 0.350 0.296 0.212 0.180 0.130 0.095 0.081 0.069 0.051 0.038 Period 19 0.828 0.686 0.570 0.475 0.396 0.331 0.277 0.232 0.194 0.164 0.116 0.083 0.070 0.060 0,043 0.031 Period 20 0.820 0.673 0.554 0.456 0.377 0.312 0.258 0.215 0.178 0.149 0.073 0.061 0.051 0.037 0.026 Period 21 0.811 0.660 0.538 0.439 0.359 0.294 0.242 0.199 0.164 0.135 0.093 0.064 0.053 0.044 0.031 0.022 Period 22 0.803 0.647 0.522 0.422 0.342 0.278 0.226 0.184 0.150 0.123 0.0830.056 0.046 0.038 0.026 0.018 0.368 1. Compute the payback, the ARR, the NPV, and the profitability index of these two options Which option should Mandel choose? Why? 2. 0.250 Print Done 0.104 Enter any number in the edit fields and then click Check Answer. Print Done 8 parts remaining

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

Managerial Accounting Information For Decisions

Authors: Thomas L. Albright , Robert W. Ingram, John S. Hill

4th Edition

0324222432, 978-0324222432

More Books

Students also viewed these Accounting questions

Question

In Deep Reinforcement Learning, what are backup diagrams?

Answered: 1 week ago

Question

2. What appeals processes are open to this person?

Answered: 1 week ago

Question

4. How would you deal with the store manager?

Answered: 1 week ago