could you please solve this problem.

ignment Help Gurung Co has a noncontributory defined benefit pension plan adopted on January 20X5. On 31 December 20X5, the following information is available For accounting purposes Interest rate used for pension amounts, 5 Past service con granted as of 1 January 20X55400.000 This is also the defined benefit obligation on January . Current service cost for 2005 appropriately measured for accounting purposes 587.000 For finding purposes . Funding was 5109,500 in 20x5 for at pension amounts. The payment was made on 31 December Adulrings on fund assets zero Required: 1 Prepare a pension spreadsheet that suas relevant person data for 20x5 PA Panton Nute Ad 00 Beginning PC