Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 1 - LT Contracts -- Contract with Overall Loss In 2021, the Westgate Construction Company entered into a contract to construct a road for
Problem 1 - LT Contracts -- Contract with Overall Loss 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 2910,000 4,400,000 2,840,000 Estimated costs to complete as of year end 5.630,000 2,784,000 Billings during the year 2,700,000 3,380,000 3920,000 Cash collections during the year 2,400,000 3,000,000 4,600,000 Westgate recognizes revenue over time according to percentage of completion. Required Prepare an Excel Workbook with sheets for each of the following: Calculations of the amount of revenue and gross profit (loss) to be recognized in each of the three years. Do not round intermediate calculations. Round final numbers to whole dollars. Loss amounts should be indicated in parenthesis. Make sure your spreadsheet set up clearly demonstrates the numbers used in calculations Prepare the journal entries necessary for each year (credit "Various accounts for the construction costs incurred. Link the journal entry amounts to the spreadsheet of calculations Prepare T-accounts to post the journal entries Link the journal entries to the T-accounts and show balances for each year Show income statement and balance sheet presentation for the related accounts. Link the amounts in the spreadsheet to the income statement and balance sheets
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started