Please show all work in excel! Thank you will upvote once both anwered!

1. What is the present value of a perpetuity that will pay $10,000 in one year and grow at 3% annually, if the discount rate is 10%. (first payment at the end of this year).

   		150,000.00
   		142,857.14
   		200,000.00
   		198,756.22
   		136,689.55

2. You borrowed an amount three years ago. The terms of the loan calls for an annual payment of $2,717.36 each year for 10 years. If the interest rate on the loan is 6%, what is the outstanding balance today?

   		15,169.34
   		19,021.98
   		Cannot be calculated
   		16,745.12
   		14,568.22