Hello,

I am having trouble calculating question 1 in the THA7 directions sheet. I put the ages into a table on the excel sheet attached (THA7), and used the Greatest Common Divider (GCD) formula on excel to find the GCD, but after that I am not sure how to calculate a ratio. I tried looking online how to calculate a ratio on excel but it says there is no direct way to calculate it, and the formulas I found on the internet always end up returning a Reference error or Value error. Any help would be greatly appreciated, thank you.

Rob

FIN 36058 Fall 2015 Take Home Assignment #7 Due December 10, Thursday, beginning of lecture Can be done in groups of two or three students Must be submitted electronically 1. Using the data from a set of pdf files posted on Blackboard in the Data folder inside the Population folder, compute the ratio of the projected US population in the working age (between 25 and 65 years old) to the projected US population in the retirement age (over 65 years old) for 2010, 2015, 2020, 2030, 2040, 2050, 2060, 2070, 2080, 2090 and 2100. Your solution must consist of the table of estimates of the projected population in the two age groups for the aforementioned years and the graph showing the projected dynamics of the aforementioned ratio over the sample time period. 2. Suppose you have saved $1,500,000 by the time you retire. Create a table that shows how much you can spend annually assuming a constant annual amount of spending adjusted for inflation, a fixed rate of return adjusted for inflation during retirement, and a fixed length of retirement. Your solution must consist of the table, as seen on page 2 of this assignment, filled with the respective values. Round your answers to the nearest dollar. Rename the file \"lastname1_lastname2_lastname3_THA7\". Send your SINGLE Excel file via email to ashynk1@gmail.com. Subject of your email must be \"FIN 36058 THA 7\". Years of spending 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 0 0.5 Assumed constant rate of return (adjusted for inflation) 1 1.5 2 2.5 3 3.5 4 4.5 5 2010 2015 2020 2030 2040 2050 2060 2070 2080 2090 2100 Working Age (25-65 yrs old) Retirement Age (65