2. Calculate the amount of interest and principal paid in each month based on the history of borrowing and payments on the line of credit. Using that information, find the outstanding balance as of that date. Assume that interest accrues over the course of the month. So, for example, any outstanding balance on January 1 has accrued one month of interest on February 1. Date $ Borrowed January 1 February 1 March 1 April 1 May 1 June 1 July 1 August 1 September 1 12,500 11,450 14,675 0 11,980 0 7,290 0 Interest $ Repaid Interest Paid Principal Paid Rate 8% 8% 7% 7% 7% 796 7% 8% 996 0 O 21,500 0 8,000 4,650 0 0 Outstanding Balance

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Answer plz 

2. Calculate the amount of interest and principal paid in each month based on the history of borrowing
and payments on the line of credit. Using that information, find the outstanding balance as of that date.
Assume that interest accrues over the course of the month. So, for example, any outstanding balance on
January 1 has accrued one month of interest on February 1.
Date
$ Borrowed
$ Repaid
January 1
February 1
March 1
April 1
May 1
June 1
July 1
August 1
September 1
October 1
November 1
December 1
12,500
11,450
14,675
0
11,980
0
0
7,290
0
0
0
0
Interest
Rate
8%
8%
7%
7%
7%
7%
7%
8%
9%
9%
10%
9%
0
0
0
21,500
0
8,000
4,650
0
0
0
20,000
6,350
Interest Paid Principal Paid
Outstanding
Balance
Transcribed Image Text:2. Calculate the amount of interest and principal paid in each month based on the history of borrowing and payments on the line of credit. Using that information, find the outstanding balance as of that date. Assume that interest accrues over the course of the month. So, for example, any outstanding balance on January 1 has accrued one month of interest on February 1. Date $ Borrowed $ Repaid January 1 February 1 March 1 April 1 May 1 June 1 July 1 August 1 September 1 October 1 November 1 December 1 12,500 11,450 14,675 0 11,980 0 0 7,290 0 0 0 0 Interest Rate 8% 8% 7% 7% 7% 7% 7% 8% 9% 9% 10% 9% 0 0 0 21,500 0 8,000 4,650 0 0 0 20,000 6,350 Interest Paid Principal Paid Outstanding Balance
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education