There are four financial assets whose investment terms are 12 years and annual percentage rates (APR) are 8%.

• Asset A pays simple interest
• Asset B pays annual compound interest
• Asset C pays quarterly compound interest
• Asset D pays continuously compound interest

For each of the assets: show the value (for per dollar investment) of the asset at the end of year 1, 2 12. As an investor, which asset do you prefer?

Please Show in Excel (if possible)