Use the following data to construct balance sheets for Jones Company for the past 3 years....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the following data to construct balance sheets for Jones Company for the past 3 years. Construct the statements using the raw numbers, common-sized, and year over year growth. Use the Dry Supply balance sheets as a guide. Do this in excel and format it so that all the results fit on a single page, and start with the oldest data column on the left. Include totals for current assets, total assets, current liabilities, total liabilities, total equity, and total liabilities and equity. Format to include commas but no decimal places in the raw numbers and show the percentages as a percent with one decimal place. Important: Do this in the same excel file (workbook) as the first assignment, but put it in a new worksheet. You can copy and paste the data into Excel if you like, but will need to adjust the formatting. Save a file for yourself as we will use this data again. Jones Company Period Ending 12/31/2015 12/31/2016 12/31/2017 Retained Earnings 1,592,060 1,648,896 1,722,373 Short Term Investments 65,200 68,920 54,210 Furniture and Fixtures 65,840 61,962 64,253 Common Stock 100,00 Other Current Liabilities 38,650 42,563 Land, Buildings, and Equipment 2,415,620 2,453,600 Other Current Assets 28,651 24,125 Accounts Payable 51,245 47,520 Net Accounts Receivable 61,250 74,213 Current Maturities of LT Debt 40,000 40,000 Accrued Taxes 13,560 14,895 Accumulated Depreciation 514,470 578,990 Short-term notes payable 85,462 89,562 Inventory 345,682 364,210 Cash and Equivalents 122,198 173,292 Long Term Debt 612,000 572,000 0,000 46,320 2,362,000 26,410 49,650 58,400 40,000 12,400 452,130 95,640 342,350 120,000 652,000 0,000 Assets Cash Net accounts receivable Inventory Total current assets. Furniture and fixtures Leasehold improvements Transportation equipment Gross Fixed assets Net fixed assets Total Assets Liabilities Notes payable bank-short term. Accounts payable Accrued taxes Accrued bonuses Total Current Liabilities Long term debt Total Liabilities Equity Stock Retained earnings Total net worth Total liabilities and net worth Less: Accumulated depreciation Balance Sheet 12/31/2017 12/31/2018 12/31/2019 16 20 25 113 112 109 73 198 72 67 205 204 76 75 78 1 0 53 85 130 163 85 110 45 53 243 257 59 31 7 81 42 5 10 138 48 186 2 55 57 243 1 70 146 97 49 254 68 46 6 11 131 58 Dry Supply 189 2 63 65 254 12 109 67 176 2 79 81 257 Common Size 12/31/2017 12/31/2018 12/31/2019. 9.7% 6.6% 44.9% 7.9% 44.5% 43.6% 30.0% 28.3% 26.1% 81.5% 80.7% 79.4% 31.3% 29.5% 30.4% 0.4% 0.4% 0.0% 21.8% 27.6% 33.1% 53.5% 57.5% 63.4% 35.0% 38.2% 42.8% 18.5% 19.3% 20.6% 100.0% 100.0% 100.0% 33.3% 26.8% 23.0% 17.3% 18.1% 12.1% 2.1% 2.4% 2.7% 4.1% 4.3% 4.7% 56.8% 51.6% 42.4% 19.8% 22.8% 26.1% 76.5% 74.4% 68.5% 0.8% 0.8% 0.8% 22.6% 24.8% 30.7% 23.5% 25.6% 31.5% 100.0% 100.0% 100.0% Year over Year 12/31/2018 12/31/2019 25.0% 25.0% 3.7% -0.9% -1.4% -6.9% 3.5% -0.5% -1.3% 0.0% 4.0% -100.0% 21.4% 32.1% 12.3% 11.6% 14.1% 13.4% 8.9% 8.2% 4.5% 1.2% -16.0% -13.2% 9.5% -32.6% 20.0% 16.7% 10.0% 9.1% -5.1% -16.8% 20.8% 15.5% 1.6% -6.9% 0.0% 0.0% 14.5% 25.4% 14.0% 24.6% 4.5% 1.2% Use the following data to construct balance sheets for Jones Company for the past 3 years. Construct the statements using the raw numbers, common-sized, and year over year growth. Use the Dry Supply balance sheets as a guide. Do this in excel and format it so that all the results fit on a single page, and start with the oldest data column on the left. Include totals for current assets, total assets, current liabilities, total liabilities, total equity, and total liabilities and equity. Format to include commas but no decimal places in the raw numbers and show the percentages as a percent with one decimal place. Important: Do this in the same excel file (workbook) as the first assignment, but put it in a new worksheet. You can copy and paste the data into Excel if you like, but will need to adjust the formatting. Save a file for yourself as we will use this data again. Jones Company Period Ending 12/31/2015 12/31/2016 12/31/2017 Retained Earnings 1,592,060 1,648,896 1,722,373 Short Term Investments 65,200 68,920 54,210 Furniture and Fixtures 65,840 61,962 64,253 Common Stock 100,00 Other Current Liabilities 38,650 42,563 Land, Buildings, and Equipment 2,415,620 2,453,600 Other Current Assets 28,651 24,125 Accounts Payable 51,245 47,520 Net Accounts Receivable 61,250 74,213 Current Maturities of LT Debt 40,000 40,000 Accrued Taxes 13,560 14,895 Accumulated Depreciation 514,470 578,990 Short-term notes payable 85,462 89,562 Inventory 345,682 364,210 Cash and Equivalents 122,198 173,292 Long Term Debt 612,000 572,000 0,000 46,320 2,362,000 26,410 49,650 58,400 40,000 12,400 452,130 95,640 342,350 120,000 652,000 0,000 Assets Cash Net accounts receivable Inventory Total current assets. Furniture and fixtures Leasehold improvements Transportation equipment Gross Fixed assets Net fixed assets Total Assets Liabilities Notes payable bank-short term. Accounts payable Accrued taxes Accrued bonuses Total Current Liabilities Long term debt Total Liabilities Equity Stock Retained earnings Total net worth Total liabilities and net worth Less: Accumulated depreciation Balance Sheet 12/31/2017 12/31/2018 12/31/2019 16 20 25 113 112 109 73 198 72 67 205 204 76 75 78 1 0 53 85 130 163 85 110 45 53 243 257 59 31 7 81 42 5 10 138 48 186 2 55 57 243 1 70 146 97 49 254 68 46 6 11 131 58 Dry Supply 189 2 63 65 254 12 109 67 176 2 79 81 257 Common Size 12/31/2017 12/31/2018 12/31/2019. 9.7% 6.6% 44.9% 7.9% 44.5% 43.6% 30.0% 28.3% 26.1% 81.5% 80.7% 79.4% 31.3% 29.5% 30.4% 0.4% 0.4% 0.0% 21.8% 27.6% 33.1% 53.5% 57.5% 63.4% 35.0% 38.2% 42.8% 18.5% 19.3% 20.6% 100.0% 100.0% 100.0% 33.3% 26.8% 23.0% 17.3% 18.1% 12.1% 2.1% 2.4% 2.7% 4.1% 4.3% 4.7% 56.8% 51.6% 42.4% 19.8% 22.8% 26.1% 76.5% 74.4% 68.5% 0.8% 0.8% 0.8% 22.6% 24.8% 30.7% 23.5% 25.6% 31.5% 100.0% 100.0% 100.0% Year over Year 12/31/2018 12/31/2019 25.0% 25.0% 3.7% -0.9% -1.4% -6.9% 3.5% -0.5% -1.3% 0.0% 4.0% -100.0% 21.4% 32.1% 12.3% 11.6% 14.1% 13.4% 8.9% 8.2% 4.5% 1.2% -16.0% -13.2% 9.5% -32.6% 20.0% 16.7% 10.0% 9.1% -5.1% -16.8% 20.8% 15.5% 1.6% -6.9% 0.0% 0.0% 14.5% 25.4% 14.0% 24.6% 4.5% 1.2%
Expert Answer:
Answer rating: 100% (QA)
Jones Company Particulars Balance Sheet Common Size Year over Year 12312015 12312016 12312017 123120... View the full answer
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
Use the following data to construct a 98% confidence interval to estimate the difference between 1 and 2. x1 = 34.9 ... x2 = 27.6 21 = 2.97 ... 22 = 3.50 n1 = 34 .... n2 = 31
-
Use the following data to construct a 99% confidence interval to estimate D. Assume the differences are normally distributed in thepopulation. Respondent BeforeAfter 47 53 38 50 39 27 63 35 36 56 6...
-
Use the following data to construct a 99% confidence interval to estimate p1 - p2. Sample 1 ... Sample 2 n1 = 409 ... n2 = 378 p1 = .71 ... p2 = .67
-
The statements of financial position of Parkway plc for 20X7 and 20X8 are given below, together with the income statement for the year ended 30 June 20X8. Statement of comprehensive income of Parkway...
-
The concentration of carbon monoxide in an urban apartment is 48 g/m3.What mass of carbon monoxide in grams is present in a room measuring 11.0 ft 11.5 ft 20.5 ft?
-
Write a letter to one party, a memo to one party, and an e-mail to one party, after reading the following scenario; determine how to communicate its negative information appropriately to your...
-
Circuit Board Systems (CBS) has the following data: Assets: $\$ 100,000$; Profit margin: $6.0 \%$; Tax rate: $4.0 \%$; Debt ratio: $40.0 \%$; Interest rate: 8.0\%: Total assets turnover: 3.0. What is...
-
In addition to the standard inputs discussed in Section 5.1, other input functions occasionally are useful for special purposes. One, the so-called doublet pulse, is shown in figure. (a) Find the...
-
system Solve the problem using two variables and a system of two equations. Solve the system by the method of your choice. Note that the problem could be a dependent or inconsistent A civil engineer...
-
After a series of large project disasters, what country is requiring people to complete a new academic program in project management before leading a large government project? a. Australia b. U.K. c....
-
Complete the following tasks for the trial program. 1. Display your full name. 2. Display your MMU student ID. 3. Allow user input with four decimal digits in a range of 0000 to 2500. The digits...
-
How to develop a project scope document that outlines key factors in project scope development, address the following: Identify the steps in developing a project scope. Evaluate the importance of the...
-
1. What could be added to each expression to make it a perfect square? a.+12x b. x-6x+1 c.+ 14x-10 2. Solve the equation x - 16x=-60 by completing the square. Show your reasoning.
-
On this task you have to evaluate activities and create your own rubric. We asked students of secondary education to provide their ideas on "Online Learning and Teaching" and present them in a...
-
We asked students of secondary education to provide their ideas on "Online Learning and Teaching" and present them in a document in a format of their preference. In the "Activities" folder you can...
-
Solve the following inequality. Round your answer to two decimal places if necessary. -9x+110(9 - 7x) +4 O x Ox
-
Consider a $1000 face value 2-year government bond which provides coupons of 8% per annum paid semi-annually. a) Calculate the current price of the bond if the interest rate over the period is...
-
Will the prediction interval always be wider than the estimation interval for the same value of the independent variable? Briefly explain.
-
What distinguishes entrepreneurship from the other factors of production?
-
How does the problem of double counting arise in calculating GDP, and how is it corrected?
-
In some cases, a balance of payments problem really isn't a problem at all. Yet in other cases, it could signal a fundamental problem in the economy. Explain.
-
The details in Figure 16.9 relate to D Co. Using that information and appropriate ratios, prepare a financial report on the company. The opening inventory value figures were :135,000 20X1 actual and...
-
The process of expressing a foreign subsidiarys balance sheet in its parents currency is called: A. Currency translation. B. Currency change. C. Currency conversion. D. Currency swap.
-
A loan is made to a company of $20,000, which is equal to :10,000 at the date of the loan during year 1. The loan is legally denominated in dollars. At the end of year 1, the loan is translated as...
Study smarter with the SolutionInn App