ACC3020 Personal Budget and Data Analysis Project Accounting Homework I have attached the homework assignment with this question. The homework has two port

ACC3020 Personal Budget and Data Analysis Project Accounting Homework I have attached the homework assignment with this question. The homework has two portions, I only need part one to be completed. IMPORTANT DIRECTIONS:
Look on the right side
FOR PART 1
STEP A – Workbook: YOUR BUDGET
1. Fill in all BLUE cells with your information or data
2. Show AT LEAST two sources of “cash coming in”. Note: you will have to add lines to your budget schedule
3. Show AT LEAST six categories of “cash going out”. Note: you will have to add lines to your budget schedu
4. Under each Budget column, input formulas into cells so that they calculate the following for each month:
Total Cash Coming In 2) Total Cash Going Out 3) Total Savings or (Shortfall) and 4) Ending Cash
5. Cells should be formatted so that the Ending Cash from one month becomes the Beginning Cash for the ne
6. All YELLOW cells should contain a formula.
7. Use parentheses to denote NEGATIVE numbers, i.e. a negative 493 would be (493)
8. Show a “$” sign for all the Ending Cash cells
9. Numbers with more than four digits should have a comma, i.e. 3,450
FOR PART 2
STEP A – Workbook: YOUR LEDGER
1. Beginning on June 1 and ending June 30, keep track of your daily cash coming in and cash
2. Total the amounts by column.
3. If you use your credit card to buy something, consider that amount to be “cash going out”
4. If you receive money from your parents, grandparents, etc., consider that “cash coming in”
STEP B – Workbook: YOUR BUDGET
1. Using the data recorded in YOUR LEDGER, summarize and record it in the appropriate GRAY cell under the
2. All RED cells should contain a formula
STEP C – Workbook: YOUR ANALYSIS
1. In clearly written, with correct spelling, grammar, etc., answer the three questions
cash coming in (no more than 2,500 a month)
1. Job
es to your budget schedule.
nes to your budget schedule.
ollowing for each month: 1)
Ending Cash
e Beginning Cash for the next month.
coming in”
priate GRAY cell under the column “Actual”
2. work study
cash going out (doesn’t have to be in that order)
1. transportation/gas
2. car insurance (at least $150)
3. credit card (at least 3, total $300)
4. phone bill (at least $60)
5. cable/internet (at least $200 a month)
6. pay rent to parent (at least $300-400)
7. grocery (at least $350 a month)
ACC 3020 PROJECT
PERSONAL BUDGET – Put Your Name Here
June
Budget
Actual
Cash Coming In
Total Cash Coming In
Cash Going Out
Total Cash Going Out
Total Savings or (Shortfall)
Plus: Beginning Cash
ENDING CASH
Input
Input Data Formula
Part 1
Part 2
July
Actual Amount
(Worse) /
BetterThan
Budget
Budget
Actual
August
Actual Amount
(Worse Than) /
Better Than
Budget
Budget
Actual
Actual Amount
(Worse Than) /
Better Than
Budget
ACC 3020 Project
CASH RECEIPTS AND DISBURSEMENTS – Put Your Name Here
Date
Total
Amount
Received
(Amount Paid)
Description of Item
1
2
3
Answer the following, in proper grammar and complete sentences:
How did you determine the amounts to use for your budgeted amounts?
What were the reasons for your differences on each line between the budget amount and the actual amount?
What adjustments have you made to your spending to address the differences?

Purchase answer to see full
attachment