4 Chapter Five: Spreadsheets Applications in Financial Statements Analysis 2 3 14 5 Student Name Student...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4 Chapter Five: Spreadsheets Applications in Financial Statements Analysis 2 3 14 5 Student Name Student ID EX4 Amman Company Statement of Profit or Loss For the Year Ended December 31, 2018 7 Sales 8 Sales Returns 9 Sales Discounts Net Sales 10 11 Beginning Inventory 12 Purchases 13 Purchases Returns 14 Purchases Discounts 15 Purchases Expenses 16 17 Ending Inventory 18 Cost of Net Purchases Cost of Goods Sold 19 Grass Profit / Loss 20 Advertising Expenses 21 Salaries Expenses A Sumasative Expenses 23 Total Operating Expenses 24 Profit/Loss Before Tax 25 Tax (40%) 26 BANG Profit/Loss 100000 ??? ??? ??? 10000 ??? ??? ??? ??? ??? ITE 10000 ??? ??? ??? 4500 1200 ??? ??? ??? ??? (Figure 5-23) Financial Ratio Gross Profil Marjan 164 Operating Income Margin Income (Profit) Margin Any entory Turnover of the following financial ratios: a Gross Profit Margin. 277 b. Operating Income Margin. e Income (Profit) Margin. & Inventory Turnover. 169 777 Required: 1. Create a new worksheet "Chapter5 EX4", and enter the previous EX4", data in it. ??? 2. Insert necessary equations or functions in the related cells to calculate sales returns (2% of sales), sales discounts (5% of sales), net sales, purchases (50% of sales), purchases returns (2% of purchases), purchases discounts (6% of purchases), purchases expenses (1% of purchases), cost of net purchases, cost of goods sold, gross profit/loss, advertising expenses (3% of sales), total operating expenses, profit/loss before tax, tax (40%), and profit/loss. 3. Insert necessary equations in the related cells to calculate each 227 4 Chapter Five: Spreadsheets Applications in Financial Statements Analysis 2 3 14 5 Student Name Student ID EX4 Amman Company Statement of Profit or Loss For the Year Ended December 31, 2018 7 Sales 8 Sales Returns 9 Sales Discounts Net Sales 10 11 Beginning Inventory 12 Purchases 13 Purchases Returns 14 Purchases Discounts 15 Purchases Expenses 16 17 Ending Inventory 18 Cost of Net Purchases Cost of Goods Sold 19 Grass Profit / Loss 20 Advertising Expenses 21 Salaries Expenses A Sumasative Expenses 23 Total Operating Expenses 24 Profit/Loss Before Tax 25 Tax (40%) 26 BANG Profit/Loss 100000 ??? ??? ??? 10000 ??? ??? ??? ??? ??? ITE 10000 ??? ??? ??? 4500 1200 ??? ??? ??? ??? (Figure 5-23) Financial Ratio Gross Profil Marjan 164 Operating Income Margin Income (Profit) Margin Any entory Turnover of the following financial ratios: a Gross Profit Margin. 277 b. Operating Income Margin. e Income (Profit) Margin. & Inventory Turnover. 169 777 Required: 1. Create a new worksheet "Chapter5 EX4", and enter the previous EX4", data in it. ??? 2. Insert necessary equations or functions in the related cells to calculate sales returns (2% of sales), sales discounts (5% of sales), net sales, purchases (50% of sales), purchases returns (2% of purchases), purchases discounts (6% of purchases), purchases expenses (1% of purchases), cost of net purchases, cost of goods sold, gross profit/loss, advertising expenses (3% of sales), total operating expenses, profit/loss before tax, tax (40%), and profit/loss. 3. Insert necessary equations in the related cells to calculate each 227
Expert Answer:
Answer rating: 100% (QA)
To assist you with creating the worksheet and inserting the necessary equations or functions please ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
THINK OF SELF AS LIBERAL OR CONSERVATIVE * FAVOR SPANKING TO DISCIPLINE CHILD Case Processing Summary Cases Valid N Percent 297 100.0% Total N Percent 0.0% 297 100.0% Missing N Percent 0
-
Bottle-Up, Inc. was organized on January 8, 2010. and made its Selection on January 24, 2010. The necessary consents to the election were filed in a timely manner. Its address is 1234 Hill Street,...
-
Explain 3-Cyanopropyldimethylchlorosilane?
-
Laval produces lighting fixtures. Budgeted Information for Its two production departments follows. The departments use machine hours (MH) and direct labor hours (DLH). Overhead cost Direct labor...
-
Maria purchased 1,000 shares of stock for $35.50 per share in 2003. She sold them in 2007 for $55.10 per share. Express her capital gain as a percent, rounded to the nearest tenth of a percent
-
Identify the marketing utilities you purchase when you buy a bag of potato chips.
-
Boat Repairs Services Ltd has the following trial balance as at June 20x1: Boat Repairs Services Ltds accountant has identified the following adjustments that must be made: a A special rain insurance...
-
Jennifer Ross, an employee of Hampton Company, worked 44 hours during the week of February 9 through 15. Her rate of pay is $ 30 per hour, and she receives time- and- a- half for work in excess of 40...
-
A couple wishes to borrow money using the equity in their home for collateral. A loan company will loan them up to 70% of their equity. They puchased their home 10 years ago for $65, 757. The home...
-
Chandra was the sole shareholder of Pet Emporium, which was originally formed as an S corporation. When Pet Emporium terminated its S election on August 31, 2019, Chandra had a stock basis and an...
-
Ethane is produced from the hydrogenation of acetylene. Acetylene and hydrogen are fed to a reactor in stoichiometric ratio . The product stream is analyzed and found to contain 20% by mole...
-
Your father is 60 years old and will retire in 10 years. He expects to live for 27years after he retires, until he is 89. He wants a fixed retirement income that has the same purchasing power at the...
-
Operating within a real-world international context for global marketing presents a landscape of both opportunities and challenges. On the opportunity side, it offers the chance for expansive market...
-
Harris Fabrics computes its plantwide predetermined overhead rate annually on the basis of direct labor-hours. At the beginning of the year, it estimated that 35,000 direct labor-hours would be...
-
To research a hospitality and tourism law case in the following relevant sectors (sports, theme parks, restaurant, resorts, spas, or travel industry) and prepare a Case Analysis . Your selection must...
-
1. John Murley operates John's Cleaning Service. As the bookkeeper, you have been requested to journalize the following transactions: 201X Aug. 1 6 12 Paid 2 months' rent in advance, $10,000....
-
Bravo Company wants to issue new 19-year bonds for some expansion projects. The company has 7 percent coupon bonds on the market that sell for $1,060, have a par value of $1,000, make semiannual...
-
Express these numbers in standard notation. a. 2.87 10-8 b. 1.78 1011 c. 1.381 10-23
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Charlie's Green Lawn Care is a cash basis taxpayer. Charlie Adame, the sole proprietor, is considering delaying some of his December 2012 customer billings for lawn care into the next year. In...
-
Mark owns his home and has a $250,000 mortgage related to his purchase of the residence. When his daughter went to college in the fall of 2012, he borrowed $20,000 through a home equity loan on his...
-
What is an economic rent? What is it based on?
-
Show how the conglomerate discount leads to an increase in the cost of equity.
-
Should an investment have a higher expected rate of return than required rate of return? Generally will value always be created?
Study smarter with the SolutionInn App