Q2: A $15,000 investment is to be made with anticipated annual returns as shown in the spreadsheet in the below Figure. If the investor's time value of money is 10% per year, what should be entered in cells B11, B12, and B13 to obtain present, annual, and future equivalent values for the investment? Also draw the cash flow of this problem. A 1 EOY 7 8 10 11 12 13 0 1 2 6 7 P A B Cash flow -$15,000 $2,000 $2,500 $3,000 $1,500 $4,000 $4,000 $4,000 $4,000

Please correct answer thes question

5. LL Consider the following cash flows of a project: Year Year 1. 50 0. 2. 3. 4. 1. Find the internal rate of return for this investment. 0. 20. Multiple Choice < Prev 10 of 15 Next here to search F11 F12 F4 F5 69 81 9F-

Assume an investment is priced today at $5,000 and has the following income stream: Year Cash Flow 1 123 2 3 4 $ 1,000 - 2,000 3,000 3,000 Would an investor with a required rate of return of 15 percent be wise to invest at a price of $5,000? Multiple Choice No, because the investment has a net present value of - $1,139.15. No, because the investment has a net present value of - $1,954.91. Yes, because the investment has a net present value of $1,069.66. Yes, because the investment has a net present value of $1,954.91. An investor would be indifferent between purchasing and not purchasing the above investment at the stated price.

1. John approached you with a business proposition to invest in a project. The Annual Cash Flows (CF) are uncertain. However, the following probability distribution provides you with expectations: Probability P(CF) Probable Cash Flow (CF) $80.000 $140,000 $180,000 15 55 30 What is the expected Annual Cash Flow from this project? For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). ... BIUS Paragraph Arial 10pt A 10:49 PM a 60F Cloudy 5/16/2022 P Type here to search 5 6. 8O

Vijay

H

Use python to answer the following question: Question 5 A capital investment in an equipment with an upfront cost of $23,540 will provide you with the following annual cash flow stream (paid end of year): 1. $2,000 2. $1,456 3. $3,230 4. $6,850 5. $2,384 6. $1,234 7. $5,987 8. $4,190 The project will incur the following cost for maintenance and repair (paid end of year): Year 3: ($2,984) Year 4: ($1,837) Year 6-8: ($2,000) Calculate the NPV of the investment and comment on whether you should invest in the project. Why or why not? What is the IRR of the investment? The required rate of return is 3.5%.

Vijay

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?