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 .................
-
Henry ODonnell created an inter vivos trust fund. He owns a large department store in Higgins, Utah. He also owns a tract of land adjacent to the store used as an extra parking lot when the store is...
-
Xara Stores in the United States stocks a particular type of designer denim jeans that is manufactured in China and Brazil and imported to the Xara distribution center in the United States. It orders...
-
What is the purpose of a steering committee?
-
A mobile is formed by supporting four metal butterflies of equal mass m from a string of length L. The points of support are evenly spaced a distance apart as shown in Figure P5.73. The string forms...
-
In summary, the ERM must be used by contemporary businesses to take a proactive approach to addressing cyber threats. By performing a cost-benefit analysis
-
Suppose your company introduces a referral incentive for existing customers. Namely, cus- tomers can get a $500 discount on their customer service subscription for each customer lead that they refer...
-
Please send me answer in type form strictly prohibited handwritten solution don't use chatgpt Or copied content show your own work with step by step explanation specially mentioned formula and...
-
Calculate the missing information for the purchase. Item Selling Price (in $) Sales Tax Rate Sales Tax (in $) Excise Tax Rate Excise Tax Total Purchase Price Book $ 8 $ 0 0 $12.96 Last month The...
-
An organization can attain great benefits through the implementation of Total Quality Management, yet there are still many companies that attempt a variety of quality improvement efforts and find...
-
Froya Fabrikker A/S of Bergen, Norway, is a small company that manufactures specialty heavy equipment for use in North Sea oil fields. The company uses a job-order costing system that applies...
-
The following question refers to the alexandrite laser (see Fig. Below). Suppose optical pumping promotes Q quanta of light per second to be absorbed by Cr ions. What amount of ions are in 2E and 4T2...
-
Using the Fe-C phase diagram, answer the following questions: (a) (5p.) For a 0,76%C steel, what is the amount of total ferrite at 400C? (b) (5p.) The weight percentages of proeutectoid ferrite and...
-
MGT 366 06-TR-Operations Management (W24) Homework: #1 hw ch8 Question list Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 K Demand for oil changes at Garcia's Garage has been as...
-
(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...
-
Which of the following is usually not found on a job order cost sheet? a. Manufacturing overhead b. Finished units currently on hand c. Direct materials d. Unit cost Never
-
Which of the following is not one of the categories of cost involved in the allocation of service department costs? a. Service department costs allocated to production departments b. Costs directly...
-
Which of the following would be a reason for choosing to use departmental overhead rates, instead of a single company-wide overhead rate? a. Each departments overhead is structured very different...
Study smarter with the SolutionInn App