Kevin Inc Presented the following financial data for year 2007 and 2006 Required: 1. Perform Vertical Analysis
Question:
Kevin Inc Presented the following financial data for year 2007 and 2006
Required:
1. Perform Vertical Analysis
2. Perform Horizontal Analysis
3. Perform Ratio Analysis
a. The Current Ratio
b. The Quick Ratio
c. The Receivable Turnover
d. The Collection Ratio
e. The Inventory Turnover
f. The Average Number of Days Inventory In Stock
g. The Debt-To-Equity
h. The Profit Margin
i. The Asset Turnover
4.Provide Analysis/Comment on the vertical & horizontal & ratio difference between 2006 vs. 2007, your answer should state if you believe additional investigation isnecessary.
Transcribed Image Text:
Assets Current Assets: Cash Accounts Receivable Inventory Fixed Assets Total Assets 2006 2007 S 45,000.00 S15,000.00 S 30,000.00 S 150,000.00 S 200,000.00 S (50,000.00) S 75.000.00 S 150,000.00 S (75,000.00) S 60,000.00 S 60,000.00 S S 330,000.00 S 425,000.00 S (95.000.00) Balance Sheet Accounts Payable Long Form Debit Stockholder Equity: Common Stock Paid in Capital Retained Earnings Total Liabilities & Stockholder's E S 95,000.00 S 215,000.00 S120,000.00 S 60,000.00 S60,000.00 S S 25,000.00 S25,000.00 S 50,000.00 S 75,000.00 75,000.00 S 150,000.00 S 75,000.00 S50,000.00 S 125,000.00 S 330,000.00 S 425,000.00 S 755,000.00 Comparative Income 2006 250000 125000 125000 Statement 2007 450000 300000 150000 Net Sales Cost of goods sold Gross margin Operating Expenses: Selling Expenses Administrative Expenses 50000 60000 75000 25000 Average Net Receivable Average Inventory Average Assets Aditional Information 155000 65000 330000 210000 130000 340000
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 53% (13 reviews)
1 Preparation of Balance Sheet Performa of Verticals analysis Particulars 2006Amount Percentage 2007 Amount Percentage Assets Cash 4500000 1364 1500000 353 Accounts Receivable 15000000 4545 20000000 4...View the full answer
Answered By
Loise Ndungu
I have five years of experience as a writer. As I embark on writing your papers from the prologue to the epilogue, my enthusiasm is driven by the importance of producing a quality product. I put premium product delivery as my top priority, as this is what my clients are seeking and what makes me different from other writers. My goal is to craft a masterpiece each time I embark on a freelance work task! I'm a freelance writer who provides his customers with outstanding and remarkable custom writings on various subjects. Let's work together for perfect grades.
4.90+
82+ Reviews
228+ Question Solved
Related Book For
Financial Accounting
ISBN: 978-0470507018
7th Edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Question Posted:
Students also viewed these Finance questions
-
The Haines Corp. shows the following financial data for 20X1 and 20X2. For each year, compute the following and indicate whether it is increasing or decreasing profitability in 20X2 as indicated by...
-
The following financial data were reported by 3M Company for 2008 and 2009 (dollars in millions). Instructions(a) Calculate the current ratio and working capital for 3M for 2008 and 2009.(b) Suppose...
-
The Grand retail firm reported the following financial data for the past several years: The Grand retail firm had a decentralized credit operation allowing each store to administer its credit...
-
On April 1, 2014, Briggs Corp. purchases a 24-month property insurance policy for $72,000. The policy is effective immediately. Assume that Briggs prepares adjusting entries only once a year, on...
-
Condensed income statements for Pon and its 80 percent-owned subsidiary, Star, appear below. Intercompany profit in Star's ending inventory is $60,000. At the date of combination four years ago,...
-
The Fairyland Childrens Centre is a community-based, not-for-profit childcare service. A committee of management oversees its operations, with the elected members being parents of children attending...
-
During the assessment of internal control over financial reporting, management identified the following deficiencies. Based on the context in which the deficiencies occur, management and the external...
-
Samson Products, Inc., is a wholesaler of mens hair products. The company began operations on January 1, 2012. The following transactions relate to securities acquired by Samson Products, Inc., which...
-
??????? Affordable Electronics Inc. manufactures medium-quality, reasonably priced wireless speakers for home use. The company uses standards to control its costs. The labour standards that have been...
-
Break-Even Analysis Pinnacle Party Inflatables, a supplier of inflatable bouncy houses, has budgeted the following amounts for its next fiscal year: $236,250 Total fixed expenses Selling price per...
-
Your boss provides you with the following specifications for a new machine that she heard about at a trade show, which would reduce operating costs in your department each year. She has asked for...
-
Suppose that ROSS is considering a $10M Series A investment in MIC. ROSS proposes to structure the investment as 3M shares of convertible preferred stock (CP). The employees of ROSS have claims on...
-
The president of Ferneti Company is puzzled. During the last year, the company experienced a net loss of $800,000, yet its cash increased $300,000 during the same period of time. Explain to the...
-
Consider a thin wooden rod of mass M, length d and moment of inertia ICM = (1/12) Md2 which hangs vertically from one end on a frictionless pivot, as shown in the figure. A bullet of mass m is shot...
-
Consider a project that requires an investment of $1700 in the first year, but will generate a NPV of $80. Calculate the profitability index value of this project.
-
Examine each of the following independent situations and state whether control does or does not exist. Where there is control, you are to state which party controls the entity. Give reasons for your...
-
The department head has the impression that some employees are less satisfied with their manager if the employee has worked in other companies. What is the correlation between Number of Companies...
-
Ad-Hoc Network Simulation In this homework, you are going to simulate an Ad-Hoc Network. Your simulation will have two layers with acknowledgment and resending. A header file is provided for your...
-
Which of the following is a performance measure that indicates past performance? a. Lag indicator b. Lead indicator c. Backward indicator d. Future indicator
-
The figure shows a bolted lap joint that uses SAE grade 8 bolts. The members are made of cold-drawn AISI 1040 steel. Find the safe tensile shear load F that can be applied to this connection if the...
-
Why do bonds have indentures? What, in your opinion, is the most important indenture for a bond? Are indentures more or less important for junk bond issues? Explain.
-
(Pension Funding) James Qualls, newly appointed controller of KBS, is considering ways to reduce his companys expenditures on annual pension costs. One way to do this is to switch KBSs pension fund...
-
(Various Time Value of Money Situations) Using a financial calculator, provide a solution to each of the following questions. (a) What is the amount of the payments that Karla Zehms must make at the...
-
(Various Time Value of Money Situations) Using a financial calculator, solve for the unknowns in each of the following situations. (a) Wayne Eski wishes to invest $150,000 today to ensure payments of...
-
cet (a) bo a function with f'(2) 0. Which of the following must be from about f The tangent line to the graph of fat (2. f(2)) is horizontal. Of has a local maximum or a local minimum at (2, f(2))...
-
1. Determine the standard temperature at any altitude.. 2. What "sphere/pause" has the coldest temperatures? .. Chapter 3 3. "From Hot to Cold and High to Low look out below." What is 'true' altitude...
-
of 21 > Macmillan Learning Suppose rubber prices rise in international markets. For countries that import rubber, this scenario would lead to: demand-pull inflation. an increase in potential output....
Study smarter with the SolutionInn App