Find monthly mortgage payment

Assignment Help Finance Basics
Reference no: EM132722501

Your sister is considering the purchase of a home rather than renewing the lease on her two-bedroom apartment. She is currently paying $700 per month for rent. She has asked you to help decide what sort of home she might be able to afford with her current monthly rent payment. Her bank offers first-time home buyers (with good credit) a 10-year mortgage at a fixed rate of 5.7%. Use this information to answer the questions below.

Express your answers rounded correctly to the nearest cent!

(i) If the cost of insurance and property taxes is about $300 per month in the neighborhood where she'd like to live, what monthly mortgage payment can she afford? (Refer to your class notes for the formula.)

Payment = $

(ii) Use Excel's PV function to determine how much your sister could afford to borrow for a home.

Amount to Borrow = $

Reference no: EM132722501

Questions Cloud

How human resource function has changed over last decade : How the human resource function has changed over the last decade or so. Do you anticipate any further changes to the human resource management
What annual interest rate is the bank paying : Suppose that a bank account that compounds interest continuously grows from $200to $232 in three years. What annual interest rate is the bank paying?
Make a profit on initial investment : How far would the price have to move in either direction for you to make a profit on your initial investment?
How training and development can inline activities : How training and development can inline activities within this human resource areas: recruitment,Hr Planning, Performance appraisals, compensation
Find monthly mortgage payment : If the cost of insurance and property taxes is about $300 per month in the neighborhood where she'd like to live, what monthly mortgage payment can she afford
Which variables can take to consider competitive analysis : Which variables can take to consider the competitive analysis for a digital business going to start their services ( charity and recipients)
Compare the pairs of stocks : Using the internet, compare the following pairs of stocks. For each pair, determine which stock is fundamentally stronger and holds more promise for the future?
Identify strengths and opportunities for improvement : For this Assignment, you assess where you are now in your clinical skill development and make plans for your practicum. Specifically, you will identify strength
How will other existing businesses in community affect : How will other existing businesses in your community affect the compensation vision and strategy of this new company? You can use the Overview of BLS

Reviews

Write a Review

Finance Basics Questions & Answers

  What are the finance charge and the new? balance

He made a payment of ?$1,000. If the account applies the unpaid balance? method, what are the finance charge and the new? balance?

  What is the interest rate on the debt

The levered capital structure would have 11,950 shares of stock and $88,000 of debt. What is the interest rate on the debt? Ignore taxes

  Determine the project irr and cost of capital

Determine the project IRR and the cost of capital for the project? Does the accept reject decision using IRR agree with the decision using NPV?

  What are the prices and durations of both bonds

Consider buying one 4-year bond and duration-hedging by selling an appropriate quantity of the 8-year bond. Any residual is financed with short-term (zero-duration) bonds. Suppose the yield curve can move up to 6.25% or down to 5.75% over the cour..

  Importance of prospective analysis

For years, two great armies of investors have done battle on Wall Street. In one camp stand growth investors, willing to pay dearly

  What is the value of the company share

A company expects to pay dividend of $0.72 next year. Dividends have been growing at a compound annual rate of 6% and are expected to continue growing.

  What are the two ways to raise money for a business

What are the two ways to raise money for a business? Explain the advantages and disadvantages.

  Determine the percentage holding peroid return

Assuming that the bond is held until maturity, the investor will receive $1,000 plus 6 percent interest. determine the percentage holding peroid return on this investment.

  What is a finance company

What is a money market mutual fund? Briefly describe the role of money market mutual funds in the commercial paper market.

  Determine the effective interest rate

Provide detailed descriptions and show all calculations used to arrive at solutions for the following questions:

  Problem-chamberlain canadian imports

Chamberlain Canadian Imports has agreed to purchase 15,000 cases of Canadian beer for 4 million Canadian dollars at today's spot rate. noted the following current spot and forward rates:

  What is the prepayment penalty

In 2010 a mortgage loan of $8,500,000 was issued by Associated Bank on a downtown office building. The terms of the loan were 10 years, 6.15% interest rate.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd