pls send an attachement if possible
B IN 1st C This account does not allow editing on your device. For an account with full access, contact your organisation about your subscription plan Sign in fix Design an face financial model that can help to answer the following parts (part 1-11.marks will be allocated for the presentation and clarity of your modele there are dear heading, der angement for input cells, propriate use of colors, have some spre affability, generate warning need for wrong wer inputs, etc) pe you receive end of the tree tree years het in the future value in three years of the present value you computed in part w? ne throwth as we made from the saving the end of the third year. What is the interest compet! Compute the effectiveness own, CT Action propre e sed to computer al interest rate for aroma 2 Pour understand that he is going to you $15,000 per year at the end of each of the next er borrowed thing we they were when he borrowed the money the morete but the increased to 1, in tinen The period added to the laten Peter she second option !) CoverPage Q1_25marks Q2_4marks 03_35marks 4 Files 6-25 PM Mon 14 Sep FNCE 2004 Financial Analysis Project, Semester 2 2020 Insert Draw Formulas Data Review Home View B ADE E Y S This account does not allow editing on your device. For an account with full access, contact your organisation about your subscription plan. Sign in fx Design an faceliancial model that can help to answer the following parts for marks will be allocated for the presentation and clarity of our model there are dear heading.derangement for inputs opriate use of colors have some segree of billy generate warning messages for wronger input, Suppose you receive at the end of each year for the next three years the interest rate serie di what is the presente e fios? het in the tre value in three years of the present value you computed in parte? ne that no where made from the savings account the end of the third year. What is the interest component! mark Compute the effective years the tal interest oryant, et ECT Actions not appropriate for this portauit te wed to compute ante annual interest rate from a nominal interest rate Pour uncle has just nounced that he ha poing to give you $15,000 per year at the end of each of the next year the relevant interest rate is what is the value today is promise! the interest rate changes to what the value today of his promine? plain how interest rates inuence the value of the promise in parts and Peter borrowed 500,000 to relishing trai The lannequins monthly repayments over 15 years. When he borrowed the money the interest rate was 11.5% per annum, but I months later the bank increased the interest rate to 15 per annun, in line with market rates. The bark tester he can increase his monthly repayment to pay all the loan by the originally agreed date or he can extend the term of loan and keep making the same monthly payment). Calculate 14 mars! The period added to the term Peters the second option Ti CoverPage Q1 25marks Q240marks Q3 35marks
