In: Accounting
In 2018, 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 2020. Information related to
the contract is as follows:
2018 | 2019 | 2020 | |||||||
Cost incurred during the year | $ | 2,580,000 | $ | 4,042,000 | $ | 2,175,800 | |||
Estimated costs to complete as of year-end | 6,020,000 | 1,978,000 | 0 | ||||||
Billings during the year | 2,060,000 | 4,562,000 | 3,378,000 | ||||||
Cash collections during the year | 1,830,000 | 4,200,000 | 3,970,000 | ||||||
Westgate recognizes revenue over time according to percentage of
completion.
5. Calculate the amount of revenue and gross
profit (loss) to be recognized in each of the three years assuming
the following costs incurred and costs to complete information.
(Do not round intermediate calculations and round your
final answers to the nearest whole dollar amount. Loss amounts
should be indicated with a minus sign.)
2018 | 2019 | 2020 | |||||||
Cost incurred during the year | $ | 2,580,000 | $ | 3,830,000 | $ | 3,990,000 | |||
Estimated costs to complete as of year-end | 6,020,000 | 4,160,000 | 0 | ||||||
5) | |||
Particulars | 2018 | 2019 | 2020 |
Costs incurred during the year | $2,580,000 | $3,830,000 | $3,990,000 |
Cumulative Cost incurred upto date (A) | $2,580,000 | $6,410,000 | $8,990,000 |
Estimated cost to be incurred (B) | $6,020,000 | $4,160,000 | $0 |
Total Costs have to be incurred ( C) = (A+B) | $8,600,000 | $10,570,000 | $8,990,000 |
Completion Percentage (E ) = (A / C) | 30.00% | 60.64% | 100.00% |
Total Project Revenue (F) | $10,000,000 | $10,000,000 | $10,000,000 |
Revenue to be recognized in upto date (G) = (E * F) | $3,000,000 | $6,064,333 | $10,000,000 |
Revenue recognized in previous years (H) | $0 | $3,000,000 | $6,064,333 |
Revenue to be recognized in current year (I) = (G - H) | $3,000,000 | $3,064,333 | $3,935,667 |
Expected Profit (J) = (F - C) | $1,400,000 | ($570,000) | $1,010,000 |
Gross Profit To be recognized upto date (K) = (E*J) | $420,000 | ($345,667) | $1,010,000 |
Gross Profit recognized in previous year (L) | $0 | $420,000 | ($345,667) |
Gross Profit (Loss) to be recognized in current year (M) = (K - L) | $420,000 | ($765,667) | $664,333 |
FINAL Answer | |||
Particulars | 2018 | 2019 | 2020 |
Revenue (I) | $3,000,000 | $3,064,333 | $3,935,667 |
Gross Profit (Loss) (M) | $420,000 | ($765,667) | $664,333 |