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]
4 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]4 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
1. Based on the above article, if you were an entrepreneur, which sector would fit you the most? Justify your answer by conducti
natita [175]

Answers:

1) As an entrepreneur, I would go the route of providing online fitness services combined with healthy foods that go with specific body types.

Feasibility

Justification: As people become more and more sedentary due to social distancing, a new health problem arises.

The human body was not built to be redundant. I was built for healthy activity. Exercising protects the heart and facilitates blood circulation. The increased blood flow boosts the levels of oxygen in the body.

When this happens, the risk of heart diseases such as high cholesterol, heart attack and coronary artery disease is reduced. Regular exercise can also reduce your blood pressure and the levels of triglycerides.

Exercising without eating properly also translates to serious health problems such as stamina, strength, and weight loss. So, providing consultative services on what to eat and how to eat them and who should eat what is a great complimentary add-on to the health and fitness service.

<em>Who needs the service?</em>

Except for those with serious health issues such as heart conditions, kidney diseases, etc everyone can and should exercise to prevent them becoming overweight.

People who will be able to afford our services going from the above analysis would fall in between middle income to High Net-worth Individuals.  

We will also be looking at businesses who would be interested in purchasing health/wellness programs such as ours for their staff.

<em>Why will they buy?</em>

We'd be providing continuous health tips, great eating habits and foods which are medicinal when eaten rightly.

Besides the cost of subscribing to our services and the cost of the recommended food types, and perhaps data subscriptions (which most already have) there is no other cost involved. There won't be a need for gymnastics equipment because our method of fitness training does not require such. It depends on the use of the body's weight. This is called Callisthenics.

<em>Our Unique Selling Point</em>

We will have in our employment, nutritionists with whom they can consult on the go depending on the type of subscription they opt for.

We will also have dedicated customer care personnel whose job will be to motivate and encourage clients towards their health and fitness goals

We will also have psychologists who will help people with body insecurity needs depending on which package they sign up for.

Assuming we charge a total market of 20 Million Americans who will sign up and pay $10 every month, that comes to two hundred million USD annually.  

We also charge for specialised services using the normal wage rates but not more than $10 per hour. This is to ensure that everyone buys into the program. 40% of our revenue will go into operational expenses including lump-sum payments monthly depending on initial sales.

Given the draft feasibility above, the company stands to make at least 60% of its income as profit when the market is fully developed and that comes to about $ 120 Million.

Besides investing in our staff, we'd invest in a great digital camera, mini studio and ancillary equipment for pre-recorded training.

2. Porter's 5 forces are:

  • The risk of new players
  • The risk of substitute products
  • Power of suppliers
  • Power of customers
  • Industry Competition

 

The risk of new players entering the market is significant. It all depends on the quality of expertise one is bringing on board. Many of our trainers are going to be people with many years of experience, sound academic qualifications and great results.  

The risk of substitute products /services.  As already stated above, our well-experienced trainers will have a profile that is difficult to surpass.

The risk of suppliers usurping our model is very low. We plan to build our network to gain very quickly loads and loads of followers in their millions such that we become a great platform for suppliers of vitamin supplements, healthy packaged food products etc to sell their goods.  

Customers are always king. They hold the key to the business. That is why we will have highly trained, kind, professional, customer care personnel to cater to the needs of our clients.

Industry Competition: This is to be expected. To win the competition, we will adopt the differentiation strategy, and cost focus strategy while delivering quality care.

3. Given the above, I strongly believe that it is possible to enter with a niche strategy. There were loads of chat services which entered the market when it looked saturated but have now broken through. Our strategy in terms of pricing will be crafted such that it fits our market entry model.

4. At the time of writing this, I definitely would consider launching a business in this sector. The opportunities are enormous. It is a global market which requires specialised training. Total cost of set-up is on the low side and potential profit is very high.

Cheers!  

Download txt
6 0
4 years ago
Checking account A charges a monthly service fee of $20 and a wire transfer fee of $3, while checking account B charges a monthl
natali 33 [55]
 the answer should be  
D. 10 
3 0
3 years ago
Read 2 more answers
A(n) ____ activity is one that happens on a regular basis.
astra-53 [7]
A recurring activity is one that happens on a regular basis. These activities usually are very similar and refer to the same thing and objective. Recurring activities that an organization carries out in order to enhance its efficiency and its ability to meet requirements can lead to c<span>ontinual improvement.
</span>

6 0
3 years ago
Read 2 more answers
A manager invests $20,000 in equipment that would help the company reduce it's per unit costs from $15 to $12. He expects the eq
yKpoI14uk [10]

Since the cost of $20,000 has been incurred two years ago, the firm should check and see as to how many units of the product were produced in the two years. Did the firm produce enough items to break even the cost of acquisition. Additionally the business should also check the current market value of this two year old equipment. The business manager should weigh in the savings that is to be obtained from outsourcing along with the resale value of the old machine and then take a declension as to whether the company should go for outsourcing. Also, the business manager must examine whether the outsourcing can happen for the long run. This is because two years down the line, outsourcing may have increased the cost and again another process may look attractive. So a through cost benefit analysis should be made before taking a decision.

6 0
3 years ago
A seller has accepted an offer from John. John wants to remodel and add an outdoor pool when he has enough equity built up to co
nika2105 [10]

Answer:

make a 40% down payment upfront

Explanation:

The best arrangement that would help him accomplish this would be to make a 40% down payment upfront. The best way to build equity as fast as possible is to put down the biggest down payment that you can. The bigger the down payment, the higher the boost in equity that you will receive. That is why it is the best option. Anything above 20% down payment is the ideal scenario, while 40% would be perfection.

4 0
3 years ago
Other questions:
  • A company issues a ten-year bond at par with a coupon rate of 6.5% paid semi-annually. The YTM at the beginning of the third yea
    7·1 answer
  • The aggregate demand curve shows the graphical relationship between the aggregate price level and the A. supply available. B. ma
    14·2 answers
  • Healthy Snacks has a target capital structure of 60 percent common stock, 3 percent preferred stock, and 37 percent debt. Its co
    13·1 answer
  • company purchased factory equipment on June 1, 2013, for $80,000. It is estimated that the equipment will have a $5,000 salvage
    13·1 answer
  • When managers at a large pharmaceutical company look towards the future and think about what could be, they are likely using whi
    9·1 answer
  • Anthony's Refrigerator Pasta tries to offer higher-quality food products, more product variety, and wider distribution than its
    11·1 answer
  • It costs​ Homer's Manufacturing to produce baseballs and Homer sells them for a piece. Homer pays a sales commission of​ 5% of s
    11·1 answer
  • Match the treatment of unrealized gains and losses on debt investments existing at the time of transfer between investment categ
    11·1 answer
  • To graduate from high school, which diploma is better? IB (international bachelors) or AP (advanced placement)?
    12·1 answer
  • One of the huge benefits of just-in-time production is that the need for _______________ is eliminated.
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!