Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A loan of RM200,000, paid annually, is made for a term of 30 years at an effective interest rate of 4.5%. The lender allows only

image text in transcribed
A loan of RM200,000, paid annually, is made for a term of 30 years at an effective interest rate of 4.5%. The lender allows only annual year-end interest payments made until at the end of 30 years. In order to pay the loan of RM200,000 at the end of 30 years, the borrower will make a payment of R at the end of first year, and will increase his payments of R arithmetically for the subsequent years, into a sinking fund earning 6% interest rate per year. (a) Develop a sales illustration of this loan scheme which consists of the following:- (i) Part 1:- parameters of input (loan, loan interest rate, loan period, rate of investment return). (ii) Part 2:- output - table schedule which consists of sinking fund deposit, total sinking fund deposit, sinking fund interest, principal repayment in sinking fund and outstanding balance of the loan. (b) From (a) (ii), determine, (i) R. (ii) Total principal repayment for the 10-th payment. (iii) The total profit of the borrower taking under this scheme for 30 years period. (c) Submit the report of this illustration by the following:- (i) Written answer (in pdf files) - develop suitable formula and payment schedule to answer (b) (ii) Sales illustration (in MSExcel) - to answer (b)

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

Financial Management Core Concepts

Authors: Ray Brooks, Raymond Brooks

1st Edition

0321155173, 9780321155177

More Books

Students also viewed these Finance questions