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?...
-
The following costs result from the production and sale of 1,000 drum sets manufactured by Tom Thompson Company for the year ended December 31, 2013. The drum sets sell for $ 500 each. The company...
-
Discuss your opinion regarding whether unions are still relevant and necessary in today's work environment. What other means might be used to ensure ''employee voice'' in the workplace?
-
What is meant by the term fact pleading?
-
Time Value of Money Concept The following situations involve the application of the time value of money concept: 1. Janelle Carter deposited $9,750 in the bank on January 1, 1993, at an interest rate...
-
FACEBOOK, INC. CONSOLIDATED STATEMENTS OF INCOME (In millions, except per share amounts) Year Ended December 31, 2019 2018 2017 Revenue Costs and expenses: Cost of revenue Research and development...
-
The financial statements of Aritzia Inc. are presented in Appendix A at the end of this textbook. Instructions a. What title does Aritzia use for its income statement? What title does Aritzia use for...
-
A Ltd reported the following information for the year ended 30 June 2018: Accounting profit before tax was 700 000. A building was purchased on 1 July 2015 for $600 000. It is depreciated at 10%...
-
Write down the expressions of the lift coefficient and drag coefficient of supersonic flow around a thin airfoil, and state the physical meaning of each term?
-
Briefly describe the separation phenomenon of slender axis-symmetric body flow at high angle of attack.
-
Explain the physical concept of wing-body interference in the wing-body configuration flow.
-
Try to explain the physical causes of viscous pressure drag of steady airfoil flow.
-
Explain the basic idea of cross-flow theory of slender body flow at high angle of attack.
-
13. Silicone X, Inc. has cash flows from operations of $6.0 million, capital expenditures of $2.5 million, and a weighted average cost of capital of 7.5%. If the growth rate is expected to be 5%,...
-
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...
-
A stepped bar, fixed at \(x=0\) and free at \(x=l\), has a cross-sectional area of \(2 A\) for \(0 \leq x
-
Estimate the fundamental frequency for the longitudinal vibration of a uniform bar fixed at \(x=0\) and free at \(x=l\) by assuming the mode shapes as (a) \(U(x)=c_{1}(x / l)\) and (b) \(U(x)=c_{1}(x...
-
Estimate the fundamental frequency of a fixed-fixed string, assuming the mode shape (a) \(W(x)=c_{1} x(l-x)\) and (b) \(W(x)=c_{1} x(l-x)+c_{2} x^{2}(l-x)^{2}\).
Study smarter with the SolutionInn App