Please provide responses in Excel to the following scenario: 1. Prepare the General Ledger journal entries for the General Fund for the City of Corona for the fiscal year ended May 31, 2018. a. The...

1 answer below »
I will attach instructions


Please provide responses in Excel to the following scenario: 1. Prepare the General Ledger journal entries for the General Fund for the City of Corona for the fiscal year ended May 31, 2018. a. The budget was formally adopted. Estimated revenues are $8,520,000 and appropriations are estimated to be $8,204,500. b. Revenues were received for $6,562,000. c. Purchase orders were issued for $2,950,000. d. Purchase orders were filled for $2,436,000. The invoice amount was $2,443,000, which has been paid. e. Expenditures, not encumbered, amounted to $3,225,000 which was paid. Please provide a response in Word to the following exercises: 2. Differentiate between imposed nonexchange revenues and derived tax revenues. 3. Find and provide a link, citation, and written summary of a recent podcast, article, video, or other short media that discuss one or both of these types of revenues and the difficulty that results when economic conditions change straining the operations of the recipients of government funding. An example of such as scenario could be a public-school system's financial struggles when its constituents are not paying their property tax bills timely or at all. Media chosen should be current, dated not before 2016. Paper Requirements: · Submit your responses to the questions in a 3-4-page document in MS Word plus the MS Excel documents as indicated. Label each question clearly. For computations, please include them in a table. · For written answers, please make sure your responses are well written. · The assignment should follow APA Guidleines for the use of subheadings, 1" margins, and double-spaced. · The required number of pages for the assignment does not include the title page and references page. · References need to include two additional academic references. All sources used, including your textbook, must be referenced; paraphrased and quoted material must have accompanying citations and cited per APA guidelines.
Answered Same DayDec 14, 2021

Answer To: Please provide responses in Excel to the following scenario: 1. Prepare the General Ledger journal...

Harshit answered on Dec 16 2021
150 Votes
ANSWER TO QUESTION 1:
The journal entries are as follows:
    SL NO.
    JOURNAL ENTRIES
    L.F.
    AMOUNT
     
     
     
    DEBIT
    CREDIT
    (a)
    Estimated Revenue Control A/c Dr.
     
    $85200
00
     
     
     To Appropriations Control A/c
     
     
    $8204500
     
     To Budgetary Fund Balance A/c
     
     
    $315500
     
    (Being revenue control transferred to budgetary fund balance)
     
     
     
     
     
     
     
     
    (b)
    Cash A/c Dr.
     
    $6562000
     
     
     To Revenue control A/c
     
     
    $6562000
     
    (Being cash received)
     
     
     
     
     
     
     
     
    ( c)
    Encumberances Control A/c Dr.
     
    $2950000
     
     
     To Budgetary Fund balance- Reserve for encumberances A/c
     
     
    $2950000
     
    (Being encumberances control transferred to budgetary fund account)
     
     
     
     
     
     
     
     
    (d)
    Budgetary Fund balance- Reserve for encumberances A/c Dr.
     
    $2436000
     
     
     To Encumberances Control A/c
     
     
    $2436000
     
    (Being encumbrances fund created)
     
     
     
     
     
     
     
     
    (d)
    Encumberances Control A/c Dr.
     
    $2443000
     
     
     To Cash A/c
     
     
    $2443000
     
    (Being expenditure paid)
     
     
     
     
     
     
     
     
    ( e)
    Encumberances Control A/c Dr.
     
    $3225000
     
     
     To Cash A/c
     
     
    $3225000
     
    (Being expenditure paid)
     
     
     
ANSWER TO QUESTION 2:
DIFFERENCE BETWEEN IMPOSED NON-EXCHANGE REVENUES AND DERIVED TAX REVENUES:
    SL. NO.
    IMPOSED NON-EXCHANGE REVENUES
    DERIVED TAX REVENUES
    (1)
    Imposed non exchange revenue is an assessment on non-governmental entities who are having no exchange transactions underlying.
    Derived tax revenue is an assessment on exchange transaction which are underlying by an entity or an individual.
    (2)
    It includes an entity’s activity besides an exchange transaction for instance owning a property or not following a law.
    It includes an underlying exchange transaction in which an entity might acquire a product or service or an...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here