Project #97420 - Financial Mathematics Assignment

Answers should be submitted as an excel document (not as a pdf) and an additional hand / word written document if necessary. Please show all your working for each question. 1. Mr Smith needs € 7 000 in 10 years time in order to pay for his daughter to go to college. How much must he invest this year in order to be able to pay her fees, assuming that he will receive a constant 3 % yearly compounded interest on his investment? (3) 2. A banker invests € 10 000 into two different funds. The first, fund P, accumulates simple interest at a rate of 7 % / annum. The second, fund Q, accumulates compound interest at a rate of 5 % / annum, where the accumulated interest is added to the fund at the end of each calendar year. (a) What are the compounding factors for fund P and fund Q? (1) + (1) (b) In which year of the value of fund P equal fund Q? (3) (c) At the end of which year will the value of fund Q become greater than the value of fund P? (1) 3. You have just brought a house. In order to buy the house you took out a € 175 000 mortgage, with a 5 % fixed interest rate from the bank. The term of the mortgage is for 25 years, during which time, the amount and any interest accrued must be fully repaid. (a) Calculate the annual repayment (Pmt) of the mortgage (2) Quantitative Business Methods EBBA102 Dr. Helene Meadows Assessment 3: Financial Mathematics (b) Construct a table of payments in excel for this 25 year Mortgage. Please use the structure shown below:

Subject Business
Due By (Pacific Time) 12/03/2015 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy