SHOW EXCEL WORK

.. Find the PV of $1.000 invested in year 2, end $5,000 invested n year 4. Assume quarterly compounding and en APR of . 2. You want to buy a $600,000 house. Find the monthly payment assuming : 30 year mortgate, APR of 4%, and downpayment of 2016 include the amortization schedule You invested $5,000 3 years ago and it is now worth $7,000 Calculate the APR, assuming monthly compounding 4. How long(months and years) will take for you to have a retirement und of $2.000.000 assuming a monthly contribution of $1,000 and en APR of 9 Find the PV of loan it you can pay $500 per month for the first years, and then $1,000 per month for the next 4 years. Assume APR of a 5. Find NPV and IRR of the following series of Os ssume rate of 12 Year CF ($10,000) . $4.000 $1,000 3 $5,000 $2.000 $1,000 Find PV and DPB of the following series of CF Assume rate of 12% Year 0 ($10,000 $5,000 2 34.000 1 $5,000 12.000 $6,000 Find MIRR of the following series of CES Assume reinvestment rate of 12 and financing rate of 14% Year ($10,000 1 $5,000 $4.000 3 $5,000 $2,000 $6,000 Find NPV of the following series of CFS Assume rate of 10% Date 1/1/2012 (910,000) 2/3/2011 $5,000 3/4/2014 $4.000 6/6/2015 $9.000 8/12/2016 $2,000 11/25/2017 $6,000 10. Find IRR of the following series of CES ssume rate of 10% Date CF 1/1/2012 ($10,000 4/3/2013 $7,000 7/19/2014 $1,000 4/27/2013 $1.000 9/22/2016 $2.000 12/29/2017 $6,000