Your task is to build a simple loan analysis model by selecting different payment plans and calculating the corresponding payment details.
This assignment evaluates your ability to:
- use Data Validation to control user input
- apply XLOOKUP to retrieve data from a master table
- use financial functions such as PMT correctly
- ensure consistency between rate and payment periods
- perform basic calculations using cell references
- organize inputs and outputs clearly in a structured format
Leave a Reply
You must be logged in to post a comment.