1 Proforma Income Statement 2 3 4 56 Sales Cost of Goods Sold A 7 8...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 Proforma Income Statement 2 3 4 56 Sales Cost of Goods Sold A 7 8 Operating Expenses 9 Dealer Percentage 10 11 12 13 14 15 Net Operating Income 16 17 18 Earnings Before Taxes 19 Administrative Expenses Selling Expenses (Sales* Dealer %) Depreciation Expenses Total 20 21 22 Net Income 23 B 2014 2015 $ 84,532,250.00 $ 100,138,250.00 $ $ 42,965,817.00 $ 52,723,795.00 $ Gross Profit $ 41,566,433.00 $ 47,414,455.00 $ 18% 7,952,839.00 $ 18,024,885.00 $ 2,026,001.00 $ $ 24,498,285.00 $ 28,003,725.00 $ $ 7,413,206.00 $ $ 15,215,805.00 $ $ 1,869,274.00 $ $ 17,068,148.00 $ Interest Expense $ 93,468.00 $ C Tax Percentage Taxes (Earning before taxes * Tax %) $ 8,487,340.00 $ $ 16,974,680.00 $ 19,318,141.00 $ 50% 19,410,730.00 $ 92,589.00 $ 50% 9,659,070.50 $ $ 8,487,340.00 $ 9,659,070.50 $ D 2016 115,845,850.00 $ 64,516,024.00 $ 51,329,826.00 $ 8,917,696.00 $ 20,852,253.00 $ 2,483,744.00 $ 32,253,693.00 $ 19,076,133.00 $ 110,277.00 18,965,856.00 $ 50% 9,482,928.00 $ 9,482,928.00 $ E 2017 2018 156,410,100.00 $ 196,445,370.00 77,515,149.00 $ 104,128,001.00 78,894,951.00 $92,317,369.00 F 7,964,649.00 $ 7,738,943.00 28,153,818.00 $ 35,360,166.60 2,251,791.00 $ 2,486,977.00 38,370,258.00 $ 45,586,086.60 40,524,693.00 $ 46,731,282.40 121,465.00 $ 117,855.00 40,403,228.00 $ 46,613,427.40 50% 50% 20,201,614.00 $ 23,306,713.70 20,201,614.00 $ 23,306,713.70 Question 5: Goal Seek Using the results from your 2018 income statement, identify the gross sales (in $) required in 2018 to achieve a Net Income of $30,000,000. Use Goal Seek to answer this question. Show a screenshot of your Goal Seek as it displays the answer. the 2018 sales is $ 196,445,370.00 1 Proforma Income Statement 2 3 4 56 Sales Cost of Goods Sold A 7 8 Operating Expenses 9 Dealer Percentage 10 11 12 13 14 15 Net Operating Income 16 17 18 Earnings Before Taxes 19 Administrative Expenses Selling Expenses (Sales* Dealer %) Depreciation Expenses Total 20 21 22 Net Income 23 B 2014 2015 $ 84,532,250.00 $ 100,138,250.00 $ $ 42,965,817.00 $ 52,723,795.00 $ Gross Profit $ 41,566,433.00 $ 47,414,455.00 $ 18% 7,952,839.00 $ 18,024,885.00 $ 2,026,001.00 $ $ 24,498,285.00 $ 28,003,725.00 $ $ 7,413,206.00 $ $ 15,215,805.00 $ $ 1,869,274.00 $ $ 17,068,148.00 $ Interest Expense $ 93,468.00 $ C Tax Percentage Taxes (Earning before taxes * Tax %) $ 8,487,340.00 $ $ 16,974,680.00 $ 19,318,141.00 $ 50% 19,410,730.00 $ 92,589.00 $ 50% 9,659,070.50 $ $ 8,487,340.00 $ 9,659,070.50 $ D 2016 115,845,850.00 $ 64,516,024.00 $ 51,329,826.00 $ 8,917,696.00 $ 20,852,253.00 $ 2,483,744.00 $ 32,253,693.00 $ 19,076,133.00 $ 110,277.00 18,965,856.00 $ 50% 9,482,928.00 $ 9,482,928.00 $ E 2017 2018 156,410,100.00 $ 196,445,370.00 77,515,149.00 $ 104,128,001.00 78,894,951.00 $92,317,369.00 F 7,964,649.00 $ 7,738,943.00 28,153,818.00 $ 35,360,166.60 2,251,791.00 $ 2,486,977.00 38,370,258.00 $ 45,586,086.60 40,524,693.00 $ 46,731,282.40 121,465.00 $ 117,855.00 40,403,228.00 $ 46,613,427.40 50% 50% 20,201,614.00 $ 23,306,713.70 20,201,614.00 $ 23,306,713.70 Question 5: Goal Seek Using the results from your 2018 income statement, identify the gross sales (in $) required in 2018 to achieve a Net Income of $30,000,000. Use Goal Seek to answer this question. Show a screenshot of your Goal Seek as it displays the answer. the 2018 sales is $ 196,445,370.00
Expert 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
-
(10 points) Given that ry + xy = 1. 1. Find a solution of the differential equation that satisfies the initial condition y(1) = 10. Answer: y = 2. Find a solution of the differential equation that...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Mixing together solutions of acetic acid and sodium hydroxide can make a buffered solution. Explain. How does the amount of each solution added change the effectiveness of the buffer?
-
Construct a simple example to show that a firm's existing stockholders gain if it can sell overpriced stock to new investors and invest the cash in a zero-NPV project. Who loses from these actions?...
-
Ronaldo Associates is a construction engineering firm that prepares detailed con- struction drawings for single family homes. The market for this service is very competitive. To compete successfully...
-
A simple random sample of 17 business majors from a certain university had a mean GPA of 2.81 with a standard deviation of 0.27. A simple random sample of 23 psychology majors was selected from the...
-
A mixing process consists of a single stirred-tank instrumented as shown in figure. The concentration of a single species A in the feed stream varies. The controller attempts to compensate for this...
-
istered VAT vendor and buys and sells furniture. Africa Traders wants to sell a dining room table with a cost price of R 5 2 0 0 . The mark - up percentage on cost is 2 0 % . What will be the selling...
-
You receive an email from your mentor: Hey, Tough assignment! Welcome to the messy job of...well...cleaning up messes. I've been following our mentions on social media since last night, too, so here...
-
The following table shows rates of return for a mutual fund and the market portfolio (S&P 500). A B C 1 Year Fund Market 2 1 14% 13% 3 2 -30% -14% 4 3 -6% -2% 5 4 5% 28% 6 10 14% 8% 7 6 11% 8% Part 1...
-
The following set of displacements were recorded over time intervals At = 0.01 seconds. What is the average value of the velocities calculated over each time interval? (Please provide your answer in...
-
A car travelling at a speed of 140km/h decelerates for 20 s. During this time it travels at 500 m . A) what is its deceleration in m/s 2 . b) what is its speed after the deceleration in km/h.
-
Many years into the future, football/soccer is the most popular sport on Mars. It is played inside an enclosed dome, since Mars still doesn't have a breathable atmosphere, but otherwise it's pretty...
-
RELATIONAL VIOLENCE: VERBAL ABUSE Purpose: 1. Examine the manner in which communication might be used as a form of relational abuse and violence. Directions: 1. Relational violence includes a range...
-
Chipotle estimates the value of the at the money stock options granted to the employees at $456.44 per share using the Black Sholes option pricing model. Looking at option prices in the open market...
-
For the data from a sample shown below, answer the questions. Round to 2 decimal places. X 22.1 3.8 4.4 5.3 25.3 16.7 9.8 11.6 Find the mean: Find the median: Find the standard deviation:
-
What are three disadvantages of using the direct write-off method?
-
In June of 2012, Maureen's house is vandalized during a long-term power failure after a hurricane hit the city. The president of the United States declares Maureen's city a disaster area as a result...
-
Jason and Mary Wells, friends of yours, were married on December 30, 2012. They know you are studying taxes and have come to you with a question concerning their filing status. Jason and Mary would...
-
Phil and Linda are 25-year-old newlyweds and file a joint tax return. Linda is covered by a retirement plan at work, but Phil is not. a. Assuming Phil's wages were $27,000 and Linda's wages were...
-
Joe Melton, CPA, has been contacted by the president of Mudalum Company (a company developing a process to turn mud into aluminum) and asked to perform the company's audit for the current year....
-
The use of audit committees has become widespread. Independent auditors have become increasingly involved with audit committees and consequently have become familiar with their nature and function....
-
Management of Consolidated Systems Company (CSC), a publicly held company, has asked three accounting firms, including yours, to bid on its annual audit. It has given permission to you and the...
Study smarter with the SolutionInn App