lab2_delapena

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

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

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….

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

View Full Document
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

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: 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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online