Capital Investment Decisions for Magnificent Modems, Inc.
Not what you're looking for?
Magnificent Modems, Inc. (MMI), has several capital investment opportunities. The term, expected annual cash inflows, and the cost of each opportunity are outlined in the following table. MMI has established the desired rate of return of 16 percent for these investment opportunities.
Opportunity A B C D
Investment term 4 years 5 years 3 years 5 years
Expected cash inflow $ 6,000 $ 5,000 $ 8,000 $ 4,800
Cost of investment $16,000 $15,000 $18,000 $16,000
Required
a. Compute the net present value of each investment opportunity manually using the present value tables. Record your answers in the following table. The results for Investment Opportunity A have been recorded in the table as an example.
Opportunity A B C D
Cash inflow $6,000.00 $5,000.00 $8,000.00 $4,800.00
Times present value factor $2.798181
Present value of cash flows $16,789.09
Minus cost of investment ($16,000.00) ($15,000.00) ($18,000.00) ($16,000.00)
Net present value $789.09
b. Use Excel spreadsheet software or a financial calculator to determine the net present value and the internal rate of return for each investment opportunity. Record the results in the following table. The results for investment Opportunity A have been recorded in the following table as an example. Note that the manual computation yields the same net present value amounts as the financial function routines of Excel or a financial calculator.
Opportunity A B C D
Net present value $789.09
Internal rate of return 18.45%
c. What is meant by the expression, time value of money? Why should all capital investment proposals include time value of money (present value) calculations of future cash flows that are to be received from the alternative investments?
Purchase this Solution
Solution Summary
The solution is given as a Word document report with an attached Excel spreadsheet that shows how to calculate the net present value and internal rates of return as well as explaining what the time value of money means.
Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations