Prepare an adjusted trial balance in an excel spreadsheet

Assignment Help Accounting Basics
Reference no: EM131976921

Problem

Similar to last week, there is an excel spreadsheet template attached to this unit's module. Feel free to use it for your response to this  assignment.

Unit 3 Assignment:

From the results of last assignment,

Prepare an unadjusted trial balance;

Post the following adjustments:

(a) Earned but unbilled fees at July 31 were $1,400

(b) Depreciation for the month was $200

(c ) One-twelfth of the insurance expired

(d) An inventory count showed $300 of cleaning supplies remaining on July 31

(e) Accrued but unpaid employee salaries were $500

Prepare an adjusted trial balance.

Reference no: EM131976921

Questions Cloud

What is the specific heat of silver : How much energy would it take to raise the temperature of 9.00 g of silver by 19.5 o C? What is the specific heat of silver?
Her expected range of future spot prices : Calculate what she would gain or lose at her expected range of future spot prices and her most likely estimate of $0.6700/SFR.
Calculate the molar heat capacity of water : The specific heat of water is 4.18 J/(g·oC). Calculate the molar heat capacity of water?
Combustion of pentane : The combustion of pentane, C5H12, occurs via the reaction
Prepare an adjusted trial balance in an excel spreadsheet : Prepare an adjusted trial balance in an excel spreadsheet. Feel free to use it for your response to this assignment. Earned but unbilled fees at July 31 were.
How much work has been done in joules : A piston has an external pressure of 15.0 atm. How much work has been done in joules if the cylinder goes from a volume of 0.170 liters to 0.600 liters?
What is the value of hrxn in kj : What is the value of Hrxn in kJ/(mole limiting reactant)? Assume that the specific heat of the system is 4.18 J/g·oC.
Calculate the economic ordering quantity : Calculate the economic ordering quantity (EOQ). Calculate total annual inventory cost under EOQ.
Entity which assumes the risk of policyholders : Travelers Insurance is a publicly traded entity which assumes the risk of its policyholders.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Amount of stockholder equity

If total assets increased $164,300 during the year and total liabilities decreased $79,650, what is the amount of stockholders' equity at the end of the year?

  Describe the steps which have been taken recently to

discus the steps that have been taken recently to promote greater accuracy and reliability of information concerning

  Initial investment in net working capital

The sausage system will save the firm $256,800 per year in pretax operating costs, and the system requires an initial investment in net working capital of $59,920.

  Partnerships and consolidations

What are the issues related to goodwill valuation when comparing partnerships formation with companies consolidations?

  Prepare the journal entry for the transaction

Prepare the journal entry for the below transaction: Herzog Researchers, Inc issues its Common Stock to Shelley Herzog, who invests $25,000 to the open business

  What will be the real effect on profit if order is accepted

Of the $70 of overhead, $14 is variable and $56 relates to fixed costs. What will be the real effect on profit if the order is accepted

  Prepare journal entries to record this retirement

Management retires 75% of the bonds at a cost of $6,500,000 plus accrued interest. Prepare journal entries to record this retirement

  Moonshine corp uses the product cost concept of applying

moonshine corp. uses the product cost concept of applying the cost-plus approach to product pricing. the costs and

  The market value of the mcgraw

On July 2, 2009, the McGraw Corporation issued $500,000 of convertible bonds. Each $1,000 bond could be converted into 20 shares of the company's $5 par value stock.

  Indicate the purpose of the cms being applied

Cost management systems have three primary purposes. For each of the decisions listed next, indicate the purpose of the CMS being applied.

  What is the cost of machining per ceiling fan

Brannon Company manufactures ceiling fans and uses the activity-based costing system. What is the cost of machining per ceiling fan

  Amount and character of the gain

What is the amount and character of the gain, loss or income that must be recognized by you as a result of the distribution of the SubCo stock?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd