Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

More Books

Students also viewed these Accounting questions

Question

Identify the "always bar list" and the "presumption list."

Answered: 1 week ago

Question

2. Develop a persuasive topic and thesis

Answered: 1 week ago

Question

1. Define the goals of persuasive speaking

Answered: 1 week ago