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....
-
Evaluate the expression. (a) 10 C 3 (b) 10 P 3
-
A publisher finds that the mean number of grammatical errors per page of a book is six. Find the probability that the number of grammatical errors found on any given page is (a) exactly four, (b) at...
-
You and several classmates are studying for the next accounting examination. They ask you to answer the following questions: 1. If cash is borrowed on a $70,000, 9-month, 12% note on August 1, how...
-
Year 1 January 5 Selk purchased 50,000 shares (20% of total) of Kildaire's common stock for $1,500,000. October 23 Kildaire declared and paid a cash dividend of $2.40 per share. December 31...
-
A cube of cast iron with sides of length a = 4.0 in. (see figure) is tested in a laboratory under triaxial stress. Gages mounted on the testing machine show that the compressive strains in the...
-
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...
-
Show that if a r.v. X has a continuous d.f. F(x), then the distribution of the r.v. Y = F(X) coincides with the distribution uniform on [0,1]. (The r.v. Y may not assume values 0 and 1, but for the...
-
Give examples of a universal set U and sets A, B and C such that each of the following sets contains exactly one element: An BOC. (AB)-C. (ANC)-B. (BOC)-A.A-(BUC), B- (AUC), C-(AUB), AUBUC. Draw the...
-
The company who needs a excellent and best type writer for its business department after screening and interviewing they have select 4 candidates smit, Leo, Mathew and Alex. lets say they identify...
-
Based on the introductory in Public Finance, what do you think must be the main role of the government in our individual lives? Any references will do, as long as the answer is related to question...
-
At the beginning of the year, Beck Company had total assets of $325,000 and total stockholders' equity of $105,000. If total assets increased by $50,000 during the year and total liabilities...
-
Determine the resultant moment in N.m at the origin of the forces couple system. (CCW is +). Q=404 N; F=808 N; P=93 N and M=93 N.m. Im Q Im A. MO = -1725.00 N.m B. MO 1911.00 N.m OC. MO = -1834.00...
-
Describe the structured interview, noting characteristics that improve upon the shortcomings of unstructured interviews.
-
What are current assets and current liabilities? How are they different from non-current assets and non-current liabilities?
-
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...
-
Give an example of one piece of financial information that may be used differently for two stakeholders (users) and explain how it would be used and presented differently?
-
Complete common -size statements (balance sheets) using the data below on page 246. You will be required to create a spreadsheet in MS Excel to display the statements (balance sheets).? In a 1 to 2...
-
A sail boat in the Great South Bay travels 2 miles east and then 4 miles south to get to Fire Island. What is its distance and displacement?
Study smarter with the SolutionInn App