The following information was taken from the accounting records of Prentice Company for the years ended April
Question:
Required:
Use a computer spreadsheet to do the following:
A. Complete a vertical analysis for 2010, 2009, and 2008.
B. Complete a horizontal analysis for 2010 and 2009.
C. Complete a ratio analysis for 2010 and 2009.
Transcribed Image Text:
2010 2009 Current assets: Cash Trading securities Accounts receivable Inventories Prepaid expenses $ 35,000 12,000 175,000 225,000 5,000 452,000 $ 38,000 11,000 166,000 209,000 10,000 $ 434,000 $ 10,000 62,000 112,000 269,000 4,000 S 457,000 Total current assets Property, plant, and equipment $ 50,000 141,000 68,000 Total property, plant and ent 259,000 $ 711,000 S 50,000 149,000 74,000 273,000 707,000 $ 50,000 157,000 72,000 279,000 736,000 Land Building, netof depreciation Equipment, net of depreciation Total assets Current liabilities $ 69,000 40,000 52000 $ 161,000 88,000 $ 249,000 462,000 711,000 $ 60,000 60,000 19,000 $ 139,000 161,000 300,000 436000 S 736,000 Accounts payable $ 67,000 60,000 41,000 $ 168,000 92,000 $ 260,000 447,000 $ 707000 $2,085,000 1,209,000 S 876,000 731,000 145,000 Notes payable Other current liabilities Total current liabilities Long-term liabilities Total liabilities Owners' equity Total liabilities and owners' equity Sales Cost of goods sold Gross margin Operating expenses Net income $1,920,000 1.152,000 $ 768,000 698,000 70,000 $1,880,000 1,110,000 770,000 688,000 $ 82,000
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (14 reviews)
Data 2010 2009 2008 Cash 35000 38000 10000 Trading securities 12000 11000 62000 Accounts receivable 175000 166000 112000 Total liquid assets 222000 21...View the full answer
Answered By
Joseph Mwaura
I have been teaching college students in various subjects for 9 years now. Besides, I have been tutoring online with several tutoring companies from 2010 to date. The 9 years of experience as a tutor has enabled me to develop multiple tutoring skills and see thousands of students excel in their education and in life after school which gives me much pleasure. I have assisted students in essay writing and in doing academic research and this has helped me be well versed with the various writing styles such as APA, MLA, Chicago/ Turabian, Harvard. I am always ready to handle work at any hour and in any way as students specify. In my tutoring journey, excellence has always been my guiding standard.
4.00+
1+ Reviews
10+ Question Solved
Related Book For
Introduction to Accounting An Integrated Approach
ISBN: 978-0078136603
6th edition
Authors: Penne Ainsworth, Dan Deines
Question Posted:
Students also viewed these Accounting questions
-
The following information was taken from the accounting records of three competitors for the 2016 fiscal year. Required: a. Explain how to calculate inventory turnover and the number of days sales in...
-
The following information was taken from the accounting records of the Lamberson Company: Additional information for the year: (a) Sales ............$ 39,930 Cost of goods sold .........(19,890)...
-
The following information was taken from the accounting records of Chicoutimi Ltée and Jonquière Ltée at December 31, 2016. The two companies are competitors....
-
Smile is a social media site that is growing in popularity. The firm has been around for a few years and has created a nice market niche for itself. Now the company has a possible buyer who has made...
-
What is the main objective of the Principles of Responsible Investment (PRI)?
-
What are the most common bases for federal jurisdiction?
-
Two very long wires each carry a linear charge density \(\lambda\). They initially repel each other with a force \(F\). If the wires are immersed in distilled water, with what force do they repel...
-
Rich Cole Control Devices, Inc., produces custom-built relay devices for auto makers. The most recent project undertaken by Cole requires 14 different activities. Cole's managers would like to...
-
26 The number of protons, neutrons, electrons in some particles are shown in the table below Particle Protons Neutrons electrons P 1 1 2 Q 2 2 2 R 3 4 2 T 4 5 4 Which one of the following particles...
-
The accounting staff of Best Company has assembled the following information for the year ended December 31, 2011: Cash sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
The following list of accounts was adapted from the annual report of Wiley Industries: Cash and cash equivalents ........ $ 21,989,062 Marketable securities ........... 9,199,490 Notes receivable,...
-
Why must a financial manager have an integrated understanding of the five basic finance functions? Why has the risk-management function become more important in recent years? Why is the corporate...
-
An inexperienced graduate student treated dec-5-ene with borane in THF, placed the flask in a refrigerator, and left for a party. When he returned from the party, he discovered that the refrigerator...
-
G. Consider the linear program min y + 2 + 3ys s.t. 21 2 1 (4) 32 + 3y 23 -2-1 Dr. S. 20 (a) Write down a linear program (P) the dual of which is the above linear program (4). (b) Show that the...
-
What are all the real and complex roots of the polynomial 2x^(3)-14x^(2)+24x+40, given that one root is x=-1 ?
-
A vertical cable 3m long has a cross-sectional area of 4 sq. cm. supports a weight of 50 kN. What will be the natural period and natural frequency of the system? E = 2.1 x 106 kg/cm
-
Make a BadFileException , an unchecked exception, and InvalidNameFormatException and InvalidAttendanceInformationException , two checked exceptions, each in their respective file. All of these are...
-
John earns $65000/yr, he pays 10% income tax for under $30000 and 14% between $30000 to $50000 and 19% above $50000. what is his effective income tax?
-
In what ways may work be changed?
-
Stephen Schor, an accountant in New York City, advised his client, Andre Romanelli, Inc., to open an account at J. P. Morgan Chase Bank, N.A., to obtain a favorable interest rate on a line of credit....
-
Today is April 1 and Dale has just received the annual report of Clam Chowder Company, in which he owns stock. Displayed below are the comparative balance sheet and income statement that have drawn...
-
Far East Specialties is an import company, financed primarily by stockholders and bank loans. It imports handmade goods from Central and East Asia to the United States, where they are sold to retail...
-
Markus O'Realius is considering the purchase of Caesar Company. The potential seller has provided Markus with a copy of the business's financial statements for the last three years. The financial...
-
QUESTION #2 : The age of the internet as well as the ensuing rise of social networking in the form of FaceBook, Instagram, Twitter and TikTok has significantly changed the way individuals process and...
-
Question 5 In 50 words or more, explain how advertising is implemented through each type of media listed below. Advertising Media Types How Advertising is Implemented Through Each Type of Media i....
-
1. Research and outline the Lean Method and how it applies to marketing a products. Explain in one fifty words. 2. Outline your understanding of market research and what is should include: Be...
Study smarter with the SolutionInn App