Question: Please answer using Excel and please include total of payment, interest portion and principal portion in the end Question 2 of 7 General Computers Inc.

Please answer using Excel and please include total of payment, interest portion and principal portion in the end

Please answer using Excel and please include total of payment, interest portion

and principal portion in the end Question 2 of 7 General Computers

Inc. purchased a computer server for $72,500. It paid 40.00% of the

value as a down payment and received a loan for the balance

Question 2 of 7 General Computers Inc. purchased a computer server for $72,500. It paid 40.00% of the value as a down payment and received a loan for the balance at 5.00% compounded semi-annually. It made payments of $2,750.12 at the end of every quarter to settle the loan. a. How many payments are required to settle the loan? payments Round up to the next payment 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 $43,500.00 Question 2 of 7 (X 2. X C X > :: Question 2 of 7 17 18 ... . 0.00 Total

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 Finance Questions!

Please answer using Excel and please include total of payment, interest portion and principal portion in the end and please answer both the parts a and b Allison received a loan of $33,000 at 5.5%...

A payment of $12,145 is due in 3 year, $18,000 is due in 4 years, and $9,000 is due in 7 years. What single equivalent payment made today would replace the three original payments? Assume that money...

Question 8 of 9 General Computers Inc. purchased a computer server for $67,000. It paid 40.00% of the value as a down payment and received a loan for the balance at 9.50% compounded semi-annually. It...

elink/#/course-resource/section/7304/assignment/14459 60% - Question 11 of 12 ooo General Computers Inc. purchased a computer server for $75,400. It paid 25% of the value as a down payment and...

Prepare an ammortization schedule for this question and answer all of the parts correctly also at the last please give the total of payment, interest portion, principal portion Question 2 of 7...

General Computers Inc. purchased a computer server for $64,500. It paid 30.00% of the value as a down payment and received a loan for the balance at 10.00% compounded semi-annually. It made payments...

General Computers Inc. purchased a computer server for $55,000. It paid 40.00% of the value as a down payment and received a loan for the balance at 3.50% compounded semi-annually. It made payments...

Question 1 of 4 General Computers Inc. purchased a computer server for $59.000. It paid 25.00% of the value as a down payment and received a loan for the balance at 4.50% compounded semi-annually. It...

secure.vretta.com man return t o Mall - Ashton Holmas Outlook Question 2 of 5 1 (8/8) 2 (6) 3 (1) 4 (5) 5 (2) General Computers Inc. purchased a computer server for $55,500. It paid 40.00% of the...

1 . Sepia Inc. issued bonds for $400,000 that were redeemable in 9 years. They established a sinking fund that was earning 4.51% compounded semi-annually to pay back the principal of the bonds on...

Bill has just returned from a duck hunting trip. He has brought home eight ducks. Bills friend, John, disapproves of duck hunting, and to discourage Bill from further hunting, John has presented him...

15 (10%) Problem 7: In a mechanical wave, the restoring force is the force that actually causes the oscillation. In which direction does a restoring force act? opposite the direction of the...

Devan is wanting to loan you money for five years. What type of financing would this be called?

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...