Purchase Solution

Loan Amortization Schedule Comparison Project

Not what you're looking for?

Ask Custom Question

Develop a loan amortization project using Excel spreadsheets. This can be a car loan or a home mortgage. You will develop two alternative loan schedules using realistic rates and repayment schedules and write up a comparison of your two amortization schedules. This involves two tables and two line graphs displaying the decrease in principal.

1. Open the spreadsheet, plan which two loans you want to compare.

2. Fill in the cells for loan amount, rate, and years for the loan.

3. Create two line graphs for the ending balance. Please label the bottom or x axis and the left of the graph or y axis. Write a title across the top.

4. Use the CTRL button to select years and ending balance COLUMNS

5. Insert a line graph, choose the first picture of a line graph. REPEAT for the second loan.

6. Delete the blue points from the graph, label the left side "Ending Balance".

7. In Microsoft Word, write about the trends you see in the amortization table in two paragraphs. My Suggestions: Write another two paragraphs about the second amortization table. Then write your last two paragraphs comparing the two tables.

Purchase this Solution
Solution Summary

This solution shows how to create an amortization schedule excel. It also shows how to create a line graph using excel and offers suggestions of types of loan amortizations that can be done.

Solution Preview

Your first step would be to identify the loans you want to compare and create your amortization schedules. To access the amortization template in excel click on file/new, then if you are using office 2003 click on templates/business templates/amortization schedule. If you are using office 2010 after you click on new click on Schedules under the Microsoft online section, then Loan Amortization schedule. Fill in the information pertaining to the loans of your choice. Once all the pertinent loan information is entered your amortization schedule will appear.

To create your graph you first ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Probability Quiz

Some questions on probability

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

View More Free Quizzes
Related BrainMass Solutions

  • 3 Amortization Schedules

    Then prepare a loan amortization schedule in Euros for the loan amount converted to US$. 1 US$ = 0.7849 Euro 1 Euro = 1.2740 US$ Amortization Schedule loan amortization schedule in Euro G = E * F I= G *

  • Car Buying Comparison

    Create and format a data table that includes the interest rate schedule. Create and format the amortization schedule using the present value and future value functions. Sheet 2: Car 2 Create and format a Loan Payment Calculator section.

  • Home financing options

    . ** Please see the attached Excel file for the amortization schedule ** I have attached a spreadsheet that has an amortization schedule for a 30 year fixed rate loan with no points and a 30 year fixed rate loan with points paid.

  • Mini-Project 1: Mortgage Loan Analysis

    378052 Mortgage Loan Analysis Mini-Project 1: Mortgage Loan Analysis: Mr. and Mrs. Smith plan to buy a house in Los Angeles in October, 2010. The purchase price of the house is $580,000.

  • Amortization Schedule for Two Loans

    563531 Amortization Schedule for Two Loans A) Prepare the two loan amortization schedules based on the terms below. The first amortization schedule should reflect equal annual payments.

  • Economic Concepts - Expected Value, Amortization, Cash Flows

    Amortization: Amortization is the distribution of a single lump-sum cash flow into many smaller cash flow installments, as determined by an amortization schedule.

  • Loan amortization schedule

    50348 Loan amortization schedule problem Consider a 4-year amortizing loan. You borrow $10,000 initially, and repay it in four equal annual year-end payments. a. Fill in the following Loan amortization schedule b.

  • Loan Interest Deduction for Liz Rogers - Amortization Schedule

    365866 Loan Interest Deduction: Amortization Schedule Loan interest deductions Liz Rogers just closed a $10,000 business loan that is to be repaid in three equal, annual, end-of-year payments. The interest rate on the loan is 13%.

  • Loan Amortization Schedule and Determining Interest Rate

    275491 Loan Amortization Schedule and Determining Interest Rate What is a loan amortization schedule? How would you use it to determine your loan interest rate? What factors would affect your choice between two loans?

View More Related Solutions