Question

In: Accounting

Income recognition for a contractor. On October 15, 2010, Flanikin Construction Company contracted to build a...

Income recognition for a contractor. On October 15, 2010, Flanikin Construction Company contracted to build a shopping center at a contract price of $180 million. The schedule of expected and actual cash collections and contract costs is as follows:

Year Cash collections from Customers Estimated and Actual Cost Incurred

2010 $36,000,000 $12,000,000

2011 45,000,000 36,000,000

2012 45,000,000 48,000,000

2013 54,000,000 24,000,000

   $180,000,000 $120,000,000

A) Calculate the amount of revenue, expense, and net income for each of the four years under the following revenue recognition methods:

(1)    Percentage-of-completion method.

(2)    Completed contract method.

B) Show the journal entries Flanikin will make in 2010, 2011, 2012, and 2013 for this contract. Flanikin accumulates contract costs in a Contract in Process account. Although the costs involve a mixture of cash payments, credits to assets, and credits to liability accounts, assume for purposes of this problem that all costs are recorded as credits to Accounts Payable.

C) Which method do you believe provides the better measure of Flanikin Construction Company’s performance under the contract? Why?

Can somebody please show me how to calculate this in EXCEL. Step by step excel calculations need to be shown with screenshots. Thank you.

Solutions

Expert Solution


Related Solutions

Brady Construction Company contracted to build an apartment complex for a price of $5,800,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $5,800,000. Construction began in 2021 and was completed in 2023. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2021 2022 2023 2021 2022 2023 1 1,580 2,370 1,140 3,510 1,140 — 2 1,580...
Brady Construction Company contracted to build an apartment complex for a price of $5,200,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $5,200,000. Construction began in 2018 and was completed in 2020. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2018 2019 2020 2018 2019 2020 1 1,520 2,190 960 3,150 960 — 2 1,520...
Brady Construction Company contracted to build an apartment complex for a price of $6,000,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $6,000,000. Construction began in 2018 and was completed in 2020. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2018 2019 2020 2018 2019 2020 1 1,600 2,430 1,200 3,630 1,200 — 2 1,600...
Brady Construction Company contracted to build an apartment complex for a price of $5,200,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $5,200,000. Construction began in 2021 and was completed in 2023. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2021 2022 2023 2021 2022 2023 1 1,520 2,190 960 3,150 960 — 2 1,520...
Brady Construction Company contracted to build an apartment complex for a price of $5,200,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $5,200,000. Construction began in 2021 and was completed in 2023. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2021 2022 2023 2021 2022 2023 1 1,520 2,190 960 3,150 960 — 2 1,520...
Brady Construction Company contracted to build an apartment complex for a price of $6,800,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $6,800,000. Construction began in 2018 and was completed in 2020. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2018 2019 2020 2018 2019 2020 1 1,680 2,670 1,440 4,110 1,440 — 2 1,680...
Brady Construction Company contracted to build an apartment complex for a price of $6,900,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $6,900,000. Construction began in 2018 and was completed in 2020. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2018 2019 2020 2018 2019 2020 1 1,690 2,700 1,470 4,170 1,470 — 2 1,690...
Brady Construction Company contracted to build an apartment complex for a price of $6,300,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $6,300,000. Construction began in 2018 and was completed in 2020. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2018 2019 2020 2018 2019 2020 1 1,630 2,520 1,290 3,810 1,290 — 2 1,630...
Chiefs Construction Company has contracted to build an office building. The construction is scheduled to begin...
Chiefs Construction Company has contracted to build an office building. The construction is scheduled to begin on January 1, 2020, and the estimated time of completion is July 1, 2023. The building cost is estimated to be $20,000,000 and will be billed at $24,000,000. The following data relate to the construction period: 2020 2021 2022 2023 Cost to date 5,500,000 10,000,000 13,500,000 20,000,000 Estimated cost to complete 14,500,000 10,000,000 6,500,000 -0- Progress billings to date 3,000,000 9,000,000 14,000,000 24,000,000 Cash...
Brady Construction Company contracted to build an apartment complex for a price of $6,400,000. Construction began...
Brady Construction Company contracted to build an apartment complex for a price of $6,400,000. Construction began in 2018 and was completed in 2020. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars. Estimated Costs to Complete Costs Incurred During Year (As of the End of the Year) Situation 2018 2019 2020 2018 2019 2020 1 1,640 2,550 1,320 3,870 1,320 — 2 1,640...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT