Lab2 - $485,250.40 $3,459.19 Pinder $319,765.00 30 6.25...

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

View Full Document Right Arrow Icon
First National Bank - Loan Department Creator: Michael Hanley Date: 9/6/2009 Purpose: Board of Directors Updated Loan Report
Background image of page 1

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

View Full DocumentRight Arrow Icon
Michael Hanley Sheet: Loan Data Instructor: Robert Burdwell File: f9bdc9c093768e6de3ff0e2486012c6f1823bad3.xlsx Page: 2 of 3 9/6/2009 First National Bank - New Loans Customer Selling Price Loan Term Interest Rate Down Payment Amount to be Financed Monthly Payment Allen $265,354.00 30 6.25% $66,338.50 $199,015.50 $1,219.02 Arnold $328,788.00 15 5.75% $49,318.20 $279,469.80 $2,309.68 Barber $500,000.00 15 5.75% $75,000.00 $425,000.00 $3,512.41 Bollis $112,485.00 30 6.25% $28,121.25 $84,363.75 $516.75 George $350,000.00 30 6.25% $87,500.00 $262,500.00 $1,607.88 Hood $761,978.00 20 6.00% $152,395.60 $609,582.40 $4,345.51 Morgan $192,940.00 15 5.75% $28,941.00 $163,999.00 $1,355.37 Paul $606,563.00 20 6.00% $121,312.60
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $485,250.40 $3,459.19 Pinder $319,765.00 30 6.25% $79,941.25 $239,823.75 $1,468.99 Loan Term 15 5.75% 0.15 20 6.00% 0.2 30 6.25% 0.25 Loan Statistics Number of Loans 9 609582.4 84363.75 2749004.6 Todays Date 9/10/2009 Annual Interest Rate % Required for Down Payment Highest Amount Financed Lowest Amount Financed Total Amount Financed Interactive Loan Calculator Please provide the following information What is the price the home? $500,000 How much additional money will you put down? $20,000 Will you make payments at the beginning of the month? Y Based on the information above, your loan options are: Years Interest Rate Down Pmt 15 5.75% 15% $405,000 $3,347.12 20 6.00% 20% $380,000 $2,708.89 30 6.25% 25% $355,000 $2,174.47 Amt Financed Monthy Payment...
View Full Document

This note was uploaded on 09/10/2009 for the course BUS 207 taught by Professor Rhine,s during the Spring '07 term at Waubonsee.

Page1 / 3

Lab2 - $485,250.40 $3,459.19 Pinder $319,765.00 30 6.25...

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

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