Please answes the questions 1 ,2,3,4,5,6,7
12-6] 12.55 Comparison of Capital Budgeting Techniques: Senultivity Analysis: Strategy Rob Roy Corporation has been using its present facilities at an annual full capacity of 10.000 units for the last 3 yeun. Still, the company is unable to keep pace with continuing demand for the product that is esti- mated to be 25.000 units annually. This demand level is expected to continue for at least another 4 years. To expand manufacturing capacity and take advantage of the demand, Rob Roy must acquire equipment costing S1.000.000. The equipment will double the current production quantity. This equipment has a useful life of 10 years and can be sold for $200.000 at the end of year 4 or 530.000 at the end of year 10. Analysis of current operating data provides the following information Per Unit $200 $97 10 Sales price Variable costs Manufacturing Marketing Fored costs: Manufacturing Other Pretax operating income $107 $45 25 70 177 $ 23 The fixed costs include depreciation expense of the current equipment. The new equipment will not change variable costs, but the firm will incur additional fixed manufacturing costs (excluding depreciation on the new machine) of $250,000 mually. The firm needs to spend an additional $200,000 in fired marketing costs per year for additional sales Rob Roy is in the 35% bax bracket. Management has set a minimum rate of return of 14 after-tax for all capital investments. Assume, for simplicity, that MACRS depreciation rules dones apply Required 1. Assume that the equipment will be depreciated over a year perind using the straight-line method. What effects will the new equipment have on after tas operating income in each of the 4 years? 2. What effect will the new equipment have after tax cash inflows in each of the 4 years? 3. Compute the proposed investment's payback period in years) under the assumption that after-tax cash inflows occur evenly throughout the year. (Round your answer to 2 decimal places.) 4. Compute the accounting (book) rate of retur (ARR) based on the average investmentRound your answer to 2 decimal places fes-148165 = 1480) 5. Compute the net present value (NPV) of the proposed investment. (Une both the built-in function in Excel (NPV). Round your answer to nearest Whole dollar) 6. Compute the internal rate of return (IRR) of the proposed investment using the built-in IRR function in Excel. Round your answer to 2 decinul places 7. Compute the modified internal rate of return (MIRR) of the proposal investment using the built-in MIRR function in Excel. Round your answer to 2 decimal places. In responding to this requirement, you might find the following sources to be helpful. https://support.office.com/en-us/search/results? querymir functionareas and/or http://www.journalofaccountancy.com/issues/2017/feb/ calculate-internal rate-of-return-in-excel.html) 8. Management has decided to invest in the new equipment but is unsure of the reliability of some of the estimates and as such as deed somewhat-it' questions. Treat each of the following two cases independently By how much can the unit variable con for units produced by the new equipment increase and still justify the purchase of the equipment (ie, have the investment penerate an after-tax IRR of exactly 145. its cost of capitaly Round your awer to 2 decimal places. (Hint: The present value annuity factor from Appendix C, Table 2 for 4 years, 14% is 2914) . The company is anticipating an increase in competition Management believes that, in response, it will have to reduce the selling price of the product. By how much can the firm decrease the per-unit selling price for all units sold) and still be able to justify the purchase of the new equipment Round
