Monthly amortization schedule

Assignment Help Financial Management

Reference no: EM131190727

Monthly amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $650,000 on the condo and are taking out a loan for the whole amount for the condo for twenty years at 7.0% interest.

a. What is the monthly payment on the mortgage? Construct the amortization of the loan for the twenty years in a spreadsheet to show the interest cost, the principal reduction, and the ending balance each month.

b. Then change the amortization to reflect that after ten years, Sherry and Sam will increase their monthly payment to $7,500 per month. When will they fully repay the mortgage with this increased payment if they apply all the extra dollars above the original payment to the principal?

Reference no: EM131190727

Questions Cloud

Coats into the incarnation of value : The linen weaver needs the use-value of the coat. But by offering linen forcoats, she turns coats into the incarnation of value. Explain how this paradoxical result comes about, that the linen weaver has to treat the coat as value in order to get ..

Self-employed certified public accountant : Income statement preparation On December 31, 2015, Cathy Chen, a self-employed certified public accountant (CPA), completed her first full year in business. During the year, she billed $360,000 for her accounting services. Prepare an income statement..

What is your expected income next year : What is your expected income next year?- Suppose that you could insure yourself against the risk of reduced consumption next year. What would the actuarially fair insurance premium be?

What is the beta of portfolio : Portfolio Beta You own $1,800 of City Steel stock that has a beta of 1.66. You also own $6,600 of Rent-N-Co (beta = 1.96) and $5,600 of Lincoln Corporation (beta = 1.06). What is the beta of your portfolio (closest to)?

Monthly amortization schedule : Monthly amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $650,000 on the condo and are taking out a loan for the whole amount for the condo for twenty years at 7.0% interest. What is the monthly payment on ..

What is the beta of portfolio : Portfolio Beta You own $25,000 of City Steel stock that has a beta of 3.35. You also own $40,000 of Rent-N-Co (beta = 1.80) and $21,000 of Lincoln Corporation (beta = -.80). What is the beta of your portfolio?

The problem of adverse selection in insurance markets : The problem of adverse selection in insurance markets means that it is generally a bad deal for companies to offer insurance at the same price for all potential customers.

Discuss the importance of the time value of money concepts : Define and discuss the importance of the time value of money concepts including compounding (future value), discounting (present value), and annuities. Why do organization leaders need to understand these concepts?

Calculating fees on a loan commitment : You have approached your local bank for a start-up loan commitment for $1,030,000 needed to open a car repair store. You have requested that the term of the loan be one-year.

User Account

All Pages