Explore BrainMass

# Honda Accord Car: Loan Amortization Schedule

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Please prepare a loan amortization for "Honda Accord car"

REQUIREMENTS:

YOU ARE TO USE EXCEL TO CREATE AN EXCEL FILE TO COMPLETE THE FOLLOWING ASSIGNMENT. I VIEW USING EXCEL AS IMPORTANT AS COMPILING THE INFORMATION. THOSE USING A PER-PROGRAMMED FILE WILL EARN A GRADE of 0.

YOU MUST USE FORMULAS AND FINANCIAL FUNCTIONS (PMT) TO SOLVE THE PROBLEMS AND/OR TO PREPARE YOUR SCHEDULES.

YOU MUST SUBMIT A CELL DUMP WITH YOUR COMPLETED ASSIGNMENT.

I WILL ALSO RANDOMLY ASK INDIVIDUALS TO PRESENT THEIR RESULTS TO THE CLASS OR DISCUSS WITH ME HOW THEY PREPARED THEIR ANSWERS.

PART I. Prepare a monthly loan amortization schedule USING EXCEL for a current loan that you have or an obligation that you may enter into in the future (e.g. Student loan, car loan, home mortgage, refinancing of credit card debts, etc.). You will need to state the terms of the loan (N, I, PV, PMT and FV). Regardless of the length of the loan, please prepare an amortization schedule for the first 36 months ONLY (to save paper).

PART II. In a separate table, indicate how much interest expense is paid in each of those three years and also how much is applied each year to reducing the principal balance. Also, what is your loan balance projected to be after 36 months?

PAYMENTS/
For Example: MONTHS INTEREST PRINCIPAL

1 - 12 \$ \$
13 - 24 \$ \$
25 - 36 \$ \$

If your religion does not permit you to be charged interest expense, please adjust your amortization schedule accordingly, but, state the repayment terms as applicable.
Indiv Loan Amort Web

Part 3. Analyze what happened and explain numbers.