A home is purchased for $230,000 with an amortized loan over 15 years at an interest...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A home is purchased for $230,000 with an amortized loan over 15 years at an interest rate of 4.4%. Complete an amortized loan schedule in a spread sheet and answer the following questions. a. Find the balance owed after 5 years b. Determine the cost of the loan (interest). c. If an extra $100 a month is paid towards the balance find the new number of payments and the total cost of the loan. d. If the interest rate of the loan is doubled to 8.8% does the cost of the loan double? Explain e. If the principal of the loan is doubled to $460,000 does the cost of the loan double? Explain f. If the term of the loan is doubled to 30 years does the cost of the loan double? Explain A home is purchased for $230,000 with an amortized loan over 15 years at an interest rate of 4.4%. Complete an amortized loan schedule in a spread sheet and answer the following questions. a. Find the balance owed after 5 years b. Determine the cost of the loan (interest). c. If an extra $100 a month is paid towards the balance find the new number of payments and the total cost of the loan. d. If the interest rate of the loan is doubled to 8.8% does the cost of the loan double? Explain e. If the principal of the loan is doubled to $460,000 does the cost of the loan double? Explain f. If the term of the loan is doubled to 30 years does the cost of the loan double? Explain
Expert Answer:
Answer rating: 100% (QA)
23 1 2 3 No of Years 4 Payments in year 5 Total no of Payments 8 9 10 11 182 183 184 185 6 Monthly I... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
GM Stores is a retail company that specialises in selling household and electronic goods. GM Stores also started offering cloud computing services and has invested a lot in these technologies in...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
If a currency reform has no effects on the economys real variables, why do governments typically institute currency reforms in connection with broader programs aimed at halting runaway inflation?...
-
Geek Chic Company provides computer repair services for the community. Obie Wons computer was not working, and he called Geek Chic for a home repair visit. Geek Chic Companys technician arrived at 2:...
-
Explain in words the difference between net working capital and net operating working capital.
-
Can semantic networks be used to represent anything that can be represented using temporal logic? Explain your answer.
-
Root Shoe Company makes loafers. During the most recent year, Root incurred total manufacturing costs of $26,400,000. Of this amount, $2,100,000 was direct materials used and $19,800,000 was direct...
-
An elastic bone is compressed 10 m by a student's weight. The student picks up a very heavy backpack and the same bone compressed by an extra 5 m. (a) How many times heavier or lighter is the student...
-
The Metropolitan Transit Authority (MTA) has just opened a new subway line (the Orange Line) in its underground transportation network. The Orange Line had a capital investment of $20 million,...
-
A small plane tows a glider at constant speed and altitude. If the plane does 2.00 x 10 5 J of work to tow the glider 145 m and the tension in the tow rope is 2660 N, what is the angle between the...
-
Expecting high returns, you decide to invest in the stock market. The returns will depend on various scenarios that may play out, and the two most important parameters are the growth rate of the...
-
The pressure at the eye of the impeller of a pump moving water at 120F is 2 psia. Will cavitation occur in this pump?
-
Water is being pumped through a pipe system at a temperature of 60C. Determine the maximum absolute pressure at the eye of the pumps impeller that would cause cavitation.
-
A pressure gauge attached to the suction port of a centrifugal pump indicates a pressure of 8 psig. The pump is being used to transport water at 70F. Atmospheric pressure is 14.696 psia. Will...
-
ITS Ltd is an electronics company which commenced business two decades earlier. It has an established product base and a set of loyal customers. The company is planning to introduce a new product...
-
It is now 23:20 hrs. You have conducted two 30 minute visual observations of Frieda - once at 22:30 hrs and again at 23:00 hrs. At 22:15hrs you say a quick hello and goodbye to the PCA from the...
-
XYZ Inc. a calendar year, accrual basis corporation, had the following items during 2021: Gross revenue from operations Cost of goods sold $420,000 ($180,000) $9,000 LT capital gain .LT capital...
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
While preparing Massie Miller's 2012 Schedule A, you review the following list of possible charitable deductions provided by Massie: Cash contribution to a family whose house burned...
-
Jim (age 50) and Martha (age 49) are married with three dependent children. They file a joint return for 2012. Their income from salaries totals $50,000, and they received $10,000 in taxable...
-
An analysis by Professor Peter M Rothwell and his colleagues (Nuffield Department of Clinical Neuroscience, University of Oxford, UK) published in 2012 in the medical journal The Lancet...
-
Suppose a student is interested in knowing the preferred holiday destinations of the faculty members in their university. They are affiliated to the college of business and interview a few of the...
-
The following table shows the result of the 2018 General Elections in Pakistan, along with the vote share predicted by several organizations in the days before the elections. The sample sizes were...
Study smarter with the SolutionInn App