Do you need this or any other assignment done for you from scratch?
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
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)
Do you need this or any other assignment done for you from scratch?
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.