How is the required payment amount calculated

Assignment Help Computer Engineering
Reference no: EM132107413

Programming in C Mortgage, Interest, Loan Assignment

Generally, when someone takes out a mortgage or other non-revolving loan, each payment is the same except for the final payment, which might be a little more or a little less in order to exactly pay off the loan. How is the required payment amount calculated? There is a closed form solution for this problem, which is easily derivable or can be looked up, but it produces a result that is not quite correct because it is based on the assumption that all transactions have infinite resolution, meaning, for instance, that the monthly payment might be $1234.5678473....

In actuality, all transactions are rounded to the nearest cent. The result is that the actual monthly payment will be slightly different than the ideal payment - though seldom by more than a few cents - and that the final payment must be slightly different,
usually by just a few dollars, to clear up the residual error.

Your program here will compute a mock Financial Disclosure statement for the principal and interest portion of a fixed-rate mortgage. The user will be asked to enter the initial mortage balance, the APR, and the number of years in the loan term. To simplify things, it will be assumed that the mortgage is taken out on the first day of the month and that payments are due the first day of the each month thereafter.

This is not at all an unreasonable assumption because loan companies generally force this situation to be the case, in effect, by requiring interest associated with a closing date that is not on the first of the month either be prepaid at closing or folded into the loan balance as of the first day of the next month. The other assumption we will make is that a "month" is exactly 1/12 of a year. This is common practice in the financial industry and is written into almost all mortgage contracts.

In order to determine the actual payment schedule for a real mortgage, the loan payments are simulated and the payment amount adjusted until the payment that comes closest to paying off the loan on schedule is found. The final payment is then adjusted to exactly clear the loan.

You are to run such a simulation to find the correct monthly payment. Each month interest is first computed on the prior month's balance and then this amount is added to the balance and the current month's payment is applied. Keep in mind that each transaction must be  properly rounded to the nearest cent. The simulation should run in a loop that progressively adjusts the monthly payment until the magnitude of the residual balance after the final payment is as small as possible; this might result in either a slight overpayment or a slight underpayment.

Typical run of the program:

What is the beginning principal balance ($): $ 250000.00

What is the annual interest rate (%): 4.125

What is the loan term (years): 15

IF PAID OFF ON SCHEDULE

179 equal payments of:.... $ 1864.92

Final payment of:......... $ 1864.59

Total Finance Cost:....... $ 85985.27

Run your simulations for the following cases and place the results in a ReadMe.txt file.

$200,000; 4.500%; 30 year

$200,000; 4.375%; 20 year

$200,000; 3.875%; 15 year

$200,000; 3.875%; 10 year

NOTE: These rates are current rates for no-closing cost loans with superior credit.

Reference no: EM132107413

Questions Cloud

List 5 ideas that you have seen marketed : List 5 ideas that you have seen (or heard) marketed, and then list some goods or services that come from, or are related to, each of those ideas.
Marketed ideas are commonly heard in educational : Ideas can also be marketed. Marketed ideas are commonly heard in Educational, Environmental, Health, Ethics, Religious, and Political arenas.
Short term and discontinuous in the long term mean : What does business-to-business demand is inelastic in the short term and discontinuous in the long term mean?
Contribute towards understanding the company : How would the answers to questions regarding to a companies business profile?? contribute towards understanding the company's market thrust?
How is the required payment amount calculated : Generally, when someone takes out a mortgage or other non-revolving loan, each payment is the same except for the final payment.
Downfall to health care when using social media platforms : What do you see as a downfall to health care when using social media platforms?
How does walmart measure quality : How does Walmart measure quality? How does Walmart measure customer satisfaction? What do you think the business can do in order to improve their CRM strategy?
Write a c program that converts base 10 numbers : Using algorithm given in the class write a C program (or in any programming language) that takes any number in any bas.
Generate a random ordered list of integers : In Python, the use the binary search functions given(recursive and iterative). Generate a random ordered list of integers and do a benchmark analysis.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Create a swot analysis of the presentation

In preparation for the final submission to the management team of PVSS, you will create a strengths, weaknesses, opportunities, and threats (SWOT) analysis

  Implement the given class hierarchy inside of a module

Implement the following class hierarchy inside of a module file called polygon.py. Write another "driver" script called project1.py which imports the polygon.py module, reads an input file of polygonal data and writes another file of areas and peri..

  Write a program that allows the user to specify a circle

Write a program that allows the user to specify a circle with two mouse presses, the first one on the center and the second on a point on the periphery.

  Need to build a asynchronous 4bit jk flip flop counter

Need to build a asynchronous 4bit JK flip flop counter with a 7 segment display and a unique pattern.

  Hhf employees to recognize and avoid malware treats

give screenshots and an explanation of your results when you download, install, and run a security program such as Spybot - S&D.

  Compare and contrast sdlc and two other development models

Compare and contrast SDLC and 2 other development models. What differences or similarities do you see between your posting and other classmates' postings?

  Explain relationship between twisted pair wire and crosstalk

Which type of noise is the most difficult to remove from a digital signal? Why? Explain the relationship between twisted pair wires and crosstalk.

  Describe the common features of those products

Select a specific category of vertical applications to investigate. Use the Internet and any other sources of information you might have to examine some of the different products that are available in that category.

  Design an application that allows a user to input a price

Design application that allows a user to input a price until appropriate sentinel value is entered. Output is price of each item on each day, one through seven.

  Write an lp for the mst problem

Write an LP for the MST problem, which enforces the constraint that at least one edge is selected from every cut.

  Regulating the content of internet

Specify to what extent there should be regulation of the content on the Internet, if at all? State the factors and principles the federal government must take into account when considering the indecency regulation issues.

  How the project manager guard against the natural tendency

It is sometimes suggested that time estimates for I.T. project work elements should be generated primarily by those involved in carrying out the work (e.g. analysts and programmers).

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd