Excel Assignment 1, NAME:                              

Possible Actual

Points Points

Credit Card Table 10

Interest Rate 10

Correct Columns 10

All cells contain formulas 10

Correct Formulas 10

Investment Table 10

Average Earnings Rate Cell 10

Correct Columns 10

All cells contain formulas 10

Correct Answers to Questions 10

Total: 100

• Question: how long will it take you to pay off the loan?
• Question: what is the total cost of all the stuff you bought?
• Question: what is the total amount you paid?
• Question: how much do Jennifer and Jazmine have to retire on?
• Question: when did Jazmine's investment strategy catch up to Jennifer's?
• Question: how much did each woman put into the fund?
• Question: what average rate of return gives them both about the same amount of money to retire on?