please show work in Excel and formulas

Novak Landscaping began construction of a new plant on December 1,2022. 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 bite insurence policy. An old dwelling wo the premises wos demolivhed at a cost of $3,360, with $960 being recerved from the sale of materials. Architectural plans were also formalized on December 1, 2022, when the arthitect was paid $36,000. The necessary building permits costing $3,360 were obtained from the cty and paid for on December 1 as well, The excovation work began during the first week in December with payments made to the contractor in 2023 as follows. The building was cornpleted on Xuly 1, 2023. To finance construction of this plant, Novak borrowed $603,400 from the bank on December 1, 2022, Novak had no other borrowings. The $608,400 was a 10 -rear loan bearing interest at s\%. Using Excel calculate the followng (show your work and use formulas where appropriate): 1. Balance in the Land account for December 31, 2022 and December 31, 2023 2. The weighted average of accumulated expenditures for 2022 3. The amount of interest capitalized in 2022 4. The weighted average of accumulated expenditures for 2023 5. The amount of interest capitalized in 2023 6. Balance in the Building account for December 31, 2022 and December 31, 2023 7 Balance in the Interest Expense account for Deceinber 31,2022 and December 31,2023 Novak Landscaping began construction of a new plant on December 1,2022. 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 bite insurence policy. An old dwelling wo the premises wos demolivhed at a cost of $3,360, with $960 being recerved from the sale of materials. Architectural plans were also formalized on December 1, 2022, when the arthitect was paid $36,000. The necessary building permits costing $3,360 were obtained from the cty and paid for on December 1 as well, The excovation work began during the first week in December with payments made to the contractor in 2023 as follows. The building was cornpleted on Xuly 1, 2023. To finance construction of this plant, Novak borrowed $603,400 from the bank on December 1, 2022, Novak had no other borrowings. The $608,400 was a 10 -rear loan bearing interest at s\%. Using Excel calculate the followng (show your work and use formulas where appropriate): 1. Balance in the Land account for December 31, 2022 and December 31, 2023 2. The weighted average of accumulated expenditures for 2022 3. The amount of interest capitalized in 2022 4. The weighted average of accumulated expenditures for 2023 5. The amount of interest capitalized in 2023 6. Balance in the Building account for December 31, 2022 and December 31, 2023 7 Balance in the Interest Expense account for Deceinber 31,2022 and December 31,2023