Instructions are the first picture, the questions are the second picture. Please answer anything you can :)

ASSIGNMENT #1 The purpose of this assignment is to solidify your understanding on the applications of the time value of money. The scores of this assignment will help in assessing the following learning goal of the course: "students successfully completing this course will be able to apply principles of time value of money to personal and corporate financial decisions." Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems (provided on page 5) on the applications of the time value of money. You are required to show the following 4 steps for each problem (sample questions and solutions are provided for guidance): (i) Develop the timeline (linear representation of the timing of cash flows) Identify the time value of money variable (PV, FV, PMT, N or Rate) which needs to be calculated in the question. (iii) Identify the values of the remaining four variables (PV, FV, PMT, N or Rate) from the question. Be sure to input positive or negative signs. (iv) Calculate the correct value of the variable identified in step (ii). 2. Joel has $3,600,000 in a Roth IRA and is ready to retire. He plans to withdraw equal amounts at the end of each year for the next 20 years. If the funds remaining in the account continue to earn 8% annually, how much can he withdraw each year? Round to two decimal places. 3. Alice would like to raise $420,000 in ten years for her son to go to college. She plans to deposit equal amounts into an account at the end of each year earning 13% annually. How much must she invest each year if the first deposit is made at the end of the first year? Round to two decimal places. 4. You deposited $1,000 into your savings account twelve years ago. Today, the amount has doubled to $2,000. What annual rate of interest did your account generate? Submit your answer as a percentage and round to two decimal places. 5. Abner Corporation takes out a $200,000 loan for a piece of new machinery. The annual payments are $21,878.23. If the loan accrues 7.5% interest per year how many loan payments must the company make? Round to the nearest number of years. 6. Harley invested $5,000 into various stocks and bonds exactly nine years ago. During that time, her account earned an average rate of return of 9.5% per year, compounded monthly. How much is her account worth today? Round to two decimal places. 7. Jamie plans to retire in 30 years. She decides to put $200 into a Roth IRA at the end of every month starting at the end of this month. She expects the IRA to earn 12% per year compounded monthly. How much will she have accumulated in the account at the end of 30 years? Round to two decimal places. 8. Durran has recently acquired a rare art piece that he plans to put on display in his private collection. He estimates that revenues generated from donations and admissions tickets to see the new exhibit will be $19,000 per year for the next six years. If he requires a rate of return of 4%, how much are the expected cash flows worth for him today? Round to two decimal places