Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need this done in visual basic Create a program to calculate three monthly values resulting from a mortgage payment. Below is an example GUI Mortgage

Need this done in visual basic image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Create a program to calculate three monthly values resulting from a mortgage payment. Below is an example GUI Mortgage Calculator Payment Inputs Annual Rate of interest Payment Beginning Balance $1.490.91 Payment Results Interest Paid Reduction of Principal Ending Balance 1932.56 $441.65 357819.11 $357,377 46 Calculate Payment Details History + 1 2 3 4 5 Rate 1.00 2.00 3.00 4.00 5.00 Payment $1,932.56 01, 932.56 $1,932.56 $1,932.56 1,532.56 Interest Paid $298.10 3596.37 3854.55 91, 192.73 02, 490.93 Beg. Balance 9357.919.11 $352,819.11 9357, 319.11 $257.819.11 5357. 315.11 End Balance 5356, 104.73 5356, 482.92 $356.781.10 357,079.28 2357.377.46 niimited Attempts Minimum Requirements Your program must implement all of the below requirements. 1. GUI should not include the minimize window option 2. GUI should not include the maximize window option 3. GUI border should be fixed (ie, not resizable) 4. Each input should be associated with a unique access key 5. Each output textbox should be read-only Each Text Box TextAlign property must be set to Right 7. Create a boolean function to Verify and validate data 1. If data passes both tests continue processing 2. If data fails either test, alert user and set focus to the control 8. Verify all input was provided 1. If an input is missing, provide an appropriate message and set focus to that control 9. Validate all input data 1. All data must be numeric 2. Annual Rate of Interest must be between 1 and less than 10 3. If an input value is invalid. provide an appropriate message and set focus to that control 10. Create sub procedures to perform the following tasks 1. Calculate Payment Details 2. Display Payment Details 3. Append Input to History 11. Each user-defined sub procedure must receive parameters for 1. Read-only data (ByVal) 2. Editable data (ByRef) 12. Show a history of calculations 1. Use a global variable to count the number of payments calculated 2. Use formatted string to display history in a tabular format 3. Include a header row with the following column headings 1. # 2. Rate 3. Payment 4. Interest Paid 5. Beg. Balance 6. End Balance 4. Use a global variable to determine if the history header has been displayed 13. Do not use global variables for input or output data 1. All mortgage input and output data must be passed between procedures 2. Explicitly set each parameter's passing mechanism 14. Submit a screenshot with at least five payments in the history Flowchart Below is a flowchart depicting the high-level steps the program should follow. Since this project will be developed using a GUI, the prompt should be implemented as textboxes and a button click event should call a user-defined function to check for 'valid" data. Each of the final three steps should be use defined sub procedures. Please note that the annotations refer to the values the step should produce. Starty Prompt for input Annual Rate of interest Monthly Payment Beginning Balance No Specify the missing or invalid input field and set focus tot Art User Is nout present? I Verity data is sont Yes NO 15 out valen Vape and range Cici Panel For More Reduction of En Display Payment Details interest Paid for Month Reduction of Principal Ending Balance HE E Append input to History Annual Rate of interest Monty Payment Beginning Balance End Calculate Button Click Event Private Sub btnCalculate_Click(sender As Object, e As EventArgs) Handles btnCalculate.click Dim annualRateOf Interest As Integer Dim monthlyPayment As Decimal Dim begbalance As Decimal Dim intForMonth As Decimal Dim redofPrincipal As Decimal Dim endBalance As Decimal Call user-defined boolean function to determine if input is valid If true then call calculate, display, and append sub procedures "passing each the appropriate subset of the above variables it needs End Sub Notes for Calculating Payment Details The monthly interest paid can be calculated using the below formula: Awwal Rate of interest 100 12 Beginning Balance The reduction of principal equals the monthly payment minus the monthly interest paid. The ending balance is the amount still owed. It can be calculated by subtracting the reductioff of principal from the beginning balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

What Is A Database And How Do I Use It

Authors: Matt Anniss

1st Edition

1622750799, 978-1622750795

More Books

Students also viewed these Databases questions

Question

EXPLAIN the recruitment process.

Answered: 1 week ago

Question

2. The model is credible to the trainees.

Answered: 1 week ago