. We have two mutually exclusive investments with the following cash flows:                                                                                                   Year Investment A Investment B 0 –$100 –$100 1 10 50 2 30 40 3 50 30 4 70 20   b. Calculate the NPV profile for each investment, using the discount rates of 0%, 5%, 10%, 15%, 20%, and 25%. Perform this task in an Excel spreadsheet. Cautionary note: If you use the =NPV() function in Excel to calculate the NPVs, it will provide incorrect answers. The NPV() function actually calculates the present value of all cash inflows. The NPV should be calculated as =NPV(all cash inflows) – initial cash outflow.

Can I get some help with this practice question

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

Consider two assets with the following cash flow streams:   Asset A generates $4 at t=1, $3 at t=2, and $10 at t=3. Asset B generates $2 at t=1, $X at t=2, and $10 at t=3.   Suppose X=6 and the interest rate r is constant.   For r=0.1, calculate the present value of the two assets. Determine the set of all interest rates {r} such that asset A is more valuable than asset Draw the present value of the assets as a function of the interest rate. Suppose r=0.2. Find the value X such that the present value of asset B is 12. Suppose the (one-period) interest rates are variable and given as follows: r01=0.1,r12=0.2, r23=0.3. Calculate the yield to maturity of asset A. (You can use Excel or ascientific calculator to find the solution numerically.)

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, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3. 4. Future Amount $ 24,000 $ 18,000 $ 29,000 $ 44,000 i 5% 9% 11% 10% n= 10 13 25 9 Present Value

Please solve step by step for clarity, thank you!

Present and Future Values of Single Cash Flows for Different Interest Rates Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $700 compounded for 10 years at 6%. $   An initial $700 compounded for 10 years at 12%. $   The present value of $700 due in 10 years at a 6% discount rate. $   The present value of $700 due in 10 years at a 12% discount rate. $

Present and Future Values of Single Cash Flows for Different Interest Rates Use both the TVM equations and a financial calculator to find the following values. (Hint: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in parts b and d, and in many other situations, to see how changes in input variables affect the output variable.) Do not round intermediate calculations. Round your answers to the nearest cent. An initial $700 compounded for 10 years at 3%. $ An initial $700 compounded for 10 years at 6%. $ The present value of $700 due in 10 years at a 3% discount rate. $ The present value of $700 due in 10 years at a 6% discount rate. $

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. (EV of $1. PV of $1. EVA of $1.PVA of $1. EVAD of $1 and PVAD of $1) Invested Amount 15.000 20,000 30.000 50,000 1 S 3 234 $ 4 S 1 = ON 0% 12% 4% n = 12 10 20 12 Future Value

For each of the investments below, calculate the rate of return earned over the period. Cash Flow During Period - $900 14,000 5,000 70 1,500 (Click on the icon here in order to copy the contents of the data table above into a spreadsheet.) Investment A B C D E Beginning-of-Period End-of-Period Value Value $1,400 140,000 55,000 500 14,000 $400 115,000 49,000 200 12,600