Compound Interest in EXCEL
Create an EXCEL, or equivalent, worksheet allowing a user to enter a principal and APR in labeled cells. The worksheet should fill a table with the corresponding values of investments. Each column in the table should correspond to a number of compounding periods per year, including 1, 4, 12, 365, and the user's choice. Each row in the table should be a number of years from 1 to 30. The entry in a particular row and column should be the value of the principal, invested for the number of years corrresponding to the row at the APR entered by the user, compounded according to the number of compounding periods per year specified in the column.
With careful placement of $'s the table can be filled by dragging a single formula down and to the right. Please complete the table using this technique.