Following are the October 2021 transactions for Computer Solutions. The company extends credit terms of n/30, FOB shipping point, to all customers who purchase merchandise. Computer Solutions uses a perpetual inventory system and uses the gross method to record purchases and sales on account. Inventory is maintained using FIFO for general ledger purposes.

1 Oct. 1 Purchased office building for $473,000, which included land, building, and office equipment. Financed with a 30 year loan from the bank with an interest rate of 3% (ordinary annuity). The first payment is due November 1. Appraisal of the property came in at $525,000 with the land appraised at $200,000; building, $275,000; and furniture and fixtures, $50,000. (A/C 250 Mortgage Payable)

2 1 Received partial payment of 6,000 from KC, Inc.

3 2 The company paid for merchandise purchased from Kansas Corp. on Sept 10 with a cost of $10,760 and terms of 1/10, n/30, FOB shipping point, invoice dated September 10.

4 4 The company paid $6,540 cash for one year's premium on a property and liability insurance policy. The company initially records insurance as a prepaid expense.

5 5 The company sold merchandise with a retail value of $6,600 and a cost of $4,950 to Liu Corp., invoice dated October 5.

6 7 The company completed a project for Delta, Co. and billed them $4,200.

7 7 The company purchased $875 of computer supplies on credit from Harris Office Products. (Set Harris Office Products up as vendor.)

8 9 The company received $5,220 cash from IFM Co. as full payment on its account.

9 9 The company billed Wildcat Services $6,100 for services performed in installing a new Web server.

10 10 The company purchased $5,200 of merchandise from Kansas Corp. with terms of 1/10, n/30, FOB shipping point, invoice dated October 10.

11 11 The company completed a five-day project for Alex's Engineering Co. and billed it $6,000

12 13 The company sold merchandise with a retail value of $2,500 and a cost of $1,120 to Gomez Co, invoice dated October 13.

13 15 The company paid salaries and wages for Oct. 1 - 15: Lyn Addie for 11 days' work at the rate of $150 per day. Ramona Santana receives a monthly salary of $5,700 and gets paid twice a month.

14 15 The company paid $300 cash for freight charges on the merchandise purchased on Oct 10.

15 16 The company received $4,200 cash from Delta Co. for computer services provided.

16 17 The company paid Kansas Corp. for the invoice dated October 10, net of the discount.

17 20 Liu Corp. returned $400 of defective merchandise from its invoice dated October 5. The returned merchandise had a $190 cost and was discarded. (The policy of Computer Solutions is to leave the cost of defective products in cost of goods sold.)

18 22 The company received the balance due from Liu Corp., net of the credit for the returned merchandise.

19 24 The company returned defective merchandise to Kansas Corp. and accepted a credit against future purchases. The defective merchandise invoice cost, net of the discount, was $694.

20 26 The company purchased $7,800 of merchandise from Kansas Corp. with terms of 1/10, n/30, FOB destination, invoice dated October 26.

21 26 The company sold merchandise with a $3,750 cost for $6,700 on credit to Gomez Co, Inc., invoice dated January 26.

22 29 The company recorded cash sales of $3,706. The merchandise cost Computer Solutions $2,436.

23 29 Gomez Co. paid balance due of $9,200

24 29 The company paid salaries and wages to Lyn Addie and Ramona Santana. Lyn Addie worked 10 days' work at $150 per day, and Ramona's semi-monthly pay is $2,850.

On October 1 Computer Solutions purchased an office building for $473,000, which included land, building, and office equipment. The purchase was financed with a 30 year loan from the bank with an interest rate of 3% (ordinary annuity). The first payment is due November 1. Appraisal of the property came in at $525,000 with land appraised at $200,000; building, $275,000, and office equipment, $50,000.

At what amount should land be capitalized (round to nearest dollar)? $180,190

At what amount should the building be capitalized (round to nearest dollar)? $247,762

At what amount should the office equipment be capitalized (round to nearest dollar)? $45,048

What is the amount of the loan payment (rounded to the nearest dollar)? $1,994

Required: Using Excel, create amortization of the loan to determine the payment amount along with the allocation of the payments between principal and interest. Add a sheet to this file to calculate the allocation of the purchase price between land, building, and

office equipment.