Files 6-25 PM Mon 14 Sep 30% FNCE2004. Financial Analysis Project, Semester 2 2020 Insert Draw Formulas Data Review Home View All . 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 facel financial model that can be awer the following person marks will be allocated for the presentation and clarity of our modelle there are dear heading.clear rangement for input ces opriate use of colors, have some segree of the billy generate warning movies for wrong wer inputs, etc.) suppose you receive at the end of each year for the next three years the rest rate is experimented wall what is the present of these fos? het in the future value in these years of the present value you computed in part 2 ne that no where made from the saving control the end of the third year. What is the interest component mark Compute the effective years the tal interest oryant. Jest RECT Actions not appropriate for this portauit te wed to compute angective annual interest rate from a nominal interest rate Part 2 marts Pour uncle has just nounced that he is going to give you $15,000 per year at the end of each of the next par the relevant interest rates, what is the value today of his promise! the interest rate changes to what is the value today of its prom? mark plain how interest rates infuence the value of the promise in parts and Peter borrowed 500,000 to relishing trawieThe lan equire 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 til Peter he can increase his monthly repayment to pay of the loan by the originally agreed date or he can extend the term of loan and keep making the same monthly payment). Calculate eta period added to the term Peters the second option Ti CoverPage Q1 25marks Q2_4marks Q3 35marks Files 6-25 PM Mon 14 Sep 30% FNCE2004. Financial Analysis Project, Semester 2 2020 Insert Draw Formulas Data Review Home View All . 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 facel financial model that can be awer the following person marks will be allocated for the presentation and clarity of our modelle there are dear heading.clear rangement for input ces opriate use of colors, have some segree of the billy generate warning movies for wrong wer inputs, etc.) suppose you receive at the end of each year for the next three years the rest rate is experimented wall what is the present of these fos? het in the future value in these years of the present value you computed in part 2 ne that no where made from the saving control the end of the third year. What is the interest component mark Compute the effective years the tal interest oryant. Jest RECT Actions not appropriate for this portauit te wed to compute angective annual interest rate from a nominal interest rate Part 2 marts Pour uncle has just nounced that he is going to give you $15,000 per year at the end of each of the next par the relevant interest rates, what is the value today of his promise! the interest rate changes to what is the value today of its prom? mark plain how interest rates infuence the value of the promise in parts and Peter borrowed 500,000 to relishing trawieThe lan equire 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 til Peter he can increase his monthly repayment to pay of the loan by the originally agreed date or he can extend the term of loan and keep making the same monthly payment). Calculate eta period added to the term Peters the second option Ti CoverPage Q1 25marks Q2_4marks Q3 35marks