What is the principle and interest on the first payment

Assignment Help Financial Management

Reference no: EM131020452

You take out a $200,000 mortgage for 20 years at 6%.

What is your monthly payment?

What is the principle and interest on the first payment?

What is the principle and interest on the twelfth payment?

How much interest will you pay over the 20 years?

Please show all four answers in an excel format.

Reference no: EM131020452

Questions Cloud

What are linkages among financial decisions-return-risk : What are the linkages among financial decisions, return, risk and stock value? Why are these linkages important? How does the financial manager incorporate these as s/he manages the assets and liabilities of the firm? Be sure to include examples to p..

Which contract would the manufacturer prefer : The remaining life of the patent is 10 years. Nadine uses a MARRof 10 percent/year. What must be the uniform annual sales volume of the product for Nadine to be indifferent between the contracts, based on a present worth analysis? If the sales vol..

What single sum of money should spenz pay : The Spenz corporation just made a big profit and wants to pay its insurance for three years in advance while it has the money to do so. Previously, Spenz has paid $100 in premiums semi-annually. Assuming a compound interest rate of 10%, what single s..

Considering buying an investment : You are considering buying an investment that will be worth $55,000 when it matures in two years. If you want a rate of return of at least 15% compounding quarterly, what is the most you should be willing to pay for this investment?

What is the principle and interest on the first payment : You take out a $200,000 mortgage for 20 years at 6%. What is your monthly payment? What is the principle and interest on the first payment? What is the principle and interest on the twelfth payment? How much interest will you pay over the 20 years?

What three policies that the domestic country could employ : Show that the shock either increased the domestic wage or decreased the foreign wage, at least relatively. In the years following the shock, what are three (significantly different) policies that the domestic country could employ if it wanted to r..

True regarding investment banks : Which of the following is true regarding Investment Banks? When Glass-Steagal was repealed in 1999, commercial banks and Investment banks had to be separate entities.

Define and explain job order costing : Primary Task Response: Within the Discussion Board area, write 400-500 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and..

Would your portfolio be riskless : Suppose you owned a portfolio consisting of $250,000 of U.S. government bonds with a maturity date of 30 years. Would your portfolio be riskless? What if your portfolio consisted of $250,000 of 30-day Treasury bills? Every 30 days your bills mature, ..

User Account

All Pages