Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Week 12

Week 13

Week 14

Week 15

Week 16

Week 17

Week 18

Final Exam

OBJECTIVES

Welcome to Week 7. We will be talking about:

Setting up and using a cash flow spreadsheet
Using a cash flow spreadsheet to predict future cash flow.

TUESDAY

Complete the Celerity Checking Account
Balance Spreadsheet.

Pick Two of the Three Celebrities
Create a Checking Account Balance Spreadsheet for them!

BAKER MAYFIELD Beyonce Lionel Messi
Feb 15... Starting balance in Baker's Checking account is $18,567.89
Feb 16...Baker buys some fashionable Browns Gear using his Debit Card.  He spent 345.99 at Dicks Sporting Goods.
Feb 18...Baker pays his rent for his condo in Cleveland for  $1,950.  He uses Check #2120.
Feb 21...Baker gets paid $455 for some autographs.
Feb 22.... Baker pays his car payment.   Check #2121 for $850.
Feb 23....Baker pays his Cable Bill of $120.  He uses Check #2122.
Feb 28...Baker pays his Business Manager $15,000 from his checking using Check #2123.
March 3... Baker withdrawals $400 in cash from an ATM (there is also a $2.50 fee)
March 5... Baker buys some winter clothes for $48.50.  He uses his debit card for the purchase.
March 7...Baker Gets Paid a Bonus from the NFL of $36,927.10
March 11... Baker pays for a new heating system to be placed in his house in Cleveland.  The price is $4,300.  He uses check #2124.
March 15... Baker gets paid $400 for signing some more autographs.
March 17 ...
Feb 15... Starting balance in BEYONCE's Checking account is $1,218,005.56
Feb 16...BEYONCE buys some dresses  for $400,000.00 using her Debit Card.
Feb 17...BEYONCE buys a house for $600,000 using cash that she took out of the back (Withdrawal from checking)
Feb 18.... BEYONCE pays her hair stylist $43,200 for a new hairdo.  She uses check #5150.
Feb 18....BEYONCE gets paid $30,008.58 for royalties from sales of her new album from iTunes.
Feb 28...BEYONCE pays $25,908 in Taxes using Check #5151.
March 1... BEYONCE withdrawals $8,000 in cash from an ATM in Hollywood.
March 8... BEYONCE gets a hair cut at Great Clips for $15.00
March 11... BEYONCE pays $35.00 for dance lessons using Check #5152.
March 15... BEYONCE gets paid $25,000 for an appearance on MTV.
Feb 15... Starting balance in LIONEL’s Checking account is $100,560.65
Feb 16...LIONEL buys some soccer cleats.  The cost is $145.32 and it is check #312.
Feb 17 LIONEL gets paid $35,000 for a soccer match. 
Feb 25 LIONEL buys a used Ferrari for $80,000.  He uses check #313.
Feb 27....  LIONEL pays his security guard $2,000 using check #314.
Feb 28....LIONEL pays the dog groomer $300 for a new haircut for his dog using his debit card.
March 12...LIONEL pays his electric bill of $450 using check #315.
 

Part Two:

Complete MODULES 7 and 8

You should have modules 1  -  8 completed.
Do not be afraid to work ahead, but make sure you are
scoring 70% or higher.  If you don't like one of
your scores, ask me and I can allow you to retake it
(I just need to change it on My Computer).

 

WEDNESDAY

Don't Stop Thinking About Tomorrow!
Mister Rogers Version
(Using a spreadsheet to manage checking account cash flow)

THURSDAY and FRIDAY
Don't Stop Thinking About Tomorrow!

Mister X Version
(GROUP PROJECT)