Consider the following project Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000 $200,000 $200,000   Calculate the Internal Rate of Return (to one decimal place), using Excel, and paste a screenshot of your answer below.

Determine the future value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3 4. Invested Amount 15,000 20,000 30,000 50,000 $ $ $ U $ i = 6% 8% 12% 4% n = 12 10 20 12 Future Value

Determine the future value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3. 4. Invested Amount 15,500 23,000 35,000 56,000 $ 67 67 $ $ $ i = 5% 5% 11% 6% n = 12 6 18 14 Future Value

(Click on the following icon in order to copy its contents into a spreadsheet.) Year 1 Year 2 Year 3 Year 0 -$50 -$101 $26 $20 $22 $22 $39 $49 Project A B Year 4 $16 $62 You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently?

Would you kindly input this problem into Excel and use the NPV function and IRR function in Excel? Thank You

Damien offers you a sequence of end-of-year cash flows for an investment as follows: Year 1 2 3 4 4 What is the value of the cash flows if the opportunity cost is 6 percent? (Round to the nearest dollar). Please click on the following link to access a blank worksheet Click to open:: O $8.392 $8.598 Cash Flow $4,000 $3,000 $2,000 $1,000 $8.734 $8.915

Consider a project with the following cash flows: Time 0 1 2 3 4 5 CF -$5,000 $5,000 $4,000 $2,000 $1,000 -$6,000 Please round your answer to two decimal places. (e.g. 12345.67 for $12,345.67; 12.34 for 12.34%) a)  What does excel (or your calculator) say the IRR is?

Calculate an IRR using an iterative technique. (Hint: Start by guessing 15%.)  A project has the following cash flows             C0                    C1                    C2                    C3                                         ($700)               $200                 $500                 $244 I'm not really understanding the IRR concept. please take the time to explain it to me and not just posting an Excel worksheet

Determine the present value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1. PV of $1. EVA of $1. PVA of $1. FVAD of $1 and PVAD of $1) 1. 2. 3. 4. Future Amount $ 28,000 22,000 33,000 48,000 $ $ 9% 10% 12% 11% n= 14 17 28 13 Present Value

Can you tell me how to get the 0% to 25% rate numbers? I have to plot the NPV profiles. Year Project A Discounted cashflow Discounted cashflow 0 -50,000 -$50,000.00 -$50,000.00 1 25,000 $22,727.27 $23,584.91 2 20,000 $16,528.93 $17,799.93 3 10,000 $7,513.15 $8,396.19 4 5,000 $3,415.07 $3,960.47 5 5,000 $3,104.61 $3,736.29   NPV $3,289.02 $7,477.79   IRR 14% 14%             10% 6% Year Project B Discounted cashflow Discounted cashflow 0 -50,000 -$50,000.00 -$50,000.00 1 15,000 $13,636.36 $14,150.94 2 15,000 $12,396.69 $13,349.95 3 15,000 $11,269.72 $12,594.29 4 15,000 $10,245.20 $11,881.40 5 15,000 $9,313.82 $11,208.87   NPV $6,861.80 $13,185.46   IRR 15% 15%   Rate Project A Project B 0%     1%     2%     3%     4%     5%     6%     7%     8%     9%     10%     11%     12%     13%     14%     15%     16%     17%     18%     19%     20%     21%     22%     23%     24%     25%