Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Biblical Finance Reflections On Money Wealth And Possessions

Authors: Mark Lloydbottom, Keith Tondeur

1st Edition

0956395023, 978-0956395023

More Books

Students also viewed these Finance questions

Question

Explain social supports impact on an individuals physical health.

Answered: 1 week ago

Question

How can you create a supportive context for your personal growth?

Answered: 1 week ago

Question

How do romantic relationships typically escalate and deteriorate?

Answered: 1 week ago