1. Suppose you inherited $100,000 and invested it at 7% per year. What is the most you could withdraw at the end of each of the next 10 years and have a zero balance at Year 10? How would your answer change if you made withdrawals at the beginning of each year?

Please answer all parts of the question for a good rating. Also please show how to solve in excel and on a financial calculator.