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
-
A B C D E G H M Problem #4: Gaming Consider an electronics retailer selling gaming consoles. The retailer purchases the console at $240 per unit and sells them at $450 per unit. Any unsold inventory...
-
(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...
-
What is the present value of the following cash-flow stream if the interest rate is 6%? Year Cash Flow 1............................$200 2..............................400...
-
Guess Company manufactures a variety of natural fabrics for the clothing industry. The following cost data are available for the month of January. There were 80,000 units in process on January 1...
-
Consider the matrix \[A=\left(\begin{array}{ccc} \frac{1}{2} & \frac{1}{\sqrt{2}} & \frac{1}{2} \\ -\frac{1}{\sqrt{2}} & 0 & \frac{1}{\sqrt{2}} \\ \frac{1}{2} & -\frac{1}{\sqrt{2}} & \frac{1}{2}...
-
A.J's Wildlife Emporium manufactures two unique bird feeders (Deluxe and Super Duper) that are manufacture and assembled in up to three different workstations (X, Y, Z) using a small batch process....
-
The company has a shoes and a shirts division. The company reported the following segmented income statement for last month: Division Total Shoes Shirts Sales Variable expenses Contribution Margin...
-
Problem #12: Planning and Control Don't-Cha-Wanna-a-Coffee, a large-scale coffee company that has a chain of 125 retail coffee stores throughout New England, was embroiled in an ethics scandal 3...
-
On Thursday November 10, 2016, the stock price of one share of Tesla is $187.30. What does the Exchange Ratio currently represent as the value of a share of Solar City stock?
-
The fatality rate of COVID-19 here in the Philippines up-to-date is 1.6%. Determine the probability of the following: a. Only 1 of the next 10 COVID-19 patients will recover. b. All of the next 10...
-
3. Your rich grandparents inform you that they will pay $1,000/month toward your college loans after you finish school. If you complete college with $77,777 in debt, repayable at 3.98% APR... a.......
-
What are the primary factors that contribute to resistance during organizational change, and what role does communication play in fostering a successful transformation process ?
-
/9085511/View Lexie averages 149 points per bowling game with a standard deviation of 14 points. Suppose Lexie's points per bowling game are normally distributed. Let X = the number of points per...
-
A) Your full-service brokerage firm charges $190 per stock trade. How much money do you receive after selling 360 shares of International Business Machines (IBM), which trades at $90.57? Amount...
-
10 102/12 s Tryco loans $60,000 to another company on 10/31/23 in exchange for a 10%, 6-month Note Receivable. The note matures on 4/30/24. Journalize all required entries. 10/31/23 12/31/23 4/30/24...
-
Assessing simultaneous changes in CVP relationships Braun Corporation sells hammocks; variable costs are $75 each, and the hammocks are sold for $125 each. Braun incurs $240,000 of fixed operating...
-
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?
-
The bidask spread (II) Consider the spot quotations in pounds per dollar (/\($)\) and dollars per pound (\($/)\) in Table 3.15: a. Compute the bid quotations in American and European terms. b....
-
Interest rate parity Consider Figure 3.29, which indicates (approximately) the difference between interest rates in the United States and the UK, Rus Ruk on a one-year T-bill (i.e. a two-year bill...
-
Points quotations In Table 3.16, consider the spot quotations in dollars per pound (\($/)\) and the forward quotations in basis points (1/10,000). On the basis of the points quotations in Table 3.16,...
Study smarter with the SolutionInn App