Unit 7: Types of Credit & Modeling Functions Assessment

Instructions

Reference: Compound Interest Formula
You may refer back to this formula as needed throughout the assessment.

2

Each of the following is an installment loan, except for a(n) ___________, which is a revolving line of credit.
Auto loan
Credit card
Mortgage
Student loan

2

Keon plans to buy a new GMC Sierra for $47,000 at 5.5% APR. Which financing option would have the lowest total interest?
60-month term and $2,000 down payment
60-month term and $3,500 down payment
36-month term and $3,500 down payment
36-month term and $5,000 down payment

2

In order to take out federal student loans, you need to…
Have a credit score above 600
Complete and submit the FAFSA
Choose a repayment plan before enrolling
Take out at least $6000 in private student loans

2

Which of the following is an example of a secured debt?
A credit card
A student loan
An auto loan
A personal loan from family

2

Which of the following best describes a Schumer box?
The portion of your monthly credit card bill that lists the minimum monthly payment due
The portion of your credit card agreement that lays out the important rates and fees
The portion of your credit card application that asks for your income and employment status
The portion of a plastic credit card that holds the magnetic stripe or chip

2

What is the main difference between an annual interest rate and an annual percentage rate (APR)?
APR is the interest rate combined with guaranteed fees
APR is almost always lower than interest rate
Interest rate is for loans, while APR is for credit cards
Interest rate is money you earn on investments, while APR is money you pay for debt

2

For most American households, the largest source of debt is:
Student loans
Credit cards
Medical debt
Mortgages

2

If you fall behind on your loan payments, all of the following are recommended steps, EXCEPT…
Calling your lender to negotiate a payment plan that fits your needs
Reducing your spending to divert additional income towards loan payments
Putting your past due loan payments on a credit card
Find additional sources of income to help catch up on past due payments

2

All of the following affect the monthly payment amount of a mortgage EXCEPT…
Down payment
Interest rate
Term of the loan
The bank that issues the mortgage

2

Mason takes out $2700 in Direct Subsidized student loans during their first semester of college. Which of the following statements is true?
Their loans will immediately start accruing interest once taken out
Their loans will start accruing interest after graduation
Their loans will enter repayment after one year
Their loans will enter repayment when they start their first job

2

What is one way to guarantee you don’t pay interest on your credit card?
Pay your entire balance in full every month
Pay your minimum monthly payment on time
Spend less than your credit limit
Only make new purchases every other month

2

After much shopping, Kelli found a car she’d love to buy. When it comes time to talk about financing, the salesperson at the dealer says, “I can offer you 6% on $24,000 for 5 years.” What do each of those numbers mean?
6% is the term, $24,000 is the down payment, 5 years is the interest rate
6% is the term, $24,000 is the interest rate, 5 years is the principal
6% is the interest rate, $24,000 is term, 5 years is the principal
6% is the interest rate, $24,000 is the principal, 5 years is the term

2

Moto has a $7000 credit card balance, and he cannot afford to pay it all off at once. The larger his monthly payments….
The longer it will take to pay it off and the smaller total interest he’ll pay
The longer it will take to pay it off and the larger total interest he’ll pay
The shorter it will take to pay it off and the smaller total interest he’ll pay
The shorter it will take to pay it off and the larger total interest he’ll pay

2

May is taking out student loans to pay for college. Why might she take out private student loans in addition to federal student loans?
She is ineligible for some federal student loans due to her parents’ low credit scores
She wants her private student loan balance to be forgiven under the Public Service Loan Forgiveness program
She needs more funding than is available through federal student loans
She wants to take advantage of the lower interest rates offered by private student loans

2

In a fully-amortized loan, which statement is true?
The principal portion of your payment increases and the interest portion decreases over time
The principal portion of your payment increases and the interest portion increases over time
The principal portion of your payment decreases and the interest portion decreases over time
The principal portion of your payment decreases and the interest portion increases over time

2

Nasir just got a letter from his credit card company that the terms of his agreement are changing. In the fine print, he notices that his interest will now be compounded daily instead of monthly. Nasir expects that his total interest will…
Increase due to more frequent compounding
Decrease due to more frequent compounding
Stay the same because the compounding frequency has no effect on interest
Increased by an additional $365

2

Which of the following scenarios could be accurately represented with the following recursive sequence?

a. An $8500 loan with a 4% monthly interest rate, compounded monthly
b. An $8500 loan with a 4% annual interest rate, compounded monthly
c. An $8500 loan that accrues $157 in interest each year
d. An $8500 loan that will take 157 months to pay off

2

When working in a spreadsheet, what symbol is used to create an absolute reference, a cell that will never change no matter where you move the formula?
a. $
b. @
c. &
d. %

2

What is the benefit of creating your own amortization spreadsheet over using the compound interest formula to calculate the total cost of the loan?
An amortization table is more accurate than the compound interest formula that often produces incorrect results due to approximations
An amortization table shows more details about your payments change over time than the compound interest formula
An amortization table involves fewer numbers and variable than the compound interest formula
An amortization table takes less time to set up and learn how to use than the compound interest formula

2

Missy was provided the following information about a loan:
Principal: $1,200
Interest Rate: 3.25%
Compounded: Monthly
Term: 4 years
She used the information to set up the following formula:

What error did Missy make?
a. The interest rate should be 0.325
b. The monthly interest rate should not be added to 1 in the parentheses
c. The exponent does not take into account the frequency of compounding
d. The interest rate should not be divided by 12

10

Jay’s store credit card offers a special financing program. The fine print states that if he does not pay his balance in full in 2 years, he will have to pay interest on his original purchase balance at 22.93% APR compounded daily. If Jay purchases a $2200 TV and makes no payments for 2 years, what will his balance be? Show your work and equation used

10

Use this amortization table to answer the following questions

a.  Write the formula that can be entered in cell C7 to calculate the monthly interest. Your formula should be written so that it can be copied and pasted to the rest of the cells in the interest column._______ 
b.  What formula would you enter into Cell E8 to calculate the balance after the 2nd monthly payment?_______ 

10

Recall the APY formula:

If an auto dealership offers you a car loan at 6.25% APR compounded monthly, what is your APY? Round to the nearest hundredth of a percent. Show Equation in your work

15

Tareq has a $15,000 auto loan with a 5.4% fixed annual interest rate, compounded monthly. He makes the minimum payment of $285 each month.
a.  What is Tareq’s monthly interest rate?_______ 
b.  Complete the table for Tareq’s balance over the first 3 months.
     n                                 f(n)
     #of Months        Loan Balance ($)
     0                                $1500
     1                               _______                        
     2                               _______ 
     3                               _______ 

c.  Write a recursive formula that represents Tareq’s balance after n months_______ 

15

Use this amortization table to answer the following questions

Re-write the appropriate line in the table if an extra $100 was added to the payment in the 4th month of this loan. Show your calculations.
Monthly Pmt #    PMT     Interest     Principal     Remaining Balance
_______                _______  _______   _______     _______ 

What would happen to the total payment amount if the interest rate increased? Why?_______ 

Unit 7: Types of Credit & Modeling Functions Assessment

Each of the following is an installment loan, except for a(n) ___________, which is a revolving line of credit.Auto loanCredit cardMortgageStudent loan

Keon plans to buy a new GMC Sierra for $47,000 at 5.5% APR. Which financing option would have the lowest total interest?60-month term and $2,000 down payment60-month term and $3,500 down payment36-month term and $3,500 down payment36-month term and $5,000 down payment

In order to take out federal student loans, you need to…Have a credit score above 600Complete and submit the FAFSAChoose a repayment plan before enrollingTake out at least $6000 in private student loans

Which of the following is an example of a secured debt?A credit cardA student loanAn auto loanA personal loan from family

For most American households, the largest source of debt is:Student loansCredit cardsMedical debtMortgages

All of the following affect the monthly payment amount of a mortgage EXCEPT…Down paymentInterest rateTerm of the loanThe bank that issues the mortgage

What is one way to guarantee you don’t pay interest on your credit card?Pay your entire balance in full every monthPay your minimum monthly payment on timeSpend less than your credit limitOnly make new purchases every other month

When working in a spreadsheet, what symbol is used to create an absolute reference, a cell that will never change no matter where you move the formula?a. $b. @c. &d. %

Recall the APY formula:If an auto dealership offers you a car loan at 6.25% APR compounded monthly, what is your APY? Round to the nearest hundredth of a percent. **Show Equation in your work**

Each of the following is an installment loan, except for a(n) ___________, which is a revolving line of credit.Auto loanCredit cardMortgageStudent loan

Keon plans to buy a new GMC Sierra for $47,000 at 5.5% APR. Which financing option would have the lowest total interest?60-month term and $2,000 down payment60-month term and $3,500 down payment36-month term and $3,500 down payment36-month term and $5,000 down payment

In order to take out federal student loans, you need to…Have a credit score above 600Complete and submit the FAFSAChoose a repayment plan before enrollingTake out at least $6000 in private student loans

Which of the following is an example of a secured debt?A credit cardA student loanAn auto loanA personal loan from family

For most American households, the largest source of debt is:Student loansCredit cardsMedical debtMortgages

All of the following affect the monthly payment amount of a mortgage EXCEPT…Down paymentInterest rateTerm of the loanThe bank that issues the mortgage

What is one way to guarantee you don’t pay interest on your credit card?Pay your entire balance in full every monthPay your minimum monthly payment on timeSpend less than your credit limitOnly make new purchases every other month

When working in a spreadsheet, what symbol is used to create an absolute reference, a cell that will never change no matter where you move the formula?a. $b. @c. &d. %

Recall the APY formula:If an auto dealership offers you a car loan at 6.25% APR compounded monthly, what is your APY? Round to the nearest hundredth of a percent. **Show Equation in your work**

Each of the following is an installment loan, except for a(n) ___________, which is a revolving line of credit.
Auto loan
Credit card
Mortgage
Student loan

Keon plans to buy a new GMC Sierra for $47,000 at 5.5% APR. Which financing option would have the lowest total interest?
60-month term and $2,000 down payment
60-month term and $3,500 down payment
36-month term and $3,500 down payment
36-month term and $5,000 down payment

In order to take out federal student loans, you need to…
Have a credit score above 600
Complete and submit the FAFSA
Choose a repayment plan before enrolling
Take out at least $6000 in private student loans

Which of the following is an example of a secured debt?
A credit card
A student loan
An auto loan
A personal loan from family

For most American households, the largest source of debt is:
Student loans
Credit cards
Medical debt
Mortgages

All of the following affect the monthly payment amount of a mortgage EXCEPT…
Down payment
Interest rate
Term of the loan
The bank that issues the mortgage

What is one way to guarantee you don’t pay interest on your credit card?
Pay your entire balance in full every month
Pay your minimum monthly payment on time
Spend less than your credit limit
Only make new purchases every other month

When working in a spreadsheet, what symbol is used to create an absolute reference, a cell that will never change no matter where you move the formula?
a. $
b. @
c. &
d. %

Recall the APY formula:

If an auto dealership offers you a car loan at 6.25% APR compounded monthly, what is your APY? Round to the nearest hundredth of a percent. Show Equation in your work

Each of the following is an installment loan, except for a(n) ___________, which is a revolving line of credit.
Auto loan
Credit card
Mortgage
Student loan

Keon plans to buy a new GMC Sierra for $47,000 at 5.5% APR. Which financing option would have the lowest total interest?
60-month term and $2,000 down payment
60-month term and $3,500 down payment
36-month term and $3,500 down payment
36-month term and $5,000 down payment

In order to take out federal student loans, you need to…
Have a credit score above 600
Complete and submit the FAFSA
Choose a repayment plan before enrolling
Take out at least $6000 in private student loans

Which of the following is an example of a secured debt?
A credit card
A student loan
An auto loan
A personal loan from family

For most American households, the largest source of debt is:
Student loans
Credit cards
Medical debt
Mortgages

All of the following affect the monthly payment amount of a mortgage EXCEPT…
Down payment
Interest rate
Term of the loan
The bank that issues the mortgage

What is one way to guarantee you don’t pay interest on your credit card?
Pay your entire balance in full every month
Pay your minimum monthly payment on time
Spend less than your credit limit
Only make new purchases every other month

When working in a spreadsheet, what symbol is used to create an absolute reference, a cell that will never change no matter where you move the formula?
a. $
b. @
c. &
d. %

Recall the APY formula:

If an auto dealership offers you a car loan at 6.25% APR compounded monthly, what is your APY? Round to the nearest hundredth of a percent. Show Equation in your work