Please use excel. Thank you.
Citation Builders, Inc., builds office buildings and single-family homes. The office buildings are constructed under contract with reputable buyers. The homes are constructed in developments ranging from 10-20 homes and are typically sold during construction or soon after. To secure the home upon completion, buyers must pay a deposit of 10% of the price of the home with the remaining balance due upon completion of the house and transfer of title. Failure to pay the full amount results in forfeiture of the down payment. Occasionally, homes remain unsold for as long as three months after construction. In these situations, sales price reductions are used to promote the sale. During 2016, Citation began construction of an office building for Altamont Corporation. The total contract price is $20 million. Costs incurred, estimated costs to complete at year-end, billings, and cash collections for the life of the contract are as follows: Also during 2016, Citation began a development consisting of 12 identical homes. Citation estimated that each home will sell for $600,000, but individual sales prices are negotiated with buyers. Deposits were received for eight of the homes, three of which were completed during 2016 and paid for in full for $600,000 each by the buyers. The completed homes cost $450,000 each to construct. The construction costs incurred during 2016 for the nine uncompleted homes totaled $2, 700,000. Briefly explain the difference between recognizing revenue over time and upon project completion when accounting for long-term construction contracts. Answer the following questions assuming that Citation concludes it does not qualify for revenue recognition over time for its office building contracts: How much revenue related to this contract will Citation report in its 2016 and 2017 income statements? What is the amount of gross profit or loss to be recognized for the Altamont contract during 2016 and 2017? What will Citation report in its December 31, 2016, balance sheet related to this contract? (Ignore cash.) Answer requirements 2a through 2c assuming that Citation recognizes revenue over time according to percentage of completion for its office building contracts. Assume the same information for 2016 and 2017, but that as of year-end 2017 the estimated cost to complete the office building is $9,000,000. Citation recognizes revenue over time according to percentage of completion for its office building contracts. How much revenue related to this contract will Citation report in the 2017 income statement? What is the amount of gross profit or loss to be recognized for the Altamont contract during 2017? What will Citation report in its 2017 balance sheet related to this contract? (Ignore cash.) When should Citation recognize revenue for the sale of its single-family homes? What will Citation report in its 2016 income statement and 2016 balance sheet related to the single-family home business (ignore cash in the balance sheet)
