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)
The image provided is a screenshot of an Excel workbook with an accounting assignment to be solved using two different revenue recognition methods the ... 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
-
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...
-
What does it mean when an observational study is retrospective? What does it mean when an observational study is prospective?
-
Perform the indicated operation and simplify the result. Leave your answer in factored form. x? 3 2 + 10
-
ZeeZee's Construction Company has the opportunity to select one of four projects (A, B, C, or D) or choose the null (do-nothing) alternative. Each project requires a single initial investment and has...
-
Soldner Health Care Products Inc. expects to maintain the same inventories at the end of 2010 as at the beginning of the year. The total of all production costs for the year is therefore assumed to...
-
(20%) The output of an argon ion laser can consist of a number of modes of frequency that match the cavity resonance condition and are within the gain bandwidth of the lasing transition. Assume the...
-
1. This family business has made numerous transitions. It started as two brothers and their wives (Whitehall), then became a husband and wife team (Judds Hill), and finally parents with their son and...
-
Pharoah Ltd.'s allowance for expected credit losses was $76500 at the end of 2023 and $94500 at the end of 2022. For the year ended December 31, 2023, Pharoah reported a loss on impairment of $16200...
-
joe is a sole proprietor. during the year he sold a machine (initial cost $175,000; AB 100,000) he had used in his business for 20,000 resulting in a 80,000 loss. assuming joe realized net $500,000...
-
Ella files head of household. She is interested in purchasing a clean vehicle, but she wants to determine if she qualifies for the credit. Based on her filing status, what is her maximum modified...
-
you will be acting as a Border Services Officer (BSO) at a land border crossing. Your particular crossing has been selected by the Prime Minister's Office as a location for a press conference on...
-
In March 2019, the Company issued $500.0 million of senior unsecured notes maturing on March 1, 2026 ("2026 Term Notes"). The 2026 Term Notes accrue interest at a fixed rate of 3.40% per annum, with...
-
Evaluating data reliability is a critical part of the audit process. Explain the differences among the following in terms of reliability: Data from internal versus external sources. Written data...
-
President Lee Coone has asked you to continue planning for an integrated corporate NDAS network. Ultimately, this network will link all the offices with the Tampa head office and become the...
-
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. The equation of the Phillips curve from 1970 to 1995 is: \[\pi_{t}-\pi_{t-1}=7.4 \%-1.2 u_{t}\] Calculate and define the natural rate of unemployment using this curve. b. The equation of the...
-
Suppose that the mark-up of goods prices over marginal cost is \(5 \%\), and that the wage-setting equation is: \[W=P(1-u)\] where \(u\) is the unemployment rate. a. What is the real wage, as...
-
How can a lockdown result in stagflation? A lockdown can have three different effects: a. The first happens when demand during the lockdown decreases so that actual output, \(Y_{t}\), falls exactly...
Study smarter with the SolutionInn App