Question

In 2016, 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 2018. Information related to the contract is as follows:

I NEED HELP RESOLVING THE EMPTY 8 BOXES BELOW (4&5).

4. Calculate the amount of revenue and gross profit 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.) Cost incurred during the year Estimated costs to complete as of year-end 2016 $2,610,000 6,390,000 2017 $3,850,000 3,150,000 2018 $3,250,000 2017 2018 Revenue Gross profit (loss) 2016 $2,900,000 | $ 290,000 5. Calculate the amount of revenue and gross profit 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.) Cost incurred during the year Estimated costs to complete as of year-end 2016 $2,610,000 6,390,000 2017 $3,850,000 4,200,000 2018 $4,050,000 2017 2018 Revenue Gross profit (loss) 2016 $2,900,000 S 290,000

Answer 1

Answers

• Requirement 4

	2016	2017	2018
Revenue	$                2,900,000.00	$               3,822,164	$                    3,277,836
Gross Profit (Loss)	$                   290,000.00	$                   100,000.00	$                     (100,000.00)

--Working

Working		2016	2017	2018
A	Contract Price	$             10,000,000.00	$             10,000,000.00	$                  10,000,000.00
B	Cost Incurred to Date	$                2,610,000.00	$               6,460,000.00	$                    9,710,000.00
C	Estimated cost yet to be incurred to complete the contract	$                6,390,000.00	$               3,150,000.00	$                                         -
D = B+C	Total Cost	$                9,000,000.00	$               9,610,000.00	$                    9,710,000.00
E = (B/D) x 100	% of Completion	29.00%	67.22%	100.00%
F = A x E	Revenue to date	$                2,900,000.00	$               6,722,164.41	$                  10,000,000.00
G	Revenue of Previous year	$                                     -	$               2,900,000.00	$                    6,722,164.41
H = F - G	Net Revenue this year	$                2,900,000.00	$               3,822,164.41	$                    3,277,835.59
I (=B)	Cost to date	$                2,610,000.00	$               6,460,000.00	$                   9,710,000.00
J	Cost to date of previous year	$                                     -	$               2,610,000.00	$                    6,460,000.00
K = I - J	Net Cost for the year	$                2,610,000.00	$               3,850,000.00	$                    3,250,000.00
L = A - D	Estimated Gross Profit (Loss)	$                1,000,000.00	$                   390,000.00	$                        290,000.00
M	Gross Profit (Loss) to be recognised	$                   290,000.00	$                   100,000.00	$                     (100,000.00)

• Requirement 5

	2016	2017	2018
Revenue	$                2,900,000.00	$               3,160,038	$                    3,939,962
Gross Profit (Loss)	$                   290,000.00	$                 (950,000.00)	$                        150,000.00

--Working

Working		2016	2017	2018
A	Contract Price	$             10,000,000.00	$             10,000,000.00	$                  10,000,000.00
B	Cost Incurred to Date	$                2,610,000.00	$               6,460,000.00	$                  10,510,000.00
C	Estimated cost yet to be incurred to complete the contract	$                6,390,000.00	$               4,200,000.00	$                                         -
D = B+C	Total Cost	$                9,000,000.00	$             10,660,000.00	$                  10,510,000.00
E = (B/D) x 100	% of Completion	29.00%	60.60%	100.00%
F = A x E	Revenue to date	$                2,900,000.00	$               6,060,037.52	$                  10,000,000.00
G	Revenue of Previous year	$                                     -	$               2,900,000.00	$                    6,060,037.52
H = F - G	Net Revenue this year	$                2,900,000.00	$               3,160,037.52	$                    3,939,962.48
I (=B)	Cost to date	$                2,610,000.00	$               6,460,000.00	$                  10,510,000.00
J	Cost to date of previous year	$                                     -	$               2,610,000.00	$                    6,460,000.00
K = I - J	Net Cost for the year	$                2,610,000.00	$               3,850,000.00	$                    4,050,000.00
L = A - D	Estimated Gross Profit (Loss)	$                1,000,000.00	$                 (660,000.00)	$                     (510,000.00)
M	Gross Profit (Loss) to be recognised	$                   290,000.00	$                 (950,000.00)	$                        150,000.00