Instructions: Please solve these problems in an Excel file and share with me your Excel solutions. Do not hard code your answers as I want to be able to verify your formulas. 1. What is the present value of receiving 100 per quarter for 25 years starting today, assuming 12% interest rate? 2. You want to buy a house worth $150,000 and you have $20,000 for down payment. You want to get a financing with monthly payments. Assume 5% interest rate, what will be your monthly mortgage payments? 3. You want to buy a new car worth $30,000. You can afford to pay max $500 per month with $3,000 down payment. Given an interest rate of 6%, how long it will take to clear your debt? Assume that after two years you want to pay down all the outstanding balance. How much you have to pay? 4. You want to buy a stock that will give you $100 every quarter indefinitely. Assuming 10% interest rate, what should the value of stock today? 5. You are investing in a project with cash flows of -$45,000 in year 1, -$30,000 in year 2, $80,000 in year 3, $50,000 in year 4, and from year 5 onwards you will get $70,000/year indefinitely. What is the present value of this project? 6. You have three investment options: a. Receiving $1,200/month starting today for 5 years. b. Receiving $2,240.69/quarter for seven years. c. Receiving $6,538.27/year indefinitely. If annual interest rate is 12%, which options will choose and why? If you are not given time or int rate for any of the questions, you can assume any time period or int rate and solve the question. I will mark you for the procedure. Need answers to this in four hours.