Question: please answer all parts Question 1 (11 points) A debt of $25,000 is to be amortized by making payments at the end of every six

please answer all parts please answer all parts Question 1 (11 points) A debt of

Question 1 (11 points) A debt of $25,000 is to be amortized by making payments at the end of every six months for three years. Interest on the debt is 8.5% compounded semi-annually. a. Calculate the amount of the semi-annual loan payments. Copy this table to use in your answer. Beg / End write here P/Y C/Y N 1/Y PV PMT FV Show all your work. b) Using the AMORT function, copy and complete this partial amortization table. b) Using the AMORT function, copy and complete this partial amortization table. Copy this table Payment # Amount Paid Interest Paid Principal Paid Balance 0 (XXX 1 2 3 4 5 6 Totals XXXXXXXXX c) What is the outstanding balance after the 6th payment. d) What is the loan balance after 1 year? Format BIU

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!

Question 1 (40 points) A debt of QAR 29,000.00 is to be amortized by making payments at the end of every six months for 3 years. Interest on the debt is 6.5% compounded semi-annually. Note: the...

JUST ANSWER THE FIRST PAGE: ALL INFO ARE ALREADY GIVEN PRESENT VALUE OF SIMPLE ANNUITY DUE EXAMPLE: Hope borrows money for the renovation of her house and repays by making yearly payments of P50,...

TO BE ANSWERED: All of theinfos are already given below just answer the first photo PRESENT VALUE OF SIMPLE ANNUITY DUE EXAMPLE: Hope borrows money for the renovation of her house and repays by...

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

Please answer questions. e- textbook Corporate Finance, 3rd Jonathan 'Berk and Peter DeMarzo 1. Which do you prefer: a bank account that pays 6% per year (EAR) for three years or: a. An account that...

Please complete the following test. Use the the word document "Test 1 Directions" for directions. Then use the "Test 1" RTF to complete the "Test 1 Answers Sheet RTF." Please let me know if you have...

1-4.Find the total periodic charge to retire a P38,600 debt with quarterly payments for 5 years, using the following plans: a) Amortized at 8%(4) b) Loan at 8%(4) with a sinking fund at 5%(4) c) Loan...

QUESTION 1 (25 MARKS) Cr P 70 000 12 000 364 000 Kelly's current reporting date is 31 December 2019. The financial statements of Kelly will probably be approved by the owner on 28 February 2020 for...

Percentages need to be entered in decimal format, for instance 3% would be entered as .03.) Jenna bought a bond that was issued by Sherlock Watson Industries (SWI) three years ago. The bond has a...

Considering all the options, which housing option do you think makes most sense? Come to a group consensus and describe your reasoning.

In Year1, Craigs first year of business, Craig reported $460,000 of pretax book (GAAP) income. Key line items follow: GAAP (book) income: Revenue 660,000 Other expenses (150,000) Depreciation expense...

The cost of goods sold account is credited to write down the inventory as required by the law of cost or market room true or false

What process describes glacier movement through the deformation of ice crystals themselves, independent of sliding at the base? A ) Basal sliding B ) Creep C ) Internal deformation D ) Surging

Define and discuss affirmative action.

Discuss who is responsible for ensuring equal employment opportunity.

Discuss diversity management.