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....
-
Economics is often referred to as the study of choice. a. In U.S. history, have men and women been equally free to choose the amount of education they receive even within the same family? b. What...
-
What is an economic rent? What is it based on?
-
The Baby Store had a beginning inventory on January 1 of 200 full-size strollers at a cost of $110 per unit. During the year, the following purchases were made: ___________ Units _______ Unit Cost...
-
Use the properties of logarithms to expand each logarithm as much as possible. (When possible, select "-" from the dropdown, instead of entering a negative number.) a. log2y-7 b. In y Y = 4-Y log(x)...
-
Show how the Adler algorithm (Figure 10.19) attaches weights to the data items when calculating the checksum. Figure 10.19 Start Notes L: Left 16-bit checksum R: Right 16-bit checksum D;: Next 16-bit...
-
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...
-
Does Parliament succeed in making public servants accountable for their actions?
-
Blue Ltd. (BL) is a retailer of office equipment. The company uses a periodic inventory system and on October 1 had 1,900 units of inventory with a total cost of $38,000. During the manth of October,...
-
VEC Inc. currently has 1450000 zero coupon bonds outstanding, each with a face value of $1,000. The bonds have a maturity of 4 years and they are traded in the market at 87% of par. If the tax rate...
-
A multinational company is currently producing goods in China to export to the US,WHATare the risks and strategies this company may be facing in order to deal with the uncertainties of the Trade War...
-
24) The size of a euro call is 125,000. Today, a U.S. importer places an order for machine tools that will arrive in Houston in 60 days, when he must pay 4,000,000 to the German exporter. Assume that...
-
Transaction Deposits or checking account; transaction account; Savings Deposits or savings account; Time deposits;Money Market Deposit Accounts For each service, describe whether it reflects an asset...
-
Partial comparative balance sheet and income statement information for Smith Company is as follows: In 2009, the year-end balances for Accounts Receivable and Inventory were $64,800 and $102,400,...
-
Highland Theatre is owned by Finnean Ferguson. At June 30, 2014, the ledger showed the following: Cash, $6,000; Land, $100,000; Buildings, $80,000; Equipment, $25,000; Accounts Payable, $5,000;...
-
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...
-
$'000 $'000 $'000 $'000 $'000 Sales revenue 4,620 2,840 530 f 6,930 Less cost of goods sold Opening inventories 680 630 i 30 1,280 Add purchases 3,600 2,120 f 530 5,190 Less closing inventories 710...
-
Problem 5-25 (Algo) Changes In Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO5-4, LO5-5, LO5-6] Neptune Company has developed a small inflatable toy that it is anxious to...
-
4 20 points Since 1981, family-owned Southern Tool has grown into the ultimate destination for hard working do-it-yourselfers and professionals. Southern Tool Corporation has two divisions: Hand...
Study smarter with the SolutionInn App