Question
Problem 12-49 (Algo) Basic Capital Budgeting Techniques; No Tax Spreadsheets [LO 12-4, 12-61 Bob Jensen Incorporated purchased a $800,000 machine to manufacture specialty ta sell
Problem 12-49 (Algo) Basic Capital Budgeting Techniques; No Tax Spreadsheets [LO 12-4, 12-61 Bob Jensen Incorporated purchased a $800,000 machine to manufacture specialty ta sell all it can manufacture in the next 10 years. The machine is expected to have a 10-y uses straight-line depreciation. The net cash inflow is expected to be $184,000 each y rate in evaluating capital investments. Assume, for simplicity, that MACRS depreciation Required: Using Excel (including built-in functions for NPV, IRR, and MIRR), compute the following 1. The payback period, under the assumption that cash inflows occur evenly throughout calculations. Round your final answer to 1 decimal place.) 2. The accounting (book) rate of return based on (a) initial investment, and (b) average in decimal place (i.e. 0.123 = 12.3%).) 3. The net present value (NPV) of the proposed investment under the assumption that c 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 ass throughout the year. (Note: because of this assumption, the present value calculations w present value amounts, use the appropriate factors from Appendix C. Table 1. (Do not ro final answer to 1 decimal place.) 5. The internal rate of return (IRR). (Do not round intermediate calculations. Round your 12.3%).) 6. The modified internal rate of return (MIRR). (Do not round intermediate calculations. F (i.e. 0.123 = 12.3%).) (In conjunction with this requirement, you might want to consult eithe **
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started