Hello, could you please help me solve this questions by using Excel. Thank you.

I think this is the Rate of Interest 10.00%. This rate is for question 5 and 6.

37 * Present Value 6a. What is the present value of $1,000,000, due 25 years from now? 40 1 * b. What is the present value of a $40,000 ordinary annuity for 25 years? 94 45 What is the present value of a $40,000 perpetuity, if the first payment is 1 year from now? 97 0 d. What is the present value of a $40,000 perpetuity, if the first payment is now? 100 102 101 7. You borrow $35,000 today and will make equal annual payments for the next 3 years, starting in 1 year wa a. What is the value of the annual payment if the nominal interest on the loan is: 9.50% Payment 11 105 106 107 Principal Ending Balance o b. Show the amortization of the loan in the table set up below: e Year Beg. Balance Payment Interest 111 1 12 2 13 3 4 TOTAL 15 MUST use EFF for your 6 10.00% For problems 5 & 6 use required nominal annual return: 5. Consider the following end-of-year cash flows: Year Cash flow