unit 2 brenda russell excel

# unit 2 brenda russell excel - \$11,250.00 \$25,824.71 2...

This preview shows pages 1–2. Sign up to view the full content.

Unit 2 DS Template John borrows \$150,000. The terms of the loan are 7.5% over the next 5 years. It is im Construct a loan amortization schedule that shows the 5 payments of John's loan.  A sample of a Loan Amortization Schedule can be found on page 53 in Table 2.4. (S Payment calculation in Excel - to complete this assignment we must first determine t PV = \$150,000.00 FV = 0 n = 5 nper I = 0.08 rate PMT = ? PMT (\$37,074.71) This is then the ANNUAL payment, it is negative because Year Beginning Amount Payment Interest Applied to M 1 \$150,000.00 \$37,074.71

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: \$11,250.00 \$25,824.71 2 \$124,175.29 \$37,074.71 \$9,313.15 \$27,761.56 3 \$96,413.73 \$37,074.71 \$7,231.03 \$29,843.68 4 \$66,570.05 \$37,074.71 \$4,992.75 \$32,081.96 5 \$34,488.09 \$37,074.71 \$2,586.61 \$34,488.10 important to note that he makes annual rather than monthly payments. Section 2.18 focuses on amortized loans). Submit your assignment to the Dropbox. the payment, using Excel or a financial calculator is is a cash outflow … it is a payment you make ortage Ending Balance due \$124,175.29 \$96,413.73 \$66,570.05 \$34,488.09 (\$0.01)...
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

unit 2 brenda russell excel - \$11,250.00 \$25,824.71 2...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online