Calculate two years of mortgage payments

Reference no: EM1361250

I need some help with this. I am not sure where to start figuring my formula up. Please help if you can and if you get me started I can take it from there.

Create an amortization table and assume that a full month's interest must be paid for the first month and that payments begin February 1. Only calculate 2 years of mortgage payments. Here is the information that I have:

Down payment for purchase of land and buildings, $180,000. (The total purchase price on January 10th was $240,000, of which $60,000 was financed with a mortgage on the property.)

Mortgage payments of $526 each on February 1st, March 1st, April 1st, May 1st, and June 1st. The interest rate on the mortgage is 7% and is to be paid from January 1st.

Must include the interest expense portion and the mortgage principal portion of each month's payment.

Reference no: EM1361250

Questions Cloud

Determination of gains or losses : Currency futures contracts are traded on organized exchanges. Assume you sell a contract on Australian US dollars in the amount of A$100,000 on Chicago Mercantile Exchange at $0.7900/A$.

Explain economy produced no capital goods : This means that in the particular year the economy produced no capital goods at all." Do you agree. Why or why not? Explain: "Though net investment can be positive, negative, or zero, it is quite impossible for gross investment to be less than zer..

Toxicolgy due to cadmium and lead : A low protein diet can result in increased blood levels of cadmium and lead. Propse a reason for this effect and describe the mechanism(s)that would be involved in causing this observed response.

Illustrate what defensive open market operations : If the Treasury has just paid for a supercomputer and as a result its deposits with the Fed fall, illustrate what defensive open market operations will the manager of the open market desk undertake.

Calculate two years of mortgage payments : Prepare an amortization table and assume that a full month's interest must be paid for the first month and that payments begin February 1st compute two years of mortgage payments.

Write code to find largest value found in parking tickets : Without using any additional variables, write some code that results in mostTickets containing the largest value found in parkingTickets.

Consulting experts and obtaining estimates : what hidden costs are and how they can affect a project's budget. It also provides a brief, but concise summary of what overhead costs are in comparison to indirect costs.

Illustrate what is the equilibrium price of hotel rooms : Illustrate what is the equilibrium price and quantity of hotel rooms on Manhattan Island.

Public service system flyer : How has the public service system evolved over the last 100 years and what major events and decisions were important to the evolution

User Account

All Pages