Following is the trial balance of City of Kendall Green’s General Fund at December 31, 2019. Using MS-Excel, prepare well-formatted worksheets as follows:
Q: The production department is proposing the purchase of an automatic insertion machine. It has…
A: Average rate of return : Average rate of return calculate the rate at which average income is…
Q: Alexa owns a condominium near Cocoa Beach in Florida. In 2022, she incurs the following expenses in…
A: Gross income is the amount an entity generates before deducting any expenses, which may be variable…
Q: Required Information [The following information applies to the questions displayed below.] Preble…
A: Variable costs are costs that vary with the change in the level of output.Factory overhead is the…
Q: Dual Transfer Pricing The Greek Company has two divisions, Beta and Gamma. Gamma Division produces a…
A: The Transfer pricing is the pricing of transactions between divisions of a business entity. It…
Q: E3.9 The income statement of Wolfmother Ltd for the month of July 2014 shows a profit of $1400 based…
A: "Since you have asked multiple questions, we will solve first question for you. If you want any…
Q: BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following…
A: Balance sheet is the statement of financial position being prepared in business. It shows all…
Q: A manufacturer reports the information below for three recent years. Year 1 $ 116,000 Variable…
A: The net income using variable costing and absorption costing are different due to fixed costs…
Q: Question: How do you account for non-controlling interests in consolidated financial statements…
A: Consolidated financial statements are prepared when a company holds a controlling interest in other…
Q: The depreciation schedule for certain equipment has been arrived at by various methods. The…
A: The Double Declining Balance (DDB) depreciation method is an accelerated depreciation technique used…
Q: Jing is concerned about having to repay her Old Age Security (OAS) pension that she receives. This…
A: Pension is defined as the fund collected from the taxpayer or employee during his term of…
Q: The income statement for Sutherland Inc., appears below. Net sales Cost of goods sold Gross profit…
A: Vertical analysis is a financial analysis technique used to evaluate the relative proportions of…
Q: ABC Ltd was registered as a corporation on 1 July 2012. On 4 July 2012, ABC Ltd issued a prospectus…
A: Issuance of shares is one of useful source of finance being used in business. There can be common…
Q: Why is professional judgment in auditing and accounting important?
A: Professional judgment is defined as the application of accumulated knowledge and experience gained…
Q: ! Required information [The following information applies to the questions displayed below.] Fitness…
A: Return on investment :— It is the ratio between net operating income and average operating assets.…
Q: The following information is for the standard and actual costs for the Happy Corporation. Standard…
A: Standard costing represents preparation of budgets by expecting future possibilities related to the…
Q: Create a new standard cost card that separates the variable manufacturing overhead per unit and the…
A: The standard cost is the cost which is used by the company to estimate the costs which has to be…
Q: How does the accounting treatment differ for exploration and development costs in extractive…
A: Extractive activities involve the search for and extraction of minerals, oil, gas, and other…
Q: According to the course text, the United States has employed a worldwide system of taxation for the…
A: In this analysis, we will explore the impact of the Tax Cuts and Jobs Act (TCJA) on the taxation of…
Q: Activity Expected Cost Setting up equipment Ordering materials $132,000 27,600 141,050 Machining…
A: Manufacturing overhead: It is the expense incurred as a result of the production process. These…
Q: A financial analyst is attempting to assess the future dividend policy of Environmental Systems by…
A: Earning per share = This can be computed by dividing the company return available to common stock…
Q: How does accounting help students succeed in the business world
A: Accounting plays a vital role in the business world, serving as the language of finance and…
Q: Question: Which of the following financial statements provides information about a company's…
A: FINANCIAL STATEMENTSIn accounting, financial statements are essential tools for providing a…
Q: Assume that the Genove trucking company started business in June 1.2017 Assuming that the books are…
A: Adjusted trial balance is the trial balance in which all the adjustments for the year have been…
Q: Premium Pizza retires its 7% bonds for $63,000 before their scheduled maturity. At the time, the…
A: Carrying amount of bonds$65,343Less: Face value of bonds$60,900Premium on bonds payable ($65,343 -…
Q: Use the data below to answer the question given below: B-Z Bike Service Company’s comparative…
A: Cash flow statement :— It is one of the financial statements that shows change in cash and cash…
Q: Discuss the problems a company may have by looking at short term profit as a measure of performance
A: A measure of performance refers to a indicator used to assess how effectively and efficiently an…
Q: Take me to the text The KoolaKoola Company is famous for their pop drinks. The company expects to…
A: The raw material are purchased by the entity which are required by the entity to produce the…
Q: On 28 February 20.2 you are given the following information for Betties Plumbing. RCapital252…
A: Reporting of expenses is one of the important section of income statement. Income statement will…
Q: Pretzelmania, Incorporated, issues 7%, 15-year bonds with a face amount of $64,000 for $70,216 on…
A: Cash Payment of Interest = Face Value * Stated rate of InterestInterest Expense = Carrying Value *…
Q: A machine with a cost of $170,000 and accumulated depreciation of $105,000 is sold for $56,000 cash.…
A: Cash Flow From Operating Activities :— Operating activities are the principal revenue producing…
Q: During the current year, Cullumber Corporation expects to produce 10,000 units and has budgeted the…
A: ROI stands for return on investment. It is the ratio between net income and invested assets. It is…
Q: On December 28, 2024, Videotech Corporation (VTC) purchased 14 units of a new satellite uplink…
A: A Perpetual Inventory System (PIS) is a technique of inventory management and monitoring in which…
Q: 4. Paying taxes on stocks What It Means to Invest in Stocks? Common stock is considered to be one of…
A: The tax bracket of Kevin is 28%The tax rate on the capital gains is based upon the taxable income…
Q: Jennie’s grandfather paid her tuition this fall to State University (an eligible educational…
A: It is the tax benefit available to the taxpayer provided by the government for eligible individuals…
Q: Mallard Corporation uses the product cost method of product pricing. Below is cost information for…
A: The cost can be classified into two categories i.e product cost and period cost. The product cost is…
Q: Required information [The following information applies to the questions displayed below.] Woolard…
A: The difference between an individual's or entity's income and any statutory tax deductions is called…
Q: What is the most important output of the accounting cycle? Do all companies have an accounting…
A: The accounting cycle is a fundamental concept in accounting that describes the step-by-step process…
Q: Exercise 6-10 Lower of cost and net realizable value LO4 Showtime Company's ending inventory at…
A: LCNRV stands for Lower of cost or net realizable value. Using LCNRV, the inventory is valued at the…
Q: A manufacturing company that produces a single product has provided the following data concerning…
A: Product cost includes the costs that are directly related to the manufacturing process.Costs like…
Q: The following information is available for a company: Beginning inventory $ 33,000 Inventory…
A: Journal Entry is the primary step in recording the transactions in the books of accounts.The…
Q: The following account information, in alphabetical order, was taken from the worksheet of Compu-Soft…
A: Income Statement is a financial Statement that includes revenue earned and Expense incurred during…
Q: A business makes a provision of RM3,000, which was 2% of all his trade receivables, and a further…
A: Under the Allowance method of recording uncollectibles, an entity estimates the percentage of…
Q: Sofia contributed the following business assets to S&S Partnership on March 3, 2022: Basis $ 75,000…
A: Partnership is one of the form of business organisation, under which two or more than persons join…
Q: Hello, could i depend on this solution is it an expert solution?
A: Variance - It is the difference between budgeted and actual data.There are many types of variances…
Q: To record the payment of a dividend of $10,000 to the shareholder. Please select the correct journal…
A: A dividend payment journal entry decreases the company's profits (Retained Earnings) and its…
Q: Home Demo reported the following results. Sales Net income Average total assets (a) Compute Home…
A: Return on assets :— It is the ratio between net income and average total assets. It is calculated…
Q: How does accounting help students succeed in the business world
A: Accounting plays a vital role in the business world, serving as the language of finance and…
Q: A corporation is considering purchasing a new plant asset. The asset will cost $30,000. The…
A: NPV is one of the technique of capital budgeting being used in business. NPV means net present value…
Q: Your company has a travel policy that reimburses employees for the "ordinary and necessary" costs of…
A: Only the trip between Chicago and Paris is the business trip. Remaining two trips Paris to Rio de…
Q: partnership has the following capital balances: Dunberry (40% of profits and losses) 100,000 Fox…
A: A partnership is a contract between two or more persons to form a business and share profits and…
Accounting Cycle Project
Following is the
Using MS-Excel, prepare well-formatted worksheets as follows:
(a) closing entries
(b) a post-closing trial balance.
(c) a statement of revenues, expenditures, and changes in fund balance for the year ended December 31, 2019
(d) a
Step by step
Solved in 6 steps with 4 images
- Question You are provided with the following information relating to the Consolidated Fund for the year ended 31st December, 2019. Debit Credit GHC'000 GHc'000 Corporate taxes 200,000 Personal income taxes 120,000 Capital gain taxes and sundries 50,000 Taxes on general goods and services 180,000 Fees, fines and penalties 80,000 Investment income 20,000 Custom duties 250,000 Grants 150,000 Communication service taxes 100,000 Royalties 40,000 Established post 240,000 Casual labour 60,000 Travel and transport 70,000 Repairs and maintenance 50,000 13% Social security contribution 26,000 Gratuity and end of service benefit 168,000 State protocol 180,000 Independence Day celebration 205,000 Seminar and conferences 30,000 Probation 25,000 Property plant and equipment (at cost) 300,000 Infrastructure (at…Question The trial balance below relates to the Consolidated Fund for the year ended 31st December, 2019. GHc'000 GHc'000 Indirect Taxes 120,300 Direct Taxes 85,000 Non taxe revenues 60,000 Compensation for employees 76,000 Goods and services 45,000 Consumption of fixed consumption 24,000 Loans and advances 30,000 Bank and cash balances 12,000 Equity investment 40,000 Domestic debt 90,500 External debt 110,000 Trust fund 50,000 Sundry creditors 24,500 Other expenditures 20,000 Public debt interest 33,000 Social benefit 12,000 Grants 20,000 Subsidies 12,000 Accumulated Fund (1/12/16) 216,300 540300 540,300 Required: 1. Prepare Statement of Revenue and Expenditure for the Consolidated Fund for the year ended 31st December, 2019. 2. Prepare Statement of Financial Position…Benefit obligation, 1 January 20X6 Current service cost for 20X6 SFP Accrued net OPEB liability, 1 January, 20X6 Accumulated OCI, OPEBS, 1 January 20X6, loss Fund assets, 1 January 20X6 Contributions to the benefit fund for 20X6-paid 1 April Benefit payments to retired employees for 20X6 evenly over year Actual return on fund assets Yield rate on long-term corporate bonds $ 77,000 20,000 15,000 31,000 62,000 9,800 16,000 350 7 % With this information, how would i calculate projected obligation? OPEB expense? Net OPEB? Accumulate OCI OPEB?
- Amount in fund on 1/1/20: $4,500,000 Amount in fund on 5/1/20 just before transaction: $4,600,000 Transaction: Withdrawal of $800,000 Amount in fund on 8/1/20 just before transaction: $4,000,000 Transaction: Deposit of $400,000 Amount in fund on 12/13/20: $4,600,000 Calculate the Time-Weighted Rate of Return for the fund for the year 2020The following is a pre-closing trial balance for Montpelier's General... The following is a pre-closing trial balance for Montpelier's General Fund as of June 30, 2023: Debits Credits Cash $116,500 Taxes Receivable-Current 29,000 Allowance for Uncollectible Current Taxes $3,000 Accounts Payable 7,800 Due to Other Funds 5, 500 Tax Anticipation Notes Payable 50,000 Fund Balance-Unassigned 70,200 Budgetary Fund Balance 1,000 Estimated Revenues 100,000 Revenues 102,000 Appropriations 99,000 Expenditures 93,000 Totals $ 338,500 $ 338, 500 What is the fund balance as of June 30, 2023, after all closing entries have been made?341,000 Fair value of plan assets, Jan. 1 Contributions to the retirement fund during the Benefits paid to retirees Actuarial loss 32,000 89,000 year 50,000 335,000 Fair value of plan assets, Dec. 31 How much is the return on plan assets during the year? a. 51,000 b. 81,000 с. 101,000 d. 1,000
- ($ in millions) debit (Credit) Beginning balance Service cost Interest cost Expected return on assets Gain/loss on assets Amortization of: Prior service cost Net gain/ loss Loss on PBO Contributions to fund Retiree benefits paid Ending balance Multiple Choice What was Herring's prior service cost at the beginning of the year? $92 million. $64 million. $78 million. Prior Net Plan Service (Gain) Pension PBO Assets Cost (580) $82 million. (33) (59) 59 (667) 335 (14) 78 Loss Expense Cash 82 (4) 33 102 86 (31) (80) Net Pension (Liability)/Asset (333)Can someone help with the fund balances amount (red) for requirement c? The following transactions relate to the General Fund of the City of Buffalo Falls for the year ended December 31, 2024: Beginning balances were: Cash, $95, 000; Taxes Receivable, $185, 000; Accounts Payable, $50, 000; and Fund Balance, $230,000. The budget was passed. Estimated revenues amounted to $1,200,000 and appropriations totaled $1, 197,500. All expenditures are classified as General Government. Property taxes were levied in the amount of $902, 000. All of the taxes are expected to be collected before February 2025. Cash receipts totaled $870,000 for property taxes and $272,000 from other revenue. Contracts were issued for contracted services in the amount of $90,000. Contracted services were performed relating to $82,000 of the contracts with invoices amounting to $81,500. Other expenditures amounted to $947, 000. Accounts payable were paid in the amount of $ 1,070,000. The books were closed. Required: a.…Property taxes Franchise taxes $425,000 51,500 7,900 Charges for general government services Charges for public safety services Charges for health and sanitation services Issued long-term note payable Receivables at end of year: Property taxes (90% estimated to be collectible) Payments: Salary: General government Public safety 5,500 49,200 286,500 104,500 68,350 48,300 25,500 Health and sanitation Rent: General governmant Public safety 13,500 26,900 Health and sanitation 5,400 Maintenance: General government Public safety 24,400 5,100 9,400 Health and sanitation Insurance: General government Public safety ($2,300 still prepaid at end of year) Health and sanitation 8,300 11,500 16,200 22,920 Interest on debt Principal payment on debt Storage shed Equipment Supplies (20% still held) (public safety) 5,730 201,000 85,500 15,400 96,000 Investments Ordered but not received: Equipment 13,500 MacBook Pro
- Miscellaneous scenarios requiring journal entries The following transactions and events pertain to Bean County’s General Fundfor the calendar year 2022:1. The entity receives invoices in early January 2023 for $25,000 for professional servicesobtained in 2022, and $32,000 for December 2022 utility services.2. The entity borrows $500,000 on August 1, 2022, in anticipation of thecollection of property taxes. The borrowed amount is due to be repaid onJanuary 31, 2023, with interest at the rate of 1.5 percent per annum.3. The entity invests $300,000 cash in a CD on November 1, 2022, at an interest rateof 1 percent per annum. The CD will mature on January 31, 2023.4. In September 2022, the entity receives and accepts supplies that had beenordered in August. The amount that had been encumbered was $40,000,but the amount of the approved invoice was $42,000.Prepare journal entries for the transactions and events listed above.Enter 0 or leave the field blank if no entry is required for calendar…The first $2,000 deposit is made on December 31, 2020, interest is compounded annually, and interest earned is withdrawn at the end of each year. $ Deposit Amount 2,000 No. of Payments Interest left in Fund Balance Fund 12/31/2024Here is the preclosing December 31, 2020 trial balance for the general fund of Lancaster County: All numbers are in thousands. Debit $ 371,000 113,000 Estimated revenues 1,290,000 Estimated other financing sources 60,000 General expenditures 1,015,000 25,000 Cash Taxes receivable Capital outlay Debt service: principal payments Debt service: interest payments Transfers out Due from other funds Allowance for uncollectible taxes Accounts payable Due to other funds Property tax revenues Speeding ticket revenues Transfers in Bond proceeds Appropriations Estimated other financing uses Fund balance-unassigned Totals 2,000 8,000 20,000 12,000 Credit $45,000 50,000 21,000 950,000 400,000 8,000 50,000 1,085,000 22,000 285,000 $2,916,000 $2,916,000 By how much do the closing entries at the end of 2020 increase fund balance- unassigned? $37,000 $40,000 $73,000 $95,000