Answer To: Running Head: Finance Student Name Student Id Affiliation Question one. a. Budget = $ 160 Bundles to...
Riddhi answered on Sep 05 2021
FINA501 ASSIGNMENT: PART 1 (20 marks)
Question One: Saving for a house (9 marks)
You are saving for a house that you intend to buy in exactly 5 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 your dream house is $1,000,000.
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 (i.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.) (3 marks)
Present your answers in the following space as indicated.
(a) Final answer: $2,00,000
Formula/Excel function used (if applicable):
Calculations: $10,00,000 x 20% = $2,00,000
(b) Final answer: $1,09,137
(i) Investment plan: Formula/Excel function used: =FV(1.75%/12,60,,100000)
State values for variables (state ‘N/A’ if non-applicable):
PV= $1,00,000
RATE= 0.14583%
NPER= 60
PMT= N.A.
FV= $1,09,137
(ii) Saving deposit: Formula/Excel function used: =FV(0.55%/12,60,-200)
State values for variables (state ‘N/A’ if non-applicable):
PV= N.A.
RATE= 0.4583%
NPER= 60
PMT= -200
FV= 12,163.7
(c) Final answer: $78,699.3
Formula/Excel function used (if applicable): $2,00,000-$1,09,137-$12,163.7
Calculations/Excel Table:
(d) Final answer:...