A loan of $450,000 is amortized over 30 years with payments at the end of each...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A loan of $450,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.1%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the first 15 payments. $ c) Find the total amount of interest paid over the life of the loan. $ d) Find the total of all payments made over 30 years. $ Suppose that payment number 8 is skipped and the interest owed for month 8 is added to the balance. Payments then resume as usual for the remainder of the 30 years. e) Find the balance owing at the end of month 8. $ f) Find the balance remaining after the 360th payment. $ A loan of $450,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.1%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the first 15 payments. $ c) Find the total amount of interest paid over the life of the loan. $ d) Find the total of all payments made over 30 years. $ Suppose that payment number 8 is skipped and the interest owed for month 8 is added to the balance. Payments then resume as usual for the remainder of the 30 years. e) Find the balance owing at the end of month 8. $ f) Find the balance remaining after the 360th payment. $
Expert Answer:
Answer rating: 100% (QA)
To create the amortization table in Excel we can use the PMT function to calculate the monthly payment and then use a combination of formulas to calcu... 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 accounting questions
-
26. With its current leverage, Impi Corporation will have net income next year of 4.5 million. If Impis corporate tax rate is 35% and pay 8% interest on its debt, how much additional debt can Impi...
-
Amira and her husband, Owen, are both 40 years of age and own a small bungalow in the B secAon of Brossard. They have one daughter, Ellie, born in November of 2015. Amira is the Eastern Canada Sales...
-
Part A: Millie Bandes, a successful entrepreneur, is setting up a new division for the manufacture of three new products that will complement her current line of business. Millie is currently...
-
Each of the following passages may be plausibly criticized by some who conclude that it contains a fallacy, but each may be defended by some who deny that the argument is fallacious. Discuss the...
-
An analysis in which all the components of an income statement are expressed as a percentage of net sales is called a. Solvency analysis. b. Horizontal analysis. c. Liquidity analysis. d. Vertical...
-
Multiply or divide as indicated. Write answers in lowest terms as needed. 2= 1 2
-
The following information relates to Heather Limited and its subsidiary, Thistle*Limited. 1. Heather Limited Retained profits as at 31 March 2008 700,000. 80,000 ordinary shares were purchased in...
-
For nearly 20 years Custom Coatings has provided painting and galvanizing services for manufacturers in its region. Manufacturers of various metal products have relied on the quality and quick...
-
Appalachian Crafts is analyzing a project with expected sales of 18,900 units, 2 percent. The expected variable cost per unit is $23 and the expected fixed costs are $52,000. Cost estimates are...
-
Using the format presented in Figure 2-4 in the text develop a flowchart for the process of paying vendor accounts payable. Assume that vendor invoices are received and sent to the AP department...
-
Pick a topic and show how you would research it using the classical experimental model (ie: assessing a tutoring program for children, evaluating a rehabilitation program for prison inmates,...
-
Ill stick with you through thick and thin, or What have you done for me lately? Which best describes the attitude of customers in todays marketplace? Two quality managers are debating the concept of...
-
When should the auditor avoid judgment sampling?
-
Is the same true of discovery sampling?
-
Describe parallel simulation.
-
Mark Berry, Sandra Griffith, and Juan Carlos are seniors at Florida Tech University, majoring in industrial technology with a quality emphasis. All three hope to be quality directors after...
-
LKD Co . has 8 percent coupon bonds with a YTM of 4 . 8 percent. The current yield on these bonds is 7 . 9 percent. How many years do these bonds have left until they mature? The bonds pay coupons...
-
A container holds 2.0 mol of gas. The total average kinetic energy of the gas molecules in the container is equal to the kinetic energy of an 8.0 10-3-kg bullet with a speed of 770 m/s. What is the...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family. Ivan and Irene have the following investment income, in addition to that reported in Chapter 1: Dividends...
-
Rebecca and Walter Bunge have been married for 5 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Rebecca is a homemaker and Walt is a high school teacher. Rebecca's Social...
-
Jim is fired from his job as a waiter and decides to take an extended trip to Europe. After touring Europe for 3 months, Jim returns to look for a new job as a waiter. Are his job-hunting expenses...
-
Poseidon Electronics operates ten stores in Washington, Oregon, and California selling consumer electronics including stereo equipment and home theater systems. The following financial information is...
-
Economic Value Added and the Balanced Scorecard Spectrum Book Company has two divisions-the Brick and Mortar division sells books through more than 100 bookstores throughout the United States; the...
-
Kasper Industries produces custom molds that are used by producers of molded products (e.g., ski boots and snowboards). Many of its customers use just-in-time (JIT) manufacturing, and on-time...
Study smarter with the SolutionInn App