Question: For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and

For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule.

1 .

Create a loan amortization schedule using Excel for a $

17, 500

car loan that will be repaid over

60

months at an annual interest rate of

5.0 % .

.

What is your monthly payment?

.

What is the total amount of payments made over the life of the loan

2 .

Create a loan amortization schedule using Excel for a $

225, 000

mortgage that will be repaid over

30

years with monthly payments. The annual interest rate is

7.2 % .

.

What is your monthly payment?

.

What is the total amount of payments made over the life of the loan?

.

How many years will it take to pay off the loan if you pay an extra $

125

per month?

Answer the above questions on your spreadsheet. Please put the two schedules on separate tabs

.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. 1 ....

For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. Create...

For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. You...

Excel Assignment 2: Creating Loan Amortization Schedules For this assignment you are required to create two loan amortization schedules using Excel. After you create the first one, you can simply...

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

Assignment 4 is to use SQL queries to obtain appropriate data from databases for betting decision making. In this assignment, you will be asked to write SQL queries to get relevant information from...

In order to develop our schedule, we first need to define the activities, sequence them in the right order, estimate the resources needed, and estimate the time it will take to complete the tasks. In...

A wind tunnel used in the fluid mechanics laboratory has a test section with a 40 cm x 40 cm cross section and is 60 cm in length. The test section inlet velocity is uniform and with a velocity of 10...

Variable Annuities . . . Group of answer choices are best for conservative investors looking for a steady income stream. have very low investment risk. typically pay 3 % return. are annuities where...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Jonas Doney has requested that you send him a proposal for a brochure that explains the cultural and economic climate of your state. The brochure will be sent to representatives of industries...

Should you ever give unsolicited constructive feedback? Why or why not? (Objective 3)

What role does the youviewpoint play in giving constructive feedback? (Objective 3)