1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Afina-wow [57]
3 years ago
8

A few years back, Dave and Jana bought a new home. They borrowed $230,415 at a fixed rate of 5.49% (15-year term) with monthly p

ayments of $1,881.46. They just made their twenty-fifth payment and the current balance on the loan is $208,555.87.
Interest rates are at an all-time low and Dave and Jana are thinking of refinancing to a new 15-year fixed loan. Their bank has made the
following offer: 15-year term, 3.0%, plus out-of-pocket costs of $2,937. The out-of-pocket costs must be paid in full at the time of refinancing.
Build a spreadsheet model to evaluate this offer. The Excel function:
=PMT(rate, nper, pv, fv, type)
alculates the payment for a loan based on constant payments and a constant interest rate. The arguments of this function are as follows:
rate = the interest rate for the loan
nper = the total number of payments
pv= present value - - the amount borrowed
fv = future value - - the desired cash balance after the last payment (usually 0)
type = payment type (0 = end of period, 1 = beginning of the period)
For example, for Dave and Jana's original loan there will be 180 payments (12*15 = 180), so we would use =PMT( .0549/12, 180, 230415,0,0) = $1881.46. Note that since payments are made monthly, the annual interest rate must be expressed as a monthly rate. Also, for payment calculations, we assume that the payment is made at the end of the month.
Assume that Dave and Jana have accepted the refinance offer, and that there is no pre-payment penalty, so that anything above the beyond the required payment is applied to the principal. Construct a spreadsheet model in Excel so that you may use Goal Seek to determine the monthly payment that will allow Dave and Jana to pay off the loan in 12 years. Do the same for 10 and 11 years. Which option for prepayment if any, would you choose and why?
(Hint: Break each monthly payment up into interest and principal [the amount that gets deducted from the balance owed] Recall that the monthly interest that is charged is just the monthly loan rate multiplied by the remaining loan balance.)
If required, round your answers to two decimal places.
Pay off loan in years Additional Payment
10 Years $
11 Years $
12 Years $
Which option for prepayment if any, would you choose and why?
Business
1 answer:
Aleks [24]3 years ago
7 0

Answer:

Explanation:

If required, round your answers to two decimal places.

Pay off loan in years Additional Payment

10 Years $

11 Years $

12 Years $

Which option for prepayment if any, would you choose and why?

New monthly payment

PMT(3%/12, 15*12, 208555.87, 0, 0) = $1,440.25

Now, we need find the additional amount that they need to pay in order to repay their outstanding loan in 10,11 and 12 years. So, using the above formula, we get

10-year installment = PMT(3%/12, 10*12, 208555.87, 0, 0) = $2,013.83

11-year installment = PMT(3%/12, 11*12, 208555.87, 0, 0) = $1,856.93

12-year installment = PMT(3%/12, 12*12, 208555.87, 0, 0) = $1,726.40

Additional Monthly Payment

10-year: $2,013.83 - $1,440.25 = $573.58

11-year: $1,856.93 - $1,440.25 = $416.68

12-year: $1,726.40 - $1,440.25 = $286.15

You might be interested in
Exercise 22-18 Manufacturing cycle time and efficiency LO A4 Oakwood Company produces maple bookcases to customer order. The fol
Zarrin [17]

Answer:

1. The company's manufacturing cycle time  is 17.4 days.

2. The company's manufacturing cycle efficiency is 0.40

Explanation:

1. Manufacturing cycle time

= Process time + inspection time + move time + wait time

= 7 + 0.6 + 4.8 + 5

= 17.4 days

Therefore, The company's manufacturing cycle time  is 17.4 days.

2. manufacturing cycle efficiency

= process time/manufacturing cycle time  

= 7/17.4

= 0.40

Therefore, The company's manufacturing cycle efficiency is 0.40

5 0
3 years ago
Norman, a partner of Dalextiles, a garment wholesale firm, offers discounts to giant retail apparel stores if the quantity of pr
makkiz [27]

Answer:

D) The negotiator role

Explanation:

According to my research on the different types of roles and responsibilities in a business, I can say that based on the information provided within the question Norman exemplifies the negotiator role in this scenario. This is because he is responsible for persuading buyers to buy more while negotiating the price if they do buy more of their product.

I hope this answered your question. If you have any more questions feel free to ask away at Brainly.

4 0
3 years ago
Jayda started a corporation that creates software products for clients. What position is jayda in of the corporation
goblinko [34]

If Jayda started the corporation, her position is founder and CEO of the business.

7 0
3 years ago
The supply curve represents the _____ price at which a firm is willing to _____.
Harrizon [31]
<span>The supply curve represents the lowest price at which a firm is willing to accept. The supply curve shows the lowest price the producer is willing to accept for a unit of their product. Producers need to make sure they aren't losing money but selling their products to wholesalers to then sell to the consumer. The producer needs to make a profit off of their product as well. This is where the supply curve comes in, it allows the firm to set the lowest price they can accept when they sell their units off. </span>
8 0
3 years ago
Which of the following would be considered the highest risk portfolio
algol [13]
The option that would be considered the highest risk portfolio is a<span> portfolio made up of 60% stocks, 30% mutual funds, and 10% Treasury bonds.
There is a lot of risks when investing in anything, because you pay a lot of money for something that may not be a wise idea, because in the end, you may lose a lot more than you get.
</span>
3 0
3 years ago
Read 2 more answers
Other questions:
  • What is the Fisher effect? the tendency of nominal interest rates to rise with higher expected inflation rates the tendency of r
    11·1 answer
  • Scientific and technological advancements in a specific industry as well as in society at large are included in which general en
    8·1 answer
  • Anne-Marie Cole runs the sales division for a local auto insurance firm. One of her key duties is to calculate her company's mar
    14·1 answer
  • In expectancy theory, valence is
    13·1 answer
  • Explain how firms/businesses compete without lowering their prices
    12·1 answer
  • For example, administrative expenses should be $3,700 per month plus $41 per course plus $7 per student. The company’s sales sho
    15·1 answer
  • Direct Materials Purchases Budget Pasadena Candle Inc. budgeted production of 785,000 candles for January. Wax is required to pr
    12·1 answer
  • Suppose Iceland goes from being an isolated country to being an exporter of coats. As a result, a. consumer surplus increases fo
    9·1 answer
  • Simplify (27) 2/3 x (125) 1/3 step by step explanation plz​
    5·1 answer
  • Martin Company currently produces and sells 35,000 units of product at a selling price of $13. The product has variable costs of
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!