# 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
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
(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?

attachment

Don't use plagiarized sources. Get Your Custom Essay on
ACC3020 Personal Budget and Data Analysis Project Accounting Homework I have attached the homework assignment with this question. The homework has two port
Just from \$13/Page
Calculate the Price of your PAPER Now
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

## Calculate the price of your order

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.