An amortization table shows how a loan debt is paid off in monthly payments over the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An amortization table shows how a loan debt is paid off in monthly payments over the term of a loan. For each monthly payment, the amount paid toward interest and the amount paid toward principal varies as the principal reduces over time. The table calculation breaks down each payment into the interest and principal reduction and also indicates the outstanding principal balance. This is repeated for the duration of the loan term until the principal value is zero. An example amortization table for a $5000 loan with a two year term and an annual interest rate of 5.25% is shown below: Month Interest Principal Balance 1 2 3 4 5 6 7 8 9 10 112 13 14 15 16 17 $ 21.87 $ 21.01 $ 20.14 $ 19.26 18.39 $ 17.50 $ $198.04 $198.91 $ 199.78 $ 200.65 $201.53 $ 202.41 $ 203.30 $ 204.19 205.08 $ 205.98 $ 206.88 $ 16.62 $15.73 $ 14.84 $ 13.94 $ 13.04 $ $ 12.13 $ 207.78 $11.22 $ 208.69 $ 10.31 $ 209.61 $ 9.39 $ 8.47 $ 7.55 $ 210.52 $ 211.44 $ 212.37 $ 4801.96 $ 4603.05 $ 4403.27 $ 4202.62 $ 4001.09 $ 3798.67 $ 3595.38 $ 3391.19 $ 3186.11 $ 2980.13 $ 2773.25 $ 2565.47 $ 2356.77 $ 2147.17 $ 1936.64 $ 1725.20 $ 1512.83 Activate Windows Go to Settings to activate Windows. HABAAN222 16 17 18 19 20 21 23 24 $ 1725.20 $ 1512.83 $ 1299.53 A = $ 211.44 8.47 7.55 $ 212.37 $ $ 6.62 $ 213.30 $ $ 215.17 $ 5.69 $ 214.23 4.75 3.81 2.86 $ $ 216.11 $ $ 1.91 $ 0.96 $ 218.96 $ $ 1085.30 $ 870.13 $ 654.02 $ 217.06 $ 436.96 $ 218.01 $ 218.96 0.00 This table can be generated as follows: 1. For a term loan with initial principal balance (total loan amount) value of Bo, the monthly payment A can be computed with the formula: iBo(1+i)n (1 + i)" - 1 Where i is the monthly interest rate (decimal value), computed from an annual rate r as i = r/12, and n is the number of months in the term of the loan. For the example amortization table above, the monthly interest rate i = 0.0525/12 = 0.004375. The monthly payment is calculated using the above formula to be $219.91. 2. For each month, the interest that accumulates must be paid in full before any portion of the payment is applied toward the principal balance. The interest due for the kth month, M is calculated using the monthly interest rate i and the principal balance from the previous month as M = ix Bk-1 For example in month 3 in the example table above the interest due is calculated using the principal balance from month 2 as M3 ix B₂ = 0.004375 x 4603.05 = 20.14. 3. The remaining portion of the monthly payment is applied to reduce the principal balance using the formula B₁ B-1(A-M₂) = 3. The remaining portion of the monthly payment is applied to reduce the principal balance using the formula Bk=Bk-1-(A - M₂) The portion of the payment applied to principal (P = A - M₁ from the formula above) is given in column 3 in the example table above. Continuing the example for month 3, the amount applied to principal is P3 = A - M3 = 219.9120.14 = 199.78 (off by 0.01 due to rounding). This amount is applied to reduce the principal balance to B3 = 4403.27. 4. Steps 2 and 3 are repeated each month for the duration of the term of the loan. The outstanding principal balance is $0.00 after the last payment is applied, as shown in the table above. Code has already been provided to define a function named amortization that defines three input variables as follows. ▪ The initial loan principal is assigned to the variable LoanAmount. ■ The annual interest rate is assigned to the variable AnnualInterestRate. ■ The loan term in years is assigned to the variable TermYears. Add code to the function to use the values of these three input arguments to compute and output the monthly payment and generate data for an amortization table that is output in three column vectors. Assign values to the function output variables as follows. ■ ■ ■ Assign the monthly payment amount to the variable Payment. Assign a column vector of the monthly interest amounts to the variable Interest. Assign a column vector of the amount applied toward principal each month to the variable Principal. Assign a column vector of the outstanding loan balance at the end of each month to the variable Balance. All four outputs should be default double precision numeric data type. Do not format as currency. Note the values of LoanAmount, AnnualInterest Rate, and TermYears are defined as inputs to the function. Do not overwrite these values in your code. Be sure to assign values to each of the function output variables. Function > 1 function [Payment, Interest, Principal, Balance] = amortization (LoanAmount, AnnualInterest Rate, TermYears) 2 %Write the commands for your function here. 3 Code to call your function > C Reset 1 LoanAmount = 10000;%dollars 2 InterestRate = 0.05;%annual 3 TermYears = 5;% years 4 [Payment, Interest, Principal, Balance] = amortization (LoanAmount, InterestRate, TermYears); MATLAB Documentation C Reset An amortization table shows how a loan debt is paid off in monthly payments over the term of a loan. For each monthly payment, the amount paid toward interest and the amount paid toward principal varies as the principal reduces over time. The table calculation breaks down each payment into the interest and principal reduction and also indicates the outstanding principal balance. This is repeated for the duration of the loan term until the principal value is zero. An example amortization table for a $5000 loan with a two year term and an annual interest rate of 5.25% is shown below: Month Interest Principal Balance 1 2 3 4 5 6 7 8 9 10 112 13 14 15 16 17 $ 21.87 $ 21.01 $ 20.14 $ 19.26 18.39 $ 17.50 $ $198.04 $198.91 $ 199.78 $ 200.65 $201.53 $ 202.41 $ 203.30 $ 204.19 205.08 $ 205.98 $ 206.88 $ 16.62 $15.73 $ 14.84 $ 13.94 $ 13.04 $ $ 12.13 $ 207.78 $11.22 $ 208.69 $ 10.31 $ 209.61 $ 9.39 $ 8.47 $ 7.55 $ 210.52 $ 211.44 $ 212.37 $ 4801.96 $ 4603.05 $ 4403.27 $ 4202.62 $ 4001.09 $ 3798.67 $ 3595.38 $ 3391.19 $ 3186.11 $ 2980.13 $ 2773.25 $ 2565.47 $ 2356.77 $ 2147.17 $ 1936.64 $ 1725.20 $ 1512.83 Activate Windows Go to Settings to activate Windows. HABAAN222 16 17 18 19 20 21 23 24 $ 1725.20 $ 1512.83 $ 1299.53 A = $ 211.44 8.47 7.55 $ 212.37 $ $ 6.62 $ 213.30 $ $ 215.17 $ 5.69 $ 214.23 4.75 3.81 2.86 $ $ 216.11 $ $ 1.91 $ 0.96 $ 218.96 $ $ 1085.30 $ 870.13 $ 654.02 $ 217.06 $ 436.96 $ 218.01 $ 218.96 0.00 This table can be generated as follows: 1. For a term loan with initial principal balance (total loan amount) value of Bo, the monthly payment A can be computed with the formula: iBo(1+i)n (1 + i)" - 1 Where i is the monthly interest rate (decimal value), computed from an annual rate r as i = r/12, and n is the number of months in the term of the loan. For the example amortization table above, the monthly interest rate i = 0.0525/12 = 0.004375. The monthly payment is calculated using the above formula to be $219.91. 2. For each month, the interest that accumulates must be paid in full before any portion of the payment is applied toward the principal balance. The interest due for the kth month, M is calculated using the monthly interest rate i and the principal balance from the previous month as M = ix Bk-1 For example in month 3 in the example table above the interest due is calculated using the principal balance from month 2 as M3 ix B₂ = 0.004375 x 4603.05 = 20.14. 3. The remaining portion of the monthly payment is applied to reduce the principal balance using the formula B₁ B-1(A-M₂) = 3. The remaining portion of the monthly payment is applied to reduce the principal balance using the formula Bk=Bk-1-(A - M₂) The portion of the payment applied to principal (P = A - M₁ from the formula above) is given in column 3 in the example table above. Continuing the example for month 3, the amount applied to principal is P3 = A - M3 = 219.9120.14 = 199.78 (off by 0.01 due to rounding). This amount is applied to reduce the principal balance to B3 = 4403.27. 4. Steps 2 and 3 are repeated each month for the duration of the term of the loan. The outstanding principal balance is $0.00 after the last payment is applied, as shown in the table above. Code has already been provided to define a function named amortization that defines three input variables as follows. ▪ The initial loan principal is assigned to the variable LoanAmount. ■ The annual interest rate is assigned to the variable AnnualInterestRate. ■ The loan term in years is assigned to the variable TermYears. Add code to the function to use the values of these three input arguments to compute and output the monthly payment and generate data for an amortization table that is output in three column vectors. Assign values to the function output variables as follows. ■ ■ ■ Assign the monthly payment amount to the variable Payment. Assign a column vector of the monthly interest amounts to the variable Interest. Assign a column vector of the amount applied toward principal each month to the variable Principal. Assign a column vector of the outstanding loan balance at the end of each month to the variable Balance. All four outputs should be default double precision numeric data type. Do not format as currency. Note the values of LoanAmount, AnnualInterest Rate, and TermYears are defined as inputs to the function. Do not overwrite these values in your code. Be sure to assign values to each of the function output variables. Function > 1 function [Payment, Interest, Principal, Balance] = amortization (LoanAmount, AnnualInterest Rate, TermYears) 2 %Write the commands for your function here. 3 Code to call your function > C Reset 1 LoanAmount = 10000;%dollars 2 InterestRate = 0.05;%annual 3 TermYears = 5;% years 4 [Payment, Interest, Principal, Balance] = amortization (LoanAmount, InterestRate, TermYears); MATLAB Documentation C Reset
Expert Answer:
Related Book For
Statistics The Exploration & Analysis of Data
ISBN: 978-1133164135
7th edition
Authors: Roxy Peck, Jay L. Devore
Posted Date:
Students also viewed these accounting questions
-
(1) Given A and i. (1a) Find the equivalent amount at the end of year 1. (1b) Find the equilvalent amount at the end of year B. (2) Given X and i, Find the annual equivalent A from year S to 8. *...
-
The EnTaRe charity was established in 1960. The charity's aim is to provide support to chilidren from disadvantaged backgrounds who wh to ake part in sports such tenns badminton and football EnTaRe...
-
Determine CPI, ETC (1), and EAC. Activity Total PV 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 6 6 2 20 10 10 3 30 9 6 6 6 3 4 20 8 2 5 5 5 16 4 4 4 4 6 18 9 9 7 8 4 4 Status Report: Ending Period 5 Task %...
-
In Mark A. Cohen, The Costs and Benefits of Oil Spill Prevention and Enforcement, Journal of Environmental Economics and Management Vol. 13 (June 1986), an attempt was made to quantify the marginal...
-
Genius Computers sells computers and offers an assurance-type warranty that covers all repair costs, including parts and labor, for one year after the date of purchase. Genius also sells a service-...
-
Identify and describe the types of warranties.
-
What does CFF stand for? What organization provides this certificate?
-
On December 1, 2012, Bluemound Company had the following account balances. During December, the company completed the following transactions. Dec. 7 Received $3,600 cash from customers in payment of...
-
On March 1 a dressmaker starts work on three custom-designed wedding dresses. The company uses job order costing and applies overhead to each job (dress) at the rate of 48% of direct materials costs....
-
Mailin Moon is a freelance writer who submits articles to various magazines and newspapers. She operates out of a small office where she employs one administrative assistant. The following activities...
-
Smoking induces secondhand smoke, imposing costs on non-smokers. (a) Draw a graph for demand curve, supply curve and social-value curve. Briefly explain the difference between market equilibrium and...
-
Concentric circles a. Different values of damped natural frequency b. Different values of reciprocals of time constant c. Different values of damping ratio d. Different values of natural frequency
-
In 2012, a group in Germany proposed a wealth taxon buildings, machinery, and equipmentthat would be levied on all employers having at least \($1.4\) million invested in such assets. Use theory...
-
AB Consulting and DF Partners are two identical consulting firms in all aspects except that AB Consulting fires all new hires who dont bring in at least \($5\) million in revenue during their 4-year...
-
An electronic instrument, weighing \(1000 \mathrm{~N}\), is supported on a rubber mounting whose forcedeflection relationship is given by \(F(x)=157 x+0.2 x^{3}\), where the force \((F)\) and the...
-
A cantilever beam of length \(L\) and Young's modulus \(E\) is subjected to a bending force at its free end. Compare the spring constants of beams with cross sections in the form of a solid circle...
-
Required: Determine the missing numbers. Note: Enter all amounts as positive numbers. Enter your answers in thousands. 2024 2025 2026 Beginning inventory $ 200 Cost of goods sold $ 666 $ 634 Ending...
-
Privitera and Freeman (2012) constructed a scale to measure or estimate the daily fat intake of participants; the scale was called the estimated daily intake scale for fat (EDIS-F). To validate the...
-
Jail inmates can be classified into one of the following four categories according to the type of crime committed: violent crime, crime against property, drug offenses, and public-order offenses....
-
In an AP-AOL sports poll (Associated Press, December 18, 2005), 272 of 394 randomly selected baseball fans stated that they thought the designated hitter rule should either be expanded to both...
-
What is the difference between and ? between s and ?
-
For the following sets of functions: (i) show that each is orthogonal on the given interval, and (ii) determine the corresponding orthonormal set. a. \(\{\sin 2 n x\}, \quad n=1,2,3, \ldots, \quad 0...
-
Consider the square wave function \[f(x)=\left\{\begin{array}{rc} 1, & 0
-
Consider \(f(x)=4 \sin ^{3} 2 x\). a. Derive the trigonometric identity giving \(\sin ^{3} \theta\) in terms of \(\sin \theta\) and \(\sin 3 \theta\) using DeMoivre's Formula. b. Find the Fourier...
Study smarter with the SolutionInn App