Please answer questions in EXCEL or EXCEL sheet format

11. Present value: Your brother has asked you for a loan and has promised to pay you at the end of three years. If you normally invest to earn 6 percent per year, how much will you be willing to lend to your brother if you view this purely as a financial transaction (i.e., you don't give your brother a special deal)?

12. Present value: Tracy Chapman is saving to buy a house in five years. She plans to put 20 percent down at that time, and she believes that she will need for the down payment. If Tracy can invest in a fund that pays 9.25 percent annually, how much will she have to invest today?