2. SP plans to purchase a new injection molding machine for $135,000. It will be...

50.1K

Verified Solution

Question

Accounting

image
2. SP plans to purchase a new injection molding machine for $135,000. It will be completely financed with a loan at 13% APR compounded bi-weekly (every 2 weeks) over 7 years a) What is the bi-weekly payment on the loan? b) How much interest will be paid over the 7 years of the loan? c) How much of the 1st payment will be used to pay down the loan, rather than to pay interest? d) SP is considering upgrading the machine after 5 years. How much will still be owing on the machine after 5 years? e) Using Excel, construct an amortization table showing the bi-weekly period, the opening balance, payment amount, amount of the payment going to interest, the amount going to pay the loan, and the closing balance. Print the first 10 rows of the table 1 Sackville Plastics 3 Loan Amount 4 Number of Years S Payments per year 6 Total number of payments 7 APR interest rate 8 period interest rate 9 payment per period 10 pening lance Payment Interest to Loan Balance Amount Closing 11 Payment # 12 13 14 15 16 17 18 19 20 21 Bal 6 7 8 10

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students