You want to take out a $300,000 loan on a 20-year mortgage with end-of-month payments. The annual
Question:
You want to take out a $300,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 6%. Twenty years from now, you will need to make a $40,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%.
a. Determine the amount of each year’s monthly payment. You should use a lookup table to look up each year’s monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.).
b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.06/12,240,-300000,0,0).
Step by Step Answer:
a Mortgage with balloon payment Annual interest rate 6 Annual payment growth 2 Balloon payment 40000 after 20 years Starting balance 300000 Month Payment Balloon payment Starting balance Interest Endi...View the full answer
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Students also viewed these Business questions
-
Suppose that you want to take out a loan and that your local bank wants to charge you an annual real interest rate equal to 3%. Assuming that the annualized expected rate of inflation over the life...
-
Five years ago you took out a $300,000, 25-year mortgage with an annual interest rate of 7 percent and monthly payments of $2,120.34. What is the outstanding balance on your current loan if you just...
-
You want to buy a house that costs $100,000. You have $10,000 for a down payment, but your credit is such that mortgage companies will not lend you the required $90,000. However, the realtor...
-
Suppose that a 7% semi-annual coupon bond with a time to maturity of 8 years and a par value of $100 has a price of $106,4. This bond is first callable in 6 years at a redemption price of $104,8....
-
Gamma's objective is to select the bid that maximizes its expected profit. a. What is the optimal bid for Gamma to make? b. What is the expected profit associated with the optimal bid in part (a)? c....
-
Determining effects of closing entries Gloriosa Company began the current period with a \($28,000\) credit balance in the M. Gloriosa, Capital account. At the end of the period, the companys adjusted...
-
Following is a sample of five matched pairs. Let 1 and 2 represent the population means and let d = 1 2. A test will be made of the hypotheses H0: d = 0 versus H1: d > 0. a. Compute the differences....
-
Assume that you are assigned the task of testing internal controls over financial reporting for the Van Jacobs Corporation year 2011 audit. Van Jacobs Corporation has a December 31 fiscal year end....
-
Shorty is worried that his health may soon deteriorate to the point wnere ne will no longer be able to take care of his own finances. One way he could ease his mind would be to: name an executor to...
-
The diffraction peaks shown in figure are indexed according to the reflection rules for BCC (i.e., the sum h + k + l must be even). Cite the h, k, and l indices for the first four diffraction peaks...
-
Suppose you are planning for retirement. At the beginning of this year and each of the next 39 years, you plan to contribute some money to your retirement fund. Each year, you plan to increase your...
-
An automobile manufacturer needs to plan its production for the next year. Demands for the next 12 months are forecasted to be 940, 790, 360, 720, 270, 130, 160, 300, 990, 290, 280, and 790. Other...
-
A product is composed of four parts. In order for the product to function properly in a given situation, each of the parts must function. Two of the parts have a .96 probability of functioning, and...
-
8. Determine the value of n that makes the polynomial a perfect square of a binomial and identify the perfect square binomial. a) m - 8m+n 4 b) m+m+n
-
Maurice has invested $12,000 in a security that pays 4% interest compounded monthly. How much interest does he earn in the 4th year of the investment? In the 4th year, Maurice earns __________?
-
If concrete costs $102.00 per cubic yard, what is the costof the concrete material required for the new building additionslab on carton forms? You MUST round up to the nearest wholenumber.
-
On July 1, 2025, Green Company accepted a one-year, 10 % note for $6,000 in settlement of an overdue account receivable. The accounting period ends on December 31. What would be the journal entry to...
-
How should the management of health care databases change as the health care industry changes? What are some potential risks? Provide examples and references
-
Write the electron-dot structure for the covalent compound acetylene, C 2 H 2 .
-
Sundial Technologies produces and sells customized network systems in New Brunswick. The company offers a 60-day, all software and labor-and an extra 90-day, parts-only- warranty on all of its...
-
Josie is a sales representative for Talk2Me, a communications retailer based in Fort Smith, Arkansas. Josie's sales territory is Oklahoma, and she regularly takes day trips to Tulsa to meet with...
-
Kim Corporation, a calendar year taxpayer, has manufacturing facilities in States A and B. A summary of Kims property holdings follows. Determine Kims property factors for the two states assuming...
-
True Corporation, a wholly owned subsidiary of Trumaine Corporation, generated a $400,000 taxable loss in its first year of operations. True's activities and sales are restricted to State A, which...
-
Kate Elliott, "a new product development specialist at Donaldson Family Foods, Inc., paced in her office and shuffled papers on her desk. She had a lot of work to do, but she couldn't seem...
-
Every year, Dr. Cook, a college professor, leads a group of 25 college students to the Middle East on an archaeological dig that usually lasts about eight weeks. The participants, who come from big...
-
Imagine you're part of a small team working at a tech start-up called "InnoTech Solutions." Your team consists of five members: Alex: Project Manager, with a background in software development....
Study smarter with the SolutionInn App