Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Investigate under what conditions it is financially better to rent or buy a house by comparing the present value of buying to the present value of renting For this purpose you are to create an Excel spreadsheet which will:
allow the user to input relevant assumptions
present the relevant results comparing the present value of buying a house to the present value of renting.
The relevant input assumptions are:
savings rate (per annum) – the interest rate which the user can earn on savings over the long term (e.g. 10‐20 years)
house purchase price (assume purchased today) buying costs (as % of purchase price)
deposit on the house
term of mortgage (years) ‐ the number of years over which the home loan will be fully amortised (ie fully repaid at end of the term)
mortgage interest rate (per annum) – enter as nominal annual interest rate, compounded monthly, as this is the normal approach that Australian banks take when quoting mortgage rates
annual running costs for house ownership (starting amount)
rate of increase in running costs (per annum)
period until house sold (years)
selling costs (as % of sale price)
rate of growth in rent (per annum)
rental yield (initial % and long term %, and number of years over which it will change from initial to long term %), which is measure of investment return on property
Assume all regular cashflows such as mortgage payments, running costs and rental payments, are made annually at the end of the year
Buying and selling costs for the house, although comprised of many different items some of which are fixed costs and others which are variable, to be treated as a % of the purchase/sale price respectively
Unless otherwise specified (e.g. rental yield), all rates remain constant throughout the period until house is sold.
Calculation logic:
Mortgage payments should be calculated as a fixed dollar per annum so that the loan is paid off by the end of the term of the mortgage, using the relevant mortgage interest rate.
Note: Calculate the regular mortgage payment in a manner consistent with the model assumptions (that is, assumed payable annually at the end of the year) using an appropriate effective interest rate (that is, annual effective interest).
Future house price in year t should be calculated as Rent in year t / Rental yield in year t. This approach to predicting the future sale price of the house is a rearrangement of the equation commonly used to determine rental yield (= rental income / market value). This approach is reasonable as rental yield tends to be stable in the long term. It also maintains consistency (correlation) between rents and market value of houses over the long term.
Rent to increase with annual growth in rent
Rental yield to increase evenly each year from initial % to long term % over nominated period of years (input), then remain constant.
Present value should be calculated using the savings rate (input) as the interest rate. This is appropriate in this case since the savings rate might be considered a reasonable measure of the cost of money as the user might be expected to save the difference in the regular cashflows under the two options (rent or buy).
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow