an investment under consideration has a payback of six years and a cost of 885000. Assume the cash flows are conventional. If the required return is 12% what is the worst case NPV. Please use excel when showing how you got ther

Assume a company is going to make an investment of $300,000 in a machine and the following are the cash flows that two different products would bring in years one through four. The company's required rate of return is 12%. What is the NPV for Option A?  What is the NPV for Option B?  What is the IRR for Option A?  What is the IRR for Option B?  PLEASE NOTE #1: The dollar amounts will be with "$" and commas as needed and rounded to two decimal places (i.e. $12,345.67). Round your IRR answers, in percentage format, to two decimal places (i.e. 12.34%).  Given the above answers, which project should the company invest in? Project  . PLEASE NOTE #2: Your answer is either "A" or "B" - capital letter, no quotes.

Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000

Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 14.5%. The study period needs to be exactly 8 years and each year should have at least one unique cash flow that is different from the cash flows over the other years. Your answer should contain a table showing the cash flows for each year and a graphical representation of the cash flows (cash-flow diagram).

A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows:    Year Cash Flow 0 –$ 29,000   1   13,000   2   16,000   3   12,000        What is the NPV for the project if the required return is 12 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)      At a required return of 12 percent, should the firm accept this project?   multiple choice 1 Yes No   What is the NPV for the project if the required return is 24 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)      At a required return of 24 percent, should the firm accept this project?   multiple choice 2 Yes No

(Present value of an uneven stream of payments) You are given three investment alternatives to analyze. The cash flows from these three investments are shown in the popup window: Assuming a discount rate of 16 percent, find the present value of each investment. a. What is the present value of investment A at 16 percent annual, discount rate? S (Round to the nearest cènt.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) INVESTMENT B END OF YEAR 1 23456TBLG 7 8 9 10 A $18,000 18,000 18,000 18,000 18,000 $18,000 18,000 18,000 18,000 18,000 18,000 C $18,000 90,000 18,000 -

A firm evaluates all of its projects by applying the IRR rule. A project under consideration has the following cash flows: Year Cash Flow 0 $27,700 1 11,700 14,700 3 10,700 If the required return is 18 percent, what is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR % Should the firm accept the project? Yes No

Problem #2: Consider an investment where the cash flows are: - $920.33 at time 1 = 0 (negative since this is your initial investment) S407 at time = 1 in years $222 at time = 2 in years $426 at time = 3 in years (a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the value of IRR found by Solver?

Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 11 percent, and that the maximum allowable payback and discounted payback statistics for your company are 3 and 3.5 years, respectively. Time: Cash flow: 0 1 3 4 -$233,000 $65,600 $83,800 $140, 800 $121,800 MIRR Use the MIRR decision rule to evaluate this project. Note: Do not round intermediate calculations and round your final answer to 2 decimal places. 5 $81,000 %

Find the modified internal rate of return (MIRR) for a proposed project costing $12,513. Assume that the appropriate cost of capital for projects of this risk level, at this company is 10.96%, and the estimated cash flows for the life of the project are found in the table below. (If you calculate an MIRR of 20.22% , please enter 20.22- do not include the % symbol, and use at least two decimal places). Year 1 $7,261 Year 2 $4,832 Year 3 $9,441.2 Year 4 $13,000 Year 5 $12,638