Problem $12-49$: Basic$-$Capital Budgeting Techniques; No Taxes; Uniform Net Cash Flows; Spreadsheets $($page $526)[$LO $12-4,12-6]$ See textbook

Basic Capital Budgeting Techniques; No Taxes, Uniform Net Cash Inflows; Spreadsheets Bob Jensen Inc. purchased a $$650,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 $$150,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.

$1.$ The payback period $($in years$),$ under the assumption that the cash inflows occur evenly throughout the year. Round your answer to the nearest $1$ decimal place

$2.$ The assuming $($book$)$ rate of return is based on $($a$)$ initial investment and $($b$)$ average investment. Round both answers to $1$ decimal place $($e$.$g$.,13\mathrm{.}417\%=13\mathrm{.}4\%)$

$.$

$3.$ The net present value $($NPV$),$ rounded to the nearest whole dollar.

$4.$ The present value payback period of the proposed investment under the assumption that the cash inflows occur evenly throughout the year.

$5.$ The internal rate of return $($IRR$),$ rounded to $1$ decimal place $($e$.$g$.,5\mathrm{.}491\%=5\mathrm{.}5\%)$

$6.$ The modified internal rate of return $($MIRR$),$ rounded to the $1$ decimal place.