lab2_delapena

lab2_delapena - Pinder $319,765.00 30 6.25% $79,941.25...

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

View Full Document Right Arrow Icon
First National Bank BIS155 Lab 2 Title: Lab for demonstrating some advanced formulas plus a macro\ Created By: Paul De La Pena Created On: 11/1/2010 Today is: 3/17/2011 This workbook is: 136 day old Purpose: Prepare a loan report for our customers….
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Student: Paul De La Pena Sheet: Loan Data Instructor: Kerry Miller File:ae21d5be84e6ebd87a375010a101bf66df355cf7.xlsx Page: 3 of 5 Date Printed: 03/17/2011 First National Bank - New Loans Customer Selling Price Loan Term 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 $485,250.40 $3,459.19
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Pinder $319,765.00 30 6.25% $79,941.25 $239,823.75 $1,468.99 Loan Term Interest Rate 15 5.8% 15.0% 20 6.0% 20.0% 30 6.3% 25.0% Loan Statistics Number of Loans 9 Highest Amount Financed $609,582.40 Lowest Amount Financed $84,363.75 Total Amount Financed $2,749,004.60 Todays Date 3/17/2011 Interest Rate Down Payment Amount to be Financed Monthly Payment % Required for Down Payment Interactive Loan Calculator Pleast provide the following information: What is the price of the home? $75,000 How much additional money will you put down? $0 Will you make payments at the beginning of the month? N Based on the information above, your loan options are: Years 15 5.75% 15% $63,750 $529.39 20 6.00% 20% $60,000 $429.86 30 6.25% 25% $56,250 $346.34 Interest Rate Down Payment Amt Financed Monthly Payment...
View Full Document

Page1 / 5

lab2_delapena - Pinder $319,765.00 30 6.25% $79,941.25...

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

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