LOAN SCHEDULE PROJECT

frankfterhours

New Member
Joined
Mar 3, 2022
Messages
4
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
pretty easy with the financial formulas
at startquarterpaymentsat end
1.400.000.000,00 €​
first 2 yearsnothing
1.573.040.000,00 €​
3-4 yearinterest
1.573.040.000,00 €​
23.082.546,98 €​
1.573.040.000,00 €​
5-40 yearall
1.573.040.000,00 €​
-26.534.872,33 €​
 
Upvote 0
conclusion : i did it in 10 minutes, i'm an expert (if the answers were correct ) ?
 
Upvote 0
pretty easy with the financial formulas
at startquarterpaymentsat end
1.400.000.000,00 €​
first 2 yearsnothing
1.573.040.000,00 €​
3-4 yearinterest
1.573.040.000,00 €​
23.082.546,98 €​
1.573.040.000,00 €​
5-40 yearall
1.573.040.000,00 €​
-26.534.872,33 €​
 
Upvote 0
26,500,000 * 35 = 930,000,000 < 1,600,000,000
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top