Question: Write a SQL (in PostgresSQL) function that accepts a principal mortgage amount, an annual percentage rate (APR), and the number of years a mortgage will

Write a SQL (in PostgresSQL) function that accepts a principal mortgage amount, an annual percentage rate (APR), and the number of years a mortgage will be paid back over. Calculate the associated monthly mortgage payment according to the following annuity formula:

A = P (i + in ) (1+i) 1

where:

A = Monthly Payment Amount P = Principle (Initial) Mortgage Amount i = APR / 12 = Monthly Interest Rate n = years * 12 = Total Number of Payments

Be sure to specify that data types of the input arguments have enough significant digits to account for realistic mortgage amounts

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Chapter 7:7.2 #2 (p. 168) Chapter 8:8.2 #3 (p. 205) Chapter 9:9.2 #1 (p. 225) a., b., and c. (for c., only answer the adjustable rate mortgage part Chapter 7 from Personal Finance was adapted by The...

i need some one toanswering these three questions. make sure to include apa format for the information pretty straight forward. Attached below are the chapters. Chapter 7: 7.2 #2 (p. 168) Chapter 8:...

Please write this program i n C + + : A loan calculator will help you determine your monthly payments if you decide to borrow moneyin the form of student loans, car loans and renovation loans. You...

Reference Textbook Chapter : 5 Time Value of Money Details You find that Bank of America is offering to double your savings in 9 years, Citibank's is offering to triple your savings in 16 years,...

it is solved but I don't know how it is solved can you explain it ? Problem 3: As the new analytics hire at First Band \& Trust, you have been asked to conduct an analysis of the bank's mortgage...

Problem 3 : As the new analytics hire at First Band & Trust, you have been asked to conduct an analysis of the bank s mortgage loans. The data includes the customer s name, the loan date, loan...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

B DE Enter your name in this box F G H ANN L M N 5 6 Tutorial 6 - Calculating Loan Payments and Loan Amortization You will determine the loan payment and amortization schedule fee a fixed rate loan...

Loans There may be many times in your life in which you will need to borrow money: paying for college, buying a car, buying a home, improving a home, paying for a wedding, etc. When borrowing money,...

Mini-Case B (7 marks) Like every Canadian couple, Amira and Owen carry quite a lot of debt. Three years ago, Amira purchased a Subaru Outback costing $34,750 before sales tax of 15%, with a $5,000...

1. Suppose you invest $2,700 in an account bearing interest at the rate of 15 percent per year. Complete the table to show how your accumulation grows each year to equal $6,245.10 after six years. 2....

a) How much barite is required to increase the density of 300 bbls of mud from 4 ppg to 15 ppg.

19. On December 31, the Income Summary account of Johnson Company has a Credit balance of $226,000 after revenue of $519,000 and expenses of $293,000 were closed to the account. Gloria Johnson,...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

5. Recent research has shown an inverse relationship between CEO pay and corporate performance. Read the article The Highest- Paid CEOs Are the Worst Performers, New Study Says at...

4. Suppose you have been asked to lead a task force to develop a sales incentive plan at your firm. The task force is to generate a list of strategies and issues to be evaluated by upper management....

1. What dynamics at the IRS and VA may have contributed to actions employee took to earn a bonus?