Prepare loan repayment schedule for the first five years

Assignment Help Financial Management
Reference no: EM131458333

Tillman Bragg has just received a 15-year mortgage loan for his newly acquired Sundower Inn. The purchase was financed with an $8,000,000 loan with a stated quarterly interest rate of 2%. Payments are due every 3 months. Assume a marginal tax rate of 30%. The loan can be refinanced at the end of year five for 10 years as follows: 1) 7% annual rate 2) annual payments 3) closing costs of new financing equal 3% of new loan. Assume the closing costs are part of the new loan. 4) prepayment penalty of 0.5% of the balance due. This would also be part of the new loan.

Questions:

1) Prepare a loan repayment schedule for the first 5 years.

2) What is the total interest expense for this loan over 5 years?

3) What is the interest expense less the associated tax for year one?

4) What is the balance owed at the end of 5 years?

5) What would be the amount of the new mortgage if the property were refinanced at the end of 5 years?

6) What would be the annual mortgage payment if the property were refinanced?

7) Explain whether the property should be refinanced 5 years hence.

Reference no: EM131458333

Questions Cloud

Two investments are made at the same time : Two investments are made at the same time. The first consists of investing 1570 dollars at a nominal rate of interest of 10.5 percent convertible semiannually.
What is the three-year forward price : The spot price of an investment asset is $30. It provides a fixed dividend yield of 5% with annual compounding. What is the three-year forward price?
How would i set this up using the pvif pvifga things : How would I set this up using the PVIF PVIFGA things? Liz has just paid off all her student loans and she is ready to start saving for retirement.
Which bond has higher percentage price volatility : Yield value of a price change is defined as the difference change is the difference in the yields calculated at the two price levels.
Prepare loan repayment schedule for the first five years : Tillman Bragg has just received a 15-year mortgage loan for his newly acquired Sundower Inn. Prepare a loan repayment schedule for the first 5 years.
Describe how the system will affect the hiring process : Describe how the system might affect financial management, investor relations, and market perceptions among shareholders.
Describe the antitrust law : 1. If an administrative agency begins an investigation of your company, should your company cooperate with or fight the agency's action? Please explain.
Provide five security advantages of cloud-based solutions : Provide five or more security advantages of cloud-based solutions. Explain how one or more of them could have prevented the issue in the above scenario.
What is cyber warfare : What is Cyber Warfare?Definition for Cyber Warfare.Tactical and Operational Reasons for Cyber War.

Reviews

Write a Review

Financial Management Questions & Answers

  About the merger valuation

Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt. Vandell's debt interest rate is 7.8%.  What is the per share value of Vandell to Hast..

  Suppose the average return on an asset

Suppose the average return on an asset is 11.8 percent and the standard deviation is 21.4 percent. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel to determine the probability that in any given year you wi..

  Markets required rate of return remains constant

Cayman’s Crafters is also considering issuing new shares of common stock. Their investment banker has advised them that it is a good time to sell and that the market’s required rate of return on similar securities is currently 8.5%. What price will y..

  Its return on equity has dropped from 12.25

Moogle, Inc. is in the same business as Google, Inc., but has recently retired all its debt to become an all-equity firm. Its return on equity has dropped from 12.25% to 10.60% as a result of this

  New heritage doll company case-harvard business review

What additional information does Harris need to complete her analyses and compare the two projects? What specific questions should she ask each of the project sponsors?

  Banking regulations tend to encourage financial innovation

Why do banking regulations tend to encourage financial innovation? How have money market funds, junk bonds, commercial paper, and securitization tended to reduce the profitability of traditional bank lending?

  The before tax cost of debt and cost of common stock

Debt : 200,000 bonds with 7 percent coupon rate, $1,000 par value, 15 yr to maturity, selling to maturity, for 98.6 percent of par; the bonds have annual coupons. The before tax cost of debt is: The after tax cost of debt is: The company’s cost of co..

  Describe an optimal inventory policy

The Treknotrics store begins each week with 300 phasers in stock. This stock is depleted each week and reordered. If the carrying cost per phasers is $38 per year and the fixed order cost is $75, what is the total carrying? What is the restocking cos..

  What would the estimated value for the property be now

Ace Investment Company is considering the purchase of the Apartment Arms project. Next year’s NOI and cash flow is expected to be $2,000,000, and based on Ace’s economic forecast, market supply and demand and vacancy levels appear to be in balance.  ..

  What will values of each bond be if going interest rate

What will the values of each bond be if the going interest rate is 5%, 8%, and 12%? assuem that only one more interest payment is to be made on Bond S at is maturity abd that 15 more payments are to be made on bond l.

  What is its times-interest-earned ratio

If a company has sales of $500,000, a tax rate of 25%, a profit margin of 12% and earnings before interest and taxes (EBIT) of $110,000, what is its times-interest-earned ratio

  Economic state probability return

Compute the expected return given these three economic states, their likelihoods, and the potential returns: (2 points) Economic State Probability Return

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