Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

nper 2 is not given, i need the exact excel finance functions please. i do not know how to do these excel formatting. please help

nper 2 is not given, i need the exact excel finance functions please. i do not know how to do these excel formatting. please help me. these are the only values given for me. image text in transcribed

In this part of the assignment, you are required to prepare a loan repayment schedule of a loan with an interest-only period of the first NPER, months. During the first NPER, months, only the interest amount (10) is paid at the end of each month. After the first NPFRmonths, 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. The total loan term is NPER,+NPER2 months. Complete the table below showing the variables you need for the loan repayment schedule NPER, Number of months with interest only repayments 19 Number of years, n, with Principal & Interest (P&I) repayments NPER, Number of months, n*m, with Principal & Interest (P&I) repayments Interest rate, jm, p.a (compounding monthly) 9.00% Interet rate per month (i=jm/m) 0.75% Loan amount $841,892 Fixed monthly repayment (P&I) after the interest only perlold expires Answer must be positive (greater than o) DO NOT Round any amounts in the Amortisation Schedule. Use format commands to display as currency. Loan Amortisation Schedule Month Balance at the beginning of month Interest paid Principal paid Balance at the end of month In this part of the assignment, you are required to prepare a loan repayment schedule of a loan with an interest-only period of the first NPER, months. During the first NPER, months, only the interest amount (10) is paid at the end of each month. After the first NPFRmonths, 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. The total loan term is NPER,+NPER2 months. Complete the table below showing the variables you need for the loan repayment schedule NPER, Number of months with interest only repayments 19 Number of years, n, with Principal & Interest (P&I) repayments NPER, Number of months, n*m, with Principal & Interest (P&I) repayments Interest rate, jm, p.a (compounding monthly) 9.00% Interet rate per month (i=jm/m) 0.75% Loan amount $841,892 Fixed monthly repayment (P&I) after the interest only perlold expires Answer must be positive (greater than o) DO NOT Round any amounts in the Amortisation Schedule. Use format commands to display as currency. Loan Amortisation Schedule Month Balance at the beginning of month Interest paid Principal paid Balance at the end of month

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_2

Step: 3

blur-text-image_3

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

Challenges And Impacts Of Religious Endowments On Global Economics And Finance

Authors: Buerhan Saiti , Adel Sarea

1st Edition

1799812456,1799812480

More Books

Students also viewed these Finance questions

Question

DOU for the above compounds

Answered: 1 week ago

Question

=+1. What are the three steps in the writing process? [LO-1]

Answered: 1 week ago

Question

=+What is their probable reaction to your message?

Answered: 1 week ago