Online Resources

Spread Sheet Unit
Microsoft Excel

Home Page

Online Help & Tutors

FAQ

Online Resources

Ask Mr. Kelsey

Use the following resources to gather information for your various worksheet activities.

Directions

  1. In the area labeled "Loan Amount," type in the loan amount you requested in your business letter earlier in the quarter.  If you didn't ask for a particular amount, use the amount $300,000.

  2. Change the "Term in Months" to 360 giving you a 30 year loan.

  3. Change the "Interest Rate" to 6%

  4. Click on "Calculate" and use the amount listed under "Monthly Payment" for your spreadsheet.

Directions: 

  1. Click on the type of car you want to find the price for.

  2. Then click on the specific model

  3. Then click on the year and trim (for example: 2001 Coupe 2D)

  4. Then click on get pricing report

  5. The "Retail Value" is what you should use for your spreadsheet.

 

Created By: John Kelsey
Updated July 3, 2002
Contact: John_Kelsey@ipsd.org