Purchase Solution

Payoff for a 30 year mortgage with years remaining in Excel.

Not what you're looking for?

Ask Custom Question

See attached file.

What is the payoff on a 30 year, 6% morgage of $255,413 with a payment of $1,531.33 with 7 years remaining.

I would like to know if there is a way to calculate this in Excel without creating a long amitorization schedule for 30 years. I can't seem to get a formula to work. I will attach the rest of the assignment.

Attachments
Purchase this Solution
Solution Summary

The payoff for a 30 year mortgage with years remaining in Excel.

Purchase this Solution
Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Basic TMV concepts

    What is the payoff on a 30 year, 6% mortgage of a. $255,413 with a payment of 1,321.33 with 8 years remaining? b. $530,493 with a payment of 3,180.57 with 12 years remaining? c. $297,266 with a payment of 1,782.26 with 11 years remaining?

  • Annuities, FV, PV, years, interest rate, loans, mortgages

    . $478,167 with a payment of 3,781.31 for 15 years? 14. Mortgages (Hint: P/Y=12). What is the payoff on a 30 year, 6% mortgage of a. $255,413 with a payment of 1,531.33 with 7 years remaining?

  • Calculating Present and Future Value

    . $478,167 with a payment of 3,781.31 for 15 years? 14. Mortgages (Hint: P/Y=12). What is the payoff on a 30 year, 6% mortgage of a. $255,413 with a payment of 1,531.33 with 7 years remaining?

  • d) When considering the tax savings in the first year, what is the net monthly mortgage expense for this loan (principal and interest only)? Show work. e) Originally, Mr. Buck was going to finance the condo with a 30 year fix rate mortgage at 5%.

  • Business Math : Mortgage, Interest and Amortization

    15 years remaining and the remaining amortization period is 15*2=30 e. If the mortgage is renewed at the end of the first term for another 5 year term at 8% compounded semi-annually, how much are the new monthly payments?

  • Compounding Interest on a Mortgage

    165007 Compounding Interest on a Mortgage Question: I just bought a house and have a mortgage of $150,000. The mortgage is for 30 years and has a nominal rate of 8% (compounded monthly).

  • Mortgage refinancing

    "You currently have a 30-year fixed-rate mortgage financed at 7.25% on a $200,000 home. There are 25 years remaining on the mortgage.

  • Calculating annual payment of a mortgage

    The bank agrees to allow you to pay this amount each year, yet still borrow $300,000. At the end of the mortgage (in 30 years), you must make a balloon payment; that is, you must repay the remaining balance on the mortgage.

  • Betty the Buyer vs. Randy the Renter

    Betty and Randy at age 25 Betty buys a starter home for $160,000. She makes a 10% down payment (borrowing the remaining 90%) and gets a 30-year mortgage. Her interest rate is 4.875%. 1. Calculate Betty's monthly house payment, showing your work.

View More Related Solutions