The explanation for a Spreadsheet week 17

1
The explanation for a Spreadsheet week 17

• How do you set up a spreadsheet!

2
(No Transcript)
3

• 1. How long will it take him to pay for the
  stereo?
• 2. What is the total amount José will pay for the
  stereo?
• 3. What is Josés total cost of using credit?

4
(No Transcript)
5

• Look at this formula. Write on your paper A B
• Write the answer to the following questions.
• What amount of the Stereo price?
• What is the APR amount?
• What is the Total?

6
What is a periodic interest rate?

• Periodic interest rate. The periodic interest
  rate, sometimes called the nominal rate, is the
  interest rate a lender charges on the amount you
  borrow.

7
c. What mathematical computation did you use to
get this number?
8
d. Why did I place this TOTAL here?
9
e. Write the mathematical computation or formula
for the Total PIR f. How much is the payment?
10
f. How did I get this balance? Write the formula
on your paper.
11
g. Why did I bring this amount to here? Explain.
12
h. How did I get this amount. Write down the
formula.
13
h. Now it is your turn to calculate the amounts!
You will need to do this for all last weeks
assignments.
14
Now change your calculations to 60 per month!