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
|
|
|
|
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:
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).
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)