Based on Problem 10-6 Indigo Landscaping began construction of a new plant on December 1, 2020....

Based on Problem 10-6

Indigo Landscaping began construction of a new plant on December 1, 2020. On this date, the company purchased a parcel of land for $147,600 in cash. In addition, it paid $3,120 in surveying costs and $4,080 for a title insurance policy. An old dwelling on the premises was demolished at a cost of $3,120, with $960 being received from the sale of materials.

Architectural plans were also formalized on December 1, 2020, when the architect was paid $34,800. The necessary building permits costing $3,120 were obtained from the city and paid for on December 1 as well. The excavation work began during the first week in December with payments made to the contractor in 2021 as follows.

Date of Payment		Amount of Payment
March 1		$248,400
May 1		340,800
July 1		61,200

Compute the balance in each of the following accounts at December 31, 2020, and December 31, 2021.

To finance construction of this plant, Indigo borrowed $602,400 from the bank on December 1, 2020. Indigo had no other borrowings. The $602,400 was a 10-year loan bearing interest at 9%.

The building was completed on July 1, 2021.

Using Excel calculate the following (show your work and use formulas where appropriate):

Balance in the Land account for December 31, 2020 and December 31, 2021
The weighted average of accumulated expenditures for 2020
The amount of interest capitalized in 2020
The weighted average of accumulated expenditures for 2021
The amount of interest capitalized in 2021
Balance in the Building account for December 31, 2020 and December 31, 2021
Balance in the Interest Expense account for December 31, 2020 and December 31, 2021

Expert Solution

ekkarill92 answered 2 years ago

Sage Landscaping began construction of a new plant on December 1, 2020. On this date, the...

Sage Landscaping began construction of a new plant on December 1, 2020. On this date, the company purchased a parcel of land for $138,000 in cash. In addition, it paid $2,160 in surveying costs and $4,560 for a title insurance policy. An old dwelling on the premises was demolished at a cost of $3,360, with $960 being received from the sale of materials. Architectural plans were also formalized on December 1, 2020, when the architect was paid $32,400. The necessary...

Crane Landscaping began construction of a new plant on December 1, 2020. On this date, the...

Crane Landscaping began construction of a new plant on December 1, 2020. On this date, the company purchased a parcel of land for $145,200 in cash. In addition, it paid $2,400 in surveying costs and $3,840 for a title insurance policy. An old dwelling on the premises was demolished at a cost of $3,360, with $720 being received from the sale of materials. Architectural plans were also formalized on December 1, 2020, when the architect was paid $31,200. The necessary...

Grouper Landscaping began construction of a new plant on December 1, 2020. On this date, the...

Grouper Landscaping began construction of a new plant on December 1, 2020. On this date, the company purchased a parcel of land for $146,400 in cash. In addition, it paid $2,880 in surveying costs and $4,560 for a title insurance policy. An old dwelling on the premises was demolished at a cost of $3,360, with $960 being received from the sale of materials. Architectural plans were also formalized on December 1, 2020, when the architect was paid $36,000. The necessary...

Pronghorn Landscaping Corp. began constructing a new plant on December 1, 2017. On this date, the...

Pronghorn Landscaping Corp. began constructing a new plant on December 1, 2017. On this date, the company purchased a parcel of land for $183,780 cash. In addition, it paid $1,780 in surveying costs and $3,570 for title transfer fees. An old dwelling on the premises was immediately demolished at a cost of $2,750, with $990 being received from the sale of materials. Architectural plans were also formalized on December 1, 2017, when the architect was paid $29,960. The necessary building...

On June 1, 2020, the Crocus Company began construction of a new manufacturing plant. The plant...

On June 1, 2020, the Crocus Company began construction of a new manufacturing plant. The plant was completed on October 31, 2021. Expenditures on the project were as follows ($ in millions): July 1, 2020 54 October 1, 2020 22 February 1, 2021 30 April 1, 2021 21 September 1, 2021 20 October 1, 2021 6 On July 1, 2020, Crocus obtained a $70 million construction loan with a 6% interest rate. The loan was outstanding through the end of...

Question 11 In early February 2020, Indigo Corp. began construction of an addition to its head...

Question 11 In early February 2020, Indigo Corp. began construction of an addition to its head office building that is expected to take 18 months to complete. The following 2020 expenditures relate to the addition: Feb. 1 Payment #1 to contractor $105,000 Mar. 1 Payment to architect 24,000 July 1 Payment #2 to contractor 63,000 Dec. 1 Payment #3 to contractor 186,000 Dec. 31 Asset carrying amount $378,000 On February 1, Indigo issued a $105,000, three-year note payable at a...

On January 2, 2020, Crane Company began construction of a new citrus processing plant. The automated...

On January 2, 2020, Crane Company began construction of a new citrus processing plant. The automated plant was finished and ready for use on September 30, 2021. Expenditures for the construction were as follows: January 2, 2020 $ 604000 September 1, 2020 1809600 December 31, 2020 1809600 March 31, 2021 1809600 September 30, 2021 1196000 Crane Company borrowed $3240000 on a construction loan at 12% interest on January 2, 2020. This loan was outstanding during the construction period. The company...

On January 1, 2015, the Crocus Company began construction of a new manufacturing plant. The plant...

On January 1, 2015, the Crocus Company began construction of a new manufacturing plant. The plant was completed on December 31, 2016. Expenditures on the project were as follows (in $ millions): January 1, 2015 $1 July 1, 2015 54 October 1, 2015 22 February 1, 2016 30 April 1, 2016 21 September 1, 2016 20 December 31, 2016 6 On January 1, 2015, Crocus obtained a $60 million construction loan with a 6% interest rate. The loan was outstanding...

a) On January 1, Blair began construction of a new plant. On this date, the company...

a) On January 1, Blair began construction of a new plant. On this date, the company purchased a parcel of land for $200,000 in cash. In addition, it paid $3,000 in surveying costs and $1,000 for the title insurance policy. An old dwelling on the premises was demolished at a cost of $5,000, with $2,000 being received from the sale of materials. Architectural plans were also formalized on January 1, when the architect was paid $40,000. The necessary building permits...

On April 1, 2020, Dalinar Company began construction on a new distribution warehouse. Construction was completed...

On April 1, 2020, Dalinar Company began construction on a new distribution warehouse. Construction was completed on December 31, 2020, at which time the building was placed in service. Dalinar made an initial payment toward construction on April 1, 2020 of $240,000 and made additional payments $30,000 every two months thereafter, beginning on June 1 and continuing through December 1. A final payment of $100,000 was made on December 31 at the completion of construction. Dalinar borrowed $150,000 at 4%...

Question