Monthly payment be with the new mortgage

Assignment Help Finance Basics
Reference no: EM133076557

Your amortization table should be set up so that if the assumptions change your table updates appropriately. The assumption cells should be clearly identified (e.g. yellow). Grades will not be posted until everyone in your group has completed the peer evaluation or the due date has passed whichever is sooner.

Scenario: 10 years ago, Janice got a $200,000, 30-year mortgage with an annual interest rate of 6% and monthly payments.

1) What is her monthly payment?

2) How much does she owe today (after 120 payments)?

Janice is planning to move in 2 years.

3) How much will she owe in 2 years (after 144 payments)?

Option 1: Janice is considering making an extra payment of $100 each month for the next 2 years.

4) How much will she owe in 2 years (after 144 payments) if she makes an extra $100 payment every month starting with her next payment (payment 121)?

Option 2: Janice is considering refinancing the remaining balance on her loan (your answer to 2) along with $1,500 in closing costs into a new 20-year mortgage with an annual interest rate of 3% and monthly payments.

5) What would her monthly payment be with the new mortgage?

6) How much will she owe in 2 years on her new mortgage?

7) Which option (1 or 2) do you think would be best? Explain.

Reference no: EM133076557

Questions Cloud

Determine the projected merchandise purchases : Beginning inventories of each month are budgetedat 40% of that particular month's projected cost of goods sold. Determine the projected merchandise purchases
Which of solomon biblical principles stood : Which of Solomon's biblical principles stood out to you? How might you apply this principle?
Review the power of good design : Review The Power of Good Design and select three of the ten principles noted for good design.
What the direct materials usage variance : In 2020, the company had expected to sell 60,000 bottles but actually bottled and sold 70,000 bottles. What the direct materials usage variance
Monthly payment be with the new mortgage : Your amortization table should be set up so that if the assumptions change your table updates appropriately. The assumption cells should be clearly identified (
Useful takeaway for you from workshop reading : What was the most useful takeaway for you from this workshop's reading? What concept from the reading is the most applicable to you now in your profession,
How much would the buyer of the bond : A bond with face value of $250,000 and a 5% coupon matures December 1, 2026. It was sold at a price of 99 on Tuesday October 30th, 2018. Including accrued inter
Legacy structured databases and types of unstructured data : Why has enterprise embraced big data, using legacy structured databases and all types of unstructured data?
Should the company invest in new zealand or indonesia : Bank deposit rate in New Zealand is 2.5% and deposit rate in Indonesia is 6.5%. A New Zealand company is considering a fixed-income investment.

Reviews

Write a Review

Finance Basics Questions & Answers

  Explain meaning of res ipsa loquitur and provide an example

Explain the meaning of imputed negligence and provide an example. Explain the meaning of res ipsa loquitur and provide an example. Briefly describe the standard of care to protect others from harm for each of the following liability situations.

  What is a straddle

What is a straddle, and why would an investor choose to buy one? Assume an investor buys a $21 straddle on Macy's.

  State the kind of lapse included in the accompanying exchang

State the kind of lapse included in the accompanying exchanges and say whether it will influence the assention of the trial balance or not.

  Construct a six-step binomial pricing tree for the european

(a) Construct a six-step binomial pricing tree for the European put and find the premium.

  How an increase in the risk-free interest rate affects

Explain how an increase in the risk-free interest rate affects share prices, the equity premium, and the rate of return on internal investments.

  Explain what is initial investment outlay for the machine

Explain what is the initial investment outlay for the machine for capital budgeting purposes, that is, what is the Year 0 project cash flow? Round your answer to the nearest cent.

  Lower cost component cost of capital

Explain why as debt increases (in capital structure), eventually the WACC will increase (despite the fact debt is usually the lower cost component cost of capital).

  Define the terms explicit forecast period and terminal

Define the terms explicit forecast period and terminal or horizon value as they relate to a venture’s discounted cash flow valuation.

  What is portfolio jnj weight

Use the 60 monthly returns from September 2016 to August 2021 of Johnson & Johnson (JNJ) and Goldman Sachs (GS).

  Financial analysis-supported discussion

A research- and financial analysis-supported discussion with rationales for at least two viable potential resolutions.

  Rvenues and other operating costs are expected to be

fool proof software is considering a new project whose data are shown below. the equipment that would be used has a

  Which of the budget cycle phases

Which of the budget cycle phases is the most important for accountability purposes?

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