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
The premiums paid by the employer in a business life insurance policy are
Tema [17]
<span>A life or health insurance policy is owned by an employee, but the premiums are paid by the employer: o The premiums are treated as taxable income to the employee. o The employer may deduct the premiums against business income as long as the premiums are a reasonable business expense.</span>
3 0
3 years ago
An authorization to start a business issued by the local government is a _____. fringe benefit zoning law business license liabi
Rina8888 [55]

An authorization to start a business issued by the local government is a business license. A business license allows a person to run a business legally. The license is used for tax purposes with the government and so the government can control and regulate the business on the legal side. If you do not have a business license, then you are a sole proprietor and running the business for tax purposes from your social security number.

5 0
3 years ago
If you have fully funded your 401(k) and profit-sharing plans up to the allowable limits, then you may want to put away more mon
jenyasd209 [6]

Answer:

annuity

Explanation:

Retirement annuities are helpful because they can guarantee a steady income during your retirement years. They can be either fixed retirement annuities (they provide a fix amount of money until you die) or variable annuities where the amount of money depends on how well your investments perform.

5 0
3 years ago
As the dominant member of the channel of distribution, Coca-Cola holds a lot of power in the relationship with independent groce
irakobra [83]

Answer:

System of Administered vertical marketing

Explanation:

Vertical marketing system is the system of cooperation among the several levels of the distributed channel. In this system, the members work together in order to promote the efficiency as well as economies of scale in the direction products are promoted to the end users.

Administered Vertical Marketing System is the one of the kind of vertical marketing system, which is a system that is coordinated among the distribution channel organisation, in that the flow of products from producer to the customer is controlled through size and power of one member of the system.

So, in this case, dominant member has the power of controlling the store. Therefore, it states the example of administered vertical marketing system.

6 0
3 years ago
the hire purchase price of a table And chairs is shilling 16800 with 25% paid as a deposit .the rest is spread over 12 equal mon
ZanzabumX [31]

Answer:

shillings . 4,200

Explanation:

The hire purchase price Shs. 16,800

The deposit is 25% of 16,800

= 25/100 x 16,800

=0.25 x 16,800

=Shs. 4,200

4 0
2 years ago
Other questions:
  • The management of Furrow Corporation is considering dropping product L07E. Data from the company’s budget for the upcoming year
    15·1 answer
  • The average fixed cost curve a. always declines with increased levels of output. b. always rises with increased levels of output
    13·1 answer
  • Advertising revenue, the lifeblood of newspaper operations, ______.
    6·1 answer
  • For customers purchasing a refrigerator at a certain appliancestore, let A be the event that the refrigerator wasmanufactured in
    14·1 answer
  •   Early Head Start is an example of        A. private preschool.   B. biological effect.   C. a nurturing environment.   D. priv
    5·1 answer
  • Materials were requisitioned for use, $28,200, of which $25,000 were direct materials. The entry is:
    5·1 answer
  • Coakley Beet Processors, Inc., processes sugar beets in batches. A batch of sugar beets costs $56 to buy from farmers and $18 to
    9·1 answer
  • Abigail has an inheritance tax lien placed on all of her property. What kind of a lien is it?
    14·1 answer
  • ________ is the public relations function which involves reacting to negative events.
    9·1 answer
  • A financial services firm that charges customers based on a percentage of the assets under management is best defined as:_______
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!