Explanation Approach: The first column A is the payment number, the second column B is Principal portion, the third column C is interest portion, the fourth column D is the monthly payment, the fifth column E is the outstanding balance. Make the column A wider. Format the cell E 2 by clicking the cell and press the $ button on the Excel ribbon on top of the screen. Include the % symbol in cell G 2 . The monthly payment can be found by using the amortized loan formula. Use the PMT function in Excel. The syntax for the PMT function is PMT(interest rate, number of payments, PV, [FV],[Type]). Here, PV denotes the present value, FV denotes the future Value, Type denotes when the payments are due. Steps for the monthly payment Click on cell D 3 and then on f x button. Select “Financial” under “Function Category”. Select “PMT” under function name and then press OK. Now a PMT box will appear. Type “ $ G $ @ 2 / $ G 4 $ 2 ” after rate in PMT box. Type $ G $ @ 3 / $ G 4 $ 3 after Nper in PMT box. After PV, type $ E $ 2 . Do not type anything after “FV” or “Type”. Press OK and save the spreadsheet. Click on D 3 and change=PMT( $ G $ 2 / $ G $ 4 , $ G $ 3 ∗ $ G $ 4 , $ E $ 2 ) to =ROUND(-PMT( $ G $ 2 / $ G $ 4 , $ G $ 3 ∗ $ G $ 4 , $ E $ 2 ), 2 ) To determine (b) To find: The interest paid in the first year. To determine (c) To find: The interest paid in the last year. To determine (c) To find: The remaining balance if they sell home after 3 years .

8th Edition

ISBN: 9781305104174

Author: David B. Johnson, Thomas A. Mowry

Publisher: Cengage Learning

See similar textbooks

Concept explainers

Unitary Method

The word “unitary” comes from the word “unit”, which means a single and complete entity. In this method, we find the value of a unit product from the given number of products, and then we solve for the other number of products.

Speed, Time, and Distance

Imagine you and 3 of your friends are planning to go to the playground at 6 in the evening. Your house is one mile away from the playground and one of your friends named Jim must start at 5 pm to reach the playground by walk. The other two friends are 3 …

Profit and Loss

The amount earned or lost on the sale of one or more items is referred to as the profit or loss on that item.

Units and Measurements

Measurements and comparisons are the foundation of science and engineering. We, therefore, need rules that tell us how things are measured and compared. For these measurements and comparisons, we perform certain experiments, and we will need the experime…

Videos

Question

Chapter 5.4, Problem 67E

To determine

(a)

To find:

The amortization schedule.

To determine

(b)

To find:

The interest paid in the first year.

To determine

(c)

To find:

The interest paid in the last year.

To determine

(c)

To find:

The remaining balance if they sell home after 3 years.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 5.4, Problem 66E

Chapter 5.4, Problem 68E

Students have asked these similar questions

Using the toddler data table in Question 1 and appropriate probability notation, identify and calculate the following: a. What percentage of the toddlers are right-handed males? b. What percentage of the toddlers are right-handed females? c. Suppose that you want to see whether you can find a relation between gender and dominant hand. Can you compare your answers to parts a and b to come to a Ssb conclusion? d. Find two events in this table that are mutually exclusive.

√3/2 1 √1-x2 arcsinx 1/2 dx = 2

these are the questions and solutions. Please explain and show the method of the solutions

Chapter 5 Solutions

Mathematics: A Practical Odyssey

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.