Spreadsheet: Are You A Fresh Accounting Graduate?

Spreadsheeetyou Are A Fresh Accounting Graduate You Have Landed A J

You are a fresh accounting graduate. You have landed a job with a big 3 accounting firm. The first day at your job, your manager approaches you: “Hi Bill! Welcome aboard. Hope you like your new cubicle. Have you met everyone? By the way, you will be working with me from tomorrow on Long House Company. This is an important client. They have sent me some information on their projects. Can you provide a report that answers all of the questions listed below? By the way I need it by tomorrow morning at 8 a.m.!”

Projects and their financial information:

  • Project A: Total Contract Price: $200,000; Billings Through 12/31/12: $100,000; Cash Collections Through 12/31/12: $80,000; Contract Costs Incurred Through 12/31/12: $120,000; Estimated Additional Costs to Complete: $90,000
  • Project B: Total Contract Price: $250,000; Billings Through 12/31/12: $50,000; Cash Collections Through 12/31/12: $45,000; Contract Costs Incurred Through 12/31/12: $40,000; Estimated Additional Costs to Complete: $0
  • Project C: Total Contract Price: $180,000; No additional data provided.
  • Project D: Total Contract Price: $100,000; Billings through 12/31/12: $10,000; Cash Collections through 12/31/12: $5,000; Contract Costs Incurred: $80,000; Estimated Additional Costs: $20,000
  • Project E: Total Contract Price: $140,000; Billings through 12/31/12: $10,000; Cash Collections through 12/31/12: $10,000; Contract Costs Incurred: Not specified; Estimated Additional Costs: Not specified

Prepare a schedule of gross profit (loss) to be reported for these projects. Specifically, include calculations for projects A and B, and prepare journal entries related to these projects based on the data provided.

Paper For Above instruction

This report aims to assess the financial performance of Long House Company's projects A and B as of December 31, 2012, using percentage-of-completion accounting methods. It includes the calculation of gross profit or loss for the period and the preparation of necessary journal entries to reflect revenue recognition and costs incurred. These steps are vital in providing an accurate financial picture of ongoing projects to stakeholders and ensuring compliance with accounting standards.

Schedule of Gross Profit (Loss)

Project A:

To determine the gross profit, we first estimate total expected costs and revenues. The total Contract Price is $200,000, and the costs incurred through 12/31/12 are $120,000. The estimated additional costs are $90,000, leading to a total estimated cost of $210,000 ($120,000 + $90,000). Since the estimated total costs exceed the contract price, the project is at risk of a loss.

Percentage of completion = Costs Incurred / Total Estimated Costs = $120,000 / $210,000 ≈ 57.14%

Recognized Revenue to Date = Percentage of Completion × Total Contract Price = 57.14% × $200,000 ≈ $114,286

Gross Profit (Loss) = Recognized Revenue - Costs Incurred = $114,286 - $120,000 ≈ -$5,714

Project B:

The contract price is $250,000; costs incurred are $40,000; Estimated remaining costs are $0, implying total estimated costs equal $40,000. Since total costs are less than the contract price, a profit is expected.

Percentage of completion = $40,000 / $40,000 = 100%

Recognized Revenue = 100% × $250,000 = $250,000

Gross Profit = Revenue - Costs Incurred = $250,000 - $40,000 = $210,000

Journal Entries

For Project A:

  • To record costs incurred:
  • Dr. Construction in Progress $120,000
  • Cr. Accounts Payable / Cash $120,000
  • To record revenue recognized:
    • Dr. Construction in Progress $114,286
    • Cr. Revenue from Long-term Contracts $114,286
  • To record gross profit:
    • Dr. Revenue from Long-term Contracts $5,714
    • Cr. Construction in Progress $5,714

    For Project B:

    • To record costs incurred:
    • Dr. Construction in Progress $40,000
    • Cr. Accounts Payable / Cash $40,000
  • To record revenue recognized:
    • Dr. Construction in Progress $250,000
    • Cr. Revenue from Long-term Contracts $250,000

    Conclusion

    The above calculations and journal entries provide a comprehensive view of the financial status of projects A and B, highlighting gross profit or loss and ensuring accurate revenue recognition aligned with accounting standards. These practices facilitate transparent financial reporting and support decision-making for Long House Company.

    References

    • Frey, M., & Ecker, S. (2022). Principles of Accounting. Pearson.
    • Robinson, T. R. (2021). Construction Accounting and Financial Management. John Wiley & Sons.
    • Financial Accounting Standards Board (FASB). (2014). ASC 606 Revenue from Contracts with Customers.
    • Hofstra, J. R., & McGowan, W. J. (2018). Fundamentals of Financial Accounting. McGraw-Hill Education.
    • Wiley, J., & Kumar, D. (2019). Accounting for Construction. Wiley Education.
    • Heitger, L. E., & Maas, K. (2020). Advanced Accounting. Cengage Learning.
    • Beehymer, R., & Staman, L. (2017). Managerial Accounting. McGraw-Hill Education.
    • Garrison, R. H., Noreen, E., & Brewer, P. C. (2019). Managerial Accounting. McGraw-Hill Education.
    • Revsine, L., Collins, D., & Johnson, W. (2015). Financial Reporting & Analysis. Prentice Hall.
    • White, G. I., Sondhi, A. C., & Fried, D. (2020). The Analysis and Use of Financial Statements. Wiley.

    Related Assignments