Question: This is a question that needs to be done in excel, therefore I ONLY need help with the EXCEL FORMULA. If you dont know, please

This is a question that needs to be done in excel, therefore I ONLY need help with the EXCEL FORMULA. If you dont know, please allow someone else to answer, thank you.
Keesha Company borrows $200,000 cash on November 1 of the current year by signing a 90-day, 9%, $200,000 note. 1. On what date does this note mature? 2. & 3. What is the amount of interest expense in the current year and the following year from this note? 4. Prepare journal entries to record (a) issuance of the note, (b) accrual of interest on December 31, and (c) payment of the note at maturity. Navigation: 1. Use the Open Excel
 This is a question that needs to be done in excel,
therefore I ONLY need help with the EXCEL FORMULA. If you dont

IE Exercise 9-5 (Static): Interest-bearing notes payable with year-end adjustments LO P1 Keesha Company borrows $200,000 cash on November 1 of the current year by signing a 90 -day. 9%,$200,000 note. 1. On what date does this note mature? 2 \& 3. What is the amount of interest expense in the current year and the following year from this note? 4. Prepare joumal entries to record (a) issuance of the note, (b) accrual of interest on December 31, and (c) payment of the note at maturity. Novigation: 1. Use the Open Excel in New Tab button to launch this question 2. When finished in Excel, use the Sove and Return to Assignment button in the lower right to return to Connect. Keesha Company borrows $200,000 cash on November 1 of the current year by signing a 90 -day, 9%,$200,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!