Create a spreadsheet that duplicates the shown table. Make it flexible enough that you can investigate the impact of different interest rates and principal loan amounts without changing the structure of the spreadsheet. TABLE 4-1 Three Plans for Repayment of $17,000 in Four Months with Interestat 1% per Month(1)(6) = (3) + (5)(2)Amount Owed(3) = 1% × (2)(4) = (2) + (3)Total Money(5)InterestTotalEnd-of-Monthat Beginningof MonthOwed atAccruedfor MonthPrincipalPaymentMonthEnd of MonthPayment (Cash Flow)

A loan amortization schedule is the schedule of payment of a loan which includes installment…

TABLE 4-1 Three Plans for Repayment of $17,000 in Four Months with Interest at 1% per Month (1) (6) = (3) + (5) (2) Amount Owed (3) = 1% × (2) (4) = (2) + (3) Total Money (5) Interest Total End-of-Month at Beginning of Month Owed at Accrued for Month Principal Payment Month End of Month Payment (Cash Flow)

TABLE 4-1 Three Plans for Repayment of $17,000 in Four Months with Interest at 1% per Month (1) (6) = (3) + (5) (2) Amount Owed (3) = 1% × (2) (4) = (2) + (3) Total Money (5) Interest Total End-of-Month at Beginning of Month Owed at Accrued for Month Principal Payment Month End of Month Payment (Cash Flow)

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

ChapterM: Time Value Of Money Module

Section: Chapter Questions

Problem 8E: Cash Flow Amounts R. Lee Rouse borrows 10,000 that is to be repaid in 24 equal monthly installments...

See similar textbooks

Similar questions

Everglades Consultants takes out a loan in the amount of $375,000 on April 1. The terms of the loan include a repayment of principal in eight, equal installments, paid annually from the April 1 date. The annual interest rate on the loan is 5%, recognized on December 31. (Round answers to the nearest cent, if needed.) A. Compute the interest recognized as of December 31 in year 1. B. Compute the principal due in year 1.
Cash Flow Amounts R. Lee Rouse borrows 10,000 that is to be repaid in 24 equal monthly installments payable at the end of each subsequent month with interest at the rate of 1% per month. Required: Using the appropriate table, calculate the equal installments.
II.DIRECTION: Compute for the amount of interest for the following; 1. Principal or amount barrowed : Php 10, 000Interest rate : 10% per yearTime : 3 months 2. Principal or amount barrowed : Php 30, 000Interest rate : 6% per yearTime : 60 days
Q)An amount X is placed in an account with an interest rate compounded quarterly for 27months. The accrued amount after 24 months is 1.1499 times the principal amount. Find X ifthe accrued amount at the of 24 months is increased to P4,100 at the end of 9 quarters.
At what interest rate payable quarterly will payments of Php 500 at the beginning ofeach 3 months for 7 years discharge a debt of Php 12,500 due immediately. (ans: 3.44%)
What is the amount generated by a capital of $10,000 applied to compound interest for the following terms and rates: Compound interest rate Deadline a)3.0% per quarter 30 months
a hypothetical financial instrument pays 10% annual interest permanently. It pays interest at the end of each month YTM is 12%. a. what is Macaulay duration of this financial instrument? b. what us modified duration of this financial instrument?
1 A debt of $17520 with internet at 6 % compounded quarterly is to be repaid by equal payments at the end of every three months for three years a) calculate the size of the monthly payments. b) what is the interest paid in second payment. c) calculate the outstanding balance after three payments. d) constract an amortization table
Question 2 A debt of 45,000 with interest at 12% compounded monthly is to be repaid with payments of 20,000 and 15,000 after 3 months and 9 months respectively. What is the final payment after 15 months? Full explain this question and text typing work only thanks
Problem 1. A loan of $10,000 at a fixed annual effective interest is being repaid by level annual payments. The outstanding balance immediately after the 9th pay- ment is $6,665.29 and the outstanding balance immediately after the 18th payment is $1492.11. Determine the outstanding balance immediately after the 19th payment.
Correctly solve thisf Q)A debt of $13,700 with interest at 5% compounded semi-annually is repaid by payments of $1,950 made at the end of every 3 months. Construct an amortization schedule showing the total paid and the total cost of the debt.
Problem: A debt of P15, 000.00 was paid for as follows: P4, 000.00 at the end of 1 month, P5,000.00 at the end of 4 months, P3, 000.00 at the end of 5 months, and a final payment F at the end of 7 months. If the rate of interest was 18% compounded quarterly, find the final payment F?