Business, 03.04.2020 17:31 sandygarcia65

You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.25% on a 30-year mortgage. (Use Excel)

Use function "PMT" to calculate your mortgage payment.

Use function "PV" to calculate the loan amount given a payment of $1550 per month. What is the most that you can borrow?

Use function "RATE" to calculate the interest rate given a payment of $1550 and a loan amount of $384,000.

For each scenario, calculate the total interest that you will have paid once the mortgage is paid off. (There is not a function for this, enter the formula into the cell.)

For each scenario, calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest.)

Assume that you plan to pay an extra $300 per month on top of your mortgage payment, calculate how long it will take you to pay off the loan given the higher payment. (Use the data from #1). Calculate how much interest you will pay in total? Compare this to the value that you calculated for #1.

You want to determine whether you should only 10% down on your house. Because you are only putting 10% down, lenders require that you purchase private mortgage insurance (PMI). Assume that PMI is 1% of the mortgage amount. Assume that you will pay PMI for 8 years in total (the assumption is that you will have 20% equity at that time so PMI will no longer be needed).

Calculate your total monthly payment (mortgage payment plus PMI).

Calculate the total cost of financing your home purchase (interest plus PMI). (remember that you only pay PMI for 8 years)

Calculate the total cost of the home purchase. (Down payment plus principle (loan amount) plus interest plus PMI.)

Compare this to the costs associated with a 20% down payment (use data from #1).

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 12:10

This exercise illustrates that poor quality can affect schedules and costs. a manufacturing process has 130 customer orders to fill. each order requires one component part that is purchased from a supplier. however, typically, 3% of the components are identified as defective, and the components can be assumed to be independent. (a) if the manufacturer stocks 130 components, what is the probability that the 130 orders can be filled without reordering components? (b) if the manufacturer stocks 132 components, what is the probability that the 130 orders can be filled without reordering components? (c) if the manufacturer stocks 135 components, what is the probability that the 130 orders can be filled without reordering components?

Answers: 3

Answer

Business, 22.06.2019 20:00

How many organs are supplied at a zero price? (b) how many people die in the government-regulated economy where the government-set price ceiling is p = 0? the quantity qd – qa. the quantity qe – qa. the quantity qd – qe. (c) how many people die in the market-driven economy?

Answers: 1

Answer

Business, 22.06.2019 21:00

An important source of public scrutiny is "watchdogs." these are: the efforts of a firm's competitors, including how often the competitors attack the firm's strategies. taxpayer-supported government agencies that limit a firm's ability to compete in foreign markets. companies designated by the government to only produce products that support the government defense program. socially conscious groups that make it their mission to measure the social responsibility levels of businesses, and provide consumers with their opinions about the level of corporate responsibility of various companies.

Answers: 2

Answer

Business, 22.06.2019 22:30

Which of the following situations is most likely to change a buyer's market into a seller's market? a. a natural disaster that drives away a lot of the population. b. the price of building materials suddenly going up. c. the government buys up a lot of houses to build a new freeway. d. a factory laying off a lot of workers in the area.

Answers: 1

Answer

You know the right answer?

You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the re...

Questions