Question: Giving the following data , draw the balance sheet USING EXCEL :$150,000 lands-:$200,000 equipment :$170 0,000 buildings :$140 ,000account receivable :$ 85,000 account payable -

Giving the following data , draw the balance sheet USING EXCEL :$150,000 lands-:$200,000 equipment :$170 0,000 buildings :$140 ,000account receivable :$ 85,000 account payable - :$10,000 retained earnings :$135,000 long term debts :$60,000 intangible assets :$5,000 prepaid expenses :$10 ,000 annual depreciation for building

Draw the balance sheet in (T form) using excel,copy and paste your screen shot below

Step by Step Solution

★★★★★

3.51 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

LIABILITIES ASSETS RETAINED EARNING 10000 LAND 150000 LONG TERM DEBTS 13... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

An airplane wing is subjected to a lift force (F) created by the airflow over its surface. This force is a function of the density (p) and viscosity of the air (u), the chord length (L) of the wing,...

Assume the role of a marketing communication consultant hired to plan an integrated digital marketing campaign for the ICOME2022 conference. The Faculty of Management Studies has already launched the...

Q1. The following transactions occurred during Year 1, the first year of business, for Nancy Nanny Child Care. Record each transaction in proper journal entry format below using debits and credits....

The following financial statements are available for Elm Corporation for its first month of operations: Required Using the format illustrated in Exhibit 3-1, prepare a table to summarize the...

Use the McCoy Medical Company data in S11-10 to compute the following amounts for 2014: In S11-10 1. Borrowing or payment of long-term notes payable, assuming McCoy had only one long-term note...

The balance sheet of Pixelize Inc., a photographic supplies distributor, as of May 31 is given below: Pixelize Inc. has not budgeted previously, so it is limiting its master budget planning horizon...

Comprehensive example including a multi-column worksheet Psyche Books Ltd is a bookshop specialising in psychology textbooks. Psyche Books has the following balance sheet as at 30 September 2022:...

The following trial balance was prepared for Gifts, Etc., Inc., on December 31, 2010, after the closing entries were posted. Gifts, Etc. had the following transactions in 2011. 1. Purchased...

The following post-closing trial balance was drawn from the accounts of Spruce Timber Co. as of December 31, 2012. Transactions for 2013 1. Acquired an additional $10,000 cash from the issue of...

The comparative balance sheets of Lesley Leary Design Studio, Inc., at June 30, 2012 and 2011, and transaction data for fiscal 2012, are as follows: Transaction data for the year ended June 30, 2012,...

The following table of cost information is available for the Messier Company for the month of November: Goods in Process Goods in Process Inventory - Inventory - Mixing Molding Beginning Inventory....

A corporation is considering purchasing a machine that costs $100,000 and has a $20,000 salvage value . The machine will provide net annual cash inflows of $25,000 per year and has a six year life....

RQ 3 . 4 . Which of the following statements is false? Group of answer choices Profitability ratios show the relative contribution of creditors and owners to the financing of the company. Liquidity...

II. Please try to analyze the following cases and write down the appropriate recoding process.. Payne Company purchased equipment in 2010 for $90,000 and estimated a $6,000 residual value at the end...

Equity instruments include all the following except: O a. B- Preferred stocks O b. C- Retained earnings O c. D- Bonds O d. A- Common stocks

Lucy factored $4,000,000 of accounts receivable with Ethel on a with recourse basis on May 1. (Assume the transaction meets the criteria to be classified as a sale.) Ethel assessed a finance charge...

On May 1, Dexter, Inc. factored $1,600,000 of accounts receivable with Quick Finance on a without recourse basis. Under the arrangement, Dexter was to handle disputes concerning service, and Quick...

On January 1, 2021, the Allegheny Corporation purchased equipment for $160,000 The estimated service life of the equipment is 10 years and the estimated residual value is $17,000 The equipment is...

Find the interval of convergence and the radius of convergence for the power series below. Afterfinding the interval, check the endpoints for convergence. [4 points]n=0(-1)nxn5nn

Q1. Prepare general journal entries to record the adjustments below as of December 31 for the Perry Corporation. Q2. Review the adjusting journal entries (AJEs) above. Identify each journal entry...

Q1. Examine the trend in each of the following accounts. a. Sales revenue: In Year 6 it (__________/ decreased), and then in Year 7 it (increased / __________). b. Cost of goods sold: In Year 6 it...

Q1. Make the following statements true by correcting the false information. There may be more than one way to correct the false information. a. The four financial statements include the ___________...

8.4 Identify key studies in the areas of attention, categorization, attributions, reasoning and memory that support the analytic vs. holistic cognition framework.

8.5 Assess different theories about the source of analytic vs. holistic cognition.

8.3 Describe the analytic vs. holistic cognition theoretical framework.