Question: Constructing Partial Amortization Schedule (Exercise AAA) A debt of $7500 is amortized by making equal payments at the end of every month. Required payment term

Constructing Partial Amortization Schedule (Exercise AAA) A debt of $7500 is amortized by making equal payments at the end of every month. Required payment term is next 5 years. If interest is 7.8%pa compounded monthly, construct a partial amortization schedule finding the values that follow: n ? 5 years 1 month PV-7500-PMT [(1-(1 +iY.n)i]. So PMT-S15 1.36 and n-60 required payments. i-0.65% a) Build the first row of the amortization schedule b) Find OUTSTBAL c) Find PRN d) Find the last payment value (P60) Amortization Schedule Pay Amount Interest Paid Number Paid Principal Repaid (PRP) Outstanding Principal Balance (OUTBL 151.36 151.36 151.36 151.36 151.36 59 60 Calculations

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!

What is the cash value of a three-year lease of office facilities renting for $1536.50 payable at the beginning of each month if money is worth 9% compounded monthly? Payments of $1000 are due at the...

Please clearly provide the calculations. Thanks A debt of $80,000 is amortized by making equal payments at the end of every month for ten years. Interest is 6% compounded quarterly. a) Construct a...

A debt of $80,000 is amortized by making equal payments at the end of every month for ten years. Interest is 6% compounded quarterly. a)Construct a partial amortization table of including totals of...

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

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

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

4 This assignment covers material from Units 10 to 12 in the Mathematics 244 Study Guide. It is due after Unit 12 in the Study Guide is completed. Total Marks = 100 1. Business Mathematics A debt of...

Repeat Problem 24.16, except let J = 0.20, and in part (b) consider expected alternate jump magnitudes of 0.10 and 0.50. The following two problems both use the CEV option pricing formula. Assume in...

Calculate the overall transmission loss for a wall consisting of the following components, using i) the exact method, and ii) the approximate method (T 5.2) Door: 2 entrance door, each with an area...

13. The strAmount variable contains the string 300.89. Which of the following statements changes the contents of the variable to 300.89!!!!? a. strAmount = strAmount.PadLeft(4, "!"c) b. strAmount =...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

Enter the ticker for Apple Inc. (AAPL) or Nike (NKE). Look at the trends and composition of the income statement, then answer your three questions from Part 1 AQ2.

(LO 8-3) Go to Loughran and McDonalds sentiment word lists at https://sraf.nd.edu/textual-analysis/resources/ and download the Master Dictionary. These lists are what theyve used to assess sentiment...

Select either Apple Inc. (AAPL) or Nike (NKE), and identify three questions you might want to know about that companys financial performance over the past three years. For example, What is the trend...