L23 7 5 6 8 9 10 11 12 13 5 14 15 16 17 18...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
L23 7 5 6 8 9 10 11 12 13 5 14 15 16 17 18 19 20 21 22 23 24 25 26 27 B C D ACTG 382 Excel Homework Assignment #1 Winter 2024 A a. Total contract price Instructions b. Company Background Information: On July 1, 2025, Torvill Construction Company Inc. contracted to build an office building for Gumbel Corp. On July 1, Torvill estimated that it would take between 2 and 3 years to complete the building. On December 31, 2027, the building was deemed substantially completed. Following are accumulated contract costs incurred, estimated costs to complete the contract, and accumulated billings to Gumbel for 2025, 2026, and 2027. Contract costs incurred to date Estimated costs to complete the contract Progress Billings to Gumbel during year This assignment is graded on the following: 1. Schedules are completed in totality for each year, with a profit/loss amount calculated for each year (6 points). 2. Appropriate use of Excel - Use of cell references for amounts if given in the problem data and use of formulas for all calculations (4 points). E $ $ F 2,200,000 G At 12/31/25 At 12/31/26 At 12/31/27 300,000 $1,200,000 $ 2,100,000 1,200,000 300,000 800,000 1,100,000 H 800,000 | Using the percentage-of-completion method, prepare a schedule to compute the profit or loss to be recognized as a result of this contract for the years ended December 31, 2025, 2026, and 2027. (Ignore income taxes.) Using the cost recovery method, prepare a schedule to compute the profit or loss to be recognized as a result of this contract for the years ended December 31, 2025, 2026, and 2027. (Ignore income taxes.) J K Solution: a. L b M N Year O Percent Estimated Total Complete To Year Costs Date 2025 $1,500,000 2026 $ 2,000,000 2027 $ P Revenue Recognized To Date Costs Incurred To Date 20% $ 440,000 $300,000 $ 60% $ 1,320,000 $1,200,000 $ 100% $ 2,200,000 $2,100,000 $ Q Revenue Costs Incurred Costs Incurred Recognized In In Current Year To Date Current Year 2025 $ 300,000 300,000 300,000 2026 $ 900,000 1,200,000 900,000 2027 $ 900,000 $2,100,000 $ 1,000,000 R Total Contract Profit/Loss Revenue Recognized To Date $300,000 1,200,000 2,200,000 $ Gross Profit/Loss for the year $ 140,000 200,000 $ (20,000) (100,000) $ (20,000) S Gross Profit Gross Profit To Recognized in Date Current Year 100,000 $ 100,000 T L23 7 5 6 8 9 10 11 12 13 5 14 15 16 17 18 19 20 21 22 23 24 25 26 27 B C D ACTG 382 Excel Homework Assignment #1 Winter 2024 A a. Total contract price Instructions b. Company Background Information: On July 1, 2025, Torvill Construction Company Inc. contracted to build an office building for Gumbel Corp. On July 1, Torvill estimated that it would take between 2 and 3 years to complete the building. On December 31, 2027, the building was deemed substantially completed. Following are accumulated contract costs incurred, estimated costs to complete the contract, and accumulated billings to Gumbel for 2025, 2026, and 2027. Contract costs incurred to date Estimated costs to complete the contract Progress Billings to Gumbel during year This assignment is graded on the following: 1. Schedules are completed in totality for each year, with a profit/loss amount calculated for each year (6 points). 2. Appropriate use of Excel - Use of cell references for amounts if given in the problem data and use of formulas for all calculations (4 points). E $ $ F 2,200,000 G At 12/31/25 At 12/31/26 At 12/31/27 300,000 $1,200,000 $ 2,100,000 1,200,000 300,000 800,000 1,100,000 H 800,000 | Using the percentage-of-completion method, prepare a schedule to compute the profit or loss to be recognized as a result of this contract for the years ended December 31, 2025, 2026, and 2027. (Ignore income taxes.) Using the cost recovery method, prepare a schedule to compute the profit or loss to be recognized as a result of this contract for the years ended December 31, 2025, 2026, and 2027. (Ignore income taxes.) J K Solution: a. L b M N Year O Percent Estimated Total Complete To Year Costs Date 2025 $1,500,000 2026 $ 2,000,000 2027 $ P Revenue Recognized To Date Costs Incurred To Date 20% $ 440,000 $300,000 $ 60% $ 1,320,000 $1,200,000 $ 100% $ 2,200,000 $2,100,000 $ Q Revenue Costs Incurred Costs Incurred Recognized In In Current Year To Date Current Year 2025 $ 300,000 300,000 300,000 2026 $ 900,000 1,200,000 900,000 2027 $ 900,000 $2,100,000 $ 1,000,000 R Total Contract Profit/Loss Revenue Recognized To Date $300,000 1,200,000 2,200,000 $ Gross Profit/Loss for the year $ 140,000 200,000 $ (20,000) (100,000) $ (20,000) S Gross Profit Gross Profit To Recognized in Date Current Year 100,000 $ 100,000 T
Expert Answer:
Answer rating: 100% (QA)
To compute the profit or loss using the percentageofcompletion method and the cost recovery method f... View the full answer
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Posted Date:
Students also viewed these accounting questions
-
(20 points)Write a program that prompts the user to input five decimal numbers. The program should then add the five decimal numbers, convert the sum to the nearest integer, and print the result....
-
Historical returns for the past three years for Stock B and the stock market portfolio are Stock B: 30 percent, 0 percent, 30 percent; market portfolio : 18 percent, 20 percent, 28 percent. The...
-
Chuck, a single taxpayer, earns $86,000 in taxable income and $20,000 in interest from an investment in City of Heflin bonds. (Use the U.S. tax rate schedule.) Required: a. If Chuck earns an...
-
How does the Dodd-Frank amendment of the Sarbanes-Oxley Act of 2002 affect Canadian companies with regard to internal controls? Be specific.
-
The Philadelphia Area Transit Authority wishes to estimate the proportion of central city workers that use public transportation to get to work. A sample of 100 workers revealed that 64 used public...
-
After completing tests of controls, an auditor concludes from available evidence that control risk can be assessed below the maximum and detection risk above the minimum. Under these conditions: a....
-
Hartman, Inc. has prepared the following comparative balance sheets for 2010 and 2011: 2011 2010 Cash 297000 153000 Receivables 159000 117000 Inventory 150000 180000 Prepaid expenses 18000 27000...
-
Support Department Cost Allocation-Direct Method Christmas Timber, Inc., produces Christmas trees. The trees are produced through a cutting and pruning process. Machine maintenance and janitorial...
-
The Fashion Rack has a monthly accounting period. All transactions are recorded in a general journal. Postings are made from the general journal to the accounts receivable ledger, accounts payable...
-
Part D - At t =4.0 s an object's velocity is v = 6.200 m/s, and at t = 10.0 s its velocity is v = 12.860 m/s. Assuming a constant acceleration, What is its displacement (in meters) from t to t? Keep...
-
V=_____ a=_ V= V= V= 14. V= a= a= a= a= For each set of pictures, at each position state whether the velocity is (+),(-),or (0). State whether the acceleration is (+),(-),or (0). Rocket moving to...
-
Electric Fields cannot be seen with the eye although their effects can be obvious. The use of animations and simulations is very helpful to visualize and understand electric fields. Complete the...
-
1. a. Do the two protons attract or repulse due to the electric force? Do the two protons attract or repulse due to gravity? c. In a helium nucleus, two protons are separated by 1.5 fm (1.5x10-5 m)....
-
A. In a stress measurement using strain gages, the following strain are measured: =340x10 =315x106 = 110x106 (a) Find Exity and oxy (b) Find principal strains in 2D, as E and their directions. (c)...
-
The first modern liquid fuel rockets were developed about a century ago. These were ballistic rockets, meaning that the majority of the flight path was that of a projectile, with just a small portion...
-
Let H(x) = cos(x) and if we let H(x) = f(g(x)), then identify the outer function f(u) and the inner function u = g(x). Make sure you use the variable u when entering the function for f and the...
-
White Bolder Investments (WBI) You are an intern working for WBI, a large investment advisory services in Sydney. Among other regular customers, WBI has been providing advisory services for Jumbo...
-
In the file named Problem39data.xlsx, you are given data on clients audited by QXZ Inc. You are told if a given firm is large or small and if they passed or failed their June audit. If the firm is...
-
The file named Lagged.xlsx contains data about the number of magazine ads placed by the US Army recruiting group during each of 60 consecutive months. For each month, the kmonth lagged number of ads...
-
The file named Teams.xlsx contains runs scored by Major League Baseball teams during a season. Create a histogram from the data. Are the runs scored symmetric or skewed?
-
A system has the differential equations \(\left[\begin{array}{lll}5 & 0 & 0 \\ 0 & 3 & 0 \\ 0 & 0 & 2\end{array} ight]\left[\begin{array}{c}\ddot{x}_{1} \\ \ddot{x}_{2} \\ \ddot{x}_{3}\end{array}...
-
Lagranges equations are used to derive the differential equations for a three degree-of-freedom system resulting in \(\left[\begin{array}{lll}m_{11} & m_{12} & m_{13} \\ m_{21} & m_{22} & m_{23} \\...
-
The following data relate to the manufacturing activities of MilTech company during November: 1. Sales $400,000 2. Purchases $60,700 3. Expenses include: Light and power for manufacturing: $2,700 ...
Study smarter with the SolutionInn App