Please answer parts 5 & 6 TABLE1 Present Value of $1 Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 13%…

FIRST GRADER essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.


Order a Similar Paper Order a Different Paper

Please answer parts 5 & 6


TABLE1 Present Value of $1 Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 20% 25% 30% 1 0.962 0.952 0.943 0.935 0.926 0917
Bob Jensen Inc. purchased a $1,000,000 machine to manufacture specialty taps for electrical equipment. Jensen expects to sell TABLE1 Present Value of $1 Periods 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 20% 25% 30% 1 0.962 0.952 0.943 0.935 0.926 0917 0.909 0.901 0.893 0.885 0.877 0.870 0.333 0.500 0.769 2 0.925 0.907 0.390 0.873 0.857 0.542 0.826 0.812 0.797 0.783 0.769 0.756 0.694 0.640 0.592 3 0.889 0.864 0.340 0.816 0.794 0.772 0.751 0.731 0.712 0.693 0.675 0.658 0.579 0.512 0.455 4 0.855 0.823 0.792 0.763 0.735 0.705 0683 0.659 0.636 0.613 0.592 0.572 0.482 0.410 0.350 5 0.822 0.784 0.747 0.713 0.681 0.650 0.621 0.593 0.567 0.543 0.519 0.497 0.402 0.328 0.269 6 0.790 0.746 0.705 0.666 0.630 0.596 0.564 0.535 0.507 0.400 0.456 0.432 0.335 0.262 0.207 7 0.760 0.711 0.665 0.623 0.583 0.547 0.513 0.482 0.452 0.425 0.400 0.376 0.279 0.210 0.159 S 0.731 0.677 0.627 0.582 0.540 0.502 0.467 0.434 0.404 0376 0.351 0.327 0.233 0.168 0.123 9 0.703 0.645 0.592 0.544 0.500 0.460 0.424 0.391 0.361 0.333 0.308 0.284 0.194 0.134 0.094 10 0.676 0.614 0.558 0.508 0.463 0.422 0.356 0.352 0.322 0.295 0.270 0.247 0.162 0.107 0.073 11 0.650 0.585 0.527 0.475 0.429 0.385 0.350 0.317 0.287 0.261 0.237 0.215 0.135 0.036 0.056 12 0.625 0.557 0.497 0.444 0.397 0.356 0.319 0.256 0.257 0.231 0.208 0.187 0.112 0.069 0.043 13 0.601 0.530 0.469 0.415 0.368 0.326 0.290 0.25% 0.229 0.204 0.192 0.163 0.093 0.055 0.033 14 0.577 0.505 0.442 0.385 0.340 0.299 0.263 0.232 0.205 0.181 0.160 0.141 0.078 0.044 0.025 15 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.209 0.183 0.160 0.140 0.123 0.065 0.035 0.020 16 0.534 0.458 0.394 0.339 0.292 0.252 0.215 0.15 0.163 0.141 0.123 0.107 0.054 0.028 0.015 17 0.513 0.436 0.371 0.317 0.270 0.231 0.19 0.170 0.146 0.125 0.108 0.093 0.045 0.023 0.012 18 0.494 0.416 0.350 0.296 0.250 0.212 0.180 0.153 0.130 0.111 0.095 0.081 0.038 0.018 0.009 190.475 0.396 0.331 0.277 0.232 0.194 0.164 0.13 0.116 0.098 0.083 0.070 0.031 0.014 0.007 20 0.456 0.377 0.312 0.258 0.215 0.178 0.149 0.124 0.104 0.087 0.073 0.061 0.026 0.012 0.005 0.422 0.342 0.278 0.226 0.184 0.150 0.123 0.101 0.083 0.068 0.056 0.046 0.018 0.007 0.003 24 0.390 0.310 0.247 0.197 0.158 0.126 0.102 0. 02 0.066 0.053 0.043 0.035 0.013 0.005 0.002 25 0.375 0.295 0.233 0.184 0.146 0.116 0.092 0.074 0.059 0.047 0.038 0.030 0.010 0004 0.001 30 0.308 0.231 0.174 0.131 0.099 0.075 0.057 0.044 0.033 0.026 0.020 0,015 0,004 0.001 0.000 35 0.253 0.181 0.130 0.094 0.068 0.049 0.036 0.026 0.019 0.014 0.010 0.008 0.002 0.000 0.000 40 0.205 0.142 0.097 0.067 0.046 0.032 0.022 0.015 0.011 0.008 0.005 0.004 0.001 0.000 0.000 Note: The present value (PV) factor for periods and cater per period (rounded 1 (1+) For example, the PV factor for 10%. 5 years = 1 + ( + 0.10 0.631 Bob Jensen Inc. purchased a $1,000,000 machine to manufacture specialty taps for electrical equipment. Jensen expects to sell all it can manufacture in the next 10 years. To encourage capital investments, the government has exempted taxes on profits from new investments. This legislation is to be in effect for the foreseeable future. The machine is expected to have a 10-year useful life with no salvage value. Jensen uses straight-line depreciation. The net cash inflow is expected to be $230,000 each year for 10 years. Jensen uses a 12% discount rate in evaluating capital investments. Assume, for simplicity, that MACRS depreciation rules do not apply. Required: Using Excel (including built-in functions for NPV, IRR, and MIRR), compute the following for the above-referenced investment: 1. The payback period, under the assumption that cash inflows occur evenly throughout the year. (Do not round intermediate calculations. Round your final answer to 1 decimal place.) 2. The accounting (book) rate of return based on (a) initial investment, and (b) average investment. (Round your final answers to 1 decimal place.) 3. The net present value (NPV) of the proposed investment under the assumption that cash inflows occur at year-end. (Do not round intermediate calculations. Round your final answer to nearest whole dollar amount.) 4. The present value payback period, in years, of the proposed investment under the assumption that cash inflows occur evenly throughout the year. (Note: because of this assumption, the present value calculations will be approximate, not exact.) To calculate present value amounts, use the appropriate factors from Appendix C. Table 1. (Do not round Intermediate calculations. Round your final answer to 1 decimal place.) 5. The internal rate of return (IRR) (Do not round intermediate calculations. Round your final answer to 1 decimal place.) 6. The modified Internal rate of return (MIRR) (Do not round Intermediate calculations. Round your final answer to 1 decimal place.) (in conjunction with this requirement, you might want to consult either of the following two references: MIRR Function and/or IRR in Excel) 1 Unadjusted payback period 2a ARR based on initial investment 2b. ARR based on average Investment 3. NPV 4. Present value payback period 5. Internal rate of return (IRR) 6. Modified internal rate of return (MIRR)

Got stuck with another paper? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order


Order a Similar Paper Order a Different Paper
Writerbay.net