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 |

Tutor | Rating |
---|---|

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.. |