Homework H04

FinCalc - Upgrading your Simple Financial Calculator

FinCalc

Alert: Inclement Weather

Due to the forecast weather conditions it might be difficult for you to get to the labs and do the homework.  For this reason there will be no late penalties for H04. Take your time and stay warm!

Also: if you got zero points in H03 (likely because you did not save/submit correctly) feel free to resubmit to me via MS Teams. There will be a late penalty, but you will get back many points).

Learning Goal

Learning more basic coding commands in VBA by upgrading the simple financial app created in the previous homework.

Optional Prework

Check reading #2 and #3 in the Resources.  They are reference materials as you learn the VBA language.  Your favorite GenAI can help, too!

If you run into trouble, check the "How Tos" page. It is a collections of solutions to problems experienced by the Fintech Community. It is included in the headers of all homework.

Task

Make a copy of your FinCalc I and modify it to accommodate the new requirements.

Submit your work to myFiles as "H04.zip" (that is a zero). Do not add anything else to the filename.

Criteria/Requirements

Your app must satisfy the following requirements

  • all the requirements for the previous homework, plus:
  • at start, the calculator cells and the table with data (year, interest, and principal+interest) are clear
  • all results are nicely formatted, all 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
  • shapes, fonts, and colors of the app resemble closely the picture
  • all rows of the table have the same height

Hints and Tips

  •  I added a new link to the header of the home work pages: "HOW TOs". Go there to learn how to get things done/solve problems with VS/VBA. I will constantly update it. 
  • Do not mute the video. The verbal explanations often provide critical context that you won’t get by simply watching the screen.
  • Expect differences between vLabs and homework instructions. Sometimes the virtual labs leave parts for you to complete, and other times the homework text introduces additional or different requirements. This is intentional—it’s designed to make you think independently. Don’t follow the vLab blindly!