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
T-account: Accounts ReceivableBeg. Bal. 188,400 105,800 18,090 63,990 5,490 14,790 19,290 Partial list of account balances at th
olganol [36]

Answer:

thats a hard one

Explanation:

7 0
3 years ago
Charles Clinton Spaulding, one of the pioneering theorists of administrative management, proposed eight _____ of management base
nikitadnepr [17]

Answer:

B, Necessities

Explanation:

Administrative management can be defined as the process of managing information between people in an organization.

One of the pioneering theorists of administrative management was Charles Clinton Spaulding. He was an African-American business leader as well as the  head of an insurance company, Mutual life insurance company, the largest black business in the USA at the time.

He postulated 8 necessities of administrative management and they are

1. Cooperation and teamwork

2. Authority and responsibility

3. Division of labor

4. Adequate manpower

5. Adequate capital

6. Feasibility studies/analysis

7. Advertising budget

8. Conflict resolution

Cheers.

4 0
3 years ago
In a suit by the National Forest Preservation Organization (NFPO) against Old Growth Logging, Inc., NFPO serves a written reques
svetlana [45]

Answer:

b. ​an admission in court.

Explanation:

An admission in the law of evidence is a prior statement by an adverse party which can be admitted into evidence over a hearsay objection. In general, admissions are admissible in criminal and civil cases

6 0
3 years ago
On January 1, 2021, Rapid Airlines issued $200 million of its 8% bonds for $184 million. The bonds were priced to yield 10%. Int
miv72 [106K]

Answer:

1.Dr Interest expense $8million

Cr Cash $8 million

2.Dr Interest expense $8 million

Cr Cash 8 million

3. Dr Bonds Payable $12million

Cr Adjustment in fair value $12 million

Explanation:

Preparation of Journal entries

1) June 30, 2021 Preparation of Journal entry for interest payment

Dr Interest expense $8million

Cr Cash $8 million

[($200 million * 8%) *6/12]

The reason why it was multipled with 6/12 was because the payments are half yearly.

2) Dec 31, 2021 Preparation of Journal entry for interest payment

Dr Interest expense $8 million

Cr Cash 8 million

[($200 million * 8%) *6/12]

3) Dec 31, 2021 Preparation of Fair value adjustment

Dr Bonds Payable $12million

Cr Adjustment in fair value $12 million

($200 million - $188 million)

3 0
3 years ago
What is a good indicator of determining if you are exercising at the most beneficial intensity level?
Flura [38]

Answer:

Target heart rate.

Explanation:

Target heart rate is a term that refers to the minimum amount of heartbeats per given amount of time that is needed in order to reach the level of exertion that is necessary for fitness.

It is different for different people because it is calculated by subtracting one's age from 220. For instance, to get the average number of maximum heartbeats per minute during an exercise, an individual of 30 years will subtract 30 from 220 to get a maximum heart rate of 190. This is therefore the maximum number of times that the person's heart should beat per minute.

Target heart rate is important because it helps people to get the most benefit from their exercise routine.

5 0
3 years ago
Other questions:
  • Anthony’s debit card was stolen and someone purchased over $1,000 worth of items on it. Which law or regulation protects Anthony
    8·1 answer
  • On May 10, Sheffield Corp. issues 2,500 shares of $5 par value common stock for cash at $12 per share.
    14·1 answer
  • Which of the following statements is true about financial planning?
    7·2 answers
  • Funds acquired by the firm through retaining earnings have no cost because there are no dividend or interest payments associated
    11·2 answers
  • The Clayton Act of 1914 makes price discrimination, exclusive dealers, tying contracts, and the acquisition of competing compani
    12·1 answer
  • Oh, no! The television was finally delivered today, but was left on the porch by the delivery company. When Jamie Lee was finall
    11·1 answer
  • Noelle, assistant manager at Green Gardens Restaurant, is preparing a questionnaire to help her evaluate customer satisfaction.
    12·1 answer
  • When consumers and businesses have greater confidence that they will be able to repay in the future, _______________________. Qu
    13·1 answer
  • United States exports soybean oil to China. However, to protect the Chinese soybean oil market, Chinese government has high tari
    13·1 answer
  • Conlon Enterprises reports the following information about resources. Cost Driver Rate Cost Driver Volume Resources used Setups
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!