Question: Please make an ammortization table using excel for this question and at the last please add total for payments , interest portion and principal portion

Please make an ammortization table using excel for this question and at the last please add total for payments , interest portion and principal portion

Please make an ammortization table using excel for this question and at

the last please add total for payments , interest portion and principal

portion Question 2 of 7 General Computers Inc. purchased a computer server

for $68,000. It paid 45.00% of the value as a down payment

Question 2 of 7 General Computers Inc. purchased a computer server for $68,000. It paid 45.00% of the value as a down payment and received a loan for the balance at 4.00% compounded semi-annually. It made payments of $2,250.55 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 Number Payment Interest Portion Principal Portion Principal Balance $37,400.00 1

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 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 Question...

Please make an ammortization table using excel and solve all the parts also at the last give the total of payment, interest portion, and principal portion Question 2 of 7 General Computers Inc....

Agency Funds. Does the government operate a tax agency fund or participate in a tax agency fund operated by another government? Does the government act as an agent for owners of property within a...

Requirements: Please use the data from the following table to complete the cash budget in Excel spreadsheets. You can use the Excel file (FINA 3562 Project 2 data.xlsx) that I uploaded on Blackboard....

GUARANTEED LIKE Question 5 (15 Points) Assuming that Dahlgren is correct in that Swedish Match will receive a credit rating of BBB if it moves forward with the transaction. Answer the following: What...

Please help fill in the blanks with the information provided, excel sheet with formulas probably easiest to use to accomplish problem. Thanks. Project 2 Learning objective: Students will learn how to...

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...

The four elements W, X, Y, Z form diatomic molecules and also form singly charged negative ions. The following observations are made in a series of experiments: (b) 2W + Y No reaction (a) 2X + Y2Y +...

You are required to prepare a report on Progressive Insurance Claims Department. This report also includes. New Claims division Aids in Customers Needs Vision and Business Model How the...

Suppose the rate of return on the short term government securities ( perceived to be risk fiee ) is about 5 % . Suppose also that the expected rate of return required by the market for a portfollo...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...