4 Using Excel to Account for Zero-Interest Bearing Notes PROBLEM 5 On March 1, 2025, Parnevik Company sold goods to Goosen Inc. in exchange for a zero-interest-bearing note. Information concerning the note is provided here. Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. B Sales price of goods $ 660,000 0 Face amount of note 1,062,937 1 Cost of goods on Parnevik's books 400,000 2 Term of note in years 5 3 4 5 6 7 B Use the RATE function to determine the imputed interest rate on the note. Display the answer as a positive amount. Imputed rate of interest on note Prepare the journal entries for Parnevik on these dates. List the credit accounts in alphabetical order. March 1, 2025 December 31, 2025 3/1/25 3/1/25 12/31/25 DR CR