In: Accounting
In 2021, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2023. Information related to the contract is as follows:
| 2021 | 2022 | 2023 | |||||||
| Cost incurred during the year | $ | 2,610,000 | $ | 3,162,000 | $ | 2,230,800 | |||
| Estimated costs to complete as of year-end | 6,390,000 | 2,028,000 | 0 | ||||||
| Billings during the year | 2,100,000 | 3,672,000 | 4,228,000 | ||||||
| Cash collections during the year | 1,850,000 | 3,000,000 | 5,150,000 | ||||||
Westgate recognizes revenue over time according to percentage of completion.
Required:
1. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years. (Do not round intermediate calculations. Loss amounts should be indicated with a minus sign.)
Solution
| 2021 | 2022 | 2023 | |
| Revenue | $ 2,900,000 | $ 4,500,000 | $ 2,600,000 |
| Gross profit | $ 290,000 | $ 1,338,000 | $ 369,200 |
Working
| 2021 | 2022 | 2023 | ||
| A | Contract Price | $ 10,000,000 | $ 10,000,000 | $ 10,000,000 |
| B | Cost Incurred to Date | $ 2,610,000 | $ 5,772,000 | $ 8,002,800 |
| C | Estimated cost yet to be incurred to complete the contract | $ 6,390,000 | $ 2,028,000 | $ 0 |
| D = B+C | Total Cost | $ 9,000,000 | $ 7,800,000 | $ 8,002,800 |
| E = (D/B) x 100 | % of Completion | 29% | 74% | 100% |
| F = A x E | Revenue to date | $ 2,900,000 | $ 7,400,000 | $ 10,000,000 |
| G | Revenue of Previous year | $ 0 | $ 2,900,000 | $ 7,400,000 |
| H = F - G | Net Revenue this year | $ 2,900,000 | $ 4,500,000 | $ 2,600,000 |
| I | Cost to date | $ 2,610,000 | $ 5,772,000 | $ 8,002,800 |
| J | Cost to date of previous year | $ 0 | $ 2,610,000 | $ 5,772,000 |
| K = I - J | Net Cost for the year | $ 2,610,000 | $ 3,162,000 | $ 2,230,800 |
| L = H - K | Gross Profits | $ 290,000 | $ 1,338,000 | $ 369,200 |