MMP742 – Investment Valuation
Trimester 1, 2021
Assessment Task 2
DUE DATE AND TIME: Week 10, 17/05/2021, 8PM (AEST)
PERCENTAGE OF FINAL GRADE: 25%
WORD COUNT: 2,500 words
Learning Outcome Details
| Unit Learning Outcome (ULO) | Graduate Learning Outcome (GLO) |
| ULO 1: Collect, evaluate and interpret market data relevant to property asset valuation. | GLO 1: Discipline-specific knowledge and capabilities. |
| ULO 2: Apply financial formulae appropriately to undertake a discounted cash flow analysis | GLO 2: Communication |
| ULO 3: Produce an investment property report. | GLO 3: Digital literacy |
| ULO 4: Analyse and synthesise investment data to form, justify and explain property valuation decisions and assumptions | GLO 4: Critical thinking |
Students who submit their work by the due date will receive their marks and feedback on CloudDeakin within 15 working days of the due date.
Assignment Brief
You have been approached by an Australian investor who would like to purchase an income-producing residential property for investment purposes. She is not an active property investor but is considering the purchase of a brand new three-bedroom house in Kangaroo Way, Armstrong Creek, Victoria. The price for the house is a Turn-Key package (i.e. inclusive of driveway, landscaping, fixture, fittings, curtains etc). In other words, the house is ready for occupancy immediately. Furthermore, the investor has employed a property manager who will guarantee occupancy of a tenant upon settlement. The investor knows you are studying Investment Valuation and has asked for your advice.
Tasks
Using the following assumptions, determine if the property purchase is a sound investment decision.
Assumptions
| Purchase Price | $449,000 |
| Holding Period | 5 years |
| Loan to Value Ratio | 80% |
| Loan Type | Principle & interest over 30 years |
| Interest Rate | You are to research a 5-year fixed interest rate, with reference to your source |
| Acquisition & financing costs | You are required to research these costs, with reference to your sources |
| Vacancy & Collection | 3% of gross rent |
| Rent | The unit will be leased at $410 per week |
| Annual Rental Growth | 2.5% |
| Annual Operating Expenses (AOE) | 20% of annual gross rent |
| AOE Growth | 2% |
| Depreciation Method | Straight line |
| Value of Depreciable Assets | $55,000 |
| Effective life of Depreciable Assets | 10 years |
| Capital Works Cost | $145,000 |
| Effective Like of Building | 40 years |
| Year Built | 2021 |
| Estimated Capital Growth | 3% p.a. |
| Selling Expenses | 2% of expected selling price |
| Tax Rate | Highest personal income tax rate for 2020/21 financial year (inc. Medicare Levy) |
| Capital Gain Tax (GCT) | Domestic investor |
| Investors Require Rate of Return | 7% |
Part A
Prepare a discounted cash flow spreadsheet analysis reporting the Net Present Value (NPV) and internal Rate of Return (IRR) results for the potential investor. Assume the investor has sufficient income from her employment to cover any cash shortfalls during the life of the investment. The property will be held for 5 years after purchase. Based on your results, should the investor purchase the investment property? Why or why not?
8 Marks
Part B
Partition the IRR and discuss your results. Conduct a sensitivity analysis utilising two (only two) critical variables that might impact the NPV. Explain the results and the key risks associated with this investment from your findings.
7 Marks
Part C
Now suppose that the investor is considering a longer investment horizon, she wants to increase the holding period to 7 years. Produce a new DCF spreadsheet to calculate the NPV and IRR results for a 7-year holding period (i.e. the property will be sold after 7 years). Assume fixed rates for a 7-year principal and interest loan is now 3% p.a. All other assumptions remain unchanged. Compare your results from Part A and Part C, would you advise her to invest for 5 or 7 years? Justify your advice.
10 Marks
Structure
Please clearly label each part of your assignment. Due to the nature of this assessment, the word count is not an issue to worry about (i.e. you are not expected to provide 2,500 words of discussions to accompany your results).
Please Note: You are required to upload your excel spreadsheet (5 year and 7 year holding periods) with formulas. You can develop summary result tables to be embedded in the body of your report for ease of presentation (please do not just copy and paste all of the output from excel in to the word document).
Submission Instructions
To be uploaded and submitted electronically to the assignment dropbox on CloudDeakin. Please make sure you submit both your assignment document (in PDF format) and your live excel spreadsheet.
You must keep a backup copy of every assignment you submit, until the marked assignment has been returned to you. In the unlikely event that one of your assignments is misplaced, you will need to submit your backup copy.
Any work you submit may be checked by electronic or other means for the purposes of detecting collusion and/or plagiarism.
When you are required to submit an assignment through your CloudDeakin unit site, you will receive an email to your Deakin email address confirming that it has been submitted. You should check that you can see your assignment in the Submissions view of the Assignment dropbox folder after upload, and check for, and keep, the email receipt for the submission.
Referencing
Students must correctly use the Harvard style of referencing.
Academic integrity, plagiarism and collusion
Plagiarism and collusion constitute extremely serious breaches of academic integrity. They are forms of cheating, and severe penalties are associated with them, including cancellation of marks for a specific assignment, for a specific unit or even exclusion from the course. If you are ever in doubt about how to properly use and cite a source of information, consult your lecturer or the Study Support website:
Plagiarism occurs when a student passes off as the student’s own work, or copies without acknowledgement as to its authorship, the work of any other person or resubmits their own work from a previous assessment task.
Collusion occurs when a student obtains the agreement of another person for a fraudulent purpose, with the intent of obtaining an advantage in submitting an assignment or other work.
Notes
- Penalties for late submission: The following marking penalties will apply if you submit an assessment task after the due date without an approved extension: 5% will be deducted from available marks for each day up to five days, and work that is submitted more than five days after the due date will not be marked. You will receive 0% for the task. ‘Day’ means working day for paper submissions and calendar day for electronic submissions. The Unit Chair may refuse to accept a late submission where it is unreasonable or impracticable to assess the task after the due date.
- · Extension requests: Extensions can only be approved by the Unit Chair. Extensions can be granted for documented serious illness (not just on the day the assignment is due!) or for compassionate reasons under extenuating circumstances. The unit chair can ask to see how much work has been completed before granting an extension. Work or holiday reasons are NOT grounds for an extension
– you are expected to manage these issues as part of your studies. You are strongly encouraged to start early and to continually backup your assignment as you progress. Computer crashes or corrupted files will NOT be accepted as valid reasons for an extension of any length.
- · Special consideration: You may be eligible for special consideration if circumstances beyond your control prevent you from undertaking or completing an assessment task at the scheduled time. For further information about Special Consideration
- For more information about academic misconduct, special consideration, extensions, and assessment feedback, please refer to the document Your rights and responsibilities as a student in this Unit in the first folder next to the Unit Guide of the Resources area in the CloudDeakin unit site.
- Building evidence of your experiences, skills and knowledge (Portfolio) – Building a portfolio that evidences your skills, knowledge and experience will provide you with a valuable tool to help you prepare for interviews and to showcase to potential employers. There are a number of tools that you can use to build a portfolio. You are provided with cloud space through OneDrive, or through the Portfolio tool in the Cloud Unit Site, but you can use any storage repository system that you like. Remember that a Portfolio is YOUR tool. You should be able to store your assessment work, reflections, achievements and artefacts in YOUR Portfolio. Once you have completed this assessment piece, add it to your personal Portfolio to use and showcase your learning later, when applying for jobs, or further studies. Curate your work by adding meaningful tags to your artefacts that describe what the artefact represents.
Get expert help for MMP742 – Investment Valuation and many more. 24X7 help, plag free solution. Order online now!
