Skip to main content
Chemistry LibreTexts

9.03 My First Car - Spreadsheet

  • Page ID
    185055
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    You will be using the Internet to compare two different vehicles. You will then determine payments on these vehicles using Microsoft Excel. You will finish the lesson by writing a letter describing your findings.

    1. Research on the Internet two vehicles: one new and one used.  They do not need to be the same vehicle. 
    2. Make a list of all of the oF all options each car has.
    3. Open Microsoft Excel to input the two prices for their vehicles and the bank loan information.
    4. Calculate the monthly payments and yearly payments for the vehicles based on the loan time and percentage given by the teacher.  Interest Rate 8%   Loan Time Period is 5 years.

    Attached you will find a .pdf file with some additional help on setting up and formatting your spreadsheet. You will turn in your letter on the next page. 



    9.03 My First Car - Spreadsheet is shared under a CC BY-NC-SA 4.0 license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?