Search
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

# Quantitative Methods - Assignment Example

Comments (0) Cite this document
Summary
The first type, the repayment Mortgage can be paid by a series of regular payments or instalments. Its value is equal to the present value of all future instalments. An example of this mortgage is a mortgage taken on a property.
If an Interest Only Mortgage is taken out then only the interest is paid over the mortgage period…

## Extract of sample"Quantitative Methods"

Download file to see previous pages For calculating the monthly expenses for the both types of mortgages first the nominal interest rates should be used to calculate the effective annual interest rates. This is done by using the following formula: I=(1+r/x)^x-1
In order to obtain the effective annual rates the Microsoft Excel formula was used: EFFECT(nominal_rate,npery), where nominal_rate is the annual nominal rate and npery is the number of compounding times per year.
These values were calculated in Microsoft Excel using the formula: PMT(rate,nper,pv,fv,type). Rate is the interest rate of the mortgage, Nper is the total number of repayments for the loan, in this case 300 months (25*12), Pv is the present value of the total repayments that are to be made, Fv is the future value that one wishes to attain after the last repayment, in this case 0 and lastly Type indicates whether the repayment is made at the beginning of the month (0) or at the end (1), in this case we assume it is made at the start of the month so 0.
In order to evaluate the Interest Only Mortgage option we must first calculate the effective annual interest rate on the deposit placed in the sinking fund. This will be done in the same way as for the Repayment Mortgage. The results are presented in the table below:
The monthly cost Interest Only mortgage consists of the interest paid over the mortgage period and the amount accumulated in the sinking fund....
epayments for the loan, in this case 300 months (25*12), Pv is the present value of the total repayments that are to be made, Fv is the future value that one wishes to attain after the last repayment, in this case 0 and lastly Type indicates whether the repayment is made at the beginning of the month (0) or at the end (1), in this case we assume it is made at the start of the month so 0.

In order to evaluate the Interest Only Mortgage option we must first calculate the effective annual interest rate on the deposit placed in the sinking fund. This will be done in the same way as for the Repayment Mortgage. The results are presented in the table below:

Nominal interest rate on deposit in sinking fund
Number of compounding periods per year
Effective annual interest rate on deposit in sinking fund
5.50%
1
0.055
5.75%
1
0.0575
6.00%
1
0.06
6.25%
1
0.0625
6.50%
1
0.065
6.75%
1
0.0675
7.00%
1
0.07
7.25%
1
0.0725
7.50%
1
0.075
7.75%
1
0.0775
8.00%
1
0.08
8.25%
1
0.0825
8.50%
1
0.085
8.75%
1
0.0825
9.00%
1
0.09

The monthly cost Interest Only mortgage consists of the interest paid over the mortgage period and the amount accumulated in the sinking fund. In order to calculate the monthly payment into the sinking fund using Excel the PPMT(rate,per,nper,pv,fv,type) formula was used where rate is the interest rate per period, per is the period, nper is the total amount of payments in the sinking fund, pv is the present value of the mortgage, fv is the future value expected in our case 0 and type indicates when the monthly payments are due in this case we assume that they are made at the beginning of the period so we take the value 1. The results are listed below:

Annual interest rate
Number of years in the loan
Amount of loan
Payment into investment plan
5.50%
25
Cite this document
• APA
• MLA
• CHICAGO
(“Quantitative Methods Assignment Example | Topics and Well Written Essays - 2750 words”, n.d.)
Quantitative Methods Assignment Example | Topics and Well Written Essays - 2750 words. Retrieved from https://studentshare.org/business/1526868-quantitative-methods-assignment
(Quantitative Methods Assignment Example | Topics and Well Written Essays - 2750 Words)
Quantitative Methods Assignment Example | Topics and Well Written Essays - 2750 Words. https://studentshare.org/business/1526868-quantitative-methods-assignment.
“Quantitative Methods Assignment Example | Topics and Well Written Essays - 2750 Words”, n.d. https://studentshare.org/business/1526868-quantitative-methods-assignment.
Click to create a comment or rate a document
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
Quantitative Methods Portfolio
This study aims investigating the perceptions of tourists on the industry and their destinations. There are two main approaches to research; qualitative and quantitative. This research uses a quantitative research. A quantitative research refers to investigation on the basis of numerical data through mathematical, statistical, and computational methods (Miller & Acton, 2009).
10 Pages(2500 words)Assignment
QUANTITATIVE METHODS FOR BUSINESS
Furthermore, he states that a man brain is larger than that of a woman’s and that mediocre people have smaller brains compared to the eminent ones. On the other side, Hooton, an
7 Pages(1750 words)Assignment
Project work, Quantitative methods
According to the available data, the best articles the magazine could feature include real estate, balanced gender issues, and youth related issues. The responses presented in excel as ‘Yes’ and ‘No’ were coded during the analysis phase to
4 Pages(1000 words)Assignment
Quantitative Methods Portfolio
Questionnaire is one of the many methods and instruments of data collection commonly used in research studies. Different questionnaires are designed relative to the objective of the study. In this study, the main aim is to obtain the opinion of tourists on
10 Pages(2500 words)Assignment
Quantitative Methods Portfolio
The hospitality service providers in UK often engage themselves in knowing their customers’ attitudes, who often visit UK and its major cities from different parts of the world belonging to different demographics (PWC,
10 Pages(2500 words)Assignment
Quantitative Methods (Assignment #1: JET Copies Case Problem)
4. The amount of revenue lost can be obtained through multiplying the number of days taken to repair the copier by the number of copies you may have sold that day (r3) which is a random number between 2000 and 8000 then multiplied by the
6 Pages(1500 words)Assignment
Quantitative Methods
This may make the researcher to scrutinize the results wrongly. The results may demonstrate a false correlation between the independent and dependent variables,
5 Pages(1250 words)Assignment
Quantitative Methods database assignment
at group, to identify the pricing characteristics of the hotel rooms according to locality, star ratings, and amenities, review score from customers and value added services like swimming pool or Wi-Fi connectivity (Maliene, 2011). This analysis will help to rent of the rooms of
9 Pages(2250 words)Assignment
Research Methods Quantitative
How does aircraft noise affects your health and wellbeing? In your opinion, how do you rate the overall annoyance from the aircraft noise? 8. Instrument(s) analysis: The study will rely on the Osgood’s sematic differential to
2 Pages(500 words)Assignment
Quantitative Methods Individual work1
The projected fee for the seminar is \$600 per student. The cost for the conference room, instructor compensation, lab assistants, and promotion is \$9600. Micromedia rents computers for its seminars at a cost of \$60 per computer per day. 14. Eastman
3 Pages(750 words)Assignment
Let us find you another Assignment on topic Quantitative Methods Assignment for FREE!
+16312120006