*** Visual Studio in some lab computers is not working well for some students. Try these instructions created by the McIntire helpdesk. If VS still fails to load correctly, contact the McIntire Help Desk in person, at 434.924.7988, or helpdesk@comm.virginia.edu and let them know.


Homework H04

Simple Financial Calculator - Part II

Goal

to familiarize you with loops and relative cell addresses (offset).

Context

"Hey, great job with the financial calculator! You got good Excel skills.... "
Your boss liked your financial calculator. That is good news: you scored some points. However, having discovered your skills, now she wants you to do even more. This is the 'competency curse': the better you become at something, the more tasks you will be assigned and the higher the expectation about the quality of your results.

"Thank you!"

"Yes... I was wondering....  It would be very nice to print out a table that shows interest and principal+interest per each year, just next to the calculator.  Do you think you can do that?"

"Of course. I am on it."

Task

Modify your FinCalc I to accommodate the new requirements.

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

Criteria

  • all the requirements for the previous homework, plus:
  • at start, the calculator cells and the table with data are clear
  • all results are nicely formatted, columns fitted properly
  • the old table is cleared before a new table is printed
  • the program implements the Activity diagram shown in class and in the video
  • shape and colors of the app resemble closely the picture above
  • all rows of the table have the same height.

NOTES:
Careful! The video does not show exactly the requested solution.   Also, listen to the comments in the video, not just look at it.
Microsoft has changed the definition of their Styles.  In the video I am using Style 5. For the homework, pick colors that resemble closely the picture above.