Problems 1. Using the data presented below: Sales Cost of Goods Gross Profit Depreciation Selling &...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problems 1. Using the data presented below: Sales Cost of Goods Gross Profit Depreciation Selling & Admin. Expense Other Operating Expense Big Rock Candy Mountain Mining Co. Income Statements For the Years 2015 and 2016 Net Operating Income Interest Expense Earnings Before Taxes Taxes Net Income Notes: Tax Rate Shares Earnings per Share Assets Cash Inventory Marketable Securities Accounts Receivable Total Current Assets Big Rock Candy Mountain Mining Co. Balance Sheet For the Year Ended December 31, 2016 2016 Gross Fixed Assets Accumulated Depreciation Net Plant & Equipment Total Assets Liabilities & Owner's Equity Accounts Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock ($1.00 par) Additional Paid-in-Capital Retained Earnings 2016 $369,300 285,400 83,900 26,820 23,340 1,080 32,660 7,685 24,975 9.990 $14,985 Total Owner's Equity Total Liab & Owner's Equity 40.00% $2,100 $0.29 $14,714 $1,841 $41,090 $46,910 $104,555 $388,000 $78,020 $309,980 $414,535 $35,200 $2,850 $38,050 $152,700 $190,750 2015 $354,000 281,800 72,200 26,360 21,820 1,080 22,940 7,505 15,435 6,174 $9,261 $52,100 $121,500 $50,185 $223,785 $414,535 40.00% 52,100 $0.18 2015 $10,300 $5.50 $42,100 $48,490 $101,440 $352,600 $51,200 $301,400 $402,840 $32,700 $2,740 $35,440 $158,600 $194,040 $52,100 $121,500 $35,200 $208,800 $402,840 a. Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly. b. On another worksheet, create a statement of cash flows for 2016. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets. c. Using Excel's outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section. d. Suppose that sales were $400,000 in 2016 rather than $369,300. What is the 2016 net income and retained earnings? e. Undo the changes from part d. and change the tax rate to 35%. What is the 2016 net income and retained earnings? 2. Using the data from the previous problem: a. Create a common-size income statement for 2015 and 2016. This statement should be created on a separate worksheet with all formulas linked directly to the income statement. b. Create a common-size balance sheet for 2015 and 2016. This statement should be created on a separate worksheet with all formulas linked directly to the balance sheet. c. Create a common-size statement of cash flows for 2016 that can be switched between using sales and the 2015 cash balance in the denominator. 3. Download the file named "Chapter 2 Problem 3.xlsx" from the text support Web site. (www.cengagebrain.com) a. Fill in the blanks on the financial statements for Winter Park Web Design with formulas. Some of the formulas will require links to data given in other worksheets in the workbook. b. Create a common-size income statement and balance sheet using your answers from above. Using the techniques you have learned in this chapter, you should be able to do these statements in less than one minute with formatting that is identical to the original worksheets. Problems 1. Using the data presented below: Sales Cost of Goods Gross Profit Depreciation Selling & Admin. Expense Other Operating Expense Big Rock Candy Mountain Mining Co. Income Statements For the Years 2015 and 2016 Net Operating Income Interest Expense Earnings Before Taxes Taxes Net Income Notes: Tax Rate Shares Earnings per Share Assets Cash Inventory Marketable Securities Accounts Receivable Total Current Assets Big Rock Candy Mountain Mining Co. Balance Sheet For the Year Ended December 31, 2016 2016 Gross Fixed Assets Accumulated Depreciation Net Plant & Equipment Total Assets Liabilities & Owner's Equity Accounts Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock ($1.00 par) Additional Paid-in-Capital Retained Earnings 2016 $369,300 285,400 83,900 26,820 23,340 1,080 32,660 7,685 24,975 9.990 $14,985 Total Owner's Equity Total Liab & Owner's Equity 40.00% $2,100 $0.29 $14,714 $1,841 $41,090 $46,910 $104,555 $388,000 $78,020 $309,980 $414,535 $35,200 $2,850 $38,050 $152,700 $190,750 2015 $354,000 281,800 72,200 26,360 21,820 1,080 22,940 7,505 15,435 6,174 $9,261 $52,100 $121,500 $50,185 $223,785 $414,535 40.00% 52,100 $0.18 2015 $10,300 $5.50 $42,100 $48,490 $101,440 $352,600 $51,200 $301,400 $402,840 $32,700 $2,740 $35,440 $158,600 $194,040 $52,100 $121,500 $35,200 $208,800 $402,840 a. Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly. b. On another worksheet, create a statement of cash flows for 2016. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets. c. Using Excel's outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section. d. Suppose that sales were $400,000 in 2016 rather than $369,300. What is the 2016 net income and retained earnings? e. Undo the changes from part d. and change the tax rate to 35%. What is the 2016 net income and retained earnings? 2. Using the data from the previous problem: a. Create a common-size income statement for 2015 and 2016. This statement should be created on a separate worksheet with all formulas linked directly to the income statement. b. Create a common-size balance sheet for 2015 and 2016. This statement should be created on a separate worksheet with all formulas linked directly to the balance sheet. c. Create a common-size statement of cash flows for 2016 that can be switched between using sales and the 2015 cash balance in the denominator. 3. Download the file named "Chapter 2 Problem 3.xlsx" from the text support Web site. (www.cengagebrain.com) a. Fill in the blanks on the financial statements for Winter Park Web Design with formulas. Some of the formulas will require links to data given in other worksheets in the workbook. b. Create a common-size income statement and balance sheet using your answers from above. Using the techniques you have learned in this chapter, you should be able to do these statements in less than one minute with formatting that is identical to the original worksheets.
Expert Answer:
Answer rating: 100% (QA)
Formulas of each is also shared for clarity 1 common size income sta... View the full answer
Related Book For
A Survey of Mathematics with Applications
ISBN: 978-0134112107
10th edition
Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde
Posted Date:
Students also viewed these mathematics questions
-
Fill in the blanks with an appropriate word, phrase, or symbol(s). Rational numbers such as and are examples of __________ numbers. 1}
-
Fill in the blanks with an appropriate word, phrase, or symbol(s). In the Babylonian numeration system, (a) The symbol represents the numeral ______ (b) The symbol represents the numeral ______. (c)...
-
Fill in the blanks with an appropriate word, phrase, or symbol(s). The following Euler diagram represents the statement _________ As are Bs. U A
-
1. What are the advantages to Southwest of its proactive approach to passenger problems? n n 2. How might Fred Taylor use the four-part plan suggested in this chapter to compose his apology letters...
-
What competencies and skills does a manager need to have to work effectively across cultures?
-
In a discussion of the technological capabilities of ancient civilizations, a friend offers this hypothesis: "Some ancient civilizations built sophisticated instruments based on a mysterious type of...
-
A stock dividend a. Decreases Common Stock b. Increases Retained Earnings c. Has no effect on total equity d. All of the above
-
Arnold Industries has pretax accounting income of $33 million for the year ended December 31, 2011. The tax rate is 40%. The only difference between accounting income and taxable income relates to an...
-
Case 1 Boston Duck Tours How Perseverance and Creativity Led an Entrepreneur to Great Success It is not uncommon for entrepreneurial ventures to meet with resistance. Even though small businesses...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: (a) The gross margin in 25% of sales (b) Actual and budgeted sales data: (c) Sales are 60%...
-
= Cost or pricing data includes: (b) (a) Facts that would affect negotiated price agreement Subcontractor bids after award of contract Assumptions of escalation factors All of the above (d)
-
Choose the best statement. A. A subsidy to peanut growers lowers peanut growers costs, lowers the market price of peanuts, and increases the demand for peanuts. B. A price support for peanut growers...
-
To avoid possible duplicated records being inserted into a database, the Insert button on a Frame Form should be enabled after a desired record has been inserted. (True/False)
-
The so-called implicit objects in JSP are objects that are automatically available in JSP because they are automatically instantiated as the project runs. (True/False)
-
To separate presentation and business logic, we can use pages to present our GUI and the to store our data to perform business-related logic. a. HTML, Java help class b. XML, JSF pages c. JSP, Java...
-
A object, which contains all pieces of necessary information about the returned data stored in a ResultSet instance, is returned when the method is executed. a. getMetaData(), ResultSetMetaData b....
-
Explain how the different personalities you have studied manifest in intimate partner violence. Explain possible counterintuitive behaviors that victims might display. Provide examples that...
-
Catherine (aged 42) and Johnson (aged 45) have been married for 12 years. Johnson is a project manager of an event company at a monthly salary of $55,000 with an additional one-month salary of...
-
Dunkin Donuts collected the following information regarding purchases from 100 of its customers. 65 purchased coffee. 41 purchased donuts. 22 purchased both coffee and donuts. Of those surveyed, (a)...
-
Use the following list which shows the names of the 43 U.S. presidents and the number of children in their families. Does this distribution appear to be normal? Explain. W. H. Harrison Washington J....
-
Brenda cuts her grass every six days and trims her shrubs every 16 days. If Brenda cut her grass and trimmed her shrubs on June 1, how many days will it be before she cuts her grass and trims her...
-
True or False. The system stiffness matrix is always singular unless the boundary conditions are incorporated.
-
Derive the stiffness and mass matrices of the planar frame element (general beam element) shown in Fig. 12.16 in the global \(X Y\)-coordinate system. Y U U3 U Joint 1 Joint 2 U6 Us UA FIGURE 12.16 A...
-
Fill in the Blank. The displacement within a finite element is expressed in terms of _____________ functions.
Study smarter with the SolutionInn App