please provide the answer and formula used

10 pts. Age in years: Current Balance: Annual interest rate: Monthly Payment: Retirement Age: # of monthly payments: Future Value assume that today is your birthday assume some balance (could be 50) assume when you retire (e.g. 65 or 67) calculate based on the retirement and current age use the standard capitalization type Suppose that on your birthday you checked the balance on your retirement account and you decided to make a $1,000 payment at the end of every month until you retire at the specified age. If you disreagard the inflation (i.e. we adjust payments and interest with the inflation rate) and assume a 2% annual growth rate of your retirement fund, how much money will you have at the time you retire? 10 pts. Build a model to calculate hours worked per shift and total hours worked. Please note that the company operates 24/7. DO NOT change the format of Hours Worked and Total Hours Worked; it has to be General Name John Bob Barb Tracy Date/Time Started Date/Time Finished Hours Worked Total Hours Worked: The tricky part here is that some of the shifts span across two different days Make sure to test if your model captures that FORMULAS: Some formulas need to be copied and they will not work with named ranges which use absolute addresses. Use the cell addresses not names if you need to copy formulas with relative addressing (e.g., D7 instead of P4inp1) |10pts. EXAMPLE: C | D | E | F | &6 | H | | | J Build a model to parse address lines (extract the details) assuming that the street name is always followed by "5t." (there are no avenues, boulevards, etc.). Assume that there are no apartment numbers and that all ZIP codes are 5 digits and the two-character state code is preceeded by ", " Please note that street and city names may contain more than one word, e.g. 100 Some Tree 5t. Yorba Linda, CA 94000. Address line House # Street Name City State ZIP 100 Some Tree 5t. Yorba Linda, CA 94000 100 Som, e St Yorba Linda, CA 94000 100 Yorba Linda cA 54000 iy o A i m Ly This problem requires using mulif e text extraction formulas and quite complex statements. Remember to stick to the constraints - you are not building @ generic address parser but a parser that can handle specific types of addresses. FORMULAS: Some formulas need to be copied and they will not work with named ranges which use absolute addresses. Use the cell oddresses not names if you need to copy formulos with relative addressing (e.g., CB instead of P5inpl)