Accounting budget homework

User Generated

oyvmm003

Business Finance

Blah Blah

Description

Please see the attached file and work on part-two of the homework assignment. Thanks

Unformatted Attachment Preview

IMPORTANT DIRECTIONS: 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 going out. Record these amounts in the Excel spreadsheet titled "Your Ledger". 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 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" ACC 3020 PROJECT PERSONAL BUDGET - Put Your Name Here June Budget Cash Coming In Job Work Study Total Cash Coming In 2.100 400 2.500 Cash Going Out Transportation & Gas Insurance Loan Payments Phone bill Interent / Cable Grocery Rent Credit card Miscellneous Total Cash Going Out 100 150 300 75 200 450 400 300 225 2.200 Total Savings or (Shortfall) Plus: Beginning Cash ENDING CASH $ 300 200 500 $ Actual Budget Actual August Actual Amount (Worse Than) / Better Than Budget Budget - 2.100 400 2.500 2.100 400 2.500 - 100 150 300 75 200 450 400 300 225 2.200 100 150 300 75 200 450 400 300 225 2.200 300 500 800 300 800 1.100 200 200 Input Input Data Formula Part 1 July Actual Amount (Worse) / BetterThan Budget $ $ Actual Actual Amount (Worse Than) / Better Than Budget Part 2 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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Find the solution sheet attached herewith..

IMPORTANT DIRECTIONS:
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 number...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags