Prepare updated ppe roll forward for garfailed university

Assignment Help Financial Accounting
Reference no: EM132642404

You are the new accounting assistant assigned to the fixed assets of Garfailed University (the "University"), which was organized in the Philippines on June 3, 1907 to establish, maintain, and operate an educational institution or institutions for the instruction and training of the youth in all branches of the arts and sciences, offering classes in tertiary level. The University's fiscal year ends every March 31.

The following are the additional information relevant to your year-end review:

1) Depreciation of property and equipment is computed on a straight-line basis over the following estimated useful lives of the assets:

Number of Years
Land Improvements 10
Building 50
Furniture and Equipment 5
Library Books 5
Leasehold Improvements 10 or lease term whichever is shorter

2) The University acquired a parcel of land through a donation from the Provincial Government of La Union appraised at P20, 521,289 on April 2, 2019. The purpose of the land is to open a new campus to cater the residents of the province, including the neighboring provinces.

3) Additional major development accounted under construction in progress is the construction of 8-storey building in San Fernando City, La Union for Health Science Courses.

The University contracted Bob Vance Construction, Inc. on May 2, 2019 to construct a building for P109, 031,699. The contract provides that the University is to make five payments, with the last payment to be made upon completion.

The University made the following payments during 2020:

                                                   Amount
May 2, 2019                    10,903,170
August 1, 2019              18,399,099
November 31, 2019           23,628,317
February 1, 2019          28,843,188

The University made the following arrangements with financing companies during 2020:

  1. 12%, 2-year, P49 million loan dated May 2, 2019, with simple interest. Interest is payable annually on April 30. This loan is related specifically to the building project. Interest of P245, 000 was earned from the temporary investment of the borrowing proceeds.
  2. 10%, 10-year, P36 million note dated April 30, 2019, with simple interest; interest payable annually on April 30. The loan was for general financing purposes including the partial financing of the construction. 
  3. 12%, 5-year, P42 million note dated April 30, 2019, with simple interest; interest payable annually on April 30. The loan was for general financing purposes including the partial financing of the construction.

The construction of this building is still on-going as at the end of the fiscal year.

4) The University is renting the entire 5th floor (2,810 square meters) of RCBC Tower 1 to house its Makati Executive Campus. The campus caters the Graduate School of Business. Such improvements introduced to the space is recorded in under Leasehold Improvements. Under the agreement, the University is required to restore the area before such space will revert to the lessor. The following are the relevant information related to asset retirement obligation:

                                                         2020                                                            2019
 
Estimated future cash flows       P2,500 per square meter                   P50,000 plus P1,800 per square meter

Discount rate used                          3.12%                                            2.77%

Remaining lease term                     2 years                                               3 years

5) On April 1, 2019, the University purchased a new van for P500, 000 cash and trade-in of a two-year old car with a cost of P450, 000 and a book value of P135, 000. The new car has a cash price of P700, 000; market value of trade-in is not known. This was recorded as debit to Transportation Equipment and credit Cash for P500, 000. Depreciation expense of P100, 000 was recorded in 2020.

6) Various office- general-purpose computers and peripherals were sold to employees at a minimal price of 10% of the original cost. Such computers costed P1, 525,000 and were fully depreciated. The accountant recorded the transaction as debit to Cash and credit to Gain on PPE disposal for the amount of proceeds.

7) The amount shown in the Laboratory Equipment asset retirement column represents cash received on December 3 upon disposal of a machine purchased in April 1, 2013 for P2,148,699. The chief accountant recorded depreciation expense of P429, 740 on this machine in 2020.

8) The University exchanged two machines from the Mechanical Engineering Department. The University has received the following offers from other companies in the industry and has accepted the same.

Monday Company offered to exchange a similar machine plus P23, 000. (The exchange has commercial substance for both parties.)
Lasagna Company offered to exchange a similar machine. (The exchange lacks commercial substance for both parties.)

Other relevant information in relation to the exchanges are as follows:

                                           Garfailed                    Monday                       Lasagna

Machine cost                         P160,000                   P120,000                   P152,000

Accumulated depreciation            60,000                       45,000                    71,000

Fair value                                    92,000                     69,000                     92,000


The depreciation for the exchanged assets is properly recorded and updated. The accountant of the University recorded the transaction as a debit to Laboratory Equipment for the fair value of the asset received, a credit to Laboratory Equipment for the cost of the old asset, with any difference recorded as Gain or Loss on Exchange. The exchange occurred on October 31, 2019.

9) To start the next school year stronger, the University purchased a new laboratory equipment for its Biology Department on the last day of School Year 2019 - 2020. The following costs are included as additions to Laboratory Equipment:


Cash paid for equipment, including value added tax of P12,000 P112,000

Freight and insurance cost while in transit 2,000

Cost of moving equipment into place at the Biology Lab 3,100

Wage cost for technicians to test equipment 6,000

Insurance premium paid during first year of operation on this equipment 1,500

Special plumbing fixtures required for new equipment 8,000

Repair cost incurred in first year of operations related to this equipment 1,300
P133,900

10) Included in the additions of Library Books account are different book titles acquired locally and overseas for a cost of P5, 998,090 on June 2, 2019. These items were purchased on account with terms 5/30, n/45. The University were not able to pay within the discount period but paid before the date. Depreciation based on the invoice price/cost has been provided for these items.

11) At the beginning of the current fiscal year, the entity purchased furniture and fixtures for P2, 000,000 in exchange for a noninterest bearing note requiring four payments of P500, 000. The machine was included in the additions to Furniture, Transportation and Auxiliary Equipment, with a corresponding increase to Notes Payable for P2, 000,000. The first payment was made at the end of the current fiscal year. The rate of interest for this note at date of issuance was 10%. Depreciation was recorded for this machine, based on a 5-year estimated useful life.

12) Michael Scott, PhD, is a philanthropist and an alumnus of Garfailed University. He donated new books to the University costing P4, 138,682 on November 3, 2019. Unaware of the accounting procedures for donations, the University did not reflect the grant on its books.

13) On April 28, 2019, the Group's construction pertaining to Nueva Ecija campus was completed. This pertains to the opening balance of the Construction in Progress account.

14) As at March 31, 2020, the cost of the Group's fully depreciated property and equipment still in use amounted to P776, 721,453.

15) The carrying amount of the Group's idle laboratory equipment amounted to P1,908,948 as at March 31, 2020

16) An analysis of repairs and maintenance expenditures for the current fiscal year revealed the following:

  1. The entire Manila Campus was repainted at a cost of P323, 000. Work was completed on January 31, 2020.
  2. The electrical system on its School of Accountancy, Business and Management (SABM) was upgraded at a cost of P1, 200,000. The cost of the old electrical system was not known. It is estimated that the useful life of the building will not change as a result of this updating. Work was completed on March 31, 2020. 
  3. The University has an existing service contract with an IT provider for the scheduled and frequent repairs and maintenance work for its computer laboratories. Quarterly payments to the IT provider amounted to P122, 000.

Required:

Question 1) Prepare the updated PPE Roll forward for Garfailed University as at and for the year ended March 31, 2020. Show supporting schedules for each movement in cost and/or accumulated depreciation.

Question 2) Make any necessary adjusting journal entries as of March 31, 2020.

Reference no: EM132642404

Questions Cloud

Explain what social and environmental reporting is : Explain what social and environmental reporting is, why is important, why is different from traditional financial reporting and how information is disseminate
Discuss the categories of industries : Use relevant examples from different industries to discuss the categories of industries or entities that marketing professional are responsible for marketing.
Prepare a condensed multi-step income statement : Prepare a condensed multi-step 2020 income statement for Grouper Rose Corporation, showing expenses by function
Outline the reasons for specialisation of work : Briefly explain the evolution of specialisation and outline the reasons for specialisation of work.
Prepare updated ppe roll forward for garfailed university : Prepare the updated PPE Roll forward for Garfailed University as at and for the year ended March 31, 2020. Show supporting schedules
What the company retained earnings at the end of the year : The company recorded revenues of $450,000, expenses of $300,000, and paid dividends of $200,000. What the company's retained earnings at the end of the year
Determine the opportunity or threat : Midlands Pork Products Limited is Malawan's leading company in the processing and sale of pork. However, the company has observed that the demand
Cultural backlash in india : As you look at the latest quarterly earnings report of your clothing and accessories company, you think to yourself: "You are a genius!"
Code of conduct and code of ethics : What is the differences, importance, and purpose of both the code of conduct and the code of ethics?

Reviews

Write a Review

Financial Accounting Questions & Answers

  What was the amount of accrued interest received by louis

What was the amount of accrued interest received by Louis on March 31, 2018 when the bonds were issued? What was the amount of discount or premium on the bonds

  Geographic service area

Clyde had worked for many years as the chief executive of red industries, Inc., and had been a major shareholder. Clyde and the company had a falling out, and Clyde was terminated. Clyde and Red executed a document under which Clyde's stock in red wo..

  What is risk adjusted cost of capital for each type of loan

If Altra adjusts for risk by adding or subtracting one percentage point. What is the risk adjusted cost of capital for each type of loan?

  Is this plan ethical-common stockholders

Hancock Corporation is a Publishing Company. The Hancock Family formed this corporation in colonial times more than 200 years ago. The stock (400 shares of $1 par common stock) has remained in the hands of the Hancock Family for all of that time. Is ..

  Explain the term initial direct costs

Explain the term initial direct cost.Determine the amounts at which Endeavour Ltd would recognise the right-ofuse asset and the lease liability on 1 July 2016.

  Transition to a computerized system

Ashton Fleming has decided to document and analyze the accounts payable process at S&S so the transition to a computerized system will be easier. He also hopes to improve any weaknesses he discovers in the system. In the following narrative, Ashton e..

  What the limitations concerning amount of qualified expenses

What the requirements that must be met to receive a tax credit for child and dependent care expenses, and the limitations concerning the amount

  Assuming adrian has no other capital gains or losses

Three years ago, Adrian purchased 220 shares of stock in X Corp. for $29,480. On December 30 of year 4, Adrian sells the 220 shares for $22,000. Assuming Adrian has no other capital gains or losses, how much of the loss is Adrian able to deduct on he..

  Prepare journal entries to record the fair value model

Ali Baba PJSC acquired, Prepare journal entries to record the fair value model and the cost model assuming the company adopts.

  Entries records proper adjusting entry for bad debt expense

Allowance for Doubtful Accounts has a debit balance of $600 at the end of the year (before adjustment), and an analysis of accounts in the customers ledger indicates uncollectible receivables of $13,000. Which of the following entries records the pro..

  Implementing employee of the month program

You are about to recommend a series of sweeping changes within your department. They include: Replacing existing cubicles with new ones that are larger and provide your employees more privacy. Implementing an “Employee of the Month” program. Implemen..

  Balanced scorecard know whether a particular score

How does a manager looking at a balanced scorecard know whether a particular score is good or bad? If a customer waits an average 30 seconds, is that good or bad? Is a net income of $10 million good or bad?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd