Submission Details: 1 Due Date and Time: January 1, 2025. 2 Maximum Upload Attem

Submission Details: 1 Due Date and Time: January 1, 2025. 2 Maximum Upload Attempts: 2 3 File Types: ◦ Part 1: Excel file with computations. ◦ Part 2: Report in Word. Part 1 – Excel File (50 Marks) Perform the following computations using Excel formulas and functions: • a) Monthly mortgage payments calculation.  • b) Initial cash outflows for purchasing the property.  • c) Monthly opportunity cost of using initial funds.  • d) Present value (PV) of cash outflows for 10 years (buy decision) vs PV of rent.  • e) Mortgage principal outstanding at the end of 10 years.  • f) Net gain/loss from selling the property after 10 years under these scenarios:  ◦ i. No change in property value. ◦ ii. Property value increases by 10%. ◦ iii. Property value decreases by 10%. ◦ iv. Property value and rent increase by 0.15% monthly. Ensure all computations are driven by formulas/functions, not hardcoded values. Part 2 – Report & Recommendation Create a professional report following these guidelines: 1 Format: ◦ Arial font, size 11. ◦ Line spacing: 1.5. ◦ Margins: Normal. ◦ Length: 2-3 pages (excluding tables and references). 2 Content: ◦ Analysis Description: Briefly explain the computations performed. (10 marks) ◦ Results Summary: Highlight key quantitative findings from Part 1. (5 marks) ◦ Recommendation: Offer advice to the Wongs based on the quantitative insights. (20 marks) ◦ Qualitative Considerations: Discuss non-numerical factors impacting the decision (e.g., lifestyle, market trends, flexibility). (10 marks) ◦ Presentation Quality: Ensure the report is clear, concise, and professionally formatted. (5 marks)