Intermediate Accounting 3
1 Excel Spreadsheet
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.!"
Project | Total Contract Price | Billings Through 12/31/12 | Cash Collections Through 12/31/12 | Contract Costs Incurred Through 12/31/12 | Estimated Additional Costs to Complete |
A | $200,000 | $100,000 | $80,000 | $120,000 | $90,000 |
B | 250,000 | 50,000 | 45,000 | 40,000 | 180,000 |
C | 180,000 | 180,000 | 150,000 | 120,000 | 0 |
D | 100,000 | 10,000 | 5,000 | 80,000 | 20,000 |
E | 140,000 | 120,000 | 110,000 | 100,000 | 10,000 |
870,000 | 460,000 | 390,000 | 460,000 | 300,000 |
- Prepare a schedule of gross profit (loss) to be reported.
- Prepare the entries for projects A and B only.
12 years ago
5
Purchase the answer to view it

- journal_entries_for_project_a_b.docx
- math
- Discuss price comparison and trend comparison
- pick 3 contaminats in the tap water in pocatello and devise a procedure to test for them. typed double spaced times...
- Management: Project Recommendations – Coca Cola Company
- Foundations of Accounting I Accounting Project Written by: Karen Pitsch Davidâs Entertainment is a merchandising business. Their account balances as of November 30,...
- calculus 3 help needed
- Psychology of Health in the Workplace
- OPS 571 Week 5 Quiz (February 2014 Updated)
- 3
- GB540 Unit 2