What is the amount of repaid principal and the interest paid

Reference no: EM13207097

Suppose you get a mortgage loan of $30,000 to be repaid in 360 months (i.e. in 30 years).

a) Using the mortgage calculator spreadsheet available on VISTA, produce a graph which displays, for each month, the amount of repaid principal (also called normal paydown) and the interest paid when the nominal mortgage rate is r = 5.33% compounded monthly. (You may want to understand the spreadsheet first). explain how you modified the formulas in the spreadsheet.

b) Suppose now that the loan is repaid on a semiannual basis. Add a new sheet to the Excel file, and produce a graph which displays, for each semi-annual period, the amount of repaid principal and the interest paid when the nominal mortgage rate is r = 5.33% compounded semi-annually.

Reference no: EM13207097

Questions Cloud

Write a six different iterated triple integrals : write a six different iterated triple integrals for the volumeof the tetrahedron cut from the first octant by the plane 6x+3y+2z.evaluate one of the integrals.

State what is the initial diluted fe concentration : solution were added to 12.00 mL of an aqueous 0.025 M Fe3+ solution. The total volume of the solution is 20.75 mL. What is the initial diluted Fe3+ concentration?

Explain who is harmed by such restrictions on imports : Why does international trade occur What does it mean to run a deficit in the merchandise trade balance Distinguish between a tariff and a quota. Who benefits from and who is harmed by such restrictions on imports

State chloride and sand is placed in an evaporating dish : A mixture of ammonium chloride and sand is placed in an evaporating dish and massed at 56.246g. The mixture is heated, driving off the ammonium chloride and massed again

What is the amount of repaid principal and the interest paid : Using the mortgage calculator spreadsheet available on VISTA, produce a graph which displays, for each month, the amount of repaid principal (also called normal paydown) and the interest paid when the nominal mortgage rate is r = 5.33% compounded ..

What is the equilibrium price : The price at which supply and demand are equal is called the equilibrium price. What is the equilibrium price?

State what is the ph of the resulting buffer : NaOH is added to 625 mL of 0.250 M weak acid (Ka = 5.62 × 10-5). What is the pH of the resulting buffer?

Calculate the work required to empty the tank through a hole : A tank in the shape of a sphere with radius 10 m is full of gasoline, with density 680 kg/m3. Calculate the work required to empty the tank through a hole at the top.

Contemporary artists or art forms : Do you believe we are currently living in a "period of great art"? Why or why not? Please share the names of the contemporary artists or art forms that inform your response.

User Account

All Pages