N23 B 1 Function: RATE, Formula: Multiply, Subtract; Cell Referencing 2 3 Using Excel to...

Transcribed Image Text:

N23 B с 1 Function: RATE, Formula: Multiply, Subtract; Cell Referencing 2 3 Using Excel to Account for Notes Payable 4 PROBLEM X✓ fx 9 10 5 Snade Corporation issued a five-year note to Hames Corp. on January 1, 2020, 6 and received a piece of equipment. The note requires annual interest 7 payments each December 31. Information concerning the note follows. 8 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Face value of note Stated interest rate Note term in years Value of equipment received Market interest rate of similar notes Ś $ D 50,000 5% 5 38,912 11% E F G H Student Work Area Required: Provide input into cells shaded in yellow in this template. Use Excel's RATE function with cell references to the Problem and work areas to calculate the implicit rate of the note. Use mathematical formulas with cell references to the Problem area and work area as indicated for other amounts. (a) Using Excel's Rate function, calculate the implicit interest rate. Annual interest payments Implicit interest rate (b) Prepare Snade's journal entry for the January 1, 2020 issuance. Debit Credit (c) Prepare the entry for the December 31, 2020 interest payment using the effective interest method. M N O P N23 B с 1 Function: RATE, Formula: Multiply, Subtract; Cell Referencing 2 3 Using Excel to Account for Notes Payable 4 PROBLEM X✓ fx 9 10 5 Snade Corporation issued a five-year note to Hames Corp. on January 1, 2020, 6 and received a piece of equipment. The note requires annual interest 7 payments each December 31. Information concerning the note follows. 8 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Face value of note Stated interest rate Note term in years Value of equipment received Market interest rate of similar notes Ś $ D 50,000 5% 5 38,912 11% E F G H Student Work Area Required: Provide input into cells shaded in yellow in this template. Use Excel's RATE function with cell references to the Problem and work areas to calculate the implicit rate of the note. Use mathematical formulas with cell references to the Problem area and work area as indicated for other amounts. (a) Using Excel's Rate function, calculate the implicit interest rate. Annual interest payments Implicit interest rate (b) Prepare Snade's journal entry for the January 1, 2020 issuance. Debit Credit (c) Prepare the entry for the December 31, 2020 interest payment using the effective interest method. M N O P

Answer rating: 100% (QA)

Based on the Excel worksheet you shared youre being asked to use Excel to calculate the implicit interest rate of a note using the RATE function and then prepare journal entries for the note issuance ... View the full answer