Step 1 Instructions Complete the steps below using cell references to given data or previous calculations....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Step 1 Instructions Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue colls highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Start Excel. Download and open the workbook named: Keown Martin Petty_Problem 3- 3_Start. Important note: All calculations must be shown using cell references. Do NOT enter numerical values in the cells. Points Possible 0 2 In cell C16, input the sales amount. 1 3 In cell C17, input the cost of goods sold amount. 1 Note: The output of the expression or function you typed in this cell is expected as a positive number. 4 In cell C18, calculate the gross profits. 1 5 In cell B19, input the general and administrative expenses amount. 1 Note: The output of the expression or function you typed in this cell is expected as a positive number. 6 In cell B20, input the depreciation expense amount. Note: The output of the expression or function you typed in this cell is expected as a positive number. 7 In cell C21, calculate the total operating expense. 1 Note: The output of the expression or function you typed in this cell is expected as a positive number. 8 In cell C22, calculate the operating income (EBIT). 1 9 In cell C23, input the interest expense amount. 1 Note: The output of the expression or function you typed in this cell is expected as a positive number. 10 In cell C24, calculate the earnings before taxes. 1 Grader - Instructions Step 11 12 Ñ 13 Instructions In cell C25, input the taxes amount. Note: The output of the expression or function you typed in this cell is expected as a positive number. In cell C26, calculate the net income. To prepare the common-sized income statement, find the ratio between each account in the income statement and the sales amount. In cell D16, divide the sales amount by the sales datum and make an absolute cell reference to the sales datum for copying and pasting purposes. Excel 2016 Project Points Possible 1 1 1 14 Copy cell D16 and paste onto the cell ranges D17:D18 and D21:D26. 2 15 In cell D19, divide the general and administrative expenses amount by the sales datum and make an absolute cell reference to the sales datum for copying and pasting purposes. 1 16 Copy cell D19 and paste onto cell D20. 1 17 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 16 Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of 5 the data in your formulas, usually the Given Data section. 6 DATA 7 Sales 8 Cost of goods sold 9 General and administrative expenses 10 Depreciation expenses 11 Interest expense 12 Income taxes 13 14 SOLUTION 15 Income Statement and Common-Sized Income Statement: 16 Sales 17 Cost of goods sold 18 Gross profits 19 General and administrative expenses 20 Depreciation expense 21 Total operating expense 22 Operating income (EBIT) 23 Interest expense 24 Earnings before taxes 25 Taxes (40%) 26 Net income 27 28 Requirements: 1. Start Excel. Download and open the workbook named: Keown Martin_Petty_Problem_3-3_Start. $525,000 200,000 62,000 8,000 12,000 97,200 Step 1 Instructions Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue colls highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Start Excel. Download and open the workbook named: Keown Martin Petty_Problem 3- 3_Start. Important note: All calculations must be shown using cell references. Do NOT enter numerical values in the cells. Points Possible 0 2 In cell C16, input the sales amount. 1 3 In cell C17, input the cost of goods sold amount. 1 Note: The output of the expression or function you typed in this cell is expected as a positive number. 4 In cell C18, calculate the gross profits. 1 5 In cell B19, input the general and administrative expenses amount. 1 Note: The output of the expression or function you typed in this cell is expected as a positive number. 6 In cell B20, input the depreciation expense amount. Note: The output of the expression or function you typed in this cell is expected as a positive number. 7 In cell C21, calculate the total operating expense. 1 Note: The output of the expression or function you typed in this cell is expected as a positive number. 8 In cell C22, calculate the operating income (EBIT). 1 9 In cell C23, input the interest expense amount. 1 Note: The output of the expression or function you typed in this cell is expected as a positive number. 10 In cell C24, calculate the earnings before taxes. 1 Grader - Instructions Step 11 12 Ñ 13 Instructions In cell C25, input the taxes amount. Note: The output of the expression or function you typed in this cell is expected as a positive number. In cell C26, calculate the net income. To prepare the common-sized income statement, find the ratio between each account in the income statement and the sales amount. In cell D16, divide the sales amount by the sales datum and make an absolute cell reference to the sales datum for copying and pasting purposes. Excel 2016 Project Points Possible 1 1 1 14 Copy cell D16 and paste onto the cell ranges D17:D18 and D21:D26. 2 15 In cell D19, divide the general and administrative expenses amount by the sales datum and make an absolute cell reference to the sales datum for copying and pasting purposes. 1 16 Copy cell D19 and paste onto cell D20. 1 17 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 16 Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of 5 the data in your formulas, usually the Given Data section. 6 DATA 7 Sales 8 Cost of goods sold 9 General and administrative expenses 10 Depreciation expenses 11 Interest expense 12 Income taxes 13 14 SOLUTION 15 Income Statement and Common-Sized Income Statement: 16 Sales 17 Cost of goods sold 18 Gross profits 19 General and administrative expenses 20 Depreciation expense 21 Total operating expense 22 Operating income (EBIT) 23 Interest expense 24 Earnings before taxes 25 Taxes (40%) 26 Net income 27 28 Requirements: 1. Start Excel. Download and open the workbook named: Keown Martin_Petty_Problem_3-3_Start. $525,000 200,000 62,000 8,000 12,000 97,200
Expert Answer:
Answer rating: 100% (QA)
Based on the instructions provided lets go through each step In cell C16 input the sales amount Cell C16 Reference the given data cell containing the ... View the full answer
Related Book For
Project management the managerial process
ISBN: 978-0073403342
5th edition
Authors: Eric W Larson, Clifford F. Gray
Posted Date:
Students also viewed these finance questions
-
Provide an overview of the OS and the manufacturer What is the footprint for the selected OS? What security architecture was implemented? How many CVEs does this OS have?
-
Several Investment Committee members have asked about interest rate swap agreements and how they are used in the management of domestic fixed-income portfolios. a. Define an interest rate swap, and...
-
Discuss the risks depicted by the fixed asset system flowchart for Problem 10. Describe the internal control improvements to the system that are needed to reduce theserisks. Vendor User Department...
-
Public Expenditure on Education Figure 2.27 shows the public expenditure on education as percentage of Gross Domestic Product (GDP) for all countries. The mean expenditure is $\mu=4.7 %$ and the...
-
Referring to Problem 16-3, how many kanbans would be needed in each case? a. Demand is increased to 200 circuit boards per hour. b. The lead time for components is increased to 30 minutes. c. The...
-
For each of the following products and services, indicate whether it is more likely produced in a process operation or a job order operation. 1. Tennis balls 2. Tea 3. Solar panels 4. Maple syrup 5....
-
1. How will you characterize Tupperwares distribution strategy in relation to the theoretical models? 2. What are the advantages and disadvantages of Tupperwares distribution model? 3. How do you...
-
) find all possible ualues A such that the line to the cerele Cx -7/2)2+ Cy-17/3)" = 792.1614od is true ?
-
What is the velocity when the price level is 110, RGDP is 7200, and M is 660? Additional comments: the answer is 12, just need to know how to solve it. What is the velocity when the price level is...
-
How Unions and Employee Rights Unions represent under 7% of the private sector work force, perhaps 1/3d of public sector employees, down from a peak of union representation in the 1950's.?
-
In factor markets, what is the primary resource that is bought and sold? Explain briefly
-
How study examined levels of gas prices and carbon monoxide levels for a sample of municipalities.? Explain briefly
-
Describe the purpose of each of the four primary financial statements. What does each statement communicate to its users? What type of accounts are found on each statement?
-
Which of the following is NOT normally regarded as being a good reason to establish an ESOP? a. To help prevent a hostile takeover. b. To make it easier to grant stock options to employees. c. To...
-
For all of the following words, if you move the first letter to the end of the word, and then spell the result backwards, you will get the original word: banana dresser grammar potato revive uneven...
-
Assume the network and data that follow. Compute the total direct cost for each project duration. If the indirect costs for each project duration are $400 (19 time units), $350 (18), $300 (17), and...
-
Given the project network and baseline information below, complete the form to develop a status report for the project at the end of period 4 and the end of period 8. From the data you have collected...
-
Use the cultural dimensions listed in Figure to assess the culture of your school. Instead of employees, consider students, and instead of management, use faculty. For example, member identity refers...
-
We had mentioned that from the partition function \(Z\), all possible thermodynamical quantities can be determined. In this problem, we will use the harmonic oscillator's partition function of Eq....
-
Let's consider the harmonic oscillator immersed in a heat bath of temperature \(T\). For any Hermitian operator \(\hat{A}\), we can define its thermal average denoted as...
-
We had established an intriguing relationship between the path integral of the previous chapter and the partition function here through "complexification" of the time coordinate. In this problem, we...
Study smarter with the SolutionInn App