Homework 4

The Simple Financial Calculator

The objective of this exercise is to familiarize you with loops and relative cell addresses. Modify the simple financial calculator built in H3 so that: calculations are shown for every year, up to the year indicated by the user. Assume that the user enters an integer as a value for years. Results are nicely formatted, and the screen is fully cleared before a new computation.

Example output

Suppose for example that the user entered $1,000, 10 years, 5% interest rate, and option 'a'. The output should look like this

h4

A vLab with a partial solution is provided. You will have to complete the solution for case (b) and (c).