Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me with my homework. Thanks! Please make an amortization schedule using the format I put in the image belowa minimum of 12 periods.

Please help me with my homework. Thanks!

Please make an amortization schedule using the format I put in the image belowa minimum of 12 periods. Note: I attached an example of the sample problem and its amortization schedule below. Please create one with the same format with a minimum of 12 periods. Thanks!

image text in transcribedimage text in transcribed
Amortization Schedule Period Outstanding Interest due at end Payment (A) Principal repaid at principal (OP) of period (OP x i) end of period (A-l) 1 P 5000 P 300 P 1 0,1681 P 716.81 4,283.19 256. 99 1,016.81 759. 82 3523 37 1,016.81 2717.96 . 1,016.81 1,864.23 1,016 81 959. 27 57.55 1,.016 81 959.27 TOTALS P 1,100.87 P 0,100.80 P 5,000.00 Sample Problem 1. A debt of P5,000 with interest at 12% compounded semi-annually is to be amortized by equal semi-annual payments over the next 3 years. the rst due in 6 months. Find the semi-annual payment and construct an amortization schedule. Given: P=P5,000 r=12% m=2 n=3 Required: Amortization Schedule Solution: A[1 (1 + 0-H] PA = i A 2 PA 0) [1 (1 + i)'"] 500mg) )(3)(2) \"([1 _ 1 1 A: P1,016.81 \\

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Economics Of Inequality

Authors: Thomas Piketty, Arthur Goldhammer

1st Edition

0674504801, 9780674504806

More Books

Students also viewed these Economics questions

Question

What is the difference between persistence and self-determination?

Answered: 1 week ago

Question

Write a Python program to check an input number is prime or not.

Answered: 1 week ago

Question

Write a program to check an input year is leap or not.

Answered: 1 week ago

Question

Write short notes on departmentation.

Answered: 1 week ago