ACTG 382 Excel Homework Assignment #1 Spring 2024 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 (7 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 (3 points). 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. NOTE: The company's fiscal year aligns with the calendar year. The phrase "to date" that is used in the contract details below, as well as in the answer table, means up to the present time. Pay attention to the years that you're working with! Total contract price $ 2,400,000 At 12/31/25 Contract costs incurred to date $ Estimated costs to complete the contract Progress Billings to Gumbel during year 300,000 At 12/31/26 At 12/31/27 300,000 $ 1,220,000 $2,150,000 1,200,000 800,000 1,100,000 800,000 Instructions a. b. Using the percentage-of-completion method, prepare schedules 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 schedules 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.) Record Your Answers Here: a. Estimated Date Total Costs 12/31/2025 $ 1,500,000 12/31/2026 $ 2,020,000 12/31/2027 $ 2,150,000 Percent Revenue Complete To Recognized To Date Date 20% $ 480,000 60% $ 1,449,505 100% $ 2,400,000 Revenue Recognized in Current Year Gross Profit Costs Incurred Recognized in To Date Current Year b Date Costs Incurred In Current Year Revenue Revenue Gross Profit Costs Incurred Recognized In Recognized To Date Current Year To Date Gross Profit To Recognized in Date Current Year 12/31/2025 12/31/2026 12/31/2027