Question

In: Accounting

Revenue Recognition - Percentage of Completion - Project Instructions, Spring 2018 One of your clients is...

Revenue Recognition - Percentage of Completion - Project Instructions, Spring 2018

One of your clients is a large regional construction company. The company has many long-term projects in the works. The spreadsheet you are given contains some information about these jobs. Some of the jobs began last year and continue into the current year, so they exist on both tabs. The projects are in various phases of construction; some of which were completed during the current year.

You've been asked by your firm to analyze the data and prepare the following:

1) Complete the revenue recognition process by adding the necessary calculations into the blank columns F-J and L-M on the Current Year and Prior Year tabs and populate the data for all rows. It is expected that you look back at the text for definitions and to remind yourself of the percentage of completion method prior to asking questions.

Current year:

Job	Description	Final Est Contract Amount	Costs To Date	Total Est Cost @ Completion	Est to Complete	Est GP @ Completion	Cur % Comp	GP TO DATE	Earned Rev To Date	Billings To Date	Costs and profit in Excess of Billings	Billings in Excess of Costs and Profits	Phase	Revenue to Book
1959	MISC	7,465,878	7,247,171	7,247,523						7,465,878
1960	MISC	7,959,254	7,666,799	7,706,890						7,959,254
1968	MISC	46,201,877	44,283,436	45,810,921						44,435,743
1029	MISC	6,770,156	7,187,389	7,169,543						6,693,717
1972	MISC	13,157,854	9,938,521	12,926,801						10,169,759
1974	MISC	16,811,634	16,636,718	16,614,718						16,811,634
1978	MISC	3,240,516	3,180,526	3,180,526						3,290,995
1980	MISC	7,098,168	6,696,897	6,825,642						6,989,363
1981	MISC	22,464,145	22,067,900	22,067,900						22,462,520
1982	MISC	26,910,817	26,266,450	26,384,521						26,910,817
1987	MISC	21,527,597	20,758,005	20,758,244						21,527,597
1037	MISC	67,479	65,707	62,708						67,480
1038	MISC	966,844	949,107	938,107						966,845
1040	MISC	166,942	143,084	143,084						166,942
1041	MISC	700,689	598,903	598,804						700,689
1042	MISC	346,721	251,917	292,629						346,721
1043	MISC	1,079,159	1,079,159	1,079,159						1,079,190
1044	MISC	510,939	393,910	411,390						503,188
1991	MISC	21,145,050	21,511,616	21,511,616						21,045,050
1992	MISC	3,564,527	3,519,267	3,519,270						3,572,179
1994	MISC	7,789,575	7,516,192	7,552,450						7,789,575
1995	MISC	13,320,841	12,531,906	12,784,219						13,006,125
1996	MISC	13,535,310	12,331,088	13,178,122						13,029,481
1997	MISC	2,729,944	2,657,501	2,661,842						2,729,944
1998	MISC	7,341,782	5,274,107	7,161,359						5,440,960
1999	MISC	13,327,661	12,510,677	13,078,905						12,745,737
2000	MISC	3,479,901	3,391,393	3,392,850						3,479,901
2001	MISC	8,880,861	4,967,713	8,671,818						4,897,156
2002	MISC	5,407,348	5,097,975	5,232,080						5,278,519
2003	MISC	6,057,682	4,689,023	5,835,790						5,088,472
2004	MISC	3,388,921	3,327,035	3,371,364						3,388,921
2005.01	MISC	1,541,229	651,078	1,488,653						677,958
2005.02	MISC	1,382,138	494,118	1,382,138						494,118
2005.03	MISC	109,951	109,951	109,951						109,727
2006	MISC	6,243,535	4,063,446	6,138,535						4,160,662
2007	MISC	12,234,190	9,906,338	11,918,995						10,139,456
1045	MISC	1,273,869	473,014	1,178,757						558,982
1047	MISC	2,000,000	1,532,818	1,934,051						1,498,479
1048	MISC	289,132	280,188	277,088						289,132
1050	MISC	337,399	330,095	337,399						287,285
1051	MISC	103,714	91,533	93,701						95,000
1052	MISC	1,627,500	898,738	1,532,500						867,785
1053	MISC	587,936	119,971	534,936						59,133
1054	MISC	272,187	93,423	232,095						139,406
1055	MISC	1,368	1,189	1,189						-
1056	MISC	6,500	3,241	5,800						6,500
1057	MISC	160,254	3,979	151,254						53,418
2008	MISC	12,027,982	11,540,290	11,792,749						11,624,921
2010	MISC	3,564,023	3,442,746	3,482,704						3,510,318
2011	MISC	3,571,024	3,172,365	3,471,558						3,263,051
2012	MISC	8,863,236	3,382,784	8,483,236						3,484,037
2013	MISC	17,562,203	3,043,921	17,237,203						3,175,529
2014	MISC	3,469,196	1,713,032	3,379,313						2,240,054
2015	MISC	6,270,919	1,759,495	6,111,394						2,468,135
2017	MISC	906,972	870,069	870,070						907,612
2018	MISC	16,981,831	20,841	16,646,831						123,250
2019	MISC	12,514,813	734,163	12,188,248						825,637
2020	MISC	12,215,549	35,797	11,860,853						-
2021	MISC	5,475,364	82,553	5,575,364						226,051
2022	MISC	14,031,862	90,859	13,669,617						-
2023	MISC	-	831	-						-
2024	MISC	-	-	-						-
2025	MISC	5,399,500	-	5,243,500						-
2026	MISC	1,030,000	8,317	1,000,000						-
2027	MISC	5,700,000	-	5,586,000						-
1941	MISC	11,700,949	11,306,077	11,306,077						11,700,949
1951	MISC	430,558	429,853	429,853						430,558
1958	MISC	5,113,424	5,012,706	5,012,706						5,113,424
1966	MISC	2,746,125	2,749,328	2,749,328						2,746,125
1027	MISC	297,482	290,349	290,349						297,482
1028	MISC	1,462,324	1,478,580	1,478,580						1,462,324
1030	MISC	819,108	709,272	709,272						819,108
1971	MISC	5,439,533	5,205,826	5,205,826						5,439,533
1973	MISC	6,997,612	7,190,985	7,190,985						6,997,612
1975	MISC	3,541,081	3,412,625	3,412,625						3,541,081
1977	MISC	2,111,870	2,060,093	2,060,093						2,111,870
1979	MISC	3,883,384	4,095,004	4,095,004						3,883,384
1983	MISC	8,416,157	8,228,116	8,228,116						8,416,157
1984	MISC	10,454,724	10,201,631	10,201,631						10,454,724
1986	MISC	7,120,629	6,862,156	6,862,156						7,120,629
1988	MISC	244,433	190,944	190,944						244,433
1989	MISC	6,573,752	6,410,702	6,410,702						6,573,752
1031	MISC	356,254	331,883	331,883						356,254
1032	MISC	1,262,853	1,261,237	1,261,237						1,262,853
1033	MISC	2,184,271	1,668,446	1,668,446						2,184,271
1034	MISC	276,190	276,190	276,190						276,190
1035	MISC	221,826	206,835	206,835						221,826
1036	MISC	112,637	112,629	112,629						112,637
1039	MISC	73,237	56,173	56,173						73,237
1990	MISC	4,753,810	4,682,621	4,682,621						4,753,810
1993	MISC	2,419,387	2,381,836	2,381,836						2,419,387
1046	MISC	167,393	156,353	156,353						167,393
1049	MISC	204,076	177,714	177,714						204,076
		540,556,527	410,834,439	529,232,641	-	-	-	-	-	420,711,067	-	-

Prior Yr:

Job	Description	Final Est Contract Amount	Costs To Date	Total Est Cost @ Completion	Est to Complete	Est GP @ Completion	Cur % Comp	GP TO DATE	Earned Rev To Date	Billings To Date	Costs and profit in Excess of Billings	Billings in Excess of Costs and Profits
1977	MISC	2,090,204	2,058,488	2,060,000						2,090,204
1966	MISC	2,740,196	2,747,956	2,750,000						2,740,196
1951	MISC	429,853	429,853	429,853						430,558
1988	MISC	238,471	190,944	190,944						236,471
1027	MISC	297,482	290,349	290,349						277,482
1028	MISC	1,459,971	1,468,711	1,468,711						1,449,843
1030	MISC	819,108	707,310	707,310						805,483
1979	MISC	3,883,384	4,094,330	4,095,000						3,883,384
1036	MISC	112,637	112,618	112,637						112,637
1973	MISC	6,997,612	7,189,463	7,190,800						6,997,612
1974	MISC	16,396,834	16,098,923	16,107,664						15,945,665
1958	MISC	5,113,424	5,008,868	5,012,893						5,111,033
1984	MISC	10,458,619	10,191,522	10,204,882						10,453,214
1975	MISC	3,541,081	3,410,943	3,415,946						3,544,656
1941	MISC	11,700,949	11,277,526	11,305,949						11,700,949
1971	MISC	5,439,533	5,205,826	5,223,433						5,439,533
1960	MISC	7,959,254	7,633,497	7,706,890						7,959,254
1983	MISC	8,363,611	8,084,939	8,164,134						8,286,417
1978	MISC	3,240,516	3,146,456	3,180,516						3,185,418
1993	MISC	2,419,988	2,357,037	2,384,988						2,419,387
1035	MISC	220,950	205,377	208,000						217,330
1034	MISC	278,849	274,429	278,849						253,479
1980	MISC	7,098,168	6,710,276	6,825,642						6,945,454
1990	MISC	4,711,151	4,598,024	4,678,950						4,626,775
1989	MISC	6,661,286	6,383,190	6,497,850						6,556,992
1986	MISC	7,162,422	6,712,121	6,920,598						6,884,933
1037	MISC	68,879	56,897	61,400						67,480
1031	MISC	378,974	330,684	360,200						356,254
1981	MISC	22,282,269	20,016,392	22,051,402						20,470,769
1992	MISC	3,461,496	2,945,587	3,404,937						2,955,664
1991	MISC	20,138,168	16,559,725	19,452,425						17,234,825
1033	MISC	2,104,258	1,417,904	1,710,084						1,754,574
1029	MISC	6,674,301	5,588,592	6,912,342						5,447,628
1994	MISC	6,194,488	4,644,358	6,008,863						4,857,414
1032	MISC	1,327,931	1,025,867	1,327,931						987,505
1959	MISC	7,510,509	5,122,011	7,291,759						5,241,333
1987	MISC	21,977,597	14,703,934	21,524,620						15,315,793
1997	MISC	2,601,318	1,489,455	2,543,216						1,709,841
1039	MISC	72,622	36,578	62,622						47,226
1972	MISC	9,300,000	4,670,647	9,097,073						5,175,762
1982	MISC	28,064,434	13,169,455	27,648,138						14,477,824
1968	MISC	44,263,879	16,221,792	43,722,923						16,494,611
1996	MISC	8,000,000	2,586,688	7,825,000						2,743,271
1041	MISC	701,835	54,041	633,948						112,435
1038	MISC	835,000	63,697	755,000						75,493
1040	MISC	166,121	11,069	143,721						35,000
2000	MISC	3,460,051	248,325	3,375,675						206,325
1999	MISC	11,950,980	547,127	11,651,589						586,828
1995	MISC	13,371,080	368,910	12,831,080						383,667
2002	MISC	3,500,000	66,826	3,411,000						62,565
2003	MISC	4,624,038	54,191	4,461,051						0
2001	MISC	8,437,049	30,923	8,235,633						289,215
1043	MISC	628,920	1,801	628,920						1,801
2006	MISC	6,000,000	1,739	5,820,000						0
2004	MISC	3,440,871	828	3,330,871						0
1998	MISC	5,500,000	875	5,375,000						0
2007	MISC	12,100,481	0	11,789,465						0
2005	MISC	0	0	0						0
1042	MISC	302,473	0	268,381						0
1044	MISC	0	0	0						0
1925	MISC	12,598,919	11,943,651	11,943,651						12,598,919
1932.01	MISC	38,775,649	37,277,096	37,277,096						38,775,649
1932.02	MISC	15,209,443	14,612,438	14,612,438						15,209,443
1933	MISC	17,332,336	16,836,298	16,836,298						17,332,336
1940	MISC	2,908,333	2,577,844	2,577,844						2,908,333
1023	MISC	110,178	110,174	110,174						110,178
1944	MISC	6,010,630	5,769,964	5,769,964						6,010,630
1945	MISC	2,982,172	2,872,203	2,872,203						2,982,172
1949	MISC	3,552,127	3,314,044	3,314,044						3,552,127
1954	MISC	3,011,044	2,906,830	2,906,830						3,011,044
1961	MISC	4,403,166	4,250,089	4,250,089						4,403,166
1965	MISC	3,649,431	3,600,724	3,600,724						3,649,431
1967	MISC	3,256,442	3,158,722	3,158,722						3,256,442
1970	MISC	771,601	688,644	688,644						771,601
1026	MISC	185,392	156,420	156,420						185,392
1976	MISC	7,990,442	7,796,645	7,796,645						7,990,442
1985	MISC	4,962,349	4,826,861	4,826,861						4,962,349
		506,985,229	351,324,541	493,827,704	0	0		0	0	363,355,116	0	0

Expert Solution

Under percentage of completion method total estimated revenue and total estimated costs of a project are considered.

Where the cost incurred till the last date of the accounting period is compared with the total estimated cost and a percentage is arrived at.

The arrived percentage of the estimated revenue is to be accrued as revenue for the said accounting period.

In the next period, where the project has further executed, the new percentage of completion is arrived with the total cost incurred till date for the project and the total cost estimated of the project.

The percentage is applied to get the proportionate revenue to be recognised.

The revenue so recognized after reducing the revenue recognized in previous period is considered to be the revenue to be accrued for the current period.

Based on the above principle, the excel sheet with the formulae displayed on the top are the workings for the projects revenue to be recognized.

ekkarill92 answered 11 months ago

1. Explain Revenue Recognition methods (percentage of completion, completed production, traditional, installment) 2. Explain Expense Recognition...

1. Explain Revenue Recognition methods (percentage of completion, completed production, traditional, installment) 2. Explain Expense Recognition methods (cause & effect, rational & systematic, immediate recognition) 3. Describe Fair value hierarchy: Level 1 - observable (quoted prices), Level 2 (prices of similar items observable), Level 3 (non-observable – must base value on assumptions) 4. Identify the four basic assumptions of accounting: Economic entity, monetary unit, periodicity, and going concern 5. Recognize the two fundamental qualitative characteristics of financial reporting: Relevance and...

Bob Ross Ltd builds large ships and uses the percentage of completion method of revenue recognition....

Bob Ross Ltd builds large ships and uses the percentage of completion method of revenue recognition. The following information pertains to the construction contracts it had in place as of its December 31, 2012 year-end. 2011 2012 Cost incurred to date 200 million 400 million Costs to complete contracts 600 million 600 million Total price of contracts outstanding at December 31, 2012 1,300 million 1,300 million 4a1) How much revenue will Bob's Construction recognize in 2011? 4a2) How much G.P....

In Enron's bankruptcy, "Revenue Recognition" was one of the major issues. First, summarize the revenue recognition...

In Enron's bankruptcy, "Revenue Recognition" was one of the major issues. First, summarize the revenue recognition issue in Enron Bankruptcy. Second, as an auditor, what type of evidence would you want to examine to determine whether Enron was inappropriately recording revenue from the Sithe Energies contract?

Exercise 5-20 Long-term contract; revenue recognition upon project completion; loss projected on entire project [LO5-8, 5-9]...

Exercise 5-20 Long-term contract; revenue recognition upon project completion; loss projected on entire project [LO5-8, 5-9] On February 1, 2018, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,025,000. During 2018, costs of $2,010,000 were incurred, with estimated costs of $4,010,000 yet to be incurred. Billings of $2,512,000 were sent, and cash collected was $2,260,000. In 2019, costs incurred were $2,512,000 with remaining costs estimated to be $3,615,000. 2019 billings were...

Under which two situations can a firm utilize the percentage completion method to recognize revenue as...

Under which two situations can a firm utilize the percentage completion method to recognize revenue as the asset for sale is being constructed?

Assume you are a CPA and during a review of your clients' tax papers for completion...

Assume you are a CPA and during a review of your clients' tax papers for completion of the client’s tax return, you discover certain deposits to your client’s accounts that you suspect may be additional income which your client did not advise you about. When you ask the client about the deposits they say “let’s just make that our secret.” What are your ethical obligations in this situation and what authority did you use to determine your obligation?

Horner Construction Co. uses the percentage-of-completion method. In 2018, Horner began work on a contract for...

Horner Construction Co. uses the percentage-of-completion method. In 2018, Horner began work on a contract for $22,000,000; it was completed in 2019. The following cost data pertain to this contract for the year-ended 2018... Cost incurred during the year: $7,800,000... Estimated costs to complete: $5,200,000. The following cost data pertain to this contract for the year-ended 2019... Cost incurred during the year: $5,600,000... Estimated costs to complete: n/a. If the completed-contract method of accounting was used, the amount of gross...

PERCENTAGE OF COMPLETION METHOD AttiK Construction Company currently has a long-term construction project. The project has...

PERCENTAGE OF COMPLETION METHOD AttiK Construction Company currently has a long-term construction project. The project has a contract price of $130,000,000 with total estimated costs of $100,000,000. AttiK appropriately uses the percentage of completion method. After 2 years of construction, the following costs have been accumulated: Actual cost incurred, Year 1 $30,000,000 Total estimated costs remaining after Year 1 70,000,000 Actual cost incurred, Year 2 50,000,000 Total estimated cost remaining after Year 2 20,000,000 Determine the gross profit for each...

FIN 390 Assignment – Spring 2018 Capital Budgeting Mini Case Instructions: The assignment is based on...

FIN 390 Assignment – Spring 2018 Capital Budgeting Mini Case Instructions: The assignment is based on the mini case below. The instructions relating to the assignment are at the end of the case. Samantha Groves and Harry Finch are facing an important decision. After having discussed different financial scenarios into the wee hours of the morning, the two computer engineers felt it was time to finalize their cash flow projections and move to the next stage – decide which of...

ACC 3010 Project 2 Spring Summer 2018 This project will be submitted in 3 parts. The...

ACC 3010 Project 2 Spring Summer 2018 This project will be submitted in 3 parts. The submission dates and Required parts to be completed for each submission are: Submission 1 - due Saturday June 16 before 5pm - You must submit your completed March Journal entries, your completed Inventory Cards for all 3 Inventory costing methods, and the Worksheet complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 2 part 1....