Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

you are required to prepare a loan repayment schedule of a loan with an interest-only period of the first NPER1 months. During the first NPER1

you are required to prepare a loan repayment schedule of a loan with an interest-only period of the first NPER1 months. During the first NPER1 months, only the interest amount (IO) is paid at the end of each month. After the first NPER1 months, an equal month-end repayment including principal and interest (P&I repayments) is made at the end of each month for NPER2 months until the end of the loan term.

NPER1 Number of months with interest only repayments : 36

Number of years, n, with Principal & Interest (P&I) repayments : 25

NPER2 Number of months, n*m, with Principal & Interest (P&I) repayments : 300

Interest rate, jm, p.a (compounding monthly) : 8%

Interet rate per month (i=jm/m) : 8%/12 Loan amount : $936,814

Q1: find the Fixed monthly repayment (P&I) after the interest only periold expires with excel code

Q2: find the Balance at the beginning of month, Interest paid, Principal paid, Balance at the end of month with excel code, please provide the first 3 months code

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

Principles Of Finance With Excel

Authors: Simon Benninga, Tal Mofkadi

3rd Edition

0190296380, 9780190296384

More Books

Students also viewed these Finance questions

Question

What is your least favorite U.S. dialect? Why?

Answered: 1 week ago