3.4: Graphic Loan Assignment

Last updated
Save as PDF

Page ID: 13026

\( \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}}\)

The purpose of this assignment is to:

Demonstrate your understanding of the use of the PMT function.

Preparation: (Review these terms)

Review the steps in the assignment called “Advantage Loan”

New Terms (Terms are bolded in the steps below)

No new terms for this assignment

Narrative:

From the previous assignment, Advantage Loan, you learned how the PMT function calculates the periodic payment amount for money borrowed. If you want to borrow money to buy a car, a house or a college education, you need to know the Basics: The principle amount, the interest rate and the number of months you wish to borrow. All of this can be put into a formula to quickly determine what your payments will be.

Graphic Loan Assignment

1. Open Graphic Loan Spreadsheet and save it to your storage device by giving it the name Graphic Loan.

2. Complete the worksheet as follows:

Over the table width, center Graphic Solutions and center the sub-title.
Adjust the column widths so all information is visible
Bold all the column headings
Insert formula for Monthly Payment
Insert formula for Total Payments
Insert formula for Total Interest columns
Box the table
Put your name two rows below the bottom of the table.

3. Save this worksheet as Graphic Loan

4. Check the rubric below to get your maximum points.

5. Submit your completed Graphic Loan Solution to Blackboard.

6. If you are not taking this course through Blackboard, check with your instructor

Rubric for Graphic Loan Summary

Screen-Shot-2017-07-06-at-9.53.38-AM-300x273.png

Graphic Loan Assignment. Authored by: Fran Wells. License: CC BY: Attribution