Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need help preparing a monthly amortization table

i need help preparing a monthly amortization table On April 1, 2020,...

60.1K

Verified Solution

Question

Accounting

i need help preparing a monthly amortization table image
On April 1, 2020, Clyde Barrow Company bought a delivery truck for $54,000 on a 8%, five-year installment note. You have been tasked with preparing an amortization table in Excel for the bookkeeper to assist him in recording the monthly payments, with the first payment starting on May 1,2020. Prepare a monthly amortization table for the loan showing the payment date, payment, principal part of the payment, the interest portion of the payment, and the remaining balance. At the top of the table, be sure to show the calculation of the monthly payment and, below the table, show the monthly journal entry to record the first payment on May 1st. Everything should be set up so that if the interest rate or the principal of the loan were changed, the rest of the table will update appropriately

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students