Question:1 Preparation of Financial Statements analysis in Excel. (8 Marks) The cormparative balance sheet of Mason...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question:1 Preparation of Financial Statements analysis in Excel. (8 Marks) The cormparative balance sheet of Mason Company appears below (attached as Excel on blackboard): MASON COMPANY Comparative Balance Sheet As of December 31, 2017 Assets Cash Short-terminvestments Aaounts receivable (net) Inventory Property, plant, and equipment (net) Total assets 2016 S30,000 S45,000 10,000 2017 25,000 60,000 40,000 50,000 200,000 160,000 Saso,000 S320,000 S0,00 Liabilities and stocholders' equity Accounts payable Short-termnotes payable Bonds payable Common stock Retained earnings Total liabilities and stockholders' equity S10,000 S30,000 35,000 40,000 20,000 20,000 220,000 200,000 60,000 35,000 S350,000 S320,000 MASON COMPANY Income Statement Forthe Year Ended December31, 2017 Income Statement S200,000 75,000 125,000 Net sales Cost of goods sold Gross profit Expenses Depredation expense Interest expense Selling expenses Administrative expenses Total expenses SE5,000 5,000 8,000 12.000 90,000 35,000 10,000 Income before income taxes Income taxexpense Net income S25,000 Instructions (a) Using horizontal analysis with excel, show the percentage change for each balance sheet item using 2016 as a base year. (04 Marks) (b) Using vertical analysis with excel, prepare a common size comparative balance sheet and income statement for 2017. (04 Marks) Question:1 Preparation of Financial Statements analysis in Excel. (8 Marks) The cormparative balance sheet of Mason Company appears below (attached as Excel on blackboard): MASON COMPANY Comparative Balance Sheet As of December 31, 2017 Assets Cash Short-terminvestments Aaounts receivable (net) Inventory Property, plant, and equipment (net) Total assets 2016 S30,000 S45,000 10,000 2017 25,000 60,000 40,000 50,000 200,000 160,000 Saso,000 S320,000 S0,00 Liabilities and stocholders' equity Accounts payable Short-termnotes payable Bonds payable Common stock Retained earnings Total liabilities and stockholders' equity S10,000 S30,000 35,000 40,000 20,000 20,000 220,000 200,000 60,000 35,000 S350,000 S320,000 MASON COMPANY Income Statement Forthe Year Ended December31, 2017 Income Statement S200,000 75,000 125,000 Net sales Cost of goods sold Gross profit Expenses Depredation expense Interest expense Selling expenses Administrative expenses Total expenses SE5,000 5,000 8,000 12.000 90,000 35,000 10,000 Income before income taxes Income taxexpense Net income S25,000 Instructions (a) Using horizontal analysis with excel, show the percentage change for each balance sheet item using 2016 as a base year. (04 Marks) (b) Using vertical analysis with excel, prepare a common size comparative balance sheet and income statement for 2017. (04 Marks)
Expert Answer:
Answer rating: 100% (QA)
Solution Page No Date 0 Meuon Company Balance Sheet years ended Dec 3 20... View the full answer
Related Book For
Financial Statement Analysis
ISBN: 978-0078110962
11th edition
Authors: K. R. Subramanyam, John Wild
Posted Date:
Students also viewed these accounting questions
-
The preparation of financial statements in accordance with AASB standards is one of the most important government regulations imposed on many companies in Australia. According to Australian...
-
Preparation of Financial statements under the guidance in IAS 1 Preparation of Financial Statements should be sufficient for most entities. However, there are business companies that are required to...
-
An object moving with uniform acceleration has a velocity of 13.0 cm/s in the positive x direction when its x coordinate is 3.30 cm. If its x coordinate 1.95 s later is -5.00 cm, what is its...
-
At fiscal year-end December 31, 2015, Shop-World had the following assets and liabilities on its balance sheet (in millions): Current liabilities ............ $9,459 Long-term debt .................
-
On January 1, 2013, Zoe Ltd. purchased all of the outstanding common shares of Noah Inc., a company based in the United States. This is the first time that Zoe Ltd. has acquired a company that is...
-
In Exercises 1-2, use a rectangular coordinate system to plot 1. 2. 4 2 -1 011xi T(x) = | 0 21x2
-
Nissan is changing the design of one of its highest-selling cars, the Murano, and is conducting an internet survey to determine whether the design change would affect customer perception of the car...
-
The city of Morristown operates a printing shop through an Internal Service Fund to provide printing services for all departments. The Central Printing Fund was established by a contribution of...
-
Company M has reported the following information for the month of February: Direct labor $ 4 5 , 0 0 0 Manufacturing overhead applied $ 9 0 , 0 0 0 Direct materials inventory has decreased by $ 1 1 ,...
-
Professional and Scientific Staff Management (PSSM) is a unique type of temporary staffing agency. Many organizations today hire highly skilled technical employees on a short-term, temporary basis to...
-
Q3) You're currently a buy-side analyst working for a big asset manager. You believe that investing in Tesla presents interesting opportunities for your fund: the share price is currently $119,...
-
Discuss the following statement in accordance with the relevant generally accepted accounting principle. `Competent managers have been called the most value asset of a business. However, accountants...
-
Halbert is an international student who came to study in Australia. After 2 years, he went back home for a holiday and was given 21,000 AUD by his parents as family support funds. Later on, he wired...
-
5 job descriptions for the accounting and payroll admin that you would apply for with a couple of sentences explaining why you chose them. Identify technical and specific skills as well as keywords...
-
What are the primary differences in accounting for for-profit businesses and nonprofit organizations? What some differences in accounting for governmental, nonprofit, and educational organizations?...
-
Discuss the importance of fixed cost and variable cost with respect to special orders. How might failure to identify a fixed cost impact the decision to accept or reject a special order? Use an...
-
During Covid pandemic, Clorox disinfecting wipe's inventory evaporated due to the rise of demand. At first, consumers tolerated memes about consuming Clorox wipes, but soon rise in frustration at...
-
(a) How far away can a human eye distinguish two ear headlights 2.0 m apart? Consider only diffraction effects and assume an eye pupil diameter of 5.0 mm and a wavelength of 550 nm. (b) What is the...
-
What are cash-based ratios of liquidity? What do they measure?
-
Falcon.Com purchases its merchandise at current market costs and resells the product at a price 20 cents higher. Its inventory costs are constant throughout the current year. Data on the number of...
-
It is difficult to measure the business performance of a company in the short run using only cash flow measures because of timing and matching problems. Describe each of these problems and cite at...
-
Why can staging investment decisions add value?
-
How do you use a decision tree to make the best investment decision?
-
How can you identify a real option in a decision tree?
Study smarter with the SolutionInn App