Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Loan Amortization Schedule - must make in excel. Needing formula to drag to get all 120 months. Car Price 287,650 Down payment 37,650 Loan Amount

Loan Amortization Schedule - must make in excel. Needing formula to drag to get all 120 months.

Car Price 287,650
Down payment 37,650
Loan Amount 250,000
Interest 6.000% 0.005
Term 10 120

See below for example:

Month Beginning PMT Interest Principle Additional Prin Ending Balance
1 250,000.00 $2,775.51 1,250.00 $1,525.51 0 248,474

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics Of Finance

Authors: Petr Zima, Robert L. Brown

5th Edition

0070871353, 978-0070871359

More Books

Students also viewed these Finance questions

Question

Explain how thinking of a response can hamper listening.

Answered: 1 week ago