LOAN SCHEDULE PROJECT

frankfterhours

New Member
PROJECT: CONTRACTION OF A LOAN REPAYMENT SCHEDULE FOR A HOUSE MORTGAGE

The mortgage, of UGX 1,400,000,000, has a term of 40 years. For the first 2 years, no repayments are made, although interest still accrues on the loan. Interest-only repayments are due from this point until the end of the fourth year. After the end of the fourth year, and up to the end of the term, level repayments are due, set at a level such that the mortgage will be repaid in full at the end of the 40-year term.

All repayments are made quarterly in arrears. Interest is charged at an effective rate of 6% p.a.

i) Calculate the amount of each quarterly repayment

ii) Construct the loan schedule for the mortgage.

iii) Suppose the interest rate increases to 8% in the last 20 years of the loan, show how this change will affect the loan repayment schedule.

The conditions of the loan permit borrowers to make additional payments in order to

reduce the term of the mortgage. These additional payments can be made once each

year, excluding the first two years, subject to a maximum of 20% of the outstanding capital amount, as determined at the beginning of each year of payment. The original

repayments, including the repayments in the first 10 years, will not change but the term of the mortgage will reduce.

The original repayment schedule will remain unchanged except for the term.

Mr Mubiru decides to make additional payments to reduce the term of the mortgage as much as possible.

iv) Determine the shortest possible term that can be achieved in this way.

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

schoolwork ?

BSALV

Banned user
pretty easy with the financial formulas
 at start quarterpayments at end 1.400.000.000,00 €​ first 2 years nothing 1.573.040.000,00 €​ 3-4 year interest 1.573.040.000,00 €​ 23.082.546,98 €​ 1.573.040.000,00 €​ 5-40 year all 1.573.040.000,00 €​ -26.534.872,33 €​ ​

BSALV

Banned user
conclusion : i did it in 10 minutes, i'm an expert (if the answers were correct ) ?

frankfterhours

New Member
pretty easy with the financial formulas
 at start quarterpayments at end 1.400.000.000,00 €​ first 2 years nothing 1.573.040.000,00 €​ 3-4 year interest 1.573.040.000,00 €​ 23.082.546,98 €​ 1.573.040.000,00 €​ 5-40 year all 1.573.040.000,00 €​ -26.534.872,33 €​ ​

frankfterhours

New Member
All payments are made quarterly. Not yearly

BSALV

Banned user
26,500,000 * 35 = 930,000,000 < 1,600,000,000

Replies
2
Views
136
Replies
3
Views
476
Replies
4
Views
740
Replies
9
Views
337
Replies
0
Views
700

1,186,087
Messages
5,955,763
Members
438,214
Latest member
Siledhrel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back