We would like you to consider the following investment: imagine that you have $100 and want to invest that for three years. The annual interest rate is 50% and the interest is paid on a semi-annual basis (at the end of each half-a-year period).

Prepare a table in which you provide the details of the interest payment at the end of each half-a-year period. For each such period show specifically the interest payments that result from the initial capital and the interest payments that result from each past interest payment. We encourage you to use an Excel spreadsheet for the above analysis.