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)
Based on the instructions provided in the photograph and the information in the Statement of Profit or Loss lets calculate the values that should be i... 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
-
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...
-
The concrete wall of a building is 0.10 m thick. The temperature inside the building is 20.0 C, while the temperature outside is 0.0 C. Heat is conducted through the wall. When the building is...
-
How is the initial measurement of a financial asset determined? Explain how a gain or loss can arise on initial measurement of a financial asset.
-
Until recently, Seth worked for the Seaside Cruise Ship Line Corporation (Seaside) as an engineer. Seaside is a U.S. company based in Florida. For the past two years, Seth has been assigned to one of...
-
The comparative balance sheet of Mills Engine Co. at December 31, 2013 and 2012, is as follows: The noncurrent asset, noncurrent liability, and stockholders' equity accounts for 2013 are as follows:...
-
Explain why clients may want to have a review, versus an audit. In detail, explain the differences between a certified audit and a review. In addition, what role does an internal auditor play in...
-
You have a 9 9 grid of squares, each of which can be colored red or blue. The grid is initially colored all blue, but you can change the color of any square any number of times. Imagining the grid...
-
The pH of a 0.53 M solution of pentanoic acid (HC,H,O) is measured to be 2.56. Calculate the acid dissociation constant K of pentanoic acid. Round your answer to 2 significant digits.
-
Prepare and submit a table summarizing the major differences and similarities of these different delivery system agreements. The different delivery systems agreements are Design-Bid-Build,...
-
You buy a 5-year, 8 percent coupon bond at par, $100, and hold it for three years. When you sell the bond, the interest rate is 7 percent. What is the annualized holding period yield?
-
What is defined as the procedure used to standardize the instrument for accuracy by determining the instrument's deviation from calibration references (fine tuning)? What is defined as the procedure...
-
Stor Inc. owns 35% of the outstanding stock of Investee Company. During 2022, Investor received a $4,000 cash dividend which was declared and paid by the Investee. What effect did this have on...
-
Why are Reserves created by companies? Distinguish between (i) Free Reserves and 'Specific Reserve' and (ii) Revenue Reserve and Capital Reserve.
-
You have just been appointed President of Holy Shoe Company. You are studying the key past financial statistics and credit rating data of your company for the years 2017 & 2018, as outlined on the...
-
What mass of H2 will be produced when 122 g of Zn are reacted? Zn(s) + 2HCl(aq) ( ZnCl2(aq) + H2(g)
-
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...
-
Use Stokes' theorem [Eq. (27.5)] to prove that Eq. (27.4) leads to Eq. (27.6). Data from Eq. 27.4 Data from Eq. 27.5 Data from Eq. 27.6 = z ) ); A dr. - SA dr) = f A dr.
-
Prove the result of Eq. (26.10) that a path-dependent representation of a gauge group is sensitive to a gauge transformation only at the endpoints of the path.
-
In Eq. (26.7), invert \(A^{\mu}(x)=A_{i}^{\mu}(x) \tau^{i}\) to obtain \(A_{i}^{\mu}(x) \equiv 2 \operatorname{Tr}\left(\tau_{i} A^{\mu} ight)\).
Study smarter with the SolutionInn App