Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are saying for a house that you intend to buy in exactly years and need to determine whether you will be able to achieve
You are saying for a house that you intend to buy in exactly years and need to determine whether you will be able to achieve your target down payment deposit of 20% of the purchase price. You intend to check if you will be able to save enough. The forecasted market price of you dream house is $ 1 0 0 0 0 0 0 You have just placed $100.000 into an investment plan that matures in five years. This investment plan offers a guaranteed APR of 1.75%, with interest compounded monthly Meanwhile, you plan to save $200 every month into a saving deposit that pays an APR of 0.55%, with interest compounded monthly (a) What is the amount ($) of your targeted down payment deposit in 5 years? (1 mark) (b) Use Excel to calculate the total amount of money that the above investments (including the saving deposit) will generate at the end of 5 years. (2 marks) (c) Compare your calculations in (a) and (b) How far off (state in total $ amount) is the amount you have in 5 years from the targeted amount? (1 mark) (d) How much more do you have to save monthly into the same saving deposit account that earns 0.55% of APR compounded monthly in order to reach your target deposit? (2 marks) (e) After going through your income and spending budget, you concluded that the maximum amount of additional saving per month would be $300 (1.e a total of $500 per month), comment if this additional $300 monthly saving for 5 years will help you achieve your saving goal Why or why not! What can be changed about this house purchasing goal to make it achievable? Be specific in your answer and explanations Use relevant figures to clearly illustrate your point. (Word limit 80 words excluding calculations answers beyond word limit will NOT be marked )
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started