CPA DemoLes 7 PMT demo & practice

CPA DemoLes 7 PMT demo & practice - Problem 1 Payment...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Problem 1 Payment Schedule for a Loan Loan Amount $5,000.00 Annual Interest Rate (APR) 6% Term (In years) 1 Periods in a year 12 Monthly Payment $430.33 Schedule Interest Prinicple Start $5,000.00 End of Period 1 $25.00 $405.33 $4,594.67 End of Period 2 $22.97 $407.36 $4,187.31 End of Period 3 $20.94 $409.40 $3,777.91 End of Period 4 $18.89 $411.44 $3,366.47 End of Period 5 $16.83 $413.50 $2,952.97 End of Period 6 $14.76 $415.57 $2,537.40 End of Period 7 $12.69 $417.65 $2,119.76 End of Period 8 $10.60 $419.73 $1,700.03 End of Period 9 $8.50 $421.83 $1,278.19 End of Period 10 $6.39 $423.94 $854.25 End of Period 11 $4.27 $426.06 $428.19 End of Period 12 $2.14 $428.19 $(0.00) Total Interest $163.99 Remaining Principle 1. Calculate the m create a payment the following terms total interest paid Loan amount: Annual interest rat Periods in a year: Term (in years):
Background image of page 1

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

View Full DocumentRight Arrow Icon
onthly payment and schedule for a loan with s. Also determine the over the life of the loan. $5,000 te: 6% 12 1 year
Background image of page 2
Problem 2 Payment Schedule for a Loan Loan Amount $2,500.00 Annual Interest Rate (APR) 8% Term (In years) 1.5 Periods in a year 12 Monthly Payment $147.85 Schedule Interest Prinicple Start $2,500.00 End of Period 1 $16.67 $131.18 $2,368.82 End of Period 2 $15.79 $132.06 $2,236.76 End of Period 3 $14.91 $132.94 $2,103.82 End of Period 4 $14.03 $133.83 $1,969.99 End of Period 5 $13.13 $134.72 $1,835.28 End of Period 6 $12.24 $135.62 $1,699.66 End of Period 7 $11.33 $136.52 $1,563.14 End of Period 8 $10.42 $137.43 $1,425.71 End of Period 9 $9.50 $138.35 $1,287.36 End of Period 10 $8.58 $139.27 $1,148.10 End of Period 11 $7.65 $140.20 $1,007.90 End of Period 12 $6.72 $141.13 $866.77 End of Period 13 $5.78 $142.07 $724.70 End of Period 14 $4.83 $143.02 $581.68 End of Period 15 $3.88 $143.97 $437.70 End of Period 16 $2.92 $144.93 $292.77 End of Period 17 $1.95 $145.90 $146.87 End of Period 18 $0.98 $146.87 $(0.00) Total Interest $161.31 Remaining Principle 2. Calculate the and create a pay a loan with the fo Also determine t paid over the life Loan amount: Annual interest r Periods in a year Term:
Background image of page 3

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

View Full DocumentRight Arrow Icon
monthly payment yment schedule for following terms. the total interest e of the loan. $2,500 rate: 8% r: 12 1.5 years
Background image of page 4
Problem 3 Payment Schedule for a Loan Loan Amount $20,000.00 Annual Interest Rate (APR) 6.50% Term (In years) 3 Periods in a year 12 Monthly Payment $612.98 Schedule Interest Prinicple Start $20,000.00 End of Period 1 $108.33 $504.65 $19,495.35 End of Period 2 $105.60 $507.38 $18,987.97 End of Period 3 $102.85 $510.13 $18,477.84 End of Period 4 $100.09 $512.89 $17,964.95 End of Period 5 $97.31 $515.67 $17,449.28 End of Period 6 $94.52 $518.46 $16,930.82 End of Period 7 $91.71 $521.27 $16,409.55 End of Period 8 $88.89 $524.10 $15,885.45 End of Period 9 $86.05 $526.93 $15,358.52 End of Period 10 $83.19 $529.79 $14,828.73 End of Period 11 $80.32 $532.66 $14,296.07 End of Period 12 $77.44 $535.54 $13,760.53 End of Period 13 $74.54 $538.44 $13,222.09 End of Period 14 $71.62 $541.36
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Page1 / 26

CPA DemoLes 7 PMT demo & practice - Problem 1 Payment...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online