Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please make an ammortization table using excel and

Please make an ammortization table using excel and at the last please give total of...

90.2K

Verified Solution

Question

Finance

Please make an ammortization table using excel and at the last please give total of payments, interest portion and principal portion. Answer all the parts correctly, I've already done A part

image

image

image

image

Question 2 of 7 General Computers Inc. purchased a computer server for $57,000. It paid 35.00% of. the value as a down payment and received a loan for the balance at 6.50% compounded semi-annually. It made payments of $2,800.63 at the end of every quarter to settle the loan. a. How many payments are required to settle the loan? 15 payments Round up to the next payment F 1 Question 2 of 7 b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Payment Interest Portion Payment Number Principal Portion Principal Balance 0 $37,050.00 $2,800.63 Question 2 of 7 $2,800.63 1 ].. $2,800.63 2. Question 2 of 7 :: :: 14 $2,800.63 (X) . . 15 $2,800.63 0.00 (X Total (X v

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